SQL to check syslogs record types

1> select op,case op
2> when 17 then 'CHECKPOINT'
3> when 4 then 'INSERT'
4> when 30 then 'ENDXACT-commit'
5> when 0 then 'BEGINXACT-begin tran'
6> when 9 then 'MODIFY-apl update'
when 26 then 'CLR-rollback'
7> 8> when 5 then 'DELETE'
when 77 then 'DROPEXTSMAP-truncate table'
9> 10> when 65 then 'DOL_UPDATE'
11> when 54 then 'LOGDEALLOC'
12> when 25 then 'PGCHGSYSIND'
13> when 14 then 'DBNEXTID'
when 7 then 'IINSERT'
14> 15> when 41 then 'OAMCREATE'
when 39 then 'OAMINSERT'
16> 17> when 13 then 'ALLOC'
18> when 63 then 'DOL_INSERT'
19> when 71 then 'BT_INSERT'
20> when 12 then 'DNOOP'
21> when 8 then 'IDELETE'
22> when 66 then 'DOL_DELETE'
23> when 51 then 'OAMENTRYMOVE'
24> when 52 then 'OAMATPUT'
25> end as operation,
26> numop=count(*) from syslogs group by op
27>
op operation numop
--- -------------------------- -----------
72 NULL 26
4 INSERT 2
17 CHECKPOINT 1
9 MODIFY-apl update 7
71 BT_INSERT 34
14 DBNEXTID 2
65 DOL_UPDATE 13
0 BEGINXACT-begin tran 18
54 LOGDEALLOC 1
30 ENDXACT-commit 18
63 DOL_INSERT 4