Combined Vulnerability Report Q1 2019

[Esben_D]

This report will provide an overview of the vulnerability updates we released in Q1 of 2019. If your asset has software on it which had a vulnerability we reported on in Q1, it will display whether that software is up-to-date (enough to fix the vulenrability) or not.

This report checks for the following vulnerabilities:

• PuTTY
  
• Winrar
  
• Google Chrome
  
• LibreOffice

Select Distinct Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename As AssetType,
  tblAssets.Username,
  tblAssets.Userdomain,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
    s1.PuTTY,
  s2.Winrar,
  s3.Chrome,
  s4.LibreOffice,
  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 tblState On tblState.State = tblAssetCustom.State
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Left Join (Select Top 1000000 tblAssets.AssetID,
        Case
          When tblSoftware.softwareVersion < '0.71.0.0' Then 'Outdated'
          Else 'Up to date'
        End As PuTTY
      From tblAssets
        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 '%putty%') As s1 On
    s1.AssetID = tblAssets.AssetID
  Left Join (Select Top 1000000 tblAssets.AssetID,
        Case
          When tblSoftware.softwareVersion < '5.70' Then 'Outdated'
          Else 'Up to date'
        End As Winrar
      From tblAssets
        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 '%winrar%') As s2 On
    s2.AssetID = tblAssets.AssetID
  Left Join (Select Top 1000000 tblAssets.AssetID,
        Case
          When tblSoftware.softwareVersion Like '74%' Then
            'Up to date'
          Else 'Outdated'
        End As Chrome
      From tblAssets
        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 '%Google Chrome%'
      Union
      Select Top 1000000 tblAssets.AssetID,
        Case
          When tblMacApplications.Version Like '74%' Then
            'Up to date'
          Else 'Outdated'
        End As Chrome
      From tblAssets
        Inner Join tblMacApplications On tblAssets.AssetID =
          tblMacApplications.AssetID
        Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
          tblMacApplications.softid
        Inner Join tblMacOSInfo On tblMacOSInfo.AssetID = tblAssets.AssetID
      Where tblSoftwareUni.softwareName Like '%Google Chrome%'
      Union
      Select Top 1000000 tblAssets.AssetID,
        Case
          When tblLinuxSoftware.Version Like '74%' Then
            'Up to date'
          Else 'Outdated'
        End As Chrome
      From tblAssets
        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 '%google-chrome%') As s3 On
    s3.AssetID = tblAssets.AssetID
  Left Join (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 tblSoftwareUni.softwareName Like '%libreoffice%' And
            tblSoftware.softwareVersion <= '6.1.4%' Then 'Outdated'
          Else 'Up to date'
        End As LibreOffice
      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,
        tblSoftwareUni.softwareName As Software,
        tblLinuxSoftware.Version As Version,
        tblSoftwareUni.SoftwarePublisher As Publisher,
        tblLinuxSoftware.LastChanged,
        Case
          When tblSoftwareUni.softwareName Like '%libreoffice%' And
            tblLinuxSoftware.Version <= '%6.0.7%' Then 'Outdated'
          Else 'Up to date'
        End As Libreoffice
      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'
      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,
        tblMacOSInfo.SystemVersion As OS,
        tblAssets.SP,
        tblAssets.Lastseen,
        tblAssets.Lasttried,
        tblSoftwareUni.softwareName As Software,
        tblMacApplications.Version As Version,
        tblSoftwareUni.SoftwarePublisher As Publisher,
        tblMacApplications.LastChanged,
        Case
          When tblSoftwareUni.softwareName Like '%libreoffice%' And
            tblMacApplications.Version <= '6.1.4%' Then 'Outdated'
          Else 'Up to date'
        End As Libreoffice
      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 tblMacApplications On tblAssets.AssetID =
          tblMacApplications.AssetID
        Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
          tblMacApplications.softid
        Inner Join tblMacOSInfo On tblMacOSInfo.AssetID = tblAssets.AssetID
      Where tblSoftwareUni.softwareName Like '%LibreOffice%' And
        tblState.Statename = 'Active') As s4 On s4.AssetID = tblAssets.AssetID
Where tsysAssetTypes.AssetTypename In ('Windows', 'Linux', 'Mac') And
  tblState.Statename = 'Active'
Order by tblAssets.Domain,
tblAssets.AssetName