Adobe July Security Update Vulnerability Audit

Find All Outdated Adobe Bridge, Adobe Dreamweaver and Adobe Experience Manager Installations

Adobe released multiple vulnerability advisories covering Adobe Bridge, Adobe Dreamweaver and Adobe Experience Manager.  The audit below provides an overview of all your Windows assets and whether they have one of the software installed. Additionally, the report indicates whether the version is up to date or not. You can find more details about the vulnerabilities in our blog post.

Adobe July Security Update

Adobe June 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,
  Bridge.[Bridge CC Status],
  Dreamweaver.[Dreamweaver Status],
  AEM.[AEM Status],
  tblAssets.IPAddress,
  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
  Left Join (Select Top 1000000 tblAssets.AssetID,
        Case
          When tblSoftware.softwareVersion >= '9.0.2' And
            tblSoftwareUni.softwareName Like 'Adobe Bridge CC%' Then
            'Up to date'
          Else 'Out of date'
        End As [Bridge CC Status]
      From tblAssets
        Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
        Inner Join tblState On tblState.State = tblAssetCustom.State
        Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
        Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
        Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
      Where tblSoftwareUni.softwareName Like 'Adobe Bridge CC%' And
        tblState.Statename = 'Active') As Bridge On Bridge.AssetID =
    tblAssets.AssetID
  Left Join (Select Top 1000000 tblAssets.AssetID,
        Case
          When tblSoftware.softwareVersion >= '6.3.3.5' And
            tblSoftwareUni.softwareName Like 'Adobe Experience Manager%' Then
            'Up to date'
          When tblSoftware.softwareVersion >= '6.4.5.0' And
            tblSoftwareUni.softwareName Like 'Adobe Experience Manager%' Then
            'Up to date'
          When tblSoftware.softwareVersion >= '6.5' And
            tblSoftwareUni.softwareName Like 'Adobe Experience Manager%' Then
            'Up to date'
          Else 'Out of date'
        End As [AEM Status]
      From tblAssets
        Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
        Inner Join tblState On tblState.State = tblAssetCustom.State
        Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
        Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
        Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
      Where tblSoftwareUni.softwareName Like 'Adobe Experience Manager%' And
        tblState.Statename = 'Active') As AEM On AEM.AssetID = tblAssets.AssetID
  Left Join (Select Top 1000000 tblAssets.AssetID,
        Case
          When tblSoftware.softwareVersion >= '19.0' And
            tblSoftwareUni.softwareName Like 'Adobe Dreamweaver%' Then
            'Up to date'
          Else 'Out of date'
        End As [Dreamweaver Status]
      From tblAssets
        Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
        Inner Join tblState On tblState.State = tblAssetCustom.State
        Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
        Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
        Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
      Where tblSoftwareUni.softwareName Like 'Adobe Dreamweaver%' And
        tblState.Statename = 'Active') As Dreamweaver On Dreamweaver.AssetID =
    tblAssets.AssetID
Where tsysAssetTypes.AssetTypename = 'Windows' And
  tblState.Statename = 'Active'
Order By Bridge.[Bridge CC Status] desc,
  Dreamweaver.[Dreamweaver Status] desc,
  AEM.[AEM Status] desc

Audit and Take Action in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Audit & Take Action

Download Lansweeper to Run this Audit

Harness the Power of Reporting