SQL Query for SCCM - Hierarchy information
This is a very simple SQL query but still very useful and will give you a lot of information about your Configuration Manager hierarchy.

 select * from sites

Run this on your Configuration Manager database server or you can use it to create a custom report using SSRS.

Labels: , ,