Enhanced Security Measures in Place: To ensure a safer experience, we’ve implemented additional, temporary security measures for all users.
05-15-2023 09:59 PM
Hey everyone,
I'm trying to list all devices within organization that have installed some VPN on them, but my query fails each time or returns small number of results. I set it to have most popular 10 VPN's in the list like Nord, OpenVPN, Express, Cyber Ghost etc.
Could you please help me out in adjusting query, to list hostname of the devices and the installed VPN:
dataset = xdr_data
| filter actor_process_image_name in(" *VPN*, ")
| comp
values(actor_process_image_path ) by agent_hostname, actor_effective_username
05-17-2023 06:33 AM
Hi DragomirGaliaIT,
The query example you listed has some slight syntax errors. To search for for a match on the process name using the "in" operator, make sure you have each value in quotes and separated by a coma as shown below. Another suggestion would be using the digital signer field and searching for these VPN's digital signer for a more thorough search.
dataset = xdr_data
| filter actor_process_image_name in("*nord*", "*express*")
| comp
values(actor_process_image_path ) by agent_hostname, actor_effective_username
Thanks,
Ben
05-17-2023 06:33 AM
Hi DragomirGaliaIT,
The query example you listed has some slight syntax errors. To search for for a match on the process name using the "in" operator, make sure you have each value in quotes and separated by a coma as shown below. Another suggestion would be using the digital signer field and searching for these VPN's digital signer for a more thorough search.
dataset = xdr_data
| filter actor_process_image_name in("*nord*", "*express*")
| comp
values(actor_process_image_path ) by agent_hostname, actor_effective_username
Thanks,
Ben
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!
