Software Inventory View Reference
The software inventory views contain information about the files and products that are found on Microsoft Systems Management Server (SMS) clients during software inventory scanning. Software Inventory, by default, will scan for all executable file types (*.exe) on SMS clients. Depending on which rules are configured on the site and which programs have been installed on the SMS, 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
The software inventory views contain information about the files and products that are found on SMS clients during software inventory scanning. During the initial software inventory scan, by default, SMS collects information about all executable (*.exe) file types on SMS clients.
Some of the software inventory views created in SMS 2003 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 SMS 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 listed and described in the following table.
Software Inventory View |
Description |
|---|---|
v_GS_LastSoftwareScan |
Lists the last time each SMS client was scanned for software inventory. The view can be joined to other views by using the ResourceID column. |
v_GS_CollectedFile |
Lists the files collected by software inventory on each SMS client. The view can be joined to other views by using the ResourceID column. |
v_GS_SoftwareFile |
Lists the files and associated products on each SMS client. The view can be joined to other views by using the ResourceID column. |
v_GS_UnknownFile |
Lists the files, which are not associated with an identified product, on each SMS client. The view can be joined other views by using the ResourceID column. |
v_GS_SoftwareProduct |
Lists the products found on each SMS client. The view can be joined to other views by using the ResourceID column. |
v_ProductFileInfo |
Lists all of the distinct files that have been inventoried in the site. Includes some product information. The view can be joined to other views by using the FileID column. |
v_SoftwareFile |
Lists all of the distinct files that have been inventoried in the site. The view can be joined to other views by using the FileID or ProductID column. |
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. |