REVIEWED by Sophos
A quick and dirty query leveraging curl to get the latest version of Firefox from Mozilla.org and compare to the installed version.
Uses curl a bit too much, but I'm having trouble using "with" clauses and parsing that result, hopefully stay tuned for a slightly more efficient version!
SQL published at https://gist.github.com/andrewmundellsophos/37d5c1626704591c6d8f81969845be4e and below:
--Tested and working as of 2020-07-14
select
version as Current,
(
select
substr(
result,(
(
select
instr(result, 'data-latest-firefox=')
from
curl
where
url = 'https:' || '/' || '/' || 'www.mozilla.org/en-US/firefox/new/'
) + 21
),
6
) as Latest
from
curl
where
url = 'https:' || '/' || '/' || 'www.mozilla.org/en-US/firefox/new/'
) as Latest
from
programs
where
name like '%firefox%'
and version < (
select
substr(
result,(
(
select
instr(result, 'data-latest-firefox=')
from
curl
where
url = 'https:' || '/' || '/' || 'www.mozilla.org/en-US/firefox/new/'
) + 21
),
6
) as Latest
from
curl
where
url = 'https:' || '/' || '/' || 'www.mozilla.org/en-US/firefox/new/'
)
|
