SQL to check syslogs record types - Hallo there Sarah Server reader, this time we will talk about SQL to check syslogs record types, We have prepared this article for you, hope you enjoy this Guide, Happy reading.

Title : SQL to check syslogs record types
link : SQL to check syslogs record types

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

There is SQL to check syslogs record types

Thus article SQL to check syslogs record types this time, hope can give benefits to all of you. well, see you in other post.

You are reading SQL to check syslogs record types with link https://saraserver.blogspot.com/2009/12/sql-to-check-syslogs-record-types.html