query rule hit counter db via command line

From cpwiki.net
Revision as of 21:42, 16 April 2017 by Nighthawk (Talk | contribs)

Jump to: navigation, search
Check Point Profressional Services
sqlite3 $FWDIR/conf/hit_count_rules_table.sqlite 'select datetime(start_date, "unixepoch") as time, datetime(end_date, "unixepoch") as time, netobj_name, rule_uid, hits from HitCountRules where netobj_name="PBROxxRCHVCP1" and rule_uid="{609C7EC8-82CA-4A58-BEB8-226626DBD3E3}"'



sqlite3 $FWDIR/conf/hit_count_rules_table.sqlite 'select datetime(start_date, "unixepoch") as time, datetime(end_date, "unixepoch") as time, netobj_name, rule_uid, hits from HitCountRules where netobj_name="PBROxxRCHVCP1" and rule_uid="{609C7EC8-82CA-4A58-BEB8-226626DBD3E3}"'
</pre>
Retrieved from "http://www.cpwiki.net/index.php?title=query_rule_hit_counter_db_via_command_line&oldid=618"