How to import custom reports in SCCM 1511

2373

This post is a quick guide on how to import custom reports in SCCM 1511. The steps listed in this post will work on other versions of configuration manager as well. When you install Configuration Manager, it comes with lots of built-in reports. Configuration Manager provides report definitions for over 400 reports in over 50 report folders, which are copied to the root report folder in SQL Server Reporting Services during the reporting services point installation process. But sometimes the companies require a custom report that does come built-in with SCCM. So when i say importing custom reports, we are basically importing the .rdl files. RDL is a file extension for an XML file used Microsoft SQL Server reporting services. RDL stands for Report Definition Language. RDL files contain calculations, charts, images, graphs and text and can be rendered into a variety of formats as needed.

How to import custom reports in SCCM 1511

So now let’s see how to import custom reports in Configuration Manager 1511. I have downloaded a report that shows the last reboot time of the machines from a collection. I have copied this file inside the sources folder on SCCM server. You could click the below button to download the RDL file.

[TS_VCSC_Icon_Flat_Button button_style=”ts-color-button-midnight-blue-flat” button_text=”Download Find Last Reboot Time RDL File” icon=”ts-awesome-cog” el_file=”” link=”url:https%3A%2F%2Fwww.dropbox.com%2Fs%2Fdh444wj54hgysnu%2FFind%2520Last%2520Reboot%2520Time.zip%3Fdl%3D0|title:Download%20Find%20Last%20Reboot%20Time%20RDL%20File|target:%20_blank”]

How to import custom reports in SCCM 1511

Open the browser and browse to the Reporting Services webpage, by default http://server/reports as a user with permissions to edit reports (To run a report, an administrative user must have the Run Report permission for the object. To create or modify a report, an administrative user must have the Modify Report permission for the object). Now click on New Folder. We will create a new folder and upload the rdl file into that folder.

How to import custom reports in SCCM 1511

Provide a name to the folder and click OK.

How to import custom reports in SCCM 1511

Once you have created the folder, click on the folder and now click on Upload File.

How to import custom reports in SCCM 1511

Click on Browse and specify the path to upload the rdl file. Click OK.

How to import custom reports in SCCM 1511

Now you will see the report is imported. Do not run the report. We need to ensure that the report is configured to use your SCCM database as the data source.

How to import custom reports in SCCM 1511

Click on the drop down and click Manage.

How to import custom reports in SCCM 1511

In the left pane, click Data Sources. You need to click on Browse and choose the data source.

How to import custom reports in SCCM 1511

Choose the data source and click OK.

How to import custom reports in SCCM 1511

Now run the report. This reports lists the last reboot time of computers from a selected collection. We have successfully imported a custom report into SCCM.

How to import custom reports in SCCM 1511