
poam-automation
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-suiteRun it inside Claude Code after adding the marketplace with /plugin marketplace add GRCEngClub/claude-grc-engineering.
Contents
Discovered from sourceSkills 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-20xcontrol_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 CVEremediation: 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
- Install the required Python dependency:
pip install openpyxl
- Verify your scanner export files are present. Supported formats:
| Scanner | Format |
|---|---|
| Nessus | .csv or .xml / .nessus |
| Tenable.io | .csv |
| Qualys | .csv |
| Wiz | .csv |
| Generic | .csv |
-
Confirm
grc_tool.pyandpoam_converter.pyare in the same directory. -
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- sg-mas-trmv0.1.0
- singapore-pdpav0.1.0
- slack-inspectorv0.1.0
- snowflake-inspectorv0.1.0
- soc2v0.1.0
- splunk-inspectorv0.1.0
- staterampv0.1.0
- teach-mev0.1.0
- tenable-inspectorv0.1.0
- testssl-inspectorv0.1.0
- trust-centerv0.1.0
- us-ccpav0.1.0
- us-exportv0.1.0
- us-finrav0.1.0
- us-hipaa-securityv0.1.0
- us-nerc-cipv0.1.0
- us-soxv0.1.0
- vault-kvv0.1.0
- wiz-inspectorv0.1.0
- academic-research-companionv0.1.0
- au-apra-cps-234v0.1.0
- aws-inspectorv0.1.0
- aws-secrets-inspectorv0.1.0
- azure-inspectorv0.1.0