Security updates available for Adobe Acrobat and Reader | APSB18-09

[caverna]

Hi guys, this is my suggestion to report this vulnerability described at https://helpx.adobe.com/security/products/acrobat/apsb18-09.html

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblSoftwareUni.softwareName As Software,
  tblSoftware.softwareVersion As Version,
  tblSoftwareUni.SoftwarePublisher As Publisher,
  tblSoftware.Lastchanged
From tblAssets
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On (
    tblSoftwareUni.SoftID = tblSoftware.softID And (
      (tblSoftwareUni.softwareName Like '%Acrobat Reader%' Or tblSoftwareUni.softwareName Like '%Acrobat%') And 
      tblSoftwareUni.softwareName Not Like '%Extended Asian%' And 
      tblSoftwareUni.softwareName Not Like '%Acrobat.com%' And 
      tblSoftwareUni.softwareName Not Like '%MUI%'
    )
  )
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where
  tblAssetCustom.State = 1 And
  Convert(Int,replace (tblSoftware.softwareVersion,'.','')) <= 1801120038
Order By
  tblAssets.Domain,
  tblAssets.AssetName,
  Software

based on: https://www.lansweeper.com/forum/yaf_postst16153_7-Zip-Arbitrary-Code-Execution-Vulnerability-Check.aspx
updated according to Sylvie suggestion!

[Esben_D]

Thank you for sharing!