This website uses Cookies. By clicking Accept, you agree to the storing of cookies on your device to enhance your community experience. Read our Privacy Policy.
Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements
Please sign in to see details of an important advisory in our Customer Advisories area.

Who rated this post

zarnous
L2 Linker

‎02-01-2024 06:05 AM

hi @MatthieuFouet 

 

I hope i got the use correctly, and based on my understadning, you may try the below query 


dataset = alerts
| fields rule_id , file_name , file_sha256
| arrayexpand file_name
| comp count(file_name ) as Hits by file_name
| sort desc Hits

Sample output should look like the below 

zarnous_0-1706796223324.png

You may also add more fields, and filters as you wish if you need so!

If this answers your question feel free to mark it as a solution so other can benefit from!

Thanks
Z

Z

View solution in original post

(1)
Who rated this post
LEGAL NOTICES
RESOURCES
Khoros awards 2022
Copyright 2007 - 2024 - Palo Alto Networks