Tag Archives: System Center Configuration Manager

CM 2012 – Reporting – Using Actions to Provide for Drill-Downs

To conclude this particular series on using SQL Report Builder from within Configuration Manager 2012, I will show how to create an action inside the dashboard’s summary report, linking it to the Operating System Details report we created in the previous half of this series.

Previous videos for the dashboard part of the series can be found here:

CM 2012 – REPORTING – SUMMARIZING RESULTS WITH COUNT STATEMENTS

CM 2012 – REPORTING – GRAPHICALLY REPRESENTING DATA WITH CHARTS

CM 2012 – REPORTING – USING AND CONFIGURING GUAGES

 

CM 2012 – Reporting – Using and Configuring Guages

This video will continue building the dashboard we’ve been working on over the last two videos.  Those demonstrations can be found here:

CM 2012 – REPORTING – SUMMARIZING RESULTS WITH COUNT STATEMENTS

CM 2012 – REPORTING – GRAPHICALLY REPRESENTING DATA WITH CHARTS

This session will concentrate on inserting three-color-range guages into the dashboard and configuring them to represent specific defined values.  Additionally, a new dataset will be created to define the variables being used.

The SQL query used in this video is shown below:

DECLARE @TOTAL INT, @CLIENT INT, @ACTIVE INT

SELECT
@TOTAL = COUNT(*)
FROM
v_R_System

SELECT
@CLIENT = COUNT(*)
FROM
v_R_System
WHERE
v_R_System.Client0 = 1

SELECT
@ACTIVE = COUNT(*)
FROM
v_R_System
WHERE
v_R_System.Active0 = 1

SELECT @TOTAL AS Total, @CLIENT AS Client, @ACTIVE AS Active

CM 2012 – Reporting – Graphically Representing Data with Charts

In my last video, I showed how to create summarized data using SQL COUNT statements.  You can find that post here:

CM 2012 – REPORTING – SUMMARIZING RESULTS WITH COUNT STATEMENTS

For this demonstration, I will use the same SQL dataset and create a simple chart which shows the same data in chart form.

 

CM 2012 – Configuration – Custom Client Settings for SUP

A client recently requested preliminary design for moving security updates from WSUS to CM 2012.  There were several requirements for the move as well:  1) SUP would need to be tested on a small group of clients initially;  2) WSUS would need to remain in parallel during the process in order to keep current desktop/laptop clients and servers patched; 3) WSUS would need to remain in place after the move as the server team would continue to use it until their conversion to CM 2012.

I’m only going to focus on how custom client settings were used to segment out the test group from the main body of desktops and laptops.  (There were Group Policy and other adjustments which had to be made as well, but they are not part of this discussion.)

First, I created a test collection to house the initial software updates test group.

CCSSUP01

Current Default Client settings have Software Updates turned off.

CCSSUP02

I created a custom client device setting specifically targeted at software updates.  You can do this by navigating to Administration > [expand] Overview > [expand] Site Configuration > [select] Client Settings, then either right-click on Client Settings and select “Create Custom Client Device Settings” or click the same-named icon in the top ribbon.

On the General tab of the resulting screen, I named the Custom Device Settings “Software Updates – Enabled” and checked the Software Updates box.  Checking this box reveals the Software Updates tab in the left panel.

CCSSUP03

On the Software Updates tab, I enabled software updates on clients (1 in the picture below), set bundling of updates having deadlines within 1 day of any update which has reached its deadline. (2 and 3 in the picture below) Save the custom client setting by clicking OK and then deploy it to the test collection.  I set the priority of the setting to 1.  If this is your first custom setting, it will default to a priority of 1.  You can change the priority of any custom setting by right-clicking on the setting and using the Increase or Decrease Priority selections from the drop-down menu.  Remember that the lower the priority number, the higher the priority in settings application on the client machine.

CCSSUP04

The newly deployed shows up under the deployments tab of the custom settings.

CCSSUP06

Force a Machine Policy Retrieval & Evaluation Cycle on the machines located in the test collection and the new custom settings will be applied.  You can check this by looking at the Components tab of the Configuration Manager control panel applet.

CCSSUP08

Initiate a Software Updates Scan Cycle on the machines located in the test collection and then spot-check the WUAHandler.log file on those machines to validate that the clients are pointing to the correct SUP server and that the scan is not encountering any errors which need addressing.  You should see something similar to the below entries in the log file.

Enabling WUA Managed server policy to use server: [YOUR SERVER HERE]
Async searching of updates using WUAgent started.
Async searching completed.
Successfully completed scan.

If you feel so inclined, use a tool such as Roger Zanders Client Center to check things out. (http://sccmclictr.codeplex.com/  –  don’t forget to donate!)

CCSSUP10