My Top 5 Reasons for Attending MMS 2018 Desert Edition

In case you missed the memo, MMS 2018 Desert Edition is coming up December 2-4 in Scottsdale, Arizona! Check out the action packed schedule, showcasing the top talent in the Enterprise Systems Management space. Take a look at the speakers, schedule, as well as learn about cabana sessions.


Greg’s Top 5

Based on my previous experiences at MMS MOA, here are my top five reasons for attending MMS 2018 Desert Edition:

  1. Community – MMS has consistently hit the mark for fostering community. The speakers are available and visible, and eager to talk to you. Evals clearly show how much attendees enjoy attending MMS.
  2. SpeakersTop notch speakers – industry best come together to collaborate and present on the topics they love.
  3. Healthy balance of Microsoft and Industry Involvement – As IT Pros, we need the “boots on the ground/industry” perspective more than ever. But there’s also the right representation from Microsoft to give great feedback, get your questions answered, and influence change in the products.
  4. Sessions – Deep, technical sessions, topics you won’t find in a book, webcast, or other publication. Plenty of time (1h 45 min) to absorb the presentation, ask a lot of questions, and hang out after to network.
  5. Timing – Stay current, stay relevant! Our world is quickly changing. Just think of all the changes in ConfigMgr and Intune since MMS 2018 in May, and you know that there’s plenty to catch-up.

Bonus Reason! Cabana sessions are a new addition to MMS, and is something we envisioned at the beginning. In addition to all the community and network time that you get at MMS, the cabana sessions allow you to schedule 1×1 time with industry peers as well as MS product team members.

I’ll see you at MMS DE!



How To: Build Client Health Trend Line

I’ve received great feedback on my previous post, Client Health – More than Just Percentages, as well as several requests for the SSRS .RDL file. Instead of sharing the file, I’m going to talk you through the process to create it yourself! First, let me say with that previous post, those are examples, and you probably wouldn’t show them all on the same page.  I’ll break these down into a couple posts.

This example is to create the trend line report to get a better understanding of client health over time (both percentage, and client count).

Prerequisite: You must have Client Heath options configured to retain the data for 30 days (or whatever number you require). In the admin console, go to Monitoring->Client Status, and select Client Status Settings. You can see for my environment, I’m retaining the information for 31 days.


Here is the SQL used for the reports – 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


1. Using Report Builder, create a new report and connect to your ConfigMgr database. After you’ve verified connectivity, you’ll see the “Design an query” page. Select “Edit as Text”:

DesignAQuery_1_201711202. Paste your query, and click the red exclamation mark to run it (always test it here, to ensure you receive the expected results):


3. Click Next, and then chose “Line” for the chart type, and then Next again. Now you need to select the fields, as shown here:


4. Click Next again to see a preview (don’t pay much attention to the shape of the graph in the preview – it’s not using your values), and then Finish.

5. Now from this view, add a catchy title (“Client Health Counts – Active vs. Healthy”) and click the Run icon in the tool bar to view the data. Nice start, but still room for improvement.


6. Click Design to clean this up a little. Let’s modify the scale, so we can focus on what’s important. Single-click on the Y axis (you may need to click it a second time to get proper focus), and then right-click to select “Vertical Axis Properties.”


7. The easy button is to clear the Always include zero option and click OK:


8. Perform similar steps to get to “Horizontal Axis Properties” and change the Axis type to Scalar:


9. You now have a pretty nice graph to show you client health


Now that you’ve successfully created “Client Health Counts – Active vs. Healthy”, go back and create a similar report to show percentages instead of counts (Hint: The SQL query above contains all the info you need).

Stay Tuned! I’ll follow up this post with a couple more to cover gauges and spark lines!