To run an XQL query for USB device being plugged in the environment

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

To run an XQL query for USB device being plugged in the environment

L0 Member

I am looking to run an XQL query to search for the USB devices being plugged into the environment. Can anyone please help me out so I can figure which USB devices have already been plugged into the environment at the client's office. 

#usb #xql query

1 REPLY 1

L4 Transporter

Hi @indy47 

 

Thank you for writing to live community!

 

You may start with the following XQL query to begin your investigation and tune your query and include relevant fields.

dataset = xdr_data      // Using the xdr dataset
|filter event_type=FILE
| alter Drive_Type = json_extract(to_json_string(action_file_device_info),"$.storage_device_drive_type")
| filter drive_type = "2" // filter Storage Device Drive type with value 2 which is for 'Removable Media'

Note: action_file_device_info is the field here which contains storage device info.

Hope this helps!

Please mark the response as "Accept as Solution" if it answers your query.

  • 1431 Views
  • 1 replies
  • 1 Likes
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!