Site Administration Views in Configuration Manager
Updated: January 1, 2014
Applies To: System Center 2012 Configuration Manager, System Center 2012 Configuration Manager SP1, System Center 2012 R2 Configuration Manager
The System Center 2012 Configuration Manager site views contain information such as the site code, Configuration Manager version, the location of the SMS provider, site server name, site system names, site boundary information, and more. There are also status views that contain information about sites, site systems, and components. The site and site status views will most often be joined to other views by using the SiteCode or ServerName columns.
The following sections provide detailed information about site views and site status views.
Site Views
The site views contain information about the Configuration Manager site and are described in the following table.
Site view |
Description |
|---|---|
v_BoundarySiteCode |
Lists each boundary in the Configuration Manager hierarchy together with the site code associated with that boundary. This view can be joined to other views by using the BoundaryID column. |
v_BoundarySiteSystems |
BoundaryIDServerNALPathSiteSystemName |
v_Identification |
Lists information about each site in the hierarchy, including site code, site name, Configuration Manager version, Configuration Manager 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_LocalizedNameValue |
Lists the matching English name to the localized name. It is unlikely that this view will be joined to other views. |
v_LocalizedSettingType |
Lists the matching English view setting type with the localized name for the setting type. 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_SITE_CONTROL_MANAGER, and so on. The site code, server name, and Configuration Manager components are listed. The view can be joined to other views by using the SiteCode, MachineName, or ComponentName columns. |
v_Site |
Lists information about each site in the Configuration Manager hierarchy, including site code, site name, site version, site server name, installation directory, and more. The view can be joined to other views by using the SiteCode or ServerName columns. |
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_SupportedPlatforms |
Lists the supported operating systems, including operating system platform, minimum and maximum version, and operating system name. This list is used by a number of Configuration Manager operations. It is unlikely that this view will be joined to other views. |
v_SystemResourceList |
Lists all site system locations for each site in the Configuration Manager 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. |
v_SiteAndSubsites |
List information about each site in the hierarchy, including the site code, site name, site type, build number, site server name and more. This view can be joined to other views by using the SiteCode and ServerName columns. |
Site Status Views
The site status views contain status and status summary information about Configuration Manager components, site servers, site systems, and so on. For more information about the status views, see Status and Alert Views in Configuration Manager. The status views that contain site information are described in the following table.
Site view |
Description |
|---|---|
v_ComponentSummarizer |
Lists summary status information for all Configuration Manager components for different intervals. The view also provides the site code, server name, component name, the count of information, warning, and error messages, and so on. The information in this view contains the same information that is displayed in the Component Status node of the Configuration Manager console, but the view contains information for all display intervals. The value in the Status column provides the current status for the component. A value of 0 indicates that the component is OK, a value of 1 indicates a warning state for the component, and a value of 2 indicates a critical state for the component. The view can be joined to other views by using the SiteCode, MachineName, and ComponentName columns. |
v_ServerMessageStatistics |
Lists the site system servers, the associated site code, when the last heartbeat occurred, and how long the heartbeat took to process. The view can be joined to other views by using the ServerName column. |
v_SiteDetailSummarizer |
Lists status summary information for all Configuration Manager sites, by site code, for different intervals. The view also provides the site name, site version, interval, the count of information, warning, and error messages, and so on. The information in this view contains the same information that is displayed in the Site Status node of the Configuration Manager console, but the view contains information for all display intervals. The view can be joined to other views by using the SiteCode column. The value in the Status column provides the current status for the site. A value of 0 indicates that the site is OK, a value of 1 indicates a warning state for the site, and a value of 2 indicates a critical state for the site. |
v_SiteSystemSummarizer |
Lists status summary information for all Configuration Manager sites systems for different intervals. The view also provides the object location, the site role for the site system, total disk space, free disk space, and percentage of free disk space for the site system, the time of the last status reported, and whether the site system is available. The information in this view contains the same information that is displayed in the Site System Status node of the Configuration Manager console. The view can be joined to other views by using the SiteCode column. |
v_SummarizerSiteStatus |
Lists the site summary status, which is the same status displayed for the <site code> - <site name> node of the Configuration Manager console. The view can be joined to other views by using the SiteCode column. |