XQL Query - Machine Custom Reports

[Miguel_Silva]

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?

[aspatil · Accepted solution]

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.