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. [SSRS 2019 Download Link]
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 pug, 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:
On the Installation Tab, chose "Install SQL Reporting Services" That will launch your browser to: