# awk weekly - Security rule hits statistics . Checkpoint

As I mentioned before once you export firewall logs into human-readable format you can do lots of interesting things - for example script that gives statistics of how many times each Security rule was hit . Be aware that this counts explicit Security rules only - i.e. the ones you see in Security tab of the Smartdashboard. No other rules you usually see in Smartview Tracker are counted - e.g. SmartDefense,Web Filtering etc. Also afterwards I sort it by number of hits to see what rules are used most:

```
awk -F\; ' {match($0,/rule: +([0-9]+)/,rules);rule_count[rules[1]]++} END {for (rule_number in rule_count) print " Rule number: " rule_number " Hits: " rule_count[rule_number]}' ./fw.log.txt | sort -n -k5
```

```
Rule number: Hits: 1197330 <strong> Ignore this line as it counts non-matched lines I dont want to filter with additional conditions and added time processing</strong>
Rule number: 2 Hits: 9
Rule number: 5 Hits: 366
Rule number: 11 Hits: 12296
Rule number: 9 Hits: 14457
Rule number: 0 Hits: 17094
Rule number: 1 Hits: 44066
Rule number: 7 Hits: 233643
Rule number: 10 Hits: 366275
Rule number: 6 Hits: 424639
```

**Update 2012** Below is the script to use Rule ID instead of Rule sequential numbers - this way changing rules order will not affect statistics. The script matches also non-security rules - e.g. email session id, that are a bit shorter then Rule ID, but I didn't want to slow down the processing with additional formatting .

```
awk -F\; ' {match($0,/{([[:print:]]+)}/,rules);rule_count[rules[1]]++} END {for (rule_number in rule_count) print " Rule number: " rule_number " Hits: " rule_count[rule_number]}' ./fw.log.txt | sort -n -k5
```

```
Rule number: D199972C-ED3E-4EB4-8B83-813333156D18 Hits: 175
Rule number: 85A905A7-951E-4100-A4BA-E13333151D29 Hits: 219
Rule number: 81333316-E942-4313-BB7D-E1333315802F Hits: 1519
Rule number: 71333215-2DB5-4A3A-95BC-5080AD0F5564 Hits: 2298
Rule number: 11331315-AE52-44E0-A42A-711029B5768E Hits: 3755
Rule number: 01333315-D290-4B05-AFE7-23BF24D889FF Hits: 4116
Rule number: 121FA62F-3885-4328-8090-BF1333315eB1 Hits: 399793
Rule number: FE40E076-BAEB-4979-8E41-5EF1333315e6 Hits: 440101
Rule number: BB3F6772-4D38-4D5A-952A-301333315de8 Hits: 1354341
Running time for a file of 900 Mb with 4.7 million records
real 5m50.287s
user 4m22.890s
sys 0m3.190s
```