Find all instances of a particular file by its distinct Version number (e.g. "FileVersion" property). In this example, I'm looking for what versions of Sysinternals' PsExec.exe are in the environment, and how many instances were found for each version.
[Begin T-SQL]
SELECT DISTINCT
[ExecutableName0],[FileVersion0], COUNT(*) AS QTY
FROM [dbo].[v_GS_INSTALLED_EXECUTABLE]
WHERE ExecutableName0 = 'psexec.exe'
GROUP BY ExecutableName0, FileVersion0
ORDER BY FileVersion0
[End T-SQL]
Tuesday, August 26, 2014
SCCM Database Queries: Find Executable Files by Name, Version and Install Count
Labels:
database,
inventory,
reports,
sccm,
sql,
sysinternals,
system center
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment