topic Re: Cortex XDR XQL Query in Cortex XDR Discussions

Cortex XDR XQL Query

Vinothkumar_SBA — Thu, 14 Dec 2023 06:41:40 GMT

Hi Team,

Could you please provide us with the XQL query to retrieve the reasons behind the "Agent Disconnected" and "Connection Lost" statuses from Cortex XDR? I have attempted to create a query, but I haven't obtained any results. Please assist me with this.

Re: Cortex XDR XQL Query

aspatil — Thu, 14 Dec 2023 12:10:52 GMT

Hello @Vinothkumar_SBA ,

Thank you for writing to live community.

May I know exactly which column or field you are looking for to find out the reason? Is it available in the All Endpoints table?

Basically we need to check the Agent logs to find out the connection lost and Agent Disconnected status.

Regards.

Re: Cortex XDR XQL Query

Vinothkumar_SBA — Thu, 14 Dec 2023 12:24:03 GMT

Hi Aspatil,

Thank you for your response. We are interested in an XQL query to identify the reason why an agent disconnected and the reasons for connection loss. Specifically, we are interested in columns related to the reasons for agent disconnection and connection loss.

Re: Cortex XDR XQL Query

aspatil — Thu, 14 Dec 2023 14:05:48 GMT

Thank for providing the information. Unfortunately, the reasons are not generic and may require the extensive troubleshooting by analyzing the various logs to identify the RCA. Hence such information cannot be retrieved from XQL.
Will check again and update you if I find any information.

Thanks.

Re: Cortex XDR XQL Query

Vinothkumar_SBA — Fri, 15 Dec 2023 04:26:13 GMT

Thanks for your information.