Dear All,
We are trying to understand that, there are certain applications installed on a host by using the below query. preset = host_inventory_applications |filter endpoint_type = "AGENT_TYPE_WORKSTATION" |filter application_name in("Application A","application B", "Application C") | comp latest(report_timestamp) by endpoint_name, application_name | dedup endpoint_name, application_name | sort asc endpoint_name | fields endpoint_name, application_name
By running the above query, the result is that, we are getting hostname, application name etc, but we would like to get the result like the below.
Host Name, Applicatioin A, Application B etc, instead of duplicate entries of host with different applications.
... View more