|
Sample Reports from SMF 119 subtype 96 and 97 Records --
| |||||||||||||||||||||||||||||
It's easy to report on SMF data!
| |
|
Spectrum SMF Writer handles all of the difficult SMF record parsing for you automatically. You just specify the fields you want to see. Plus Spectrum SMF Writer even exports SMF data as comma delimited files, to use on your PC. All of this for only $4,995!
|
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 ASMF 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)
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 |
Documentation |
Prices |
Testimonials |
Company |
30-Day Trials
| FAQ
| Sample Reports
| SMF Records
Send Your Comments or Questions
