Export (0) Print
Expand All

Asset Intelligence Views

Applies To: System Center Configuration Manager 2007, System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3, System Center Configuration Manager 2007 SP1, System Center Configuration Manager 2007 SP2

The Asset Intelligence views in Configuration Manager 2007 contain information about software applications that are in use throughout the Configuration Manager hierarchy, software license management in the enterprise, Asset Intelligence configuration settings, and so on. The Asset Intelligence information will be retrieved from clients only after the specific reporting classes are enabled in the SMS_DEF.MOF file. By default, the Asset Intelligence reporting classes are disabled, and until the classes are enabled in the SMS_DEF.MOF file and Configuration Manager clients collect hardware inventory, these views will not contain any information. Other Asset Intelligence views contain information from the Asset Intelligence catalog, summary information, and product licensing information. There are external dependencies and dependencies within the product that should be considered before implementing Asset Intelligence or using the SQL views. For information about the Asset Intelligence prerequisites, see Prerequisites for Asset Intelligence in the Configuration Manager Documentation Library (http://go.microsoft.com/fwlink/?LinkId=123467). For the step-by-step procedure for enabling Asset Intelligence, see How to Enable Asset Intelligence in the Configuration Manager Documentation Library (http://go.microsoft.com/fwlink/?LinkId=123296).

The following sections provide detailed information about Asset Intelligence views, Asset Intelligence hardware inventory views, and Asset Intelligence status views.

Asset Intelligence Views

The Asset Intelligence views are described in the following table.

 

Asset Intelligence View Description

v_AI_MVLS

Lists the Microsoft Volume Licensing (MVLS) product pools, by MLSProductPool, and the product family name, version, effective quantity, and unresolved quantity.

It is unlikely that this view will be joined to other views.

noteNote
This view was introduced in Configuration Manager 2007 Service Pack 1 (SP1).

v_AI_NON_MS_LICENSE

Lists the non-Microsoft product license information, including the product name, publisher, version, language, effective quantity, date of purchase, and so on.

It is unlikely that this view will be joined to other views.

noteNote
This view was introduced in Configuration Manager 2007 SP1.

v_AIHinvClass

Lists the Asset Intelligence Windows Management Instrumentation (WMI) classes, by name, and the actual and requested report states. The classes are configured by using the Edit Asset Intelligence Reporting Class Settings action on the Asset Intelligence node in the Configuration Manager console.

It is unlikely that this view will be joined to other views.

noteNote
This view was introduced in Configuration Manager 2007 SP1.

v_AIProxy

Lists proxy information for the Asset Intelligence synchronization point, if one is configured.

It is unlikely that this view will be joined to other views.

noteNote
This view was introduced in Configuration Manager 2007 SP1.

v_CAL_Device

Lists the Configuration Manager clients, by MachineID, where Client Access License (CAL) information is being tracked, as well as the IP address for the client, the computer name, the source computer, and the date the client was last used.

The view can be joined with other views by using the MachineID column, which is the same as the ResourceID column in other views.

v_CAL_DeviceProductSummary

Lists the products, by product name, where CAL information is being tracked, a summary of the number of servers, and the number of Configuration Manager clients that have used the product within 90 days and within one year.

It is unlikely that this view will be joined to other views.

v_CAL_History

Lists a history for products, and a summary for the number of user CALs and device CALs on a specific date.

It is unlikely that this view will be joined to other views.

v_CAL_INSTALLED_SOFTWARE_DATA

Lists information about the installed software applications on Configuration Manager clients found through Asset Intelligence. This view contains the same information as the v_GS_INSTALLED_SOFTWARE view, but it limits the columns displayed.

The view can be joined with other views by using the MachineID column, which is the same as the ResourceID column in other views.

v_CAL_Processor_Count

Lists the number of processors found on Configuration Manager clients. This view uses the same hardware inventory data as the v_GS_PROCESSOR view, but it displays only the count for processors on each system.

The view can be joined with other views by using the MachineID column, which is the same as the ResourceID column in other views.

v_CAL_ThisSiteCode

Lists the site code for the current Configuration Manager site.

It is unlikely that this view will be joined to other views.

v_CAL_User

Lists information about the users found on Configuration Manager clients through Asset Intelligence, including the MachineID and computer name for where the user account was found.

The view can be joined with other views by using the UserName and MachineID columns. The MachineID column is the same as the ResourceID column in other views, and the UserName column is the same as the Unique_User_Name0 in the v_R_User view.

v_CAL_UserProductSummary

Lists the products, by product name, where CAL information is being tracked, a summary of the number of servers, and the number of users that have used the product within 90 days and within one year.

It is unlikely that this view will be joined to other views.

v_CAL_UtilizationPerDevice

Lists the Configuration Manager clients that have been utilized within the last 90 days, including the computer name, IP address for the computer, resource ID for the computer, and date the client was last utilized.

The view can be joined with other views by using the MachineID column, which is the same as the ResourceID column in other views.

v_CAL_UtilizationPerUser

Lists the users, by UserName, that have utilized Configuration Manager clients within the last 90 days, as well as the source computer, resource ID for the computer, and date the client was last utilized.

The view can be joined with other views by using the UserName and MachineID columns. The MachineID column is the same as the ResourceID column in other views, and the UserName column is the same as the Unique_User_Name0 in the v_R_User view.

v_LU_CAL_ProductList

Lists the products, by SoftwareCode, that are being tracked for CALs, as well as the software hash, product category, license type, and when the product license was last updated.

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

v_LU_Category

Lists information about the Asset Intelligence software categories, by category ID and category name, as well as the language ID, description, and whether the category was created locally. The information contained in this view can be displayed and customized from the Software Categories node in the Configuration Manager console.

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

v_LU_Category_Editable

Lists information about the Asset Intelligence software categories, software families, and custom labels, including the category ID, category name, language ID, description, type, whether the category was created locally, and so on. This view contains information that is found in the v_LU_Category, v_LU_Family, and v_LU_Tags views.

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

noteNote
The values in the Type column are defined as follows: 0 = software category, 1 = software family, and 2 = custom label.

This view was introduced in Configuration Manager 2007 SP1.

v_LU_CPU

Lists information about the CPUs known to Asset Intelligence, including the manufacturer, CPU name, whether the CPU is on a mobile device, and so on. The information contained in this view can be displayed from the Processor Properties node in the Configuration Manager console.

The view can be joined to the v_GS_PROCESSOR view by using the CPUHash column.

v_LU_Family

Lists information about the Asset Intelligence software families, by family ID and family name, as well as language ID, description, and whether the family was created locally. The information contained in this view can be displayed and customized from the Software Families node in the Configuration Manager console.

The view can be joined to other views by using the FamilyID column, which is the same as the CategoryID column in the v_LU_Category_Editable view.

v_LU_HardwareReadiness

Lists information about the hardware requirements for specific software applications, including product, minimum CPU, minimum RAM, minimum hard disk size, minimum hard disk free space, and so on. The information contained in this view can be displayed and customized from the Hardware Requirements node in the Configuration Manager console.

It is unlikely that this view will be joined to other views.

v_LU_MSProd

Lists information about the Microsoft products contained in the Asset Intelligence catalog, including part number, family name, product name, version, language, license type, and so on.

It is unlikely that this view will be joined to other views.

v_LU_SoftwareCode

Lists information about the software application codes contained in the Asset Intelligence catalog, as well as the associated software ID and when the software was last updated.

The view can be joined to other Asset Intelligence and hardware inventory views by using the SoftwareCode and SoftwareID columns.

v_LU_SoftwareHash

Lists information about the software applications contained in the Asset Intelligence catalog, by software property hash, including application name, version, publisher, software ID, and when the software was last updated.

The view can be joined to other Asset Intelligence and Asset Intelligence hardware inventory views by using the SoftwarePropertiesHash and SoftwareID columns.

v_LU_SoftwareIdentity_Local_Repl

Lists information about the software applications contained in the Asset Intelligence catalog, by software ID and name, that have a custom software category, custom software family, or custom label. The view also provides the version, publisher, category ID, family ID, label ID, source site, last updated date, and so on. This view contains the same source data as the v_LU_SoftwareList_Local view.

The view can be joined to other Asset Intelligence and Asset Intelligence hardware inventory views by using the SoftwareID, CategoryID, FamilyID, Tag1ID, Tag2ID, Tag3ID, SoftwareCode, and SoftwarePropertiesHash columns.

noteNote
This view was introduced in Configuration Manager 2007 SP1.

v_LU_SoftwareIdentity_Repl

Lists information about the software applications contained in the Asset Intelligence catalog, by software ID and name, including the version, publisher, software category ID, software family ID, custom labels, and so on. The view contains the same source data as the v_SoftwareList view.

The view can be joined to other Asset Intelligence and Asset Intelligence hardware inventory views by using the SoftwareID, CategoryID, FamilyID, Tag1ID, Tag2ID, Tag3ID, SoftwareCode, and SoftwarePropertiesHash columns.

noteNote
This view was introduced in Configuration Manager 2007 SP1.

v_LU_SoftwareList

Lists information about the software applications contained in the Asset Intelligence catalog, by software ID and name, including the version, publisher, software category ID, software family ID, custom labels, and so on. The view contains the same source data as the v_LU_SoftwareIdentity_Repl view, but it updates the software application information with any custom software categories, software families, or custom labels that have been specified.

The view can be joined to other Asset Intelligence and Asset Intelligence hardware inventory views by using the SoftwareID, CategoryID, FamilyID, Tag1ID, Tag2ID, and Tag3ID columns.

v_LU_SoftwareList_Editable

Lists information about the software applications, by software ID and name, where the software category, software family, or custom label can be configured with items from the custom catalog. The view also provides the software code, software properties hash, publisher, version, category name and ID, family name and ID, custom labels, and so on. The information contained in this view can be displayed and customized from the All Inventoried Software Titles node in the Configuration Manager console.

The view can be joined to other Asset Intelligence and Asset Intelligence hardware inventory views by using the SoftwareID, SoftwareCode, SoftwarePropertiesHash, CategoryID, FamilyID, Tag1ID, Tag2ID, and Tag3ID columns.

noteNote
This view was introduced in Configuration Manager 2007 SP1.

v_LU_SoftwareList_Local

Lists information about the software applications contained in the Asset Intelligence catalog, by software ID and name, that have a custom software category, custom software family, or custom label. The view also provides the version, publisher, category ID, family ID, label ID (tag ID), last updated date, and so on. This view contains the same source data as the v_LU_SoftwareIdentity_Local_Repl view.

The view can be joined to other Asset Intelligence and Asset Intelligence hardware inventory views by using the SoftwareID, CategoryID, FamilyID, Tag1ID, Tag2ID, and Tag3ID columns.

noteNote
This view was introduced in Configuration Manager 2007 SP1.

v_LU_SoftwareSignature_Repl

Lists information about the software applications contained in the Asset Intelligence catalog, by software ID. This view combines the information from the v_LU_SoftwareCode and v_LU_SoftwareHash views.

The view can be joined to other Asset Intelligence and Asset Intelligence hardware inventory views by using the SoftwareID, CategoryID, FamilyID, Tag1ID, Tag2ID, Tag3ID, SoftwareCode, and SoftwarePropertiesHash columns.

noteNote
This view was introduced in Configuration Manager 2007 SP1.

v_LU_Tags

Lists information about the Asset Intelligence custom labels, by tag ID and tag name, as well as the language ID and a description. The information contained in this view can be displayed and customized from the Custom Labels node in the Configuration Manager console.

The view can be joined to other views by using the TagID column, which is the same as the CategoryID column in the v_LU_Category_Editable view.

noteNote
This view was introduced in Configuration Manager 2007 SP1.

Asset Intelligence Hardware Inventory Views

The Asset Intelligence hardware inventory views contain information that is retrieved from Configuration Manager client computers using hardware inventory. For more information about the hardware inventory views, see Hardware Inventory Views. The hardware inventory views that contain Asset Intelligence information are described in the following table.

 

Asset Intelligence View Description

v_GS_AUTOSTART_SOFTWARE

Lists information about the applications on Configuration Manager clients that start automatically with the operating system found through Asset Intelligence.

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

v_GS_BROWSER_HELPER_OBJECT

Lists information about the browser objects found on Configuration Manager clients through Asset Intelligence. While some browser helper objects are beneficial, most software considered "malware" is in the form of browser helper objects.

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

v_GS_INSTALLED_EXECUTABLE

Lists information about the installed software application executables on Configuration Manager clients found through Asset Intelligence.

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

v_GS_INSTALLED_SOFTWARE

Lists information about the installed software applications on Configuration Manager clients found through Asset Intelligence.

The view can be joined with other views by using the ResourceID column and with Asset Intelligence views by using the SoftwareCode0 and SoftwarePropertiesHash0 columns.

v_GS_INSTALLED_SOFTWARE_CATEGORIZED

Lists information about the installed software applications on Configuration Manager clients found through Asset Intelligence. This view contains the information in the v_GS_INSTALLED_SOFTWARE view and joins several other tables to provide additional details about the installed software.

The view can be joined with other views by using the ResourceID column and with Asset Intelligence views by using the SoftwareCode0, SoftwarePropertiesHash0, FamilyID, CategoryID, and SoftwareID columns.

v_GS_INSTALLED_SOFTWARE_MS

Lists information about the installed Microsoft software applications on Configuration Manager clients found through Asset Intelligence.

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

v_GS_SOFTWARE_LICENSING_PRODU

Lists software licensing product information for Microsoft Vista Configuration Manager clients found through Asset Intelligence.

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

v_GS_SOFTWARE_LICENSING_SERVI

Lists software licensing service information for Microsoft Vista Configuration Manager clients found through Asset Intelligence.

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

v_GS_SOFTWARE_SHORTCUT

Lists software shortcut information for Configuration Manager clients found through Asset Intelligence.

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

v_GS_SYSTEM_CONSOLE_USAGE

Lists all system console usage information for Configuration Manager clients found through Asset Intelligence by polling the System Security Event Log.

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

v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP

Lists all system console usage information for Configuration Manager clients found through Asset Intelligence by polling the System Security Event Log. This view contains a subset of information from the v_GS_SYSTEM_CONSOLE_USAGE view.

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

v_GS_SYSTEM_CONSOLE_USER

Lists all system console user information for Configuration Manager clients found through Asset Intelligence by polling the System Security Event Log.

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

v_GS_USB_DEVICE

Lists information about the USB devices found on Configuration Manager clients through Asset Intelligence.

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

Asset Intelligence Status View

The Asset Intelligence status view contains summary information about the software applications on Configuration Manager clients. For more information about status views, see Status Views. The status view that contains Asset Intelligence information is described in the following table.

 

Asset Intelligence View Description

v_INSTALLED_SOFTWARE_DATA_Summary

Lists the count of the installed software applications on Configuration Manager clients found through Asset Intelligence. This view contains the same source information as the v_GS_INSTALLED_SOFTWARE view, but it provides summary information instead of listing the individual system resources.

It is unlikely that this view will be joined to other views.

noteNote
This view was introduced in Configuration Manager 2007 SP1.

See Also

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft