#!/usr/bin/env python3
"""Filter CISA KEV for recent entries relevant to perimeter/sector software.
Reads /root/recon/kev.json, prints grouped summary + TSV to /root/recon/kev_recent.tsv
"""
import json
import re

SINCE = "2026-01-01"

VENDORS = [
    "fortinet", "ivanti", "citrix", "palo alto", "sonicwall", "watchguard",
    "cisco", "f5", "sophos", "barracuda", "check point", "pulse secure",
    "cleo", "fortra", "progress", "crushftp", "solarwinds", "vmware",
    "atlassian", "oracle", "connectwise", "beyondtrust", "zammad",
    "microsoft", "qnap", "synology", "hpe", "zyxel", "draytek", "yealink",
    "smartertools", "sitecore", "craft", "vbulletin", "liferay", "drupal",
    "nginx", "apache", "vm2", "mitel", "yeastar", "asterisk", "freepbx",
    "roundcube", "zimbra", "mexchange", "array networks", "sentry",
    "paperCut".lower(), "philips", "ge health", "medtronic", "orthanc",
    "openemr", "librehealth", "tyler", "imanage", "relativity",
]

with open("/root/recon/kev.json", encoding="utf-8") as f:
    data = json.load(f)

vulns = data["vulnerabilities"]
recent = [v for v in vulns if v.get("dateAdded", "") >= SINCE]
print(f"total KEV entries: {len(vulns)}; added since {SINCE}: {len(recent)}")

hits = []
for v in recent:
    text = " ".join(
        str(v.get(k, ""))
        for k in ("vendorProject", "product", "vulnerabilityName", "shortDescription")
    ).lower()
    if any(vd in text for vd in VENDORS):
        hits.append(v)

hits.sort(key=lambda v: (v.get("vendorProject", ""), v.get("dateAdded", "")), reverse=True)

with open("/root/recon/kev_recent.tsv", "w", encoding="utf-8") as out:
    out.write("cveID\tdateAdded\tvendor\tproduct\tname\transomware\n")
    for v in hits:
        out.write("\t".join([
            v.get("cveID", ""), v.get("dateAdded", ""),
            v.get("vendorProject", ""), v.get("product", ""),
            v.get("vulnerabilityName", "")[:90].replace("\t", " "),
            v.get("knownRansomwareCampaignUse", "?"),
        ]) + "\n")

print(f"matched entries: {len(hits)} -> /root/recon/kev_recent.tsv")
for v in hits:
    print(f'{v["dateAdded"]} | {v.get("cveID")} | {v.get("vendorProject")} / {v.get("product")} | {v.get("vulnerabilityName","")[:70]}')
