Hey everybody,
We've released a new
blog post regarding the LibreOffice vulnerability. If you're interested in the specifics, I suggest you give it a read.
The report below will give you a color-coded overview of all Windows and Linux assets in your network that are not on the latest release of LibreOffice and should be updated. Please note that this report will only check whether LibreOffice is on the latest stable version at the time of posting.
The report will list assets that meet the following criteria:
- The asset is a Windows or Linux Asset
- The asset is Active
- The asset has software installed which contains LibreOffice in its name
If you have any feedback on the report, feel free to leave it and I'll take a look at it.
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,
Case
When tblSoftwareUni.softwareName Like '%libreoffice%' And
(tblSoftware.softwareVersion Like '6.0.7%' Or
tblSoftware.softwareVersion Like '6.1.4%') Then '#d4f4be'
Else '#ffadad'
End As backgroundcolor,
tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
tblSoftware.Lastchanged,
Case
When tblSoftwareUni.softwareName Like '%libreoffice%' And
(tblSoftware.softwareVersion not like '6.0.7%' OR tblSoftware.softwareVersion Like '6.1.4%') Then ''
Else 'LibreOffice update recommended'
End As Notes
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 '%LibreOffice%' And tblState.Statename =
'Active'
Union
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,
tblLinuxSystem.OSRelease As OS,
tblAssets.SP,
tblAssets.Lastseen,
tblAssets.Lasttried,
Case
When tblSoftwareUni.softwareName Like '%libreoffice%' And
(tblLinuxSoftware.Version Like '%6.0.7%' Or
tblLinuxSoftware.Version Like '%6.1.4%') Then '#d4f4be'
Else '#ffadad'
End As backgroundcolor,
tblSoftwareUni.softwareName As Software,
tblLinuxSoftware.Version As Version,
tblSoftwareUni.SoftwarePublisher As Publisher,
tblLinuxSoftware.LastChanged,
Case
When tblSoftwareUni.softwareName Like '%libreoffice%' And
(tblLinuxSoftware.Version Like '%6.0.7%' Or
tblLinuxSoftware.Version Like '%6.1.4%') Then ''
Else 'LibreOffice update recommended'
End As Notes
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 tblLinuxSoftware On tblAssets.AssetID = tblLinuxSoftware.AssetID
Inner Join tblSoftwareUni On
tblSoftwareUni.SoftID = tblLinuxSoftware.SoftwareUniID
Inner Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
Where tblSoftwareUni.softwareName Like '%LibreOffice%' And tblState.Statename =
'Active'
Order By Domain,
AssetName,
Software
