WQL to SQL
Want to see What is the query????????
 
This SQL Query can be used to see how WQL is converted to SQL by SMS for collections
 
Select
Collections.SiteID , Collections.CollectionName , Collection_Rules.QueryName , Collection_Rules_SQL.WQL , Collection_Rules_SQL.SQL From Collections,Collection_Rules, Collection_Rules_SQL Where Collections.CollectionID = Collection_Rules.CollectionID AND Collections.CollectionID = Collection_Rules_SQL.CollectionID——————-
Thanks,
http://sccm07.blogspot.com/
 

Leave a Reply