Logo
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
EPL Standings
 
 
Windows Server

System Center Configuration Manager 2007 : Customizing Configuration Manager Reports (part 1) - Customizing Report Layout and Display

5/2/2013 6:19:32 PM

The ready-made reports Microsoft includes with ConfigMgr provide extensive capabilities for reporting on your environment and operations. However, you might sometimes need to customize these reports to get just the right report to fit your requirements. Here are several ways you can customize reports:

  • Change layout and display characteristics of a report. For example, you can re-order the columns, add a chart or modify the existing chart, or add or modify a link.

  • Change which data rows or columns are included in the report.

  • Add data from additional Configuration Manager database tables or add data ConfigMgr does not capture by default through inventory or discovery customizations.

  • Add data from sources outside the Configuration Manager database.

The following sections present examples of each of these types of customization.

Note: Cloning Reports

For purposes of discussion, some examples in this section modify the default Configuration Manager reports. In reality, you generally want to clone the original report and make your modifications to the cloned copy.

To clone a report, expand the Configuration Manager console tree to System Center Configuration Manager -> Site Database -> Computer Management -> Reporting -> Reports. Right-click the report and choose Clone. You need to supply a new name for the cloned report.


1. Customizing Report Layout and Display

To customize the order the columns appear in a report, you can edit the report’s SQL statement and simply re-order the items in the selection list. One of the reports used was Sites by hierarchy with time of last site status update. This report provides a useful view of your sites, including their hierarchical relationships and status. The most relevant data for the status dashboard, however, is in the columns on the right of the report. You cannot view the status information in the report in the upper-left quadrant of the dashboard without scrolling to the right. To change the column order so that the status information appears earlier in the report, perform the following steps:

1.
Expand the Configuration Manager console tree to System Center Configuration Manager -> Site Database -> Computer Management -> Reporting -> Reports. Right-click the Sites by hierarchy with time of last site status update report, and choose Properties.

2.
On the Properties page for the report, select the General tab and click the Edit SQL Statement button. A portion of the report’s SQL statement is:

select SPACE(3*(SiteLevel-1))+so.SiteCode as SiteCode, s.SiteName,
s.ServerName,
  CASE s.Type WHEN 1 THEN '*' ELSE ' ' END as C085, s.ReportingSiteCode,
  s.Version, stat.Updated,
  CASE stat.Status WHEN 0 THEN '*' ELSE ' '  END As 'OK',
  CASE stat.Status WHEN 1 THEN '*' ELSE ' '  END As 'Warning',]
  CASE stat.Status WHEN 2 THEN '*' ELSE ' '  END As 'Error'

3.
Edit the SQL Statement by moving the SiteName, ServerName, C085 (this is the secondary site indicator), ReportingSiteCode, and version columns to the end of the selection list. The resulting SQL statement will be:

select SPACE(3*(SiteLevel-1))+so.SiteCode as SiteCode, stat.Updated,
  CASE stat.Status WHEN 0 THEN '*' ELSE ' '  END As 'OK',
  CASE stat.Status WHEN 1 THEN '*' ELSE ' '  END As 'Warning',
  CASE stat.Status WHEN 2 THEN '*' ELSE ' '  END As 'Error', s.SiteName,
  s.ServerName,
  CASE s.Type WHEN 1 THEN '*' ELSE ' ' END as C085, s.ReportingSiteCode,
  s.Version

4.
Click OK to close the Edit SQL Statement dialog box and again to close the report Properties page. You can now run the report or the dashboard to view the results of your changes. Figure 1 displays the Status Overview dashboard reflecting the report modifications.

Figure 1. Except the first report now displays status date and overall site status.

You can also use the report Properties dialog box to add a chart or link to an existing report or to modify an existing chart or link. You can add a link to the Sites by hierarchy with time of last site status update report, which displays a map of your hierarchy as follows:

1.
Use SMSMap to create the hierarchy map and save it as a graphical interchange format (gif) file in a file system directory under your SMS reporting folder. The reporting folder in this example is http://bluebonnet/SMSReporting_CEN. You can use the Internet Information Service (IIS) Manager in the Administrative Tools program group on Bluebonnet to view the properties of the SMS_Reporting folder under the default website and see that the file system path for the folder is c:\inetpub\wwwroot\SMSReporting_CEN. The SMSMap is saved as c:\inetpub\wwwroot\SMSReporting_CEN\images\SMSMap.gif. (See the Windows Server help files for information about using IIS Manager.)

