Notification

Icon
Error

Google Chrome 75 Security Update

Posted: Wednesday, June 5, 2019 2:09:26 PM(UTC)
Esben.D

Esben.D

Member Administration Original PosterPosts: 1,676
1
Like
With the release of Chrome 75, Google also unveiled multiple CVEs and security fixes that are included. For an overview of what security related issues were fixed, you can head over to our blog post.

Similar to our previous Google Chrome vulnerability reports, this report provides a color-coded overview of all Google Chrome installations in your network and indicated whether they are on version 75 or not.

Instructions to run this report can be found here: https://www.lansweeper.c...How-to-run-a-report.aspx

Code:
Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename As AssetType,
  tblAssets.Username,
  tblAssets.Userdomain,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
    tblSoftwareUni.softwareName As Software,
  tblSoftware.softwareVersion As Version,
  tblSoftwareUni.SoftwarePublisher As Publisher,
      Case
    When tblSoftware.softwareVersion LIKE '75%' Then 'Up to date'
    Else 'Out of date'
  End As [Patch Status],
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblSoftware.Lastchanged,
  Case
    When tblSoftware.softwareVersion LIKE '75%' Then '#d4f4be'
    Else '#ffadad'
  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 '%Google Chrome%' 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,
    tblSoftwareUni.softwareName As Software,
  tblMacApplications.Version As Version,
  tblSoftwareUni.SoftwarePublisher As Publisher,
      Case
    When tblMacApplications.Version LIKE '75%' Then 'Up to date'
    Else 'Out of date'
  End As [Patch Status],
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblMacOSInfo.SystemVersion As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblMacApplications.LastChanged,
  Case
    When tblMacApplications.Version LIKE '75%' Then '#d4f4be'
    Else '#ffadad'
  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 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%' 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,
    tblSoftwareUni.softwareName As Software,
  tblLinuxSoftware.Version As Version,
  tblSoftwareUni.SoftwarePublisher As Publisher,
        Case
    When tblLinuxSoftware.Version LIKE '75%' Then 'Up to date'
    Else 'Out of date'
  End As [Patch Status],
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblLinuxSystem.OSRelease As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblLinuxSoftware.LastChanged,
  Case
    When tblLinuxSoftware.Version LIKE '75%' Then '#d4f4be'
    Else '#ffadad'
  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 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%' And tblState.Statename =
  'Active'
Order By Domain,
  AssetName,
  Software
nnewton
#1nnewton Member Posts: 10  
posted: 6/12/2019 5:19:44 AM(UTC)
If anyone is looking for a better way to do version number criteria, I am using this:

Code:

                   CASE
                       WHEN LEN(Replace(tblSoftware.softwareVersion,' ','.'))-LEN(Replace(Replace(tblSoftware.softwareVersion,' ','.'),'.','')) <= 3
                       THEN CASE
                                WHEN REVERSE(PARSENAME(REVERSE(Replace(tblSoftware.softwareVersion,' ','.')),1)) < 75
                                     OR (REVERSE(PARSENAME(REVERSE(Replace(tblSoftware.softwareVersion,' ','.')),1)) = 75
                                         AND REVERSE(PARSENAME(REVERSE(Replace(tblSoftware.softwareVersion,' ','.')),2)) = 0
                                         AND REVERSE(PARSENAME(REVERSE(Replace(tblSoftware.softwareVersion,' ','.')),3)) < 3770)
                                     OR (REVERSE(PARSENAME(REVERSE(Replace(tblSoftware.softwareVersion,' ','.')),1)) = 75
                                         AND REVERSE(PARSENAME(REVERSE(Replace(tblSoftware.softwareVersion,' ','.')),2)) = 0
                                         AND REVERSE(PARSENAME(REVERSE(Replace(tblSoftware.softwareVersion,' ','.')),3)) = 3770
                                         AND REVERSE(PARSENAME(REVERSE(Replace(tblSoftware.softwareVersion,' ','.')),4)) < 80)
                                THEN 'Vulnerable'
                                ELSE 'Safe'
                            END
                       ELSE 'Unknown'
                   END AS Vulnerablity,


The 1/2/3/4 near the end of the lines is the segment of the version number you want to look at, it will only work with version numbers with up to 4 version parts. In my testing, it should also work if there is text after the version number, e.g.: "1.2.3.4 beta"

This particular example flags anything with a version less than 75.0.3770.80 as vulnerable.

I'm using this on SQL Server 2014 Standard, so YMMV on other versions.

