12-08-2022 10:33 AM
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
12-09-2022 06:44 AM
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
12-09-2022 06:44 AM
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
12-13-2022 05:42 AM
Than you very much @bbucao
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!