2.
Open the report Properties by following step 1 of the previous procedure and click on the report Properties page Links tab. Choose Link to URL from the Link type drop-down list and enter http://bluebonnet/SMSReporting_CEN/images/smsmap.gif in the URL box; then click OK to save your changes. The report now displays a link icon next to each of the site codes, allowing you to reference the site hierarchy map.
Other -----------------
- System Center Configuration Manager 2007 : Reporting - Dashboards
- Client Access to Exchange Server 2007 : Getting the Most Out of the Microsoft Outlook Client - Deploying Outlook 2007
- Client Access to Exchange Server 2007 : Getting the Most Out of the Microsoft Outlook Client - Understanding RPC Over HTTPS in Outlook 2007
- SharePoint 2010 : Farm Governance - Configuring Resource Throttling
- SharePoint 2010 : Farm Governance - Creating a new policy for a web application
- Workflow in Dynamics AX 2009 : Windows Workflow Foundation, Automating Business Processes
- Workflow in Dynamics AX : Dynamics AX 2009 Workflow Infrastructure
- Microsoft Dynamics CRM 2011 : Using Advanced Find (part 5) - Using Edit Multiple Records and Assign Multiple Records from Advanced Find
- Microsoft Dynamics CRM 2011 : Using Advanced Find (part 4) - Using Advanced Filter Criteria
- Microsoft Dynamics CRM 2011 : Using Advanced Find (part 3) - Creating and Sharing a Saved View
- Microsoft Dynamics CRM 2011 : Using Advanced Find (part 2) - Organizing and Formatting Advanced Find Results
- Microsoft Dynamics CRM 2011 : Using Advanced Find (part 1) - Performing Advanced Find Queries
- System Center Configuration Manager 2007 : Available Reports and Use Cases (part 4) - Asset Intelligence, Reporting on Application Compatibility
- System Center Configuration Manager 2007 : Available Reports and Use Cases (part 3) - Client Status Reporting
- System Center Configuration Manager 2007 : Available Reports and Use Cases (part 2) - Reporting on Sites, Reporting on Configuration Manager Operations
- System Center Configuration Manager 2007 : Available Reports and Use Cases (part 1) - Reporting on Inventory and Discovery Data
- Microsoft Dynamics GP 2010 : Network requirements, The Terminal Server only approach, Shared files, Data backups
- Microsoft Dynamics GP 2010 : Dynamics GP system requirements
- Microsoft Lync Server 2010 : Planning for Voice Deployment - Dial Plan
- Backup and Restore of Microsoft Lync Server 2010 : Restore Processes
 
 
Most view of day
- Troubleshooting Hardware, Driver, and Disk Issues : How to Use Built-In Diagnostics (part 5)
- Microsoft Dynamic AX 2009 : .NET Business Connector - Usage Scenarios for .NET Business Connector
- System Center Configuration Manager 2007 : Network Design - Network Discovery
- Sharing Your Computer with Others : Create a User Account, Switch Between Accounts
- Using Microsoft SharePoint with Microsoft Dynamics CRM Functions (part 2) - Displaying Data Using BDC in Microsoft Office SharePoint Server
- Windows Server 2012 : File Services and Storage - Configuring iSCSI storage (part 5) - Using iSCSI Initiator - Discovering targets
- Understanding Network Services and Active Directory Domain Controller Placement for Exchange Server 2007 : Configuring DNS to Support Exchange Servers, Troubleshooting DNS Problems
- Using OneNote with Other Programs : OneNote Integration with Outlook (part 2)
- Microsoft Visio 2010 : Introducing Data Graphics (part 1) - What Is a Data Graphic?
- Creating a Home Network : Creating a Wired LAN, Creating a Wireless LAN
Top 10
- Windows Server 2012 : DHCP,IPv6 and IPAM - Exploring DHCP (part 3) - Creating IPv4 DHCP Scopes
- Windows Server 2012 : DHCP,IPv6 and IPAM - Exploring DHCP (part 2) - Installing DHCP Server and Server Tools
- Windows Server 2012 : DHCP,IPv6 and IPAM - Exploring DHCP (part 1)
- Windows Server 2012 : DHCP,IPv6 and IPAM - Understanding the Components of an Enterprise Network
- Microsoft OneNote 2010 : Using the Research and Translate Tools (part 3) - Translating Text with the Mini Translator
- Microsoft OneNote 2010 : Using the Research and Translate Tools (part 2) - Translating a Word or Phrase with the Research Pane
- Microsoft OneNote 2010 : Using the Research and Translate Tools (part 1) - Setting Options for the Research Task Pane, Searching with the Research Task Pane
- Microsoft OneNote 2010 : Doing Research with Linked Notes (part 2) - Ending a Linked Notes Session, Viewing Linked Notes
- Microsoft OneNote 2010 : Doing Research with Linked Notes (part 1) - Beginning a Linked Notes Session
- Microsoft OneNote 2010 : Doing Research with Side Notes (part 3) - Moving Side Notes to Your Existing Notes
 
 
Windows XP
Windows Vista
Windows 7
Windows Azure
Windows Server
Windows Phone
2015 Camaro