For anyone who runs Cisco ASA’s and want to check if any of your devices are affected and the uptime then you can run these queries in mysql:
All devices with affected version, shows uptime:
select hostname, (uptime/86400) as uptime from devices where os='asa' and version IN ('9.1(7)11','9.1(7)12','9.1(7)13','9.1(7)15','9.1(7)9','9.2(4)15','9.2(4)17','9.2(4)18','9.4(3)11','9.4(3)12','9.4(3)6','9.4(3)8','9.4(4)','9.4(4)2','9.5(3)','9.5(3)1','9.5(3)2','9.5(3)6','9.6(2)1','9.6(2)11','9.6(2)13','9.6(2)2','9.6(2)3','9.6(2)4','9.6(2)7','9.6(3)','9.7(1','9.7(1)2');
Only devices with the affected version and an uptime of over 200 days:
select hostname, (uptime/86400) as uptime from devices where os='asa' and version IN ('9.1(7)11','9.1(7)12','9.1(7)13','9.1(7)15','9.1(7)9','9.2(4)15','9.2(4)17','9.2(4)18','9.4(3)11','9.4(3)12','9.4(3)6','9.4(3)8','9.4(4)','9.4(4)2','9.5(3)','9.5(3)1','9.5(3)2','9.5(3)6','9.6(2)1','9.6(2)11','9.6(2)13','9.6(2)2','9.6(2)3','9.6(2)4','9.6(2)7','9.6(3)','9.7(1','9.7(1)2') AND uptime > 17280000;