Jetzt Ausprobieren

Adobe October Security Update Vulnerability Audit

Security Software Vulnerability

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

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

Show

Hide