Event log sorting in MX products

[mike318]

When sorting event logs of an MX product, I can only sort by 'Content filtering blocked URL' however, not by URL type. I want to be able to see the logs by the specific category defined. For example, sort by 'Dating' or 'Phishing'. 

Is there a way to do this that I am not aware of? 

[Adam]

Sounds like you want to be able to sort by category.  It doesn't look like that is its own column.  That information appears to be concatenated onto the 'Details' column which I don't believe will be able to be filtered or sorted.  

[Adam]

Found a workaround for you.  If you download as a csv and open in excel.  You can use this formula and it'll parse out the details column into just the category.

=RIGHT(D2,LEN(D2)-(FIND("category",D2)+8))

If you are particularly finicky you could also probably do a replace  to get rid of the final "

[mike318]

Thanks Adam. Yes, I know I can maybe works some things out in excel, but you can only export small sections of history. 

I am hopeful Meraki will implement the ability to do this in the dashboard.