Bert-Jan Pals unknown stable kql
Vulnerabilities Year To Date CISA KEV Release Year
This query uses the CISA Known Exploited Vulnerabilities Catalog to list the vulnerabilities year to date by year when the vulnerability was released.
Detection Logic
let KnowExploitesVulnsCISA = externaldata(CVEId: string, Vendor:
string, Product: string, VulnerabilityName: string, DateAdded: datetime,
Description: string, RequiredAction: string, DueDate: datetime,
Notes: string)
[@"https://www.cisa.gov/sites/default/files/csv/known_exploited_vulnerabilities.csv"]
with (format="csv", ignoreFirstRecord=True);
KnowExploitesVulnsCISA
| where DateAdded between (startofyear(now()) .. startofweek(endofyear(now())))
| extend Year = toint((split(CVEId, "-")[1])) Field Validations
Loading…
Comments (0)
Loading comments...