Thought I'd blog this as an Aide mémoire more than anything.
Determine which Site Systems are present in the Hierarchy
select distinct ServerName as SiteSystems from v_SystemResourceList where servername not in (select servername from v_site)
Notice that I'm referencing views and not tables here which is good practice when querying an SMS\ConfigMgr database.
Powered by Zimbra