Credit to this Stack Overflow post for the idea: https://stackoverflow.co...ee-columns-by-deliminter
stanislav.tsenkov
#2stanislav.tsenkov Member Posts: 2  
posted: 6/12/2019 11:48:55 AM(UTC)
Hi. This is report with vulnerable assets only.


Code:
Select Top 1000000 *
From (Select Top 1000000 tblAssets.AssetID,
        tblAssets.AssetName,
        tblAssets.Domain,
        tsysAssetTypes.AssetTypename As AssetType,
        tblAssets.Username,
        tblAssets.Userdomain,
        tsysAssetTypes.AssetTypeIcon10 As icon,
        tblAssets.IPAddress,
        tblSoftwareUni.softwareName As Software,
        tblSoftware.softwareVersion As Version,
        tblSoftwareUni.SoftwarePublisher As Publisher,
        Case
          When tblSoftware.softwareVersion Like '75%' Then 'Up to date'
          Else 'Out of date'
        End As Patch_Status,
        tsysIPLocations.IPLocation,
        tblAssetCustom.Manufacturer,
        tblAssetCustom.Model,
        tsysOS.OSname As OS,
        tblAssets.SP,
        tblAssets.Lastseen,
        tblAssets.Lasttried,
        tblSoftware.Lastchanged,
        Case
          When tblSoftware.softwareVersion Like '75%' Then '#d4f4be'
          Else '#ffadad'
        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 '%Google Chrome%' 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,
        tblSoftwareUni.softwareName As Software,
        tblMacApplications.Version As Version,
        tblSoftwareUni.SoftwarePublisher As Publisher,
        Case
          When tblMacApplications.Version Like '75%' Then 'Up to date'
          Else 'Out of date'
        End As Patch_Status,
        tsysIPLocations.IPLocation,
        tblAssetCustom.Manufacturer,
        tblAssetCustom.Model,
        tblMacOSInfo.SystemVersion As OS,
        tblAssets.SP,
        tblAssets.Lastseen,
        tblAssets.Lasttried,
        tblMacApplications.LastChanged,
        Case
          When tblMacApplications.Version Like '75%' Then '#d4f4be'
          Else '#ffadad'
        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 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%' 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,
        tblSoftwareUni.softwareName As Software,
        tblLinuxSoftware.Version As Version,
        tblSoftwareUni.SoftwarePublisher As Publisher,
        Case
          When tblLinuxSoftware.Version Like '75%' Then 'Up to date'
          Else 'Out of date'
        End As Patch_Status,
        tsysIPLocations.IPLocation,
        tblAssetCustom.Manufacturer,
        tblAssetCustom.Model,
        tblLinuxSystem.OSRelease As OS,
        tblAssets.SP,
        tblAssets.Lastseen,
        tblAssets.Lasttried,
        tblLinuxSoftware.LastChanged,
        Case
          When tblLinuxSoftware.Version Like '75%' Then '#d4f4be'
          Else '#ffadad'
        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 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%' And
        tblState.Statename = 'Active') a
Where a.Patch_Status = 'Out of date'
Order By a.Domain,
  a.AssetName,
  a.Software

Active Discussions

Lansweeper Changing/Editing tblComputerSystem.DomainRole
by  Brian.Kintech   Go to last post Go to first unread
Last post: Today at 7:23:33 PM(UTC)
Lansweeper Insert custom report into database
by  mc_connected  
Go to last post Go to first unread
Last post: Today at 3:46:06 PM(UTC)
Lansweeper LsAgent deployment problem
by  krejar   Go to last post Go to first unread
Last post: Today at 3:45:41 PM(UTC)
Lansweeper Static Text block for tickets...
by  Jay29  
Go to last post Go to first unread
Last post: Today at 2:41:29 PM(UTC)
Lansweeper Local Workstation and or User Profile Size
by  Argon0   Go to last post Go to first unread
Last post: Today at 10:03:10 AM(UTC)
Lansweeper Suggestions for SonicWall Setup
by  AZHockeyNut  
Go to last post Go to first unread
Last post: Yesterday at 3:32:33 PM(UTC)
Lansweeper Spare Hard Drives
by  AZHockeyNut   Go to last post Go to first unread
Last post: Yesterday at 3:20:40 PM(UTC)
Lansweeper Add Document as File Link
by  AZHockeyNut  
Go to last post Go to first unread
Last post: Yesterday at 3:18:49 PM(UTC)