SQL Query Example: Vulnerable Assets

Document created by synapsr on Feb 5, 2015
Version 1Show Document
  • View in full screen mode

Had an interesting question from a customer so we thought we'd share with others.  Sharing is caring after all.

 

This query shows any asset that has a vulnerability.

 

 

SELECT COUNT(*) FROM fact_asset WHERE vulnerabilities > 0;

1 person found this helpful

Attachments

    Outcomes