XQL query to pull USB plug-in statistic

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

XQL query to pull USB plug-in statistic

L2 Linker

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 

AC
2 REPLIES 2

L5 Sessionator

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.

JM

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?

AC
  • 1106 Views
  • 2 replies
  • 0 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!