Site View Reference
There is no official site view classification, but because several views contain information directly related to sites in the SMS hierarchy, they have been grouped together and will be referred to as the site views.
Site Views
The site views contain information such as site code, SMS version, SMS provider location, site server name, site system names, site boundary information, and so forth. These views contain information that may be useful individually, but it is not likely that they will need to be joined to other views to get additional information. Many of the views can be joined to other views by using the SiteCode or ServerName columns if necessary, but others in this category do not have a column that can be associated to another view. The site views are listed and described in the following table.
Site View |
Description |
|---|---|
v_Identification |
Lists information about each site in the SMS hierarchy including site code, site name, SMS version, SMS build number, service account name, where the SMS provider is located, site server name, and language. The view can be joined to other views by using the ThisSiteCode column. |
v_LocalizedNameLookup |
Lists the matching English view column names to a string resource in a resource DLL that contains the localized version of the name. It is unlikely that this view will be joined to other views. |
v_ServerComponents |
Lists the components for each site, such as SMS_EXECUTIVE, SMS_SCHEDULER, and so on. The site code, machine name, and SMS component are listed. The view can be joined to other views by using the SiteCode column. |
v_Site |
Lists information about each site in the SMS hierarchy including site code, site name, reporting site code, site version, site server name, installation directory, and so on. The view can be joined to other views by using the SiteCode column. |
v_SiteBoundary_ADSite |
Lists all AD sites defined in the site boundaries for all sites in the SMS hierarchy. This view can be joined to other views by using the SiteCode column. |
v_SiteBoundary_IPSubnet |
Lists all IP subnets defined in the site boundaries for all sites in the SMS hierarchy. This view can be joined to other views by using the SiteCode column. |
v_SiteRoamingBoundary_ADSite |
Lists all AD sites defined in the site roaming boundaries for all sites in the SMS hierarchy and whether the AD site is local or remote. Remote boundaries will have a DownloadExecute value of 1. This view can be joined to other views by using the SiteCode column. |
v_SiteRoamingBoundary_IPRange |
Lists all IP ranges defined in the site roaming boundaries for all sites in the SMS hierarchy and indicates whether the IP range is local or remote. Remote boundaries will have a DownloadExecute value of 1. This view can be joined to other views by using the SiteCode column. |
v_SiteRoamingBoundary_IPSubnet |
Lists all IP subnets defined in the site roaming boundaries for all sites in the SMS hierarchy and indicates whether the IP subnet is local or remote. Remote boundaries will have a DownloadExecute value of 1. This view can be joined to other views by using the SiteCode column. |
v_SoftwareConversionRules |
Lists all software inventory names that are to be converted to a standard name. For example, software that is inventoried with the manufacturer name of Microsoft or Microsoft Corp. is converted to a display name of Microsoft Corporation. It is unlikely that this view will be joined to other views. |
v_SystemResourceList |
Lists all site system locations for each site in the SMS hierarchy. The NAL path, resource type, site code, site system role name, and site system computer name are listed. The view can be joined to other views by using the SiteCode, ServerName, or NALPath columns. |