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:

Select distinct

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

FROM v_GS_INSTALLED_EXECUTABLE

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!