Cortex XDR Agent Scripts Library

[Vinothkumar_SBA]

Hi Community,

I have a query. I am interested in retrieving the user access history for a specific URL in the browser for the last 3 months. Is it possible to run a Python script to retrieve this information?

[jmazzeo]

Hi @Vinothkumar_SBA , thanks for reaching us using the Live Community.

Take a look at this XQL Queries that should work for the data stored in the xdr_data dataset:

dataset = xdr_data
| filter actor_effective_username contains "insert user here"
| filter actor_process_image_name in ("msedge.exe","chrome.exe","firefox.exe") and action_external_hostname != null
| fields agent_hostname, agent_ip_addresses, actor_effective_username, actor_process_image_name, action_external_hostname
| sort desc _time

preset = network_story 
| filter actor_effective_username contains "insert user here"
| filter actor_process_image_name in ("msedge.exe","chrome.exe","firefox.exe") and dst_action_external_hostname != null
| fields agent_hostname, agent_ip_addresses, actor_effective_username, actor_process_image_name, dst_action_external_hostname
| sort desc _time

You can add the filters for the external hostname as you need.

If you need older information than the stored in the dataset, the answer is yes, you can create a Python script to retrieve that information from the Endpoint.

If this post answers your question, please mark it as the solution.