Jetzt Ausprobieren

Confluence Vulnerability Audit

Security Software Vulnerability

Run an Audit of All Vulnerable Confluence Installations on your Network

Identify Confluence installations that are vulnerable to the security issue disclosed by the Atlassian security advisory. The audit below provides a color-coded overview of all Confluence on-premise installations and their versions. Versions vulnerable to CVE-2019-3395 will be highlighted so you can easily identify them and take action. Find more info about this exploit in our Confluence vulnerability blog post.

 

Confluence Vulnerability Query

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename As AssetType,
  tblAssets.Username,
  tblAssets.Userdomain,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblSoftwareUni.softwareName As Software,
  tblSoftware.softwareVersion As Version,
  tblSoftwareUni.SoftwarePublisher As Publisher,
  tblSoftware.Lastchanged,
  Case
    When tblSoftware.softwareVersion Like '1.%' Then '#ffadad'
    When tblSoftware.softwareVersion Like '2.%' Then '#ffadad'
    When tblSoftware.softwareVersion Like '3.%' Then '#ffadad'
    When tblSoftware.softwareVersion Like '4.%' Then '#ffadad'
    When tblSoftware.softwareVersion Like '5.%' Then '#ffadad'
    When tblSoftware.softwareVersion Between '6.6.0' And '6.6.11' Then '#ffadad'
    When tblSoftware.softwareVersion Like '6.0.%' Then '#ffadad'
    When tblSoftware.softwareVersion Like '6.1.%' Then '#ffadad'
    When tblSoftware.softwareVersion Like '6.2.%' Then '#ffadad'
    When tblSoftware.softwareVersion Like '6.3.%' Then '#ffadad'
    When tblSoftware.softwareVersion Like '6.4.%' Then '#ffadad'
    When tblSoftware.softwareVersion Like '6.5.%' Then '#ffadad'
    When tblSoftware.softwareVersion Like '6.7.%' Then '#ffadad'
    When tblSoftware.softwareVersion Like '6.8.%' Then '#ffadad'
    When tblSoftware.softwareVersion Like '6.9.%' Then '#ffadad'
    When tblSoftware.softwareVersion Like '6.10.%' Then '#ffadad'
    When tblSoftware.softwareVersion Like '6.11.%' Then '#ffadad'
    When tblSoftware.softwareVersion Between '6.12.0' And '6.12.3' Then
      '#ffadad'
    When tblSoftware.softwareVersion Between '6.13.0' And '6.13.3' Then
      '#ffadad'
    When tblSoftware.softwareVersion Between '6.14.0' And '6.14.2' Then
      '#ffadad'
    Else '#d4f4be'
  End As backgroundcolor
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 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 '%Confluence%' And tblState.Statename =
  'Active'

Show

Hide