Go to Home Page
Questions?
Call 1-800-572-5517
 
  Go to Home Page  
  See all products
  See price schedules
  See manuals, tutorials, articles
  Download a free 30-day trial
  See user testimonials
  About Pacific Systems Group
 
 
SMF Tools
  See SMF Record Layouts
  See Sample SMF Reports
  Learn How to Export SMF Data
  Download Free SMF Reporting Software (30 days)
 
One of the greatest SMF record parsing programming languages I've ever seen. Chief, Large Systems Services Branch, NIH
  Choose Spectrum Writer to add 4GL to your product
  Free 60-Page Book (PDF) - How to Make an SMF Report
Spectrum SMF Writer - the 4GL SMF Report Writer.

Add customized reports and PC export files to your product!


Sample Reports from SMF 119 subtype 96 and 97 Records --
OpenSSH SFTP Transfer Completion Reports

It's easy to report on SMF data!
 

SMF Spectrum Writer
We have a low-cost 4GL report writer especially for SMF files. It's called Spectrum SMF Writer.

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.
 
Try It FREE Now!


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!

These Spectrum SMF Writer Statements:

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)                                                                                

 

Produce This SMF Report:


                                          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
...

These Spectrum SMF Writer Statements:

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)                       

 

Produce This SMF Report:


                                                                                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
...

See Other Sample SMF Reports
Copyright 2017.
Pacific Systems Group.
All rights reserved.


Spectrum Writer 4GL - the economical alternative to SAS, Easytrieve, DYL-280...

Home | Products | Prices | Documentation | 30-Day Trials | Customer Reviews | Company | FAQ | Sample Reports | SMF Records
Send Your Comments or Questions