Hi,I have just started working with SCCM, and have been asked to create a dashboard with the following information:% of machines with sccm installed% of machines with no sccm% of machines with -- program installed% of machines with no -- program% of machines with x program installed% of machines with no x programI am really at a loss for how to reference all of these in the same query, as well as using the count function. I was wondering if it was possible to reference this criteria from individual collections, and the only thing I've managed to do is a count of a particular collection (which comes out to '1', which is obviously of no use). Basically, I am in need of a simple query framework in which I could just copy and paste references to these collections, and then come out with percentages based on each set, unless there's a better way to do it that I'm not aware of.

Hi You can get ideas about how to do those by following the below link. http://blogs.msdn.com/b/shitanshu/archive/2010/05/02/part-3-sql-queries-used-for-creating-custom-configuration-manager-dashboard-in-microsoft-it.aspx Thanks Raghu