|
Sample Reports from SMF 119 subtype 96 and 97 Records --
| ||||||||||||||||||||||||||||||||||||||||||
It's easy to report on SMF data!
| |
|
Spectrum SMF Writer handles the difficult SMF record parsing for you automatically. You just specify which fields you want to see. Spectrum SMF Writer also converts the arcane date and time fields and reformats them into an attractive report. Plus Spectrum SMF Writer even exports SMF data as comma delimited files to use on your PC.
|
The sample SMF reports below were created with Spectrum SMF Writer,
the low-cost 4GL SMF report writer.
In the first report, we read the SMF file and select just the type 119 subtype 96 "OpenSSH Server Transfer Completion" records. (See SMF 119-96 record layout.) We expand the operation codes from the SMF record into text descriptions, And we reformat the four 1-byte binary IP values into the familiar character IP4 format.
The second report is similar. It uses the SMF 119 subtype 97 records ("OpenSSH Client Transfer Completion"). This shows the client transfer completion information.
All of this with just a few lines of code!
Why not install a Spectrum SMF Writer trial right now and start making your own SMF reports!
OPTION: NOGRANDTOTAL
INPUT: SMF11996
INCLUDEIF:
SMF119S96_RTY = 119 /* RECORD TYPE */
AND SMF119S96_STY = 96 /* RECORD SUB-TYPE */
TITLE: '119-96 (SERVER TRANSFER COMPLETION RECORD)'
COMPUTE: FSOPER(8) =
WHEN(SMF119S96_SSH_FSOPER = 1) ASSIGN('RMDIR ')
WHEN(SMF119S96_SSH_FSOPER = 2) ASSIGN('RM ')
WHEN(SMF119S96_SSH_FSOPER = 3) ASSIGN('RENAME')
WHEN(SMF119S96_SSH_FSOPER = 4) ASSIGN('GET ')
WHEN(SMF119S96_SSH_FSOPER = 5) ASSIGN('PUT ')
WHEN(SMF119S96_SSH_FSOPER = 6) ASSIGN('CHMOD ')
WHEN(SMF119S96_SSH_FSOPER = 7) ASSIGN('CHOWN ')
WHEN(SMF119S96_SSH_FSOPER = 8) ASSIGN('MKDIR ')
WHEN(SMF119S96_SSH_FSOPER = 9) ASSIGN('SYMLINK')
ELSE ASSIGN(#FORMAT(SMF119S96_SSH_FSOPER))
SORT:
SMF119S96_SSH_FSSDATE
SMF119S96_SSH_FSSTIME
SMF119S96_SID
COLUMNS:
SMF119S96_SSH_FSSDATE('STARTDATE')
SMF119S96_SSH_FSSTIME('STARTTIME')
SMF119S96_SSH_TI_USERID('USERID')
FSOPER('OPER' 4)
SMF119S96_SSH_FSCMD('CMD')
SMF119S96_SSH_FSSTAT('STAT')
SMF119S96_SSH_FSLIP('LOCATE IP')
SMF119S96_SSH_FSRIP('REMOTE IP')
SMF119S96_SSH_FSHOSTNAME('HOST' 4)
SMF119S96_SSH_FSPATH1('PATH1' 45)
119-96 (Server Transfer Completion record)
Startdate Starttime Asname Userid Oper Cmd Stat Locate IP Remote IP Host Path1
_________ ___________ ________ ________ ____ ____ ____ _____________ _____________ ____ _______________________________________
01/03/11 07:00:19.21 TPADMIN6 TPADMIN get GET OK 55.66.77.88 11.22.33.44 sys2 /SYS2/tmp/payment_detail.SYS2
01/03/11 07:00:19.61 TPADMIN7 TPADMIN get GET OK 55.66.77.88 11.22.33.44 sys2 /SYS2/var/hkeeping/payment_history.SYS2
...
OPTION: NOGRANDTOTAL
INPUT: SMF11997 /* COPIES FILE DEF STMTS AUTOMATICALLY */
INCLUDEIF:
SMF119S97_RTY = 119 /* RECORD TYPE */
AND SMF119S97_STY = 97 /* RECORD SUB-TYPE */
TITLE: '119-97 (CLIENT TRANSFER COMPLETION RECORD)'
SORT:
SMF119S97_SSH_FCSDATE
SMF119S97_SSH_FCSTIME
SMF119S97_SID
COLUMNS:
SMF119S97_SID('SYSTEM')
SMF119S97_SSH_TI_ASNAME('ASNAME')
SMF119S97_SSH_TI_USERID('USERID')
*
SMF119S97_SSH_FCLUSER('LCL-USER')
SMF119S97_SSH_FCTTYPE('TYPE')
SMF119S97_SSH_FCMODE('MODE')
*
SMF119S97_SSH_FCSDATE('BEGDATE')
SMF119S97_SSH_FCSTIME('BEGTIME')
SMF119S97_SSH_FCDUR('DURATION')
SMF119S97_SSH_FCBYTES('BYTES')
SMF119S97_SSH_FCSTAT('STAT')
SMF119S97_SSH_FCLIP('LOCAL IP')
SMF119S97_SSH_FCLPORT('LOCAL PORT' 12 P'ZZZZZZ9')
SMF119S97_SSH_FCRIP('REMOTE IP')
SMF119S97_SSH_FCRPORT('REMOTE PORT' 12 P'ZZZZZZ9')
*
SMF119S97_SSH_FCUSERID('USERID' 20)
SMF119S97_SSH_FCPATH('PATH' 40)
119-97 (CLIENT TRANSFER COMPLETION RECORD)
System Asname Userid Cmd Type Mode Begdate Begtime Duration Bytes Stat Local IP Lclport Remote IP Rmtport Userid Path
______ ________ ________ ____ ____ ____ ________ ___________ ___________ _____ ____ ____________ _______ _______________ _______ ________ __________________________________________________
SYS1 VXATP70I PGASHC PUT A S 28/02/11 03:00:44.19 00:00:00.00 144 OK 11.22.33.2 36823 123.234.567.999 22 zutil2 /data/browse/tmp/LogFile-20110228-030042-83952264
SYS1 I4ATP70I PGAI4A PUT A S 28/02/11 03:14:30.93 00:00:00.01 144 OK 11.22.33.2 37744 123.234.567.999 22 zutil2 /data/browse/tmp/LogFile-20110228-031429-83953426
SYS2 VXATP70I PGASHC PUT A S 01/03/11 03:04:34.61 00:00:00.00 144 OK 11.22.33.6 32453 123.234.567.999 22 zutil2 /data/browse/tmp/LogFile-20110301-030432-67241185
SYS1 I4ATP70I PGAI4A PUT A S 01/03/11 03:05:54.57 00:00:00.00 144 OK 11.22.33.2 7441 123.234.567.999 22 zutil2 /data/browse/tmp/LogFile-20110301-030553-67175216
SYS2 VXATP70I PGASHC PUT A S 02/03/11 03:02:27.21 00:00:00.00 144 OK 11.22.33.6 45256 123.234.567.999 22 zutil2 /data/browse/tmp/LogFile-20110302-030224-84019194
SYS2 I4ATP70I PGAI4A PUT A S 02/03/11 03:21:33.48 00:00:00.00 144 OK 11.22.33.6 46235 123.234.567.999 22 zutil2 /data/browse/tmp/LogFile-20110302-032132-67240410
SYS2 VXATP70I PGASHC PUT A S 03/03/11 03:01:58.84 00:00:00.00 144 OK 11.22.33.6 58076 123.234.567.999 22 zutil2 /data/browse/tmp/LogFile-20110303-030155-50466520
SYS2 I4ATP70I PGAI4A PUT A S 03/03/11 03:13:10.92 00:00:00.00 144 OK 11.22.33.6 58652 123.234.567.999 22 zutil2 /data/browse/tmp/LogFile-20110303-031309-84017320
...
Home |
Products |
Prices |
Documentation |
30-Day Trials |
Customer Reviews |
Company
| FAQ
| Sample Reports
| SMF Records
Send Your Comments or Questions
