Creating or Editing a SCCM 2012 R2 Custom Report

Not a great fan of reporting in SCCM 2012 as it just seems so much more hassle than it was with the ASP reports in SCCM 2007.  Below is my preferred method of creating or editing custom reports in SCCM 2012 R2.

First Use
  • Ensure the Reporting Service Point (RSP) is installed and configured.
  • Access the RSP server using the link, e.g. http://sccmserver/reports.
  • Open the default folder – probably called ConfigMgr_ABC where ABC is the SCCM Site name.
  • Create a new folder called ABC Custom Reports.
  • In the SCCM console access the Reporting node in the Monitoring workspace.
  • Right-click on any report and choose Edit.  This will force the Report Builder tool to download to your user profile.
  • Don’t do anything, just close Report Builder.

Create a Run As Administrator Shortcut to Report Builder

  • Create a shortcut to the MSReportBuilder executable now buried in your profile here: C:\Users\username\AppData\Local\Apps\2.0\WMN9W578.6MY\4ZPA1R15.EH1\repo..tion_c3bce3770c238a49_000c.0000_f828cd3ef9610d16\MSReportBuilder.exe – not sure if the naming is consistent but it will be under the 2.0 folder somewhere.
  • Access the properties of the shortcut, click the Advanced button and tick the Run As Administrator check-box.

Creating a New Report

  • Create/obtain the SQL query to be used for the report.
  • Open Report Builder using the shortcut.
  • From the Getting Started screen select New Report on the left and Table or Matrix from the right.
  • Ensure Create a dataset is selected at the bottom and click Next.
  • The default data source should be highlighted, if not browse to it under the ConfigMgr_ABC folder (it’s listed after all the report folders).  Click Next.
  • In the Design window click Edit as text.
  • Paste the SQL in the text box and test using the execute button (the red exclamation mark).
  • Assuming the SQL syntax is OK click Next.
  • Select all the fields listed in the Available fields box and drag to the Values box.
  • Click Next, Next and Finish.
  • Adjust the column widths etc. to suit.
  • Click Save As from the ribbon button and save the report in the ABC Custom Reports folder.

The report should now be visible in the SCCM console.

Editing a Custom Report
  • Don’t use the SCCM console to edit a report – too flaky.
  • Open Report Builder using the shortcut.
  • Click Open on the Getting Started screen and browse to the custom report to be edited.

Editing an Existing Report

  • Do not edit the existing reports in place causing them to be overwritten – always do a Save As to the custom reports folder as soon as they are opened

Reference: https://technet.microsoft.com/en-gb/library/dd334596.aspx.