Query for listing installed VPN's in organization

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

Query for listing installed VPN's in organization

L1 Bithead

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

1 accepted solution

Accepted Solutions

L3 Networker

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

View solution in original post

1 REPLY 1

L3 Networker

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

  • 1 accepted solution
  • 979 Views
  • 1 replies
  • 0 Likes
  • 78 Subscriptions
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!