SELECT SiteCode, SiteName, Version, ServerName FROM sms_siteandsubsites

Result: