Wednesday, July 18, 2018

SCCM report for SCCM site roles and install directory on each server

The following query will provide details of SCCM site roles and install directory on each server;
******************************************************************
SELECT v_Site.ServerName, v_SiteSystemSummarizer.Role, v_Site.InstallDir, v_Site.SiteCode
FROM   v_Site 
INNER JOIN v_SiteSystemSummarizer ON v_Site.SiteCode = v_SiteSystemSummarizer.SiteCode
******************************************************************
More SCCM custom reports can be found here

No comments:

Post a Comment