topic XQL query to pull USB plug-in statistic in Cortex XDR Discussions

XQL query to pull USB plug-in statistic

Antony_Chan — Fri, 05 Apr 2024 09:01:57 GMT

Dear community,

I'm trying to generate the USB plug-in statistic to build case around it. Hence the following 2 XQL queries were built. The only issue is I'm not sure which one is the more accurate data as i found both results are not even close.
Does anyone know the difference between "ENUM.DEVICE.PLUG" and "ENUM.MOUNT_DRIVE_MOUNT"?

config case_sensitive = false | preset = device_control | filter event_sub_type = ENUM.DEVICE_PLUG | alter date = format_timestamp("%Y/%m/%d", _time) | filter action_device_class_name = "disk" | comp count(action_device_class_name) as TotalMountingEvents by action_device_class_name | view graph type = single subtype = standard xaxis = TotalMountingEvents yaxis = TotalMountingEvents headerfontsize = 18

config case_sensitive = false | dataset = xdr_data | filter event_sub_type = ENUM.MOUNT_DRIVE_MOUNT | alter date = format_timestamp("%Y/%m/%d", _time) | fields date, agent_hostname as hostname, action_mount_device_info as mount_info | alter serial_number = json_extract(mount_info, "$.storage_device_serial_number") | alter drivetype = json_extract(mount_info, "$.storage_device_drive_type") | alter vendor_id = json_extract(mount_info, "$.storage_device_vendor_id") | alter product_id = json_extract(mount_info, "$.storage_device_product_id") | alter class_name = json_extract(mount_info, "$.storage_device_class_name") | filter drivetype = "2" | comp count(drivetype) as TotalMountingEvents by drivetype | view graph type = single subtype = standard xaxis = TotalMountingEvents yaxis = TotalMountingEvents headerfontsize = 18

Thank you!

Re: XQL query to pull USB plug-in statistic

jmazzeo — Fri, 05 Apr 2024 20:59:29 GMT

Hi @Antony_Chan, thanks for reaching us using the Live Community.

The "ENUM.DEVICE.PLUG" is the event of any device pluged on the system, can be a usb disk drive, bluetooth headset, or any other kind of device. This is usually used to query the usb devices inserted and take the serial or guid to create device control rules.

The "ENUM.MOUNT_DRIVE_MOUNT" is an action made by the operating system to mount any drive to a directory folder, this can be a usb drive, or sometimes the OS mount drivers internally to take snapshots or backups automatically, or for some application functions. This action is more common in Linux and MacOs systems.

You can see in this doc more information about the event types: https://docs-cortex.paloaltonetworks.com/r/Cortex-XQL-Schema-Reference-Guide/Action-Actor

If this post answers your question, please mark it as the solution.

Re: XQL query to pull USB plug-in statistic

Antony_Chan — Mon, 08 Apr 2024 02:26:36 GMT

Hello @jmazzeo,

Thanks for sharing the information and the link.
The doc is definitely new to me. However, I couldn't locate the said information in the doc, am I missing something here?