GASP

Vulnerability Count

Vulnerability Count: Number of known vulnerabilities still open in your systems.

Formula

Vulnerability Count = Count of open vulnerabilities at period end

Computable definition

The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.

count_distinct(field.vulnerability_id where field.vulnerability_status = 'open')

Unit: count

Notes: Categorised by severity (critical, high, medium, low).

Data requirements

Grain: Daily snapshot · Frequency: Daily · Aggregation: snapshot (day) · Staged: no · Main source: Security Scanner.

Field Dataset Type
snapshot_date vulnerability date
vulnerability_id vulnerability string
vulnerability_status vulnerability string
Example SQL (Postgres)
SELECT (SELECT COUNT(DISTINCT vulnerability_id) FROM vulnerability WHERE snapshot_date = :period_end AND vulnerability_status = 'open') AS vulnerability_count

From an agent: with the GASP MCP server, call lookup_metric({ "name": "Vulnerability Count" }) or generate_query({ "metric": "Vulnerability Count", "adapter": "<your adapter JSON>" }).

Try searching for:

↑↓navigate↵select