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,982  
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: 2  
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 Edit Work Time Enhancements
by  pipapo   Go to last post Go to first unread
Last post: Yesterday at 3:41:25 PM(UTC)
Lansweeper software authorization based on "name" AND "version"
by  deejay3670  
Go to last post Go to first unread
Last post: Yesterday at 2:53:28 PM(UTC)
Lansweeper HP Warranty scan - broken for some products
by  JérômeS   Go to last post Go to first unread
Last post: Yesterday at 2:34:13 PM(UTC)
Lansweeper Helpdesk Report for unresolved tickets
by  Walter  
Go to last post Go to first unread
Last post: Yesterday at 2:08:39 PM(UTC)
Lansweeper Certificate status & end dates
by  Antoine EVRARD   Go to last post Go to first unread
Last post: Yesterday at 1:01:37 PM(UTC)
Lansweeper Assign switch port to location map
by  cycleheat  
Go to last post Go to first unread
Last post: 5/26/2020 5:21:54 PM(UTC)
Lansweeper Email Link back to ticket
by  TruckDriverTurnedIT   Go to last post Go to first unread
Last post: 5/26/2020 5:20:08 PM(UTC)
Lansweeper LSAgent not Scanning or Reporting all Software
by  cycleheat  
Go to last post Go to first unread
Last post: 5/26/2020 4:15:05 PM(UTC)