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 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
