XQL query to pull USB plug-in statistic

[Antony_Chan]

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!
Cortex XDR 

[jmazzeo]

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.

[Antony_Chan]

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?