Need help to create XQL Queries

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements

Need help to create XQL Queries

L2 Linker

Dear All,

 

I need your help and advise to acheive the below requirement in XQL query.

 

1. Agent malfunction/ no content updates/ no upgrade
2. Agent partially protected/memory storage/junk storage
3. Network malfunction, not able to connect back.

 

Thanks in Advance,

Venu

 

Venu
1 REPLY 1

L4 Transporter

Hi @VenuK, thank you for writing to Live Community.

1. I am not sure what do you mean by agent malfunction, but if you are referring to agent disconnected/lost connection you can use the following query as baseline:

dataset = endpoints | filter endpoint_status = CONNECTION_LOST or endpoint_status = DISCONNECTED

 2. For agents with no content update please try the below query:

dataset = endpoints 
| filter content_version = "" and (endpoint_status = CONNECTED or endpoint_status = DISCONNECTED)
| alter last_seen_diff = timestamp_diff(current_time(), last_seen, "DAY") 
| filter last_seen_diff <= 7
| comp count(endpoint_id ) as count
| view graph type = pie show_percentage = `false` xaxis = count yaxis = count default_limit = `false` legend = `false` 

3. Regarding agents being partially protected or unprotected please try the below query as baseline (feel free to choose which fields you'd like to see in the table):

dataset = endpoints 
| filter operational_status != ENUM.PROTECTED 
| fields Endpoint_Name as Name, operational_status, is_edr_enabled, operating_system as OS, os_version, kernel_version, mac_address, agent_version as Cortex_Agent_Version, ip_address as IP, endpoint_type
| view graph type = pie 

 4. Regarding agent connection issues please see the first query I suggested.

Hope these will help you get started with the queries you're looking to build.

Visit our Cortex XDR Customer Corner on Live Community to access resources for your product journey, engage in discussions with community members and subject matter experts, and register for upcoming events: Cortex XDR Customer Corner

  • 1278 Views
  • 1 replies
  • 1 Likes
Like what you see?

Show your appreciation!

Click Like if a post is helpful to you or if you just want to show your support.

Click Accept as Solution to acknowledge that the answer to your question has been provided.

The button appears next to the replies on topics you’ve started. The member who gave the solution and all future visitors to this topic will appreciate it!

These simple actions take just seconds of your time, but go a long way in showing appreciation for community members and the LIVEcommunity as a whole!

The LIVEcommunity thanks you for your participation!