In order to allow users to run the SCCM 2012 Compliance 1 – Overall compliance report without the need to enter the two required parameters the following procedure was completed.
Obtain the Required Parameters
- Obtain the Collection ID of SCCM collection to run the compliance report against. In my case I used SMSDM003 which is the generic ID for the All Desktop and Server Clients SCCM collection.
- Obtain the Software Update Group ID to run the compliance report against. This can be obtained by exposing the CI Unique ID column in the SCCM console, using ctrl+c to copy the data and then ctrl+v into Notepad.
Create Folders
- Access the SSRS home page.
- Create a new folder called Custom Reports.
- Create a subfolder called Compliance Reports.
Link the Report
Note: You need to link the report rather copy the report otherwise the secondary reports will not run.
- Navigate to the Software Updates – A Compliance report folder.
- Click the Compliance 1 – Overall compliance report and select Manage from the dropdown.
- From the menu bar click Create Linked Report.
- Give the report a name, e.g. Overall Compliance Report.
- Click the Change Location button.
- Navigate to the Compliance Reports folder just created and click OK at the bottom of the page.
- Click OK again to save the new report.
Adding the Parameters
- Navigate to the Compliance Reports folder and the newly saved report should be visible.
- Select the Overall Compliance Report and Manage from the dropdown.
- Click the Parameters button on the left.
- Clear the two checkboxes in the Prompt User column.
- Tick the two checkboxes in the Has Default column (adjacent to AuthListID and CollID labels).
- Enter the Collection ID in the CollID text box and the Software Update Group ID in the AuthListID text box.
- Click the Apply button.
Running the Report
- Back at the folder list run the Overall Compliance Report. It should now run without the need to enter any parameters.
- When the report opens in Internet Explorer copy the URL of the report.
The URL can now be distributed to users who will be able to run the report without the need to enter the parameters (subject to appropriate permissions).