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
******************************************************************
******************************************************************
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