I am trying to get the version info for a particular file installed on a lot of my workstations. I have the following set up to be inventoried via Software Inventory: [cid:[email protected]]
When I run a SQL query against the v_GS_Installed_Software view for the product name I get a count of 628 machines. (This is the correct count.) When I then run a SQL query against the v_GS_SoftwareFile view to get the file version the count is only 185. Why are the counts different? Do I need to inventory for the specific file in this case? For reference I have attached the two queries. Thanks! [cid:[email protected]] Ken Lutz Senior Systems Administrator Information Systems Department Spokane County 815 N. Jefferson Spokane, Washington 99260
<<inline: image001.png>>
<<inline: image002.png>>
File version query:
Select
SYS.Name0 As 'Computer Name'
,SYS.User_Name0 As 'Last User ID'
,'Department ID' = dbo.fn_ISD_OUString(Distinguished_Name0)
,SFile.FileName As 'File Name'
,SFile.FileVersion As 'File Version'
,SFile.FilePath As 'File Path'
from v_R_System SYS
Join v_GS_SoftwareFile SFile on SFile.ResourceID = sys.ResourceID
where
SFile.FileName = 'AEX32.exe'
--and
--(SFile.FilePath = 'C:\PRCTCP\' or SFile.FilePath =
'C:\PRCTCPCAD\')
Order by sfile.[FileVersion], 'department id'
Installed Application query:
SELECT
SYS.Name0 as 'Computer Name'
,'Department ID' = dbo.fn_ISD_OUString(Distinguished_Name0)
,SF.ARPDisplayName0 as 'Installed Software'
,SF.InstallDate0
--,SF.InstalledLocation0
,SF.ProductVersion0
FROM v_GS_INSTALLED_SOFTWARE SF
join
v_R_System SYS on SYS.ResourceID = SF.ResourceID
where
SF.ARPDisplayName0 like '%ApplicationXtender Desk%'
Order by 'Department ID', 'Computer Name'
