We’re currently experiencing a high volume of support requests, which may result in longer response times — thank you for your patience and understanding.
Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Ben-rutherford
Engaged Sweeper II

Good morning
Here is a report for the zero day security update addressing: The vulnerability in question is CVE-2025-13223 (CVSS score: 8.8), a type confusion vulnerability in the V8 JavaScript and WebAssembly engine that could be exploited to achieve arbitrary code execution or program crashes.

This will show any devices running a version of chrome that is below version: 142.0.7444.175/.176 to enable you to prioritise updating those affected. 

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename As AssetType,
  tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  Software.softwareName As Software,
  Software.softwareVersion As Version,
  Software.SoftwarePublisher As Publisher,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  Coalesce(tsysOS.OSname, tblSccmAsset.OsCaption,
  tblSccmAsset.OperatingSystemNameandVersion) As OS,
  tblAssets.Version As OSVersion,
  Case
    When tblErrors.ErrorText Is Not Null Or
      tblErrors.ErrorText != '' Then
      'Scanning Error: ' + tsysasseterrortypes.ErrorMsg
    Else ''
  End As ScanningErrors,
  tblAssets.Lastseen As [Last successful scan],
  tblAssets.Lasttried As [Last scan attempt]
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 (Select tblsoftware.assetid,
      tblSoftwareUni.softwareName,
      tblsoftware.softwareVersion,
      Case
        When tblSoftwareUni.softwareName Like '%Google Chrome%' And
          ((Cast(ParseName(tblsoftware.softwareVersion, 4) As int) < 142) Or
          (Cast(ParseName(tblsoftware.softwareVersion, 4) As int) = 142 And
          Cast(ParseName(tblsoftware.softwareVersion, 2) As int) < 7444) Or
          (Cast(ParseName(tblsoftware.softwareVersion, 4) As int) = 142 And
          Cast(ParseName(tblsoftware.softwareVersion, 2) As int) = 7444 And
          Cast(ParseName(tblsoftware.softwareVersion, 1) As int) < 175)) Then 1
        Else 0
      End As [out of date],
      tblSoftwareUni.SoftwarePublisher
    From tblsoftware
      Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblsoftware.softID
    Where tblSoftwareUni.softwareName Like '%Google Chrome%' And
      tblSoftwareUni.SoftwarePublisher Like '%Google%') As Software On
      Software.AssetID = tblAssets.AssetID
  Left Outer Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Left Outer Join tblSccmAsset On tblAssets.AssetID = tblSccmAsset.AssetId
  Left Join (Select Distinct Top 1000000 tblErrors.AssetID As ID,
      Max(tblErrors.Teller) As ErrorID
    From tblErrors
    Group By tblErrors.AssetID) As ScanningError On tblAssets.AssetID =
      ScanningError.ID
  Left Join tblErrors On ScanningError.ErrorID = tblErrors.Teller
  Left Join tsysasseterrortypes On tsysasseterrortypes.Errortype =
      tblErrors.ErrorType
Where Software.softwareName Like '%Google Chrome%' And
  Software.SoftwarePublisher Like '%Google%' And tblState.Statename = 'Active'
  And Software.[out of date] = 1
Union
Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename As AssetType,
  tblAssets.Username,
  tblAssets.Userdomain,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  Software.softwareName As Software,
  Software.Version As Version,
  Software.SoftwarePublisher As Publisher,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblMacOSInfo.SystemVersion As OS,
  tblAssets.Version As OSVersion,
  Case
    When tblErrors.ErrorText Is Not Null Or
      tblErrors.ErrorText != '' Then
      'Scanning Error: ' + tsysasseterrortypes.ErrorMsg
    Else ''
  End As ScanningErrors,
  tblAssets.Lastseen As [Last successful scan],
  tblAssets.Lasttried As [Last scan attempt]
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 (Select tblMacApplications.assetid,
      tblSoftwareUni.softwareName,
      tblMacApplications.Version,
      Case
        When tblSoftwareUni.softwareName Like '%Google Chrome%' And
          ((Cast(ParseName(tblMacApplications.Version, 4) As int) < 142) Or
          (Cast(ParseName(tblMacApplications.Version, 4) As int) = 142
          And Cast(ParseName(tblMacApplications.Version, 2) As int) < 7444) Or
          (Cast(ParseName(tblMacApplications.Version, 4) As int) = 142
          And Cast(ParseName(tblMacApplications.Version, 2) As int) = 7444 And
          Cast(ParseName(tblMacApplications.Version, 1) As int) < 175)) Then 1
        Else 0
      End As [out of date],
      tblSoftwareUni.SoftwarePublisher
    From tblMacApplications
      Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
          tblMacApplications.softid
    Where tblSoftwareUni.softwareName Like '%Google Chrome%') As Software On
      Software.AssetID = tblAssets.AssetID
  Inner Join tblMacOSInfo On tblMacOSInfo.AssetID = tblAssets.AssetID
  Left Join (Select Distinct Top 1000000 tblErrors.AssetID As ID,
      Max(tblErrors.Teller) As ErrorID
    From tblErrors
    Group By tblErrors.AssetID) As ScanningError On tblAssets.AssetID =
      ScanningError.ID
  Left Join tblErrors On ScanningError.ErrorID = tblErrors.Teller
  Left Join tsysasseterrortypes On tsysasseterrortypes.Errortype =
      tblErrors.ErrorType
