Client Health – More than Just Percentages

I recently had the pleasure of presenting a session on ConfigMgr client heath at IT/DevConnections with my friend Kent Agerlund, and wanted to reiterate one of the items we mentioned during the session. Measuring health by percentage is a great thing, but you should also look at the numbers too. Below is a pic of an example SSRS report that I created.

On the left-hand side, you see the top graph is percentage of health from 7/31-8/15 – that’s great – you can see we ran around 97%. . . but what is even more fantastic is that during that same period, we went from 31K systems to 33K systems and maintained health. This is a good thing, but what is even more important (but not shown above) is to watch those numbers for a large reduction in systems. If you’re only looking at percentages, your health may look the same, event though someone went into your admin console and ‘accidentally’ deleted 5K systems. . . .  so percentages are great, but take a look at the numbers too.

Greg

 

Here is the SQL used for the reports above – just update the SiteCode and desired CollectionID.

SELECT  [Date]
      ,[CollectionID]
      ,[SiteCode]
	  ,ROUND([ClientsActive] * 100.1 / [ClientsTotal], 1) AS PercentActive
	  ,[ClientsActive]
	  ,ROUND([ClientsHealthy] * 100.1 / [ClientsTotal], 1) AS PercentHealthy
	  ,[ClientsHealthy]
  FROM [v_CH_ClientSummaryHistory]
  where [Clientstotal] > 0 and datediff(day,[date],getdate()) <30 and SiteCode='GMR'
and CollectionID='SMS00001'
  order by date

About Greg Ramsey
Greg Ramsey is a systems engineer specializing in global systems management for Dell IT. He has a B.S. in Computer Sciences and Engineering from the Ohio State University and is a Microsoft Most Valuable Professional (MVP) for Microsoft System Center Configuration Manager. Greg coauthored SMS 2003 Recipes: A Problem-Solution Approach (Apress, 2006), Microsoft System Center Configuration Manager Unleashed (Sams, 2009), Microsoft System Center 2012 Configuration Manager Unleashed (Sams, 2012), and Microsoft System Center 2012 Configuration Manager: Administration Cookbook (Packt Publishing, 2012), and Microsoft System Center 2012 Configuration Manager R2 Unleashed (Sams, 2012). Greg is cofounder of the Ohio SMS Users Group, and the Central Texas Systems Management User Group.

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

%d bloggers like this: