In today’s article, we’ll look at Configuration Manager query for Adobe Apps. How did this come about?
I spent some time today working through a query that would gather what applications that I had in my environment which were from Adobe. I worked through the existing reports and couldn’t find anything that would give me the results for all Adobe applications for a specific collection and would provide that information down to the file level.
The following is the results which can be pasted into a report (add a parameter for Collection so it will prompt for the collection). So if you are looking for a starting point to get your Adobe apps listed from SCCM try this one:
v_R_System_Valid.Netbios_Name0 AS “Netbios Name”,
v_GS_INSTALLED_EXECUTABLE.ExecutableName0 AS “File Name”,
v_GS_INSTALLED_EXECUTABLE.Product0 AS “File Description”,
“File Version” = CASE when (v_GS_INSTALLED_EXECUTABLE.Product0 is NULL or v_GS_INSTALLED_EXECUTABLE.Product0 = ‘-1’) then ‘Unknown’
Else v_GS_INSTALLED_EXECUTABLE.Product0 End,
“File Size” = CASE when (v_GS_INSTALLED_EXECUTABLE.FileSize0 IS NULL or v_GS_INSTALLED_EXECUTABLE.FileSize0 = ‘-1’) then ‘Unknown’
Else v_GS_INSTALLED_EXECUTABLE.FileSize0 End,
“Modified Date” = CASE when (v_GS_INSTALLED_EXECUTABLE.TimeStamp is NULL ) then ‘Unknown’
Else CAST(v_GS_INSTALLED_EXECUTABLE.TimeStamp as varchar)End,
“File Path” = CASE when (v_GS_INSTALLED_EXECUTABLE.InstalledFilePath0 IS NULL or v_GS_INSTALLED_EXECUTABLE. InstalledFilePath0= ‘-1’) then ‘Unknown’
Else v_GS_INSTALLED_EXECUTABLE. InstalledFilePath0 End
INNER JOIN v_R_System_Valid
on v_R_System_Valid.ResourceID = v_GS_INSTALLED_EXECUTABLE.ResourceID
INNER JOIN v_FullCollectionMembership
on v_R_System_Valid.ResourceID= v_FullCollectionMembership.ResourceID
Where Product0 like ‘Adobe%’
and v_FullCollectionMembership.CollectionID = @Collection
order by v_GS_INSTALLED_EXECUTABLE.Product0, ‘File Version’
Big thanks to Weston and Julian for working with me on this!