This query will return to you a brief overview of your SMS site hierarchy including child and parent relations as well as your current site status.
SQL Query:
Select
SiteServer 'Server Name',
SiteName 'Site Name',
SiteCode 'Site Code',
'Parent Site Code' = Case
When ReportToSite = '' Then '<None>'
Else ReportToSite
End,
Version 'Site Version',
'Site Type' = Case
When sitetype = 1 then 'Secondary'
Else 'Primary'
'Current Status' = Case
When status = 1 then 'Active'
When status = 2 then 'Pending'
When status = 3 then 'Failed'
When status = 4 then 'Deleted'
Else 'Upgrade'
End
From Sites
No Comments