Site View Sample Queries
The following sample query demonstrates how the site views can be joined to other site views.
Joining Site Views
The following query lists the IP subnets defined for each site in the SMS hierarchy. The site code, site server name, and IP subnet are listed.
SELECT v_Site.SiteCode, v_Site.ServerName, SIP.IPSubnet
FROM v_Site INNER JOIN v_SiteBoundary_IPSubnet SIP
ON v_Site.SiteCode = SIP.SiteCode
ORDER BY v_Site.SiteCode, SIP.IPSubnet