Skip to content

Instantly share code, notes, and snippets.

@jfrantz1-r7

jfrantz1-r7/recent-vulnerabilities

Created October 5, 2018 13:33
Show Gist options
  • Save jfrantz1-r7/f4a1b2176618d504e88b6a875ef9f991 to your computer and use it in GitHub Desktop.
Save jfrantz1-r7/f4a1b2176618d504e88b6a875ef9f991 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
recent-vulnerabilities
SELECT nexpose_id, title, proofAsText(description) AS description, date_published, cvss_vector,
severity_score, severity, pci_severity_score, pci_status, round(riskscore::numeric, 0) AS risk_score,
round(cvss_score::numeric, 2) AS cvss_score, exploits, malware_kits
FROM dim_vulnerability
WHERE now() - date_published < INTERVAL '2 weeks'
ORDER BY title ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment