XQL Query Help

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

XQL Query Help

L1 Bithead

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

Venu
1 ACCEPTED SOLUTION

Accepted Solutions

L3 Networker

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

View solution in original post

2 REPLIES 2

L3 Networker

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

Than you very much @bbucao 

Venu
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!