Adobe August Security Update Vulnerability Audit
Security Software VulnerabilityFind 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%')