Difference between revisions of "query rule hit counter db via command line"
From cpwiki.net
m (Nighthawk moved page hit counter to query rule hit counter db via command line without leaving a redirect) |
|||
| Line 1: | Line 1: | ||
==example query== | ==example query== | ||
| − | 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 | + | 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 rule_uid="{609C7EC8-82CA-4A58-BEB8-226626DBD3E3}"' |
keywords: hit count, hitcount | keywords: hit count, hitcount | ||
Revision as of 04:00, 14 September 2017
example query
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 rule_uid="{609C7EC8-82CA-4A58-BEB8-226626DBD3E3}"'
keywords: hit count, hitcount