Where Software.softwareName Like '%Google Chrome%' And tblState.Statename =
  'Active' And Software.[out of date] = 1
Union
Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename As AssetType,
  tblLinuxUser.UserName,
  tblAssets.Userdomain,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  subquery1.Software,
  subquery1.Version,
  subquery1.Publisher,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblLinuxSystem.OSRelease As OS,
  tblAssets.Version As OSVersion,
  Case
    When tblErrors.ErrorText Is Not Null Or
      tblErrors.ErrorText != '' Then
      'Scanning Error: ' + tsysasseterrortypes.ErrorMsg
    Else ''
  End As ScanningErrors,
  tblAssets.Lastseen As [Last successful scan],
  tblAssets.Lasttried As [Last scan attempt]
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 tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
  Inner Join tblLinuxUser On tblAssets.AssetID = tblLinuxUser.AssetID
  Inner Join tblLinuxUserLogon On tblLinuxUserLogon.Id = tblLinuxUser.id
  Inner Join (Select tblLinuxUser.AssetId,
      Max(tblLinuxUserLogon.LogonTime) As MaxLogontime
    From tblLinuxUser
      Inner Join tblLinuxUserLogon On tblLinuxUserLogon.Id = tblLinuxUser.id
    Group By tblLinuxUser.assetid) As subquery2 On subquery2.MaxLogontime =
      tblLinuxUserLogon.LogonTime
  Inner Join (Select tblSoftwareUni.softwareName As Software,
      tblSoftwareUni.SoftwarePublisher As Publisher,
      tblLinuxSoftware.LastChanged,
      tblLinuxSoftware.assetid,
      Case
        When tblLinuxSoftware.Version Like '%-%' Then
          Left(tblLinuxSoftware.Version, CharIndex('-',
          tblLinuxSoftware.Version) - 1)
        When tblLinuxSoftware.Version Like '%R%' Then
          Left(tblLinuxSoftware.Version, CharIndex('R',
          tblLinuxSoftware.Version) - 1)
        Else tblLinuxSoftware.Version
      End As Version
    From tblLinuxSoftware
      Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
          tblLinuxSoftware.SoftwareUniID
    Where tblSoftwareUni.softwareName = 'google-chrome-stable') As subquery1 On
      subquery1.assetid = tblAssets.assetid
  Left Join (Select Distinct Top 1000000 tblErrors.AssetID As ID,
      Max(tblErrors.Teller) As ErrorID
    From tblErrors
    Group By tblErrors.AssetID) As ScanningError On tblAssets.AssetID =
      ScanningError.ID
  Left Join tblErrors On ScanningError.ErrorID = tblErrors.Teller
  Left Join tsysasseterrortypes On tsysasseterrortypes.Errortype =
      tblErrors.ErrorType
Where subquery1.Software = 'google-chrome-stable' And tblState.Statename =
  'Active' And ((Cast(ParseName(subquery1.Version, 4) As int) < 142) Or
    (Cast(ParseName(subquery1.Version, 4) As int) = 142 And
      Cast(ParseName(subquery1.Version, 2) As int) < 7444) Or
    (Cast(ParseName(subquery1.Version, 4) As int) = 142 And
      Cast(ParseName(subquery1.Version, 2) As int) = 7444 And
      Cast(ParseName(subquery1.Version, 1) As int) < 175))
Order By Domain,
  AssetName,
  Software



1 REPLY 1
Obi_1_Cinobi
Lansweeper Tech Support
Lansweeper Tech Support

Hello there!

Thanks for sharing! Awesome job!

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now