Notification

Icon
Error

Mozilla Firefox Remote Execution Vulnerability (improved) - Mozilla Firefox Remote Execution Vulnerability CVE-2018-12386 and CVE-2018-12387

Posted: Tuesday, November 6, 2018 6:15:36 PM(UTC)
Sylvie

Sylvie

Member Original PosterPosts: 14
1
Like
Hello,

I need to follow the Mozilla Firefox CVE-2018-12386 and CVE-2018-12387 remote execution vulnerabilities.

Unfortunately, the report provided by Charles.X at Mozilla Firefox Remote Execution Vulnerability - Announcements - Lansweeper only mark as "green" the 2 Firefox versions '62.0.3' and '60.2.2'.

If we got newer versions, they are marked as "red" even if the vulnerabilities are fixed and if we have older versions, they are also marked as "red" even if they are not affected by this vulnerabilities.

So here is my "improved" report Angel


Code:

SELECT TOP 1000000
       tblAssets.AssetID
      ,tblAssets.AssetName
      ,tblAssets.Domain
      ,tsysAssetTypes.AssetTypename AS AssetType
      ,tblAssets.Username
      ,tblAssets.Userdomain
      ,tsysAssetTypes.AssetTypeIcon10 AS icon
      ,tblAssets.Lastseen
      ,tblAssets.Lasttried
      ,tblSoftwareUni.softwareName AS Software
      ,AllPlatformsSoftwares.softwareVersion AS Version
      ,'backgroundcolor' = 
       CASE WHEN tblSoftwareUni.softwareName like '%ESR%' THEN
            CASE
            WHEN CAST('/' + AllPlatformsSoftwares.softwareVersion + '/' AS HIERARCHYID) < CAST('/60.2.0/' AS HIERARCHYID) THEN '#ff8300'
            WHEN CAST('/' + AllPlatformsSoftwares.softwareVersion + '/' AS HIERARCHYID) >= CAST('/60.2.2/' AS HIERARCHYID) THEN '#d4f4be'
            ELSE '#ffadad'
            END
        ELSE
            CASE
            WHEN CAST('/' + AllPlatformsSoftwares.softwareVersion + '/' AS HIERARCHYID) < CAST('/62.0/' AS HIERARCHYID) THEN '#ff8300'
            WHEN CAST('/' + AllPlatformsSoftwares.softwareVersion + '/' AS HIERARCHYID) >= CAST('/62.0.3/' AS HIERARCHYID) THEN '#d4f4be'
            ELSE '#ffadad'
            END
      END
     ,'vulnerability' = 
       CASE WHEN tblSoftwareUni.softwareName like '%ESR%' THEN
            CASE
            WHEN CAST('/' + AllPlatformsSoftwares.softwareVersion + '/' AS HIERARCHYID) < CAST('/60.2.0/' AS HIERARCHYID) THEN 'older'
            WHEN CAST('/' + AllPlatformsSoftwares.softwareVersion + '/' AS HIERARCHYID) >= CAST('/60.2.2/' AS HIERARCHYID) THEN 'fixed'
            ELSE 'vulnerable'
            END
        ELSE
            CASE
            WHEN CAST('/' + AllPlatformsSoftwares.softwareVersion + '/' AS HIERARCHYID) < CAST('/62.0/' AS HIERARCHYID) THEN 'older'
            WHEN CAST('/' + AllPlatformsSoftwares.softwareVersion + '/' AS HIERARCHYID) >= CAST('/62.0.3/' AS HIERARCHYID) THEN 'fixed'
            ELSE 'vulnerable'
            END
      END
      ,tblSoftwareUni.SoftwarePublisher AS Publisher
      ,AllPlatformsSoftwares.Lastchanged
      ,tblAssets.IPAddress
      ,tsysIPLocations.IPLocation
      ,tblAssetCustom.Manufacturer
      ,tblAssetCustom.Model
      ,AllPlatformsOS.OSname AS OS
      ,tblAssets.SP
      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 (  SELECT [AssetID]
                    ,[softID]
                    ,CASE WHEN CHARINDEX(' ',[softwareVersion])>0 THEN LEFT([softwareVersion],CHARINDEX(' ',[softwareVersion],0)-1) ELSE [softwareVersion] END AS softwareVersion
                    ,[Lastchanged]
                FROM [lansweeperdb].[dbo].[tblSoftware]
              UNION
              SELECT [AssetID]
                    ,[softid]
                    ,CASE WHEN CHARINDEX(' ',[Version])>0 THEN LEFT([Version],CHARINDEX(' ',[Version],0)-1) ELSE [Version] END
                    ,[LastChanged]
                FROM [lansweeperdb].[dbo].[tblMacApplications]
              UNION
              SELECT [AssetID]
                    ,[SoftwareUniID]
                    ,CASE WHEN CHARINDEX(' ',[Version])>0 THEN LEFT([Version],CHARINDEX(' ',[Version],0)-1) ELSE [Version] END
                    ,[LastChanged]
                FROM [lansweeperdb].[dbo].[tblLinuxSoftware]) AllPlatformsSoftwares ON tblAssets.AssetID = AllPlatformsSoftwares.AssetID AND COALESCE(AllPlatformsSoftwares.softwareVersion,'') <> ''
