SQL Query to Analyze OS Counts

Since I started my new job, I’ve been implementing ConfigMgr 2012 in a number of sites.

This simple query has proven useful to get a reasonably accurate count of installed systems, after the initial system discovery is run. Useful to identify clients that may no longer be supported.

SELECT operating_system_name_and0 AS OSType,
       Count(*)                   AS Total
FROM   v_r_system
GROUP  BY operating_system_name_and0
ORDER  BY operating_system_name_and0 

Advertisements
This entry was posted in ConfigMgr, SQL. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s