Monthly Archives: October 2014

Configuration Manager 2012, Microsoft System Center, Reporting

CM 2012 – Reporting – Narrowing Results with Parameters

Video Leave a comment

I’m continuing the series on SSRS Reporting within Configuration Manager 2012 and building on the previously create report outlined in

CM 2012 – REPORTING – CREATE A TABLE REPORT USING SSRS

CM 2012 – REPORTING – CREATING MEANINGFUL RESULTS WITH SQL CASE STATEMENTS

We will create and use a parameter which will display as a drop-down menu using values from a new dataset.

The SQL queries used in this video is shown below:

Second Dataset for Parameter

SELECT DISTINCT
Operating_System_Name_and0

FROM
V_R_System

ORDER BY
Operating_System_Name_and0

Original Dataset with Added Parameter in WHERE statement

SELECT
v_R_System.Name0,
V_R_System.Operating_System_Name_and0,
CASE
WHEN
v_R_System.Client0=1 THEN ‘YES’
ELSE
‘NO’
END AS Client0,
CASE
WHEN
v_R_System.Active0=1 THEN ‘YES’
ELSE
‘NO’
END AS Active0

FROM
v_R_System

WHERE
V_R_System.Operating_System_Name_and0 = @OSName

ORDER BY
V_R_System.Operating_System_Name_and0,
v_R_System.Name0

Configuration Manager 2012, Reporting

CM 2012 – Reporting – Creating Meaningful Results with SQL CASE Statements

Video Leave a comment

Building upon our previous reporting outlined in

CM 2012 – REPORTING – CREATE A TABLE REPORT USING SSRS

we will use a SQL CASE statement to create more meaningful results from the values presented previously.

The SQL query used in this video is shown below:

SELECT
v_R_System.Name0,
V_R_System.Operating_System_Name_and0,
CASE
WHEN
v_R_System.Client0=1 THEN ‘YES’
ELSE
‘NO’
END AS Client0,
CASE
WHEN
v_R_System.Active0=1 THEN ‘YES’
ELSE
‘NO’
END AS Active0

FROM
v_R_System

ORDER BY
V_R_System.Operating_System_Name_and0,
v_R_System.Name0

Configuration Manager 2012, Reporting

CM 2012 – Reporting – Create a Table Report Using SSRS

Video Leave a comment

One of the best features of Configuration Manager is its ability to collect immense amounts of data.  What a CM Administrator does with that data can make the difference between a supervisor being impressed with the capabilities of CM, or believing it has a database full of useless information.  That’s where the reporting feature comes in.  I’ve met many CM Administrators who are still exporting the results of SQL queries into spreadsheets and sending those to their supervisors.

Hopefully, the series of videos I’ll be releasing will help those folks create some very useful reports and get them excited about using Report Builder.

This is a short video demonstrating how to create a basic table report using Configuration Manager 2012 and SQL Report Builder.

The SQL query used in this video is shown below:

SELECT
v_R_System.Name0,
V_R_System.Operating_System_Name_and0,
v_R_System.Client0,
v_R_System.Active0

FROM
v_R_System

ORDER BY
V_R_System.Operating_System_Name_and0,
v_R_System.Name0