GRC connector wrapping networkbm/POAM-Automation-Tool: converts vulnerability scans into FedRAMP POA&M Excel and emits NIST-800-53-r5 (SI-2) findings → v1 finding contract.

version
0.1.0
GitHub stars
436

Install

/plugin install poam-automation@grc-engineering-suite

Run it inside Claude Code after adding the marketplace with /plugin marketplace add GRCEngClub/claude-grc-engineering.

Contents

Discovered from source

Skills 1

POA&M Automation Expert

Tool Behavior

This connector wraps the FedRAMP POA&M Automation Tool — a Python CLI that manages the full vulnerability finding lifecycle from scanner import through FedRAMP 20x VDR generation.

What it does

  • Parses raw scanner exports (Nessus, Tenable, Qualys, Wiz) into a structured FedRAMP POA&M
  • Auto-deduplicates findings across scanner imports using title + asset identifier
  • Enriches findings with NIST 800-53 control mappings via keyword matching
  • Manages finding lifecycle: update, close, deviation (false positive / operational requirement)
  • Generates FedRAMP 20x VDR reports with live CISA KEV and EPSS enrichment
  • Generates per-release Product VDR reports for customer-facing vulnerability disclosure
  • Outputs machine-readable JSON alongside every Excel report

VDR Classification Logic

Each finding is classified using live threat intelligence:

  • CISA KEV: Finding CVE is checked against the live CISA Known Exploited Vulnerabilities catalog. KEV findings are bumped to minimum N3 adverse impact.
  • EPSS: Exploit Prediction Scoring System score fetched from First.org API. Score ≥ 0.10 triggers LEV classification.
  • LEV/NLEV: Likely Exploitable / Not Likely Exploitable. Determined by KEV membership, EPSS score, and severity fallback.
  • IRV/NIRV: Internet Reachable / Not Internet Reachable. Derived from keywords in asset identifier and weakness description.
  • N-Rating: N1 (lowest) to N5 (highest) adverse impact. Base rating derived from severity, then adjusted upward for KEV and IRV+LEV combinations.

Evaluation Deadlines

Per FedRAMP 20x baseline:

  • High: 2 days from detection
  • Moderate: 5 days from detection
  • Low: 7 days from detection

Auto-Acceptance Threshold

Findings open 192+ days are automatically moved to the Accepted Vulnerabilities sheet per VDR-TFR-MAV.

Update Frequency Requirements

  • High baseline: Weekly (every 7 days)
  • Moderate baseline: Every 14 days
  • Low baseline: Monthly (every 30 days)

Control Coverage

This connector maps findings to NIST 800-53 Rev 5 controls via keyword matching across 30+ control families including SI-2, RA-5, AC-2, AC-3, SC-8, SC-28, AU-2, CM-6, CM-7, and others.

Failure Modes

  • Missing openpyxl: Install with pip install openpyxl
  • CISA KEV unavailable: Offline fallback uses severity-based LEV classification
  • EPSS unavailable: Offline fallback uses severity-based LEV classification
  • POA&M file open in Excel: Close the file before running any write command
  • Duplicate findings: Automatically skipped on import — same title + asset identifier

Limitations

  • Product VDR requires a manually maintained vulnerability CSV — it does not auto-discover product vulnerabilities
  • NIST control mapping is keyword-based, not authoritative — review mappings before submission
  • AI remediation text requires Ollama running locally with the Mistral model

Commands 3

POA&M Automation — Collect

Runs the full collection pipeline: import scanner findings into the POA&M, enrich with NIST 800-53 mappings, and generate FedRAMP 20x VDR outputs with live CISA KEV and EPSS enrichment.

Import Scanner Findings

python3 grc_tool.py convert --input <scanner_export> --scanner <nessus|tenable|qualys|wiz|generic> --output master_poam.xlsx

Enrich with NIST 800-53 Controls

python3 grc_tool.py enrich --poam master_poam.xlsx

Generate FedRAMP 20x VDR

Produces vdr_YYYYMMDD.xlsx and vdr_YYYYMMDD.json. The JSON is schema-conformant and ready for API serving.

python3 grc_tool.py vdr --poam master_poam.xlsx --baseline <low|moderate|high>

Generate Product VDR

For software vendors publishing per-release vulnerability disclosures to customers.

python3 grc_tool.py product-vdr --input vulns.csv --product "<name>" --version "<version>"

Export for Assessor Submission

python3 grc_tool.py export --poam master_poam.xlsx --output fedramp_submission.xlsx

JSON Output

The vdr command produces a vdr_YYYYMMDD.json file that conforms to the GRC Engineering finding schema. Each active vulnerability maps to an evaluation object with:

  • control_framework: FedRAMP-20x
  • control_id: Tracking ID (POA&M ID)
  • status: fail (active) or skipped (accepted)
  • severity: mapped from N-rating (N5=critical, N4=high, N3=medium, N2=low, N1=info)
  • message: weakness name and CVE
  • remediation: overall remediation plan with EPSS and KEV context

POA&M Automation Setup

Run this once before using any other poam-automation commands.

Get the Tool

Clone the POAM Automation Tool repo:

git clone https://github.com/networkbm/POAM-Automation-Tool
cd POAM-Automation-Tool

Steps

  1. Install the required Python dependency:
pip install openpyxl
  1. Verify your scanner export files are present. Supported formats:
ScannerFormat
Nessus.csv or .xml / .nessus
Tenable.io.csv
Qualys.csv
Wiz.csv
Generic.csv
  1. Confirm grc_tool.py and poam_converter.py are in the same directory.

  2. Run a quick check:

python3 grc_tool.py --help

If you see all 12 commands listed, setup is complete.

POA&M Automation — Status

Run these commands to get a current snapshot of your POA&M and VDR compliance state.

POA&M Dashboard

Shows open/closed counts, severity breakdown, overdue findings, and the 5 oldest open items.

python3 grc_tool.py dashboard --poam master_poam.xlsx

VDR Health Check

Shows CISA KEV findings requiring immediate action, evaluation deadline status, remediation overdue count, and when your next VDR submission is due. Run this every morning.

python3 grc_tool.py vdr-status --poam master_poam.xlsx --baseline <low|moderate|high>

ConMon Report

Monthly continuous monitoring report showing findings opened and closed in a given month.

python3 grc_tool.py conmon --poam master_poam.xlsx --month YYYY-MM

Executive Report

Severity summary, aging analysis, and scanner breakdown in Excel format.

python3 grc_tool.py report --poam master_poam.xlsx

Sponsors

Details

Marketplace
GRCEngClub/claude-grc-engineering
Source
plugins/connectors/poam-automation
Category
Community

More from GRCEngClub/claude-grc-engineering

All 70