Gary Blok

May 9, 2020

Building a CM Lab – SQL Reporting Services (SSRS) [12]

In post 12, we’ll cover reporting.

So you’ve got your CM Server and some clients, now you want to surface that data via reporting. [MS Docs] Sure Power BI is cool, but who has money for that, SSRS is included and there are some pretty nifty free reports in the community.  In this post, we’re going to be installing SSRS 2019, along with getting it configured then installing the Reporting Service Role in ConfigMgr.

If you’re a Recast Enterprise Customer, we have some great dashboards and reporting built in, which makes surfacing the data quite easy, right in the console.  Just a quick shameless plug, because I really like our dashboards. [More Info]

Requirement: SQL Service Account setup in AD (CM_SSRS), in SQL_Admin Group (Which has admin rights to SQL, see the SQL Install Post for more info)

First, I launched the SQL Server Setup from the Start menu:

So now that we’ve Installed SSRS and had it configured, we can add the Reporting Role… so in the CM Console, the Administrator Tab [MS Docs]

So now I’ve waited a bit, had dinner, and came back to check things out..

If you set up the Certificate Authority, you can then add a cert and make this HTTPS… if you want.

‍

‍

Blog Post List

Series Introduction – Building a CM Lab from Scratch

1. Domain Controller – Setting up your Domain Controller
2. Gateway Virtual Machine – Creating a Router for your Lab using Windows Server
3. Certificate Authority – On Domain Controller [Optional]
4. ConfigMgr Server Pre-Reqs (Windows Features)
5. Configuration Settings (AD & GPOs)
6. Source Server (File Share)
7. ConfigMgr SQL Install
8. ConfigMgr Install
9. ConfigMgr Basic Settings
10. ConfigMgr Collections & App Deployment
11. ConfigMgr OSD
12. ConfigMgr Reporting Services

‍

See how Right Click Tools are changing the way systems are managed.

Immediately boost productivity with our limited, free to use, Community Edition.

Get started with Right Click Tools today:

download for free

Related Resources

Building a CM Lab

Building a ConfigMgr Lab- Series Intro

Building a CM Lab

Building a CM Lab – Domain Controller VM [1]

Building a CM Lab

Building a CM Lab – Gateway VM [2]

Building a CM Lab

Building a CM Lab – Certificate Authority [3]

Building a CM Lab

Building a CM Lab – ConfigMgr [MEMCM] Server Pre-Reqs [4]

Building a CM Lab

Building a CM Lab – Configuration Settings (AD / GPO) [5]

Building a CM Lab

Building a CM Lab – ConfigMgr Source Share [6]

Building a CM Lab

Building a CM Lab – ConfigMgr [MEMCM] Installing SQL [7]

Building a CM Lab

Building a CM Lab – ConfigMgr Install [8]

Building a CM Lab

Building a CM Lab – ConfigMgr Settings Setup [9]

Building a CM Lab

Building a CM Lab – ConfigMgr Collections/App Deployments [10]

Building a CM Lab

Building a CM Lab – Operating System Deployment [11]

Building a CM Lab

Building a CM Lab – Cloud Management Gateway (CMG) – Certs PreReq [13]

Building a CM Lab

Building a CM Lab – Cloud Management Gateway (CMG) – Azure Subscription [14]

Building a CM Lab

Building a CM Lab – Azure Services Connection[15]

Building a CM Lab

Building a CM Lab – Setting up CMG in the Console [16]

Building a CM Lab

Building a CM Lab – Cloud Management Gateway (CMG) – Post CMG Config [17]

Building a CM Lab

Building a CM Lab – Cloud Management Gateway – Client CMG Endpoints [18]