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.
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'
