SQL query for Site servers and Site Systems

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.