Friday, February 20, 2009

WQL to SQL Query

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/

No comments: