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.

Note
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.

Note
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.

Note
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.

Note
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.

Note
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.

Note
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.

Note
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.

Note
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.

Note
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.

Note
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.

Note
This view was introduced in Configuration Manager 2007 SP1.

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.

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.

Note
This view was introduced in Configuration Manager 2007 SP1.