01-27-2025 10:15 PM
If you want the excel format then while you creating the report you would see an option attach .csv format, click on it and select the report that would like to see as csv file, which will be sent to you in a zip format(includes pdf, csv format files). Here I am attaching a sample query which would fetch the relevant fields, please tune it according to your exact requirement.
dataset = va_cves
| fields name, cve_id , severity , severity_score, affected_hosts
|arrayexpand affected_hosts
| join(preset = host_inventory_endpoints |
fields endpoint_name, operating_system , endpoint_type, last_report_time ) as ep ep.endpoint_name = affected_hosts
