In my example, you can see Full Evaluation collection queues.
I have added these machine from CAS (CAS Primary Concept).
In addition here is another query that gives you a rollup view of your collection counts.
In the Morning in SCCM 2012, I observed Hour Glass on the collection after adding members for almost 3 hours. Now it is 2 hours and the two machines do not show up when double clicked on the collection.
His query is shown below: Running this query in SQL Management Studio will produce a list of the collections you have and how they are configured.
It’s important to take note of of how many collections you have that are configured for incremental.