topic Re: XQL Query Help in Cortex XDR Discussions

XQL Query Help

VenuK — Thu, 08 Dec 2022 18:33:47 GMT

Dear All,

We wanted to pull the list of applications installed on our devices and would like to use XQL query to list the applications that are installed, we tried the below with no results, can someone help me how to get this achieved.

config timeframe = 24h
| dataset = host_inventory
| filter application_name in("Application Name that we have pulled using the host inventory")

Thanks in Advance

Venu

Re: XQL Query Help

bbucao — Fri, 09 Dec 2022 14:44:00 GMT

Hi VenuK,

Try using the preset in the query example below instead. This preset has the data you are looking for already parsed out nicely. In the host_inventory dataset, the application data is in a json array and would need additional XQL functions used to extract it.

preset = host_inventory_applications

|fields Vendor, application_name, version, manager_name, endpoint_name
|comp count(endpoint_name) as counter by vendor, application_name, version, manager_name
|sort desc counter

Regards,
Ben

Re: XQL Query Help

VenuK — Tue, 13 Dec 2022 13:42:26 GMT

Than you very much @bbucao