SCCM Server Details with Roles SQL Custom Report for DP MP SUP

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.

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.

Patch My PC

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 SQL Custom Report for DP MP SUP
SCCM Server Details with Roles SQL Custom Report for DP MP SUP

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.

SCCM Server Details with Roles SQL Custom Report for DP MP SUP 1
SCCM Server Details with Roles SQL Custom Report for DP MP SUP

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.

Adaptiva
Download SQL Query for SCCM Server Infra Details Custom Report
Download SQL Query for SCCM Server Infra Details Custom Report

Download – > Custom-Report-SCCM-Infra-Server-Details/Query for All SCCM Site Info.txt at main · AnoopCNair/Custom-Report-SCCM-Infra-Server-Details (github.com)

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)

3 thoughts on “SCCM Server Details with Roles SQL Custom Report for DP MP SUP”

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.