topic Re: Sort rules by hit count / last hit in API / CLI Discussion

Sort rules by hit count / last hit

Danny — Wed, 16 Jun 2021 22:02:44 GMT

I'm looking for a quick way to sort rules by hit count and last hit date. CLI / API one-liner would be all I need. Has anyone created this already?

Thanks in advance!

Re: Sort rules by hit count / last hit

JozkoMrkvicka — Thu, 17 Jun 2021 05:14:02 GMT

Have you tried export with hit count included ?

Not sure if there is simple way to do it as one-liner.

Re: Sort rules by hit count / last hit

Danny — Thu, 17 Jun 2021 07:31:48 GMT

Thanks, $MDS_FWDIR/scripts/web_api_show_package.sh -n port -c exports all the info I need. I already created the report for the rules sorted by hit count (copied the rule number and hit count from html to Excel, sorted by hit count). As the info about the last hit date (which is part of the exported json data) is not visualized it's harder to create a report for as I need to find a proper way to filter just that data out of the json content. Will let you know about my proceeding.

Re: Sort rules by hit count / last hit

Denis — Thu, 15 Feb 2024 09:05:47 GMT

Hi Danny!

Were you able to pull data on last rule triggers? I have a similar problem and if you managed to work out a solution, could you share the results?

Re: Sort rules by hit count / last hit

Danny — Thu, 15 Feb 2024 09:50:32 GMT

Hi @Denis , yes my solution is documented here.