select distinct c.SiteID as [What You Normally Think The CollectionID Is] , s.sql , s.wql , crq.queryid ,crq.QueryExpression ,crq.rulename from v_collections c join collection_rules_sql s on s.collectionid=c.collectionid join v_collectionruleQuery crq on crq.collectionid=c.siteid order by c.siteid, s.sql
ItemKey is just another name for resourceid. I often join two views together for custom reports (which I suspect Microsoft thought we wouldn't care about ) by joining itemkey in 1 view to resourceid in another view. Sherry Kissinger On Thursday, July 10, 2014 2:40 PM, Kevin Ray <kevinalive...@gmail.com> wrote: Thanks Ryan and Sherry :) Here in "Collection_Rules_SQL" what is QueryKey filed (its showing for some collections 1, for some 1,2 depeds on collection) Thanks Kevin On Wed, Jul 9, 2014 at 9:54 PM, Ryan <ryan2...@gmail.com> wrote: CEViewer is only for 2012 R2 and can be found in the toolkit: http://www.microsoft.com/en-us/download/details.aspx?id=36213 > > >How many collections do you have set up for incremental updates? You can check >it with this powershell command line: > > > > > > > >On Wed, Jul 9, 2014 at 2:38 PM, Sherry Kissinger <slkissin...@sbcglobal.net> >wrote: > >Select * from Collection_Rules_SQL >> >> >>Also, don't forget about CEViewer, in 1 of the toolkits (or was that the >>SDK?) >>CEViewer = CollectionEvaluationViewer; let's you see what collections >>historically sucked for time, and whether or not you happen to have a >>colleval backlog currently. Not that you can do anything about the >>backlog... unless there is a current collection which is just spinning and >>trying to do an infinite loop of a join or something that you want to >>kill--at least you'd know if you SHOULD go into SQL, ActivityMonitor, find >>collection_evaluator, and kill something. >> >>Sherry Kissinger >> >> >> >>On Wednesday, July 9, 2014 2:29 PM, Kevin Ray <kevinalive...@gmail.com> 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 >> >> >> >> > >