INNER JOIN tblSoftwareUni ON tblSoftwareUni.SoftID = AllPlatformsSoftwares.softID
LEFT JOIN (   SELECT [AssetID]
                    ,[Caption] as 'OSname'
                FROM [lansweeperdb].[dbo].[tblOperatingsystem]
              UNION
              SELECT [AssetID]
                    ,[SystemVersion]
                FROM [lansweeperdb].[dbo].[tblMacOSInfo]
              UNION
              SELECT [AssetID]
                    ,[OSRelease]
                FROM [lansweeperdb].[dbo].[tblLinuxSystem]) AllPlatformsOS ON tblAssets.AssetID = AllPlatformsOS.AssetID
WHERE tblSoftwareUni.softwareName LIKE '%Mozilla Firefox%' AND
      tblState.Statename = 'Active'
ORDER BY Domain,
         AssetName,
         Software


Regards,

Sylvie

Esben.D
#1Esben.D Member Administration Posts: 1,738  
posted: 11/9/2018 11:32:14 AM(UTC)
Very nice Applause Thanks!

One side note, this might not work on SQL Compact. So if anyone tries running this on SQL Compact and you get an error, that would be why ;)
jerry@netrush.com
#2jerry@netrush.com Member Posts: 1  
posted: 11/15/2018 7:01:56 PM(UTC)
I get an error on line 58; is that what you're talking about?
Saulo Benigno
#3Saulo Benigno Member Posts: 7  
posted: 3/1/2019 5:57:00 PM(UTC)
Same error here

Line 58

Active Discussions

Lansweeper Pushing Packages in Multi-Domain Trusted Environment
by  SPedraza   Go to last post Go to first unread
Last post: Yesterday at 5:43:05 PM(UTC)
Lansweeper Lansweeper Not Saving New Asset
by  Terry1337  
Go to last post Go to first unread
Last post: Yesterday at 3:52:51 PM(UTC)
Lansweeper Email configuration
by  Ian.Prentice   Go to last post Go to first unread
Last post: Yesterday at 3:14:04 PM(UTC)
Lansweeper InTune Scanning not showing all devices
by  TBRIT  
Go to last post Go to first unread
Last post: Yesterday at 3:12:03 PM(UTC)
Lansweeper Unique Custom Fields
by  Hendrik.VE   Go to last post Go to first unread
Last post: Yesterday at 11:52:35 AM(UTC)
Lansweeper Uptime incorrect
by  alfiet  
Go to last post Go to first unread
Last post: Yesterday at 10:53:33 AM(UTC)
Lansweeper Lansweeper Remote Screenshot Folder
by  Esben.D   Go to last post Go to first unread
Last post: Yesterday at 10:24:31 AM(UTC)
Lansweeper Lansweeper Enterprise optional?
by  Esben.D  
Go to last post Go to first unread
Last post: Yesterday at 10:00:22 AM(UTC)