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 >> >> >> >> >> > >