March 31, 2012

SCCM Query to find how many sites have PXE service point enabled?

This report will help to identify all the PXE service point enabled within any SCCM environment.

Select vs.sitecode,vs.sitename,vs.servername,vss.role from v_Site vs, v_SiteSystemSummarizer vss
where vs.SiteCode=vss.SiteCode and
vss.Role like 'SMS PXE Service Point'