SQL example - Patch Tuesday
This example query returns the vulnerabilities from the latest Microsoft Patch Tuesday.
Start / End Date times will need to be updated monthly.
sql
1SELECT ds.name AS site, da.ip_address, da.host_name, dv.title AS vulnerability_title, dos.description AS operating_system, dos.cpe23FROM fact_asset_vulnerability_finding favf45JOIN dim_asset da USING (asset_id)67JOIN dim_operating_system dos USING (operating_system_id)89JOIN dim_vulnerability dv USING (vulnerability_id)1011JOIN dim_site_asset dsa USING (asset_id)1213JOIN dim_site ds USING (site_id)1415WHERE dv.title LIKE 'Microsoft CVE%'1617AND dv.date_published BETWEEN '2017-04-01 00:00:00' AND '2017-04-30 11:59:59'1819ORDER BY da.ip_address ASC, dv.title ASC
Did this page help you?