Using SQL to list the Site Servers, Roles and Boundaries of the SCCM Hierarchy

Today I was trying to gather a list of all of our site servers and roles.  I then wanted to find out what site servers were protected.  The built in reports the SCCM provides did not have all this information.  That’s OK….as long as we know SQL! — Create Table #One — ( — SiteCode […]