XQL query for vulnerability

[T.Nurmi]

Hi. i need to do monthly report for vulnerabilities. So how to create like a trend report for 30 days

here is just example for get count, but how to do  trend report?

dataset = va_cves 
| filter severity >Medium
| filter affected_hosts_count >1
| fields name, affected_products, severity
| comp count() by severity

[aspatil]

Hello @T.Nurmi m

Thanks for reaching out on LiveCommunity!

Can you confirm , what exactly do want in the trend report?

Eg. Comparison between current month and last month vulnerabilities, Top 10 CVEs, Top 10 Vulnerable Applications, Vulnerabilities on Endpoint over time

[T.Nurmi]

so what i want to see this kind report> all vulnerabilities/day