I am very glad to share one Awesome report created by my colleagues Robert Spinelli and XiaoDong Zhang. Here is that pretty cool query/report that can help you in maintaining the inventory of the SCCM hierarchy and also can be used as a health check report.
The latest Post is available – SCCM Server Details With Roles SQL Custom Report For DP MP SUP HTMD Blog (anoopcnair.com)
A glimpse of the OUTPUT of the query/report.
Custom Report to Get SCCM Site System Server Roles DP MP SUP ConfigMgr
This report will provide you with all the servers and the site system roles they have installed. This report is created in SSRS but also works as a regular ASP web report.
- Download MOF File SCCM Server Details With Roles SQL Custom Report For DP MP SUP HTMD Blog (anoopcnair.com)