Share via


Discovery Views in Configuration Manager

 

Updated: April 1, 2014

Applies To: System Center 2012 Configuration Manager, System Center 2012 Configuration Manager SP1, System Center 2012 R2 Configuration Manager

The Configuration Manager discovery views consist of system resource objects, which include any resources that were discovered on the network. The four main discovery views are v_R_System for system resources, v_R_User for user resources, v_R_UserGroup for user group resources, and v_R_UnknownSystem for unknown systems.

Each of these discovered resources has a defined resource type, which is stored in the v_resourcemap schema view.

Discovery Schema Views

The discovery schema views provide information about all resources in a Configuration Manager site. The two discovery schema views are v_ResourceMap and v_ResourceAttributeMap. The v_ResourceMap view contains a list of all the resource types for discovered data. By default, Configuration Manager has the Unknown System, User Group, User, and System Resource types, each of which has its own resource type number and individual view. The view can be joined to other views by using the ResourceType column. The following table contains the default data stored in the v_ResourceMap view.

v_R_System_Valid

Lists information about valid computers. This view is sorted by ResourceID and includes the client version, the processor type, the client’s domain, the NetBIOS name, the operating system and more.

This view can be joined to other views by using the ResourceID column.

Resource type

Display name

Resource Class Name

2

Unknown System

v_R_UnknownSystem

3

User Group

v_R_UserGroup

4

User

v_R_User

5

System

v_R_System

6

IP Network

V_R_IPNetwork

The v_ResourceAttributeMap contains all of the attributes that will be discovered for each of the resource types, such as NetBIOS name, operating system, user name, user group name, domain name, and so forth. The v_ResourceAttributeMap view can be joined to other views by using the ResourceType column. The discovery schema views are also listed and described in the Schema Views in Configuration Manager topic.

Configuration Manager Discovery Views

The v_R_System view can be joined with any other view that contains system data (system discovery array views, inventory views, collection views, status views, and so forth) by using the ResourceID column. The v_R_System view will be one of the most often used when joining views. The v_R_UnknownSystem, v_R_User, and v_R_UserGroup views also use the ResourceID column to join with views that contain data for their resource type. Most of the remaining discovery views contain data where there can be more than one value for a resource, such as IP address or user organizational unit (OU) name. The discovery views are described in the following table.

Discovery view

Description

v_AgentDiscoveries

Lists all resources that have been discovered in the Configuration Manager hierarchy and by what discovery agent. The view contains data about the resource type, resource ID, agent that discovered the resource, site code where the agent resides, and time of the discovery.

The view can be joined to other views by using the ResourceID column.

v_ClientMachines

Lists all discovered system resources, by resource ID, that are not in an obsolete or decommissioned state and whether the system resource is a Configuration Manager client.

The view can be joined to other views by using the ResourceID column.

v_ClientMode

Lists all discovered system resources, by resource ID, that are not in an obsolete or decommissioned state and the associated client mode.

The view can be joined to other views by using the ResourceID column.

v_R_System

Lists all discovered system resources by resource ID, resource type, whether the resource is a client, what type of client, client version, NetBIOS name, user name, operating system, unique identifier, and more.

The view can be joined to other views by using the ResourceID, ResourceType, Netbios_Name0, and SMS_Unique_Identifier0 columns.

v_RA_System_SMS_Resident

Lists the resident site of discovered devices.

The view can be joined to other views by using the ResourceID column.

v_R_System_Valid

Lists all discovered system resources that are not in an obsolete or decommissioned state. This view is a subset of the v_R_System view and includes the resource ID, resource type, whether the resource is a client, what type of client, client version, NetBIOS name, user name, operating system, unique identifier, and so forth.

The view can be joined to other views by using the ResourceID, ResourceType, and Netbios_Name0 columns.

v_R_UnknownSystem

Lists all unknown system resources that have been discovered, including resource ID, resource type, user name, domain, and so forth.

The view can be joined to other views by using the ResourceID, ResourceType, and SMS_Unique_Identifier0 columns.

v_R_User

Lists all discovered user resources by resource ID, resource type, user name, domain, and so forth.

The view can be joined to other views by using the ResourceID, ResourceType, and Unique_User_Name0 columns.

v_R_UserGroup

Lists all disovered user group resources by ID, type, user group name, domain, and more.

The view can be joined to other views by using the ResourceID and ResourceType columns.

v_RA_System_IPAddresses

Lists the IP addresses for discovered system resources.

The view can be joined to other views by using the ResourceID column.

v_RA_System_IPSubnets

Lists the IP subnets for discovered system resources.

The view can be joined to other views by using the ResourceID column.

v_RA_System_IPv6Addresses

Lists the IPv6 addresses for discovered system resources.

The view can be joined to other views by using the ResourceID column.

v_RA_System_IPv6Prefixes

Lists the IPv6 prefixes for discovered system resources.

The view can be joined to other views by using the ResourceID column.

v_RA_System_IPXAddresses

Lists the IPX addresses for discovered system resources.

The view can be joined to other views by using the ResourceID column.

v_RA_System_MACAddresses

Lists the MAC addresses for discovered system resources.

The view can be joined to other views by using the ResourceID column.

v_RA_System_ResourceNames

Lists all discovered system resources by resource ID and fully qualified domain name.

The view can be joined to other views by using the ResourceID column.

v_RA_System_SMSAssignedSites

Lists all system resources, by resource ID, that are assigned to a site, together with the site code.

The view can be joined to other views by using the ResourceID column.

v_RA_System_SMSInstalledSites

Lists all system resources, by resource ID that have been installed as clients and the site code they belong to.

The view can be joined to other views by using the ResourceID column.

v_RA_System_SystemContainerName

Lists all system resources, by resource ID, that are in an associated Active Directory container.

The view can be joined to other views by using the ResourceID column.

v_RA_System_SystemGroupName

Lists all system resources, by resource ID, that are in an associated Active Directory group.

The view can be joined to other views by using the ResourceID column.

v_RA_System_SystemOUName

Lists all system resources, by resource ID, that and their associated Active Directory OU.

The view can be joined to other views by using the ResourceID column.

v_RA_System_SystemRoles

Lists all system resources, by resource ID, that have an associated site system role (site server, management point, software update point, and so forth).

The view can be joined to other views by using the ResourceID column.

v_RA_User_UserContainerName

Lists all user resources, by resource ID, that are in an associated Active Directory container.

The view can be joined to other views by using the ResourceID column.

v_RA_User_UserGroupName

Lists all user resources, by resource ID, that are in an associated Active Directory group.

The view can be joined to other views by using the ResourceID column.

v_RA_User_UserOUName

Lists all user resources, by resource ID, that are in an associated OU.

The view can be joined to other views by using the ResourceID column.

v_R_IPNetwork

Lists information about IP subnets discovered by Configuration Manager network discovery, sorted by ResourceID. This includes information about subnet addresses, masks, names and topology.

This view can be joined to other views by using the ResourceID column.