The following query lists all computers that have Microsoft Office installed and have less than 1 GB of free space on the local C drive.
#Sample manager software software#
Joining software inventory, discovery, and hardware inventory views ��ON SYS.ResourceID = SP.ResourceID INNER JOIN v_GS_SoftwareFile SF
SELECT DISTINCT SP.ProductName, SF.FileNameįROM v_R_System SYS INNER JOIN v_GS_SoftwareProduct SP The v_R_System and v_GS_SoftwareProduct views are joined by using the ResourceID column, and the v_GS_SoftwareProduct and v_GS_SoftwareFile views are joined by using the ProductID columns. The following query lists all inventoried products and the associated files for a computer with the NetBIOS name of COMPUTER1. Joining software inventory and discovery views WHERE SP.ProductName = 'Configuration Manager' SELECT DISTINCT SF.FileName, SF.FileDescription, SF.FileVersionįROM v_GS_SoftwareProduct SP INNER JOIN v_GS_SoftwareFile SF The v_GS_SoftwareProduct and v_GS_SoftwareFile views are joined by using the ProductID columns. The following query lists all software files for the Configuration Manager product that have been inventoried on Configuration Manager clients. The software inventory views are typically joined to other views by using the ProductID, FileID, and ResourceID columns. The following sample queries demonstrate how the Configuration Manager software inventory views can be joined to other views to retrieve specific data.
0 kommentar(er)
