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.



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

SELECT  [Date]
	  ,ROUND([ClientsActive] * 100.1 / [ClientsTotal], 1) AS PercentActive
	  ,ROUND([ClientsHealthy] * 100.1 / [ClientsTotal], 1) AS PercentHealthy
  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 Distinguished Engineer for Dell Digital - Services. He has a B.S. in Computer Sciences and Engineering from The Ohio State University and has co-authored many books over the years. Greg is also a board member of the Northwest System Center User Group and the Midwest Management Summit. ​Greg has been a Microsoft Endpoint Manager (ConfigMgr, Intune) MVP for over 14 years.

One Response to Client Health – More than Just Percentages

  1. Pingback: How: Build Client Health Trendline | Greg's Systems Management Blog

Leave a Reply

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

You are commenting using your 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 )

Connecting to %s

%d bloggers like this: