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

indy47 — Tue, 18 Jul 2023 22:57:13 GMT

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

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

PiyushKohli — Wed, 19 Jul 2023 02:53:11 GMT

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.

topic To run an XQL query for USB device being plugged in the environment in Cortex XDR Discussions

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

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