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,
https://sccm07.blogspot.com/
Thanks,
https://sccm07.blogspot.com/