Adobe August Security Update Vulnerability Audit

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%')