How to Launch ConfigMgr Reports | SCCM | Default Reports

by

Let’s check how to Launch ConfigMgr Reports. How many of you use these SCCM default reports related to Hardware, asset Intelligence, or Software Updates? Some of the out-of-the-box reports are not relevant from my perspective.

ConfigMgr has many built-in reports covering many reporting and troubleshooting tasks you might want to do. You can also use the SQL statements in these reports to help you write ConfigMgr custom reports.

Reporting in ConfigMgr provides tools and resources that help you with out-of-box reports, and these reports help with troubleshooting as well.

How to Launch ConfigMgr Reports – Video Tutorial

The following video is a quick tip about launching ConfigMgr Reports from the console and web portal.

Patch My PC
How to Launch ConfigMgr Reports | SCCM | Default Reports – Video 1

Requirements

Ensure you have all the following to access the ConfigMgr default reports.

  • Reporting Services Point is installed.
  • SSRS reports are working fine.
  • Ensure you have appropriate permissions to launch reports from the Console and SSRS URL.

Launch ConfigMgr Reports from the Console

Let’s learn how to launch default reports from the console.

  • Navigate to \Monitoring\Overview\Reporting\Reports.
  • Sort the reports by Category.
  • Right-click on the Report “Administration Activity Log“.
  • Select the RUN option.
How to Launch ConfigMgr Reports | SCCM | Default Reports - Fig.1
How to Launch ConfigMgr Reports | SCCM | Default Reports – Fig.1

Some of the reports might take more time to get loaded. In the background, it runs a SQL query against SCCM DB and presents you with the requested report.

  • You can wait until the loading screen goes away.
How to Launch ConfigMgr Reports | SCCM | Default Reports - Fig.2
How to Launch ConfigMgr Reports | SCCM | Default Reports – Fig.2

This report shows the log of administrative changes made for administrative users, security roles, security scopes, and collections.

How to Launch ConfigMgr Reports | SCCM | Default Reports - Fig.3
How to Launch ConfigMgr Reports | SCCM | Default Reports – Fig.3

Filter Options of SCCM Reports

Various filter options are available for default SCCM reports. You can filter the reports based on your requirements.

  • Filter report based on Administrative Users.
  • Click on Values.
  • Select the Admin user Anoop from the popup window.
  • Click OK to continue.
How to Launch ConfigMgr Reports | SCCM | Default Reports - Fig.4
How to Launch ConfigMgr Reports | SCCM | Default Reports – Fig.4

Click on the Values hyperlink Values from the Type filter of the report. Select Administrative User.

  • Click the OK button to continue.
How to Launch ConfigMgr Reports | SCCM | Default Reports - Fig.5
How to Launch ConfigMgr Reports | SCCM | Default Reports – Fig.5

Click on the Values hyperlink Values from the Date Range filter of the report.

  • Select During the last 90 days.
  • Click the OK button to continue.
How to Launch ConfigMgr Reports | SCCM | Default Reports - Fig.6
How to Launch ConfigMgr Reports | SCCM | Default Reports – Fig.6

Results

Let’s check the results of the report. Click on the View Report button to get the results.

How to Launch ConfigMgr Reports | SCCM | Default Reports - Fig.7
How to Launch ConfigMgr Reports | SCCM | Default Reports – Fig.7

Launch Report in Browser

You can run the SCCM reports in the browser.

  • Navigate to \Monitoring\Overview\Reporting\Reports.
  • Select the Administration activity log.
    • Click on the Run in Browser button from the ribbon menu.
How to Launch ConfigMgr Reports | SCCM | Default Reports - Fig.8
How to Launch ConfigMgr Reports | SCCM | Default Reports – Fig.8

URL – http://REPORTING_Server_Name/ReportServer/Pages/ReportViewer.aspx?%2fConfigMgr_MEM%2fAdministrative+Security%2fAdministration+activity+log&rs:Command=Render

    How to Launch ConfigMgr Reports | SCCM | Default Reports - Fig.9
    How to Launch ConfigMgr Reports | SCCM | Default Reports – Fig.9

    Resources

    We are on WhatsApp. To get the latest step-by-step guides and news updates, Join our Channel. Click here –HTMD WhatsApp.

    Author

    Anoop C Nair is Microsoft MVP! He is a Device Management Admin with more than 20 years of experience (calculation done in 2021) in IT. He is a Blogger, Speaker, and Local User Group HTMD Community leader. His primary focus is Device Management technologies like SCCM 2012, Current Branch, and Intune. He writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc.

    Leave a Comment