This will be the second half of the series I’m creating on using SQL Report Builder with Configuration Manager 2012. In this part of the series I will show how to build a dashboard using various features.

This first video will demonstrate how to use a COUNT statement in order to summarize query results.

The SQL query used in this video is shown below

SELECT
Operating_System_Name_and0, COUNT(*) AS Qty

FROM
V_R_System

GROUP BY
Operating_System_Name_and0