XQL Query - Machine Custom Reports

Miguel_Silva — Tue, 27 Feb 2024 15:32:22 GMT

Hello,

good afternoon.

I currently have a few machines and xDR installed on them.

I need to make a weekly report with the information of the machines and the scan previously configured.

Currently, what I have configured using XQL Query:

-> Checks if the scan was performed well or not.

//########### Linux - Ubuntu 20.04LTS dataset = endpoints | filter endpoint_status in (ENUM.CONNECTED , ENUM.DISCONNECTED ) | filter operating_system = "Ubuntu 20.04 LTS" | comp count(endpoint_name ) as counter by scan_status | view graph type = pie xaxis = scan_status yaxis = counter

What I would like to have configured:

-> Checks whether the scan was performed correctly or not.
-> Checks the number of objects scanned.
-> Check the number of malicious objects.
-> Etc, anything you think is necessary.

Could you help me?

Re: XQL Query - Machine Custom Reports

aspatil — Thu, 29 Feb 2024 06:17:19 GMT

Hello @Miguel_Silva ,

Thanks for reaching out on LiveCommunity!

You can find the scan status and last successful scan but not the objects information.

You can edit the query and include those fields.

If you feel this has answered your query, please let us know by clicking on "mark this as a Solution". Thank you.

topic XQL Query - Machine Custom Reports in Cortex XDR Discussions

XQL Query - Machine Custom Reports

Re: XQL Query - Machine Custom Reports