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, Enterprise Mobility MVP, is a Senior Enterprise Architect at Dell, Inc. He has a B.S. in Computer Sciences and Engineering from Ohio State University and has co-authored many books over the years. Greg is a co-founder of the Ohio SMS Users Group and the Central Texas Systems Management User Group. Greg is also a board member of the Northwest System Center User Group and the Director of Communications for the Midwest Management Summit.

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:

WordPress.com Logo

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

Google photo

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