Software Inventory 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 Configuration Manager 2007 software inventory views contain information about the files and products that are found on Configuration Manager clients during software inventory scanning. Software inventory, by default, will scan for all executable file types (*.exe) on clients. Which rules are configured on the site and which programs have been installed on the clients will determine which files are inventoried and how much information is collected about each.

Software Inventory View Schema

There is not a specific software inventory schema view, but the following query joins the v_GS_SoftwareProduct and v_FullCollectionMembership views to generate the Software Inventory view schema by product name for the All Systems collection:

SELECT MIN(PRD.ProductID) AS ProductID, PRD.ProductName,

PRD.ProductVersion, COUNT(DISTINCT PRD.ResourceID) AS 'Count'

FROM v_GS_SoftwareProduct PRD INNER JOIN v_FullCollectionMembership FCM

ON PRD.ResourceID = FCM.ResourceID

WHERE FCM.CollectionID = 'SMS00001'

GROUP BY PRD.ProductName, PRD.ProductVersion

ORDER BY PRD.ProductName

Software Inventory Views

Some of the software inventory views created in Configuration Manager store system data, and others contain general product and file data. As a general rule, views that start with the v_GS view name contain data for Configuration Manager clients and can be joined to other views that contain system data by using the ResourceID for that client. Software inventory views that start with v_ contain file and product data, but it is not specific to individual computers. The software inventory views are described in the following table.

Software Inventory View Description

v_GS_CollectedFile

Lists the files, by FileID, collected by software inventory on each Configuration Manager client.

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

v_GS_LastSoftwareScan

Lists the last time each Configuration Manager client was scanned for software inventory.

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

v_GS_Mapped_Add_Remove_Programs

Lists the software applications on each Configuration Manager client that is mapped to Add/Remove programs.

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

v_GS_SoftwareFile

Lists the files and associated products on each Configuration Manager client.

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

v_GS_SoftwareProduct

Lists the products found on each Configuration Manager client.

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

v_GS_UnknownFile

Lists the files that are not associated with an identified product, on each Configuration Manager client.

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

v_ProductFileInfo

Lists all of the distinct files, by FileID, that have been inventoried in the site, including file name, description, file size, file version, and so on.

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

v_SoftwareFile

Lists all of the distinct files, by FileID, that have been inventoried in the site, including file name, file version, description, file size, and associated product.

The view can be joined to other views by using the FileID and ProductID columns.

v_SoftwareProduct

Lists all of the distinct products that have been inventoried in the site.

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

See Also

Concepts

Configuration Manager 2007 SQL Server Views
Software Inventory View Sample Queries