Let’s help you with the SCCM Server Details with Roles using SQL custom report. This is very important to get all server details if you have a large environment with 100s of DPs, Secondary servers, and MPs. Also, it’s very useful for SCCM central team.
I am very glad to share one Awesome report created by my former colleagues Robert Spinelli and XiaoDong Zhang. Here is that pretty cool query/report that can help you maintain the inventory of the SCCM hierarchy and can be used as a health check report.
This report will provide you with all the SCCM servers, and the site system roles enabled for all those remote site systems severs. Note that this is the reposting of the previous post. We have a lot of SQL queries available for the community, and some of them are listed below.
- Convert WQL Queries To SQL Queries Using SCCM Trick
- SCCM Report for DotNet Framework Versions
- Create SCCM Report for Visual Studio
- SCCM Dynamic Report Link to Get Specific Application Details
- ConfigMgr Reports Application Package Distribution
Where to check Site System Servers Details in SCCM Console
Well, it’s not a very easy process to get all these details from the SCCM console. You can follow the steps mentioned below to get the details manually.
You can navigate to \Administration\Overview\Site Configuration\Servers and Site System Roles and select the site server or site system server to find out the roles enabled for that particular site system.
You can see all the roles associated with the primary server – Distribution Point, Management Point, Service Connection Point,
SCCM Server Details with Roles
You can get the details of the entire SCCM infra servers using this SQL query, and you can create the custom SCCM report using the RDL file uploaded into the GitHub repository.
Download SQL Query for SCCM Server Infra Details Custom Report
I have uploaded this report to the GitHub repository to be useful to the community to improve it and amend it. You can try to add additional details to the SQL query.
Download the RDL File for SCCM Server Details with Roles Custom Report
I have already uploaded the RDL file for the custom report to get the details about the SCCM servers. You can use the report builder to create the custom report using the RDP file below. More details -> SCCM Create Custom Report Using Report Builder.
Download the RDL file from -> Custom-Report-SCCM-Infra-Server-Details/SCCM Servers With Roles.rdl at main · AnoopCNair/Custom-Report-SCCM-Infra-Server-Details (github.com)
The PXE information looks not functionnal.
Anyway, awesome job, it’s a very powerfull query !
Thank you for the share
Thank you for the report. I have not worked to modify this. This is one of the reasons the solution is in GitHub so that the community can contribute to enhancing it.
Thank you for this. It’s a great script. Can this be run against a single collection?