You can use select * from Collections where SiteID = 'SMS00001'
then select * from Collection_Rules_SQL where CollectionID=2 This should give you the WQL query and SQL query too. On Wed, Jul 9, 2014 at 12:27 PM, Kevin Ray <[email protected]> wrote: > Hi All, > > My SCCM console is very slow.. So if i want check the collection WQL query > properties its taking time.. > > I just checked in SQL query(Select * from v_CollectionRuleQuery) to find > the collection WQL query.. But not exaclty same.(it has some Item key,etc).. > > Is their any tool or Script Which it will show up the collection WQL query > propertis > > Thanks in Advance > Kevin > >
