Find All Vulnerable Adobe Vulnerability Software in Your Network
Adobe released multiple vulnerability advisories in August covering After Effects, Prelude, Photoshop, Premiere Pro Character Animator, Adobe Experience Manager, Acrobat DC and Acrobat Reader DC. The audit below provides an overview of all your Windows assets if one of the software has been found on a machine that has an Adobe vulnerability, it will indicate whether the software is up to date or needs updating. You can find more details about the different vulnerabilities in the Adobe August security update blog post.
Adobe August Security Vulnerability Query
Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As AssetType,
tblAssets.Username,
tblAssets.Userdomain,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
Case
When tblSoftware.softwareVersion = '16.1.2' And
tblSoftwareUni.softwareName Like 'Adobe After Effects CC 2019%' Then
'Up to date'
When tblSoftwareUni.softwareName Like 'Adobe After Effects CC 2019%' Then 'Out of date'
End As [After Effects CC 2019 Status],
Case
When tblSoftware.softwareVersion = '2.1.1' And
tblSoftwareUni.softwareName Like 'Adobe Character Animator CC 2019%'
Then 'Up to date'
When tblSoftwareUni.softwareName Like 'Adobe Character Animator CC 2019%' Then 'Out of date'
End As [Character Animator CC 2019 Status],
Case
When tblSoftware.softwareVersion = '13.1.3' And
tblSoftwareUni.softwareName Like 'Adobe Premiere Pro CC 2019%' Then
'Up to date'
When tblSoftwareUni.softwareName Like 'Adobe Premiere Pro CC 2019%' Then 'Out of date'
End As [Premiere Pro CC 2019 Status],
Case
When tblSoftware.softwareVersion = '8.1.1' And
tblSoftwareUni.softwareName Like 'Adobe Prelude CC 2019%' Then
'Up to date'
When tblSoftwareUni.softwareName Like 'Adobe Prelude CC 2019%' Then 'Out of date'
End As [Prelude CC 2019 Status],
Case
When (tblSoftware.softwareVersion = '19.1.9' Or
tblSoftware.softwareVersion = '20.0.6') And
tblSoftwareUni.softwareName Like '%Photoshop CC%' Then 'Up to date'
When tblSoftwareUni.softwareName Like '%Photoshop CC%' Then 'Out of date'
End As [Photoshop CC Status],
Case
When tblSoftware.softwareVersion = '6.4.5.0' And
tblSoftwareUni.softwareName Like 'Adobe Experience Manager%' Then
'Check for Installed Hotfix 30379'
When tblSoftware.softwareVersion = '6.5.1.0' And
tblSoftwareUni.softwareName Like 'Adobe Experience Manager%' Then
'Check for Installed Hotfix 30379'
When tblSoftwareUni.softwareName Like 'Adobe Experience Manager%' Then 'Out of date'
End As [AEM Status],
Case
When tblSoftwareUni.softwareName Like '%Acrobat DC%' And
tblSoftware.softwareVersion Like '19%' And
tblSoftware.softwareVersion >= '19.012.20036' Then 'Up to date'
When tblSoftwareUni.softwareName Like '%Acrobat DC%' And
tblSoftware.softwareVersion Like '17%' And
tblSoftware.softwareVersion >= '17.011.30144' Then 'Up to date'
When tblSoftwareUni.softwareName Like '%Acrobat DC%' And
tblSoftware.softwareVersion Like '15%' And
tblSoftware.softwareVersion >= '15.006.30499' Then 'Up to date'
When tblSoftwareUni.softwareName Like '%Acrobat DC%' Then 'Out of date'
End As [Acrobat DC Status],
Case
When tblSoftwareUni.softwareName Like '%Acrobat Reader DC%' And
tblSoftware.softwareVersion Like '19%' And
tblSoftware.softwareVersion >= '19.012.20036' Then 'Up to date'
When tblSoftwareUni.softwareName Like '%Acrobat Reader DC%' And
tblSoftware.softwareVersion Like '17%' And
tblSoftware.softwareVersion >= '17.011.30144' Then 'Up to date'
When tblSoftwareUni.softwareName Like '%Acrobat Reader DC%' And
tblSoftware.softwareVersion Like '15%' And
tblSoftware.softwareVersion >= '15.006.30499' Then 'Up to date'
When tblSoftwareUni.softwareName Like '%Acrobat Reader DC%' Then 'Out of date'
End As [Acrobat Reader DC Status],
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblState On tblState.State = tblAssetCustom.State
Where tsysAssetTypes.AssetTypename = 'Windows' And tblState.Statename = 'Active'
and (tblSoftwareUni.softwareName Like '%Acrobat Reader DC%'
OR tblSoftwareUni.softwareName Like '%Acrobat DC%'
OR tblSoftwareUni.softwareName Like 'Adobe Experience Manager%'
OR tblSoftwareUni.softwareName Like '%Photoshop CC%'
OR tblSoftwareUni.softwareName Like 'Adobe Prelude CC 2019%'
OR tblSoftwareUni.softwareName Like 'Adobe Premiere Pro CC 2019%'
OR tblSoftwareUni.softwareName Like 'Adobe Character Animator CC 2019%'
OR tblSoftwareUni.softwareName Like 'Adobe After Effects CC 2019%')