Discovery View Reference
Discovery views consist of system resource objects which include any resources that were discovered on the network. The three main discovery views are v_R_System for system resources, v_R_User for user resources, and v_R_UserGroup for user group resources. Each of these discovered resources has a defined resource type, which is stored in the v_resourcemap schema view.
Resource Schema Information Views
The resource schema information views provide information about all resources in an SMS site. The two resource schema information views are v_ResourceMap and v_ResourceAttributeMap. The v_ResourceMap contains a list of all the resource types for discovered data. By default, SMS has the User Group, User, and System Resource types, each of which has its own resource type number and individual view. The following table represents the default data contained in the v_ResourceMap view.
ResourceType |
DisplayName |
ResourceClassName |
|---|---|---|
3 |
User Group |
v_R_UserGroup |
4 |
User |
v_R_User |
5 |
System |
v_R_System |
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.
SMS 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_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 listed and described in the following table.
Discovery View |
Description |
|---|---|
v_AgentDiscoveries |
Lists all resources that have been discovered in the SMS hierarchy. 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_R_System |
Lists all system resources by ID, type, whether the resource is an SMS client, what type of client, client version, NetBIOS name, operating system, unique identifier, and so forth. The view can be joined to other views by using the ResourceID column. |
v_R_User |
Lists all user resources by ID, type, user name, domain, and so forth. The view can be joined to other views by using the ResourceID column. |
v_R_UserGroup |
Lists all user group resources by ID, type, user group name, domain, and so forth. The view will most often be joined to other views by using the ResourceID column. |
v_RA_System_IPAddresses |
Lists all system resources by resource ID and associated IP addresses. The view can be joined to other views by using the ResourceID column. |
v_RA_System_IPSubnets |
Lists all system resources by resource ID and associated IP subnets. The view can be joined to other views by using the ResourceID column. |
v_RA_System_IPXAddresses |
Lists all system resources by resource ID and associated IPX addresses. The view can be joined to other views by using the ResourceID column. |
v_RA_System_IPXNetworkNumbers |
Lists all system resources by resource ID and associated IPX network numbers (subnets). The view can be joined to other views by using the ResourceID column. |
v_RA_System_MACAddresses |
Lists all system resources by resource ID and associated MAC addresses. The view can be joined to other views by using the ResourceID column. |
v_RA_System_ResourceNames |
Lists all system resources by resource ID and associated non-NetBIOS names. The view can be joined to other views by using the ResourceID column. |
v_RA_System_SMSAssignedSites |
Lists all system resources by resource ID and associated sites in which they are assigned. The view can be joined to other views by using the ResourceID column. |
v_RA_System_SMSInstalledSites |
Lists all system resources by resource ID and associated sites in which they are installed. The view can be joined to other views by using the ResourceID column. |
v_RA_System_SystemContainerName |
Lists all system resources by resource ID and associated containers. The view can be joined to other views by using the ResourceID column. |
v_RA_System_SystemGroupName |
Lists all system resources by resource ID and associated groups. The view can be joined to other views by using the ResourceID column. |
v_RA_System_SystemOUName |
Lists all system resources by resource ID and associated OUs. The view can be joined to other views by using the ResourceID column. |
v_RA_System_SystemRoles |
Lists all system resources by resource ID and associated site system roles (client access point, site server, SQL Server, 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 and associated containers. The view can be joined to other views by using the ResourceID column. |
v_RA_User_UserGroupName |
Lists all user resources by resource ID and associated groups. The view can be joined to other views by using the ResourceID column. |
v_RA_User_UserOUName |
Lists all user resources by resource ID and associated OUs. The view can be joined to other views by using the ResourceID column. |