Discover All Vulnerable Adobe Software in Your Network
Adobe released its October Security Update which contains multiple vulnerability advisories in October covering Adobe Experience Manager, Adobe Download Manager, Acrobat DC and Acrobat Reader DC. Since Adobe software is frequently used in corporate environments, it is important to keep these software packages up to date to prevent any security risks.
The Adobe Security audit below provides an overview of all your Windows assets if one of the software mentioned in the Adobe October Security Update 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 October security update blog post.
Adobe October Security Vulnerability Audit 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 = '6.3.3.6' And
tblSoftwareUni.softwareName Like 'Adobe Experience Manager%' Then
'Up to date'
When tblSoftware.softwareVersion = '6.4.6.0' And
tblSoftwareUni.softwareName Like 'Adobe Experience Manager%' Then
'Up to date'
When tblSoftware.softwareVersion = '6.5.2.0' And
tblSoftwareUni.softwareName Like 'Adobe Experience Manager%' Then
'Up to date'
When tblSoftwareUni.softwareName Like 'Adobe Experience Manager%' Then
'Out of date'
End As [AEM Status],
Case
When tblSoftware.softwareVersion = '2.0.0.363' And
tblSoftwareUni.softwareName Like 'Adobe Download Manager%' Then
'Up to date'
When tblSoftwareUni.softwareName Like 'Adobe Download Manager%' Then
'Out of date'
End As [Download Manager Status],
Case
When tblSoftware.softwareVersion Like '17.012%' And
tblSoftwareUni.softwareName Like '%Acrobat DC%' Then 'Out of date'
When tblSoftware.softwareVersion Like '15.023%' And
tblSoftwareUni.softwareName Like '%Acrobat DC%' Then 'Out of date'
When tblSoftware.softwareVersion Like '15.020%' And
tblSoftwareUni.softwareName Like '%Acrobat DC%' Then 'Out of date'
When tblSoftware.softwareVersion Like '15.017%' And
tblSoftwareUni.softwareName Like '%Acrobat DC%' Then 'Out of date'
When tblSoftware.softwareVersion Like '15.016%' And
tblSoftwareUni.softwareName Like '%Acrobat DC%' Then 'Out of date'
When tblSoftware.softwareVersion Like '15.010%' And
tblSoftwareUni.softwareName Like '%Acrobat DC%' Then 'Out of date'
When tblSoftware.softwareVersion Like '15.009%' And
tblSoftwareUni.softwareName Like '%Acrobat DC%' Then 'Out of date'
When tblSoftware.softwareVersion Like '15.008%' And
tblSoftwareUni.softwareName Like '%Acrobat DC%' Then 'Out of date'
When tblSoftwareUni.softwareName Like '%Acrobat DC%' And
tblSoftware.softwareVersion Like '19%' And tblSoftware.softwareVersion >=
'19.021.20047' Then 'Up to date'
When tblSoftwareUni.softwareName Like '%Acrobat DC%' And
tblSoftware.softwareVersion Like '17%' And tblSoftware.softwareVersion >=
'17.011.30150' Then 'Up to date'
When tblSoftwareUni.softwareName Like '%Acrobat DC%' And
tblSoftware.softwareVersion Like '15%' And tblSoftware.softwareVersion >=
'15.006.30504' Then 'Up to date'
When tblSoftwareUni.softwareName Like '%Acrobat DC%' Then 'Out of date'
End As [Acrobat DC Status],
Case
When tblSoftware.softwareVersion Like '17.012%' And
tblSoftwareUni.softwareName Like '%Acrobat Reader DC%' Then 'Out of date'
When tblSoftware.softwareVersion Like '15.023%' And
tblSoftwareUni.softwareName Like '%Acrobat Reader DC%' Then 'Out of date'
When tblSoftware.softwareVersion Like '15.020%' And
tblSoftwareUni.softwareName Like '%Acrobat Reader DC%' Then 'Out of date'
When tblSoftware.softwareVersion Like '15.017%' And
tblSoftwareUni.softwareName Like '%Acrobat Reader DC%' Then 'Out of date'
When tblSoftware.softwareVersion Like '15.016%' And
tblSoftwareUni.softwareName Like '%Acrobat Reader DC%' Then 'Out of date'
When tblSoftware.softwareVersion Like '15.010%' And
tblSoftwareUni.softwareName Like '%Acrobat Reader DC%' Then 'Out of date'
When tblSoftware.softwareVersion Like '15.009%' And
tblSoftwareUni.softwareName Like '%Acrobat Reader DC%' Then 'Out of date'
When tblSoftware.softwareVersion Like '15.008%' And
tblSoftwareUni.softwareName Like '%Acrobat Reader DC%' Then 'Out of date'
When tblSoftwareUni.softwareName Like '%Acrobat Reader DC%' And
tblSoftware.softwareVersion Like '19%' And tblSoftware.softwareVersion >=
'19.021.20047' Then 'Up to date'
When tblSoftwareUni.softwareName Like '%Acrobat Reader DC%' And
tblSoftware.softwareVersion Like '17%' And tblSoftware.softwareVersion >=
'17.011.30150' Then 'Up to date'
When tblSoftwareUni.softwareName Like '%Acrobat Reader DC%' And
tblSoftware.softwareVersion Like '15%' And tblSoftware.softwareVersion >=
'15.006.30504' 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 'Adobe Download Manager%')
