Searching under Mod Security section

[bpmod]

I am using WHM 11.34.0 (build 9) on CentOS 6.3 x86_64 standard.

I click on Mod Security in the plugins section and am taken to a page which shows a table of mod security triggers. The columns are (from left to right): Date, Time, IP, GET, Host, Message, & Action.

I would like to search for a particular Action (for instance, 500) and sort from newest to oldest (as I am not interested in things that triggered a 500 server error a couple of years ago).

But no matter what I choose as 'sort by' or 'sort order', it lists the first x number of records from the date the server was installed.

How can I find the latest records?

Thanks

Brian

 

[PlotHost]

Go to WHM->.phpMyAdmin-> modsec database .
There try a query like this

SELECT *
FROM `modsec`
WHERE mod_security_action LIKE '%500%'
ORDER BY DATE DESC
LIMIT 0 , 30

 

[bpmod]

That did the trick and a whole lot more.

Thanks

Brian