








	*SMF Tools*

Sample Report from RSD Folder's SMF 220 Records

It's easy to report on SMF data!

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.

The sample SMF report below was created with Spectrum SMF Writer, the low-cost 4GL SMF report writer.

It reads the SMF 220 audit records written by the RSD's Folder product and prints selected 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:

INPUT:     SMF220

INCLUDEIF: AUDRCDTY = 220
           AND AUDRCDTS > 10:00 AND AUDRCDTS < 10:15
           AND AUDOBJT ='DOC'

TITLE:     'FOLDER AUDIT STATISTICS'

COLUMNS:   AUDRCDTE('DATA')
           AUDRCDTS('ORA' TP'99:99:99')
           AUDRCDTY
           AUDCPUID('SYSNAME')
           AUDUSER('USER|NAME')
           AUDJOBN('FOLDER|JOBNAME')
           AUDJOBID('FOLDER|JOB-ID')
           AUDOBJT('TYPE OF|OBJ')
           AUDFNAME('FOLDER|NAME' 40)

SORT:      AUDRCDTE AUDRCDTS

Produce This SMF Report:


                                         FOLDER AUDIT STATISTICS
                             USER    FOLDER   FOLDER  TYPE OF                  FOLDER                   

DOCUMENT
   DATA     ORA    SYSNAME   NAME   JOBNAME   JOB-ID    OBJ                     NAME
 ________ ________ _______ ________ ________ ________ _______ ________________________________________

 04/14/12 10:00:08  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   05381:ET   -NRYNRT69C59L049N
 04/14/12 10:00:08  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   01943:CR   -TRNGMO58C10E690Z
 04/14/12 10:00:09  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   07087:IG   -VRZGMT69L46D423F
 04/14/12 10:00:15  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   15364:EH   -TVSMOZ63C64C623L
 04/14/12 10:00:16  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   14930:EH   -QSADUT67D64G388J
 04/14/12 10:00:19  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   14930:EH   -QSADUT67D64G388J
 04/14/12 10:00:20  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   01982:TB   -KLMVNK79T63B220O
 04/14/12 10:00:21  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   55598:EH   -VRZDUT70R58B300L
 04/14/12 10:00:24  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   01943:CR   -TRNGMO58C10E690Z
 04/14/12 10:00:28  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   03069:10636458-GRCMRA67M16G273I
 04/14/12 10:00:30  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   05381:ET   -NRYNRT69C59L049N
 04/14/12 10:00:31  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   10046:PD   -NRTMHL68M65G224P
 04/14/12 10:00:33  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   55598:EH   -VRZDUT70R58B300L
 04/14/12 10:00:33  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   00831:KC   -RYNMNL67D60I452F
 04/14/12 10:00:36  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   00399:RF   -QRNPRZ59C06E169F
 04/14/12 10:00:38  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   05562:XF   -TRMVEA65D62D704Q
 04/14/12 10:00:44  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   55598:EH   -VRZDUT70R58B300L
 04/14/12 10:00:47  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   03069:18357866-GCNLRA64M51H501O
 04/14/12 10:00:47  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   04182:ET   -TCRBNR75D05A662Y
 04/14/12 10:00:52  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   02827:IG   -FRCQMA60H51H501H
 04/14/12 10:00:53  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   55598:EH   -VRZDUT70R58B300L
 04/14/12 10:00:55  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   00519:FV   -TMOQMA67P41H657Z
 04/14/12 10:00:55  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   68740:EH   -QSCGLL73E57L727P
 04/14/12 10:00:56  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   03069:10632644-RNRGNN56H51B594L
 04/14/12 10:00:58  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   71377:EH   -TMNPQM82M03F839L
 04/14/12 10:00:59  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   03069:18357679-NLLLRA66L63I690T
 04/14/12 10:01:03  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   55598:EH   -VRZDUT70R58B300L
 04/14/12 10:01:09  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   02827:IG   -FRCQMA60H51H501H
 04/14/12 10:01:12  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   00105:EH   -RNCFRC70C23G388I
 04/14/12 10:01:13  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   03069:10631208-BLLMLS61R54E514K
 04/14/12 10:01:13  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   55026:EH   -CRSMLS63H65E514T
 04/14/12 10:01:15  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   03069:18402811-ZNGGPP60P11B808D
 04/14/12 10:01:16  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   55598:EH   -VRZDUT70R58B300L
 04/14/12 10:01:18  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   07381:ET   -NRTRHL68A55H703L
 04/14/12 10:01:18  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   15364:EH   -TVSMOZ63C64C623L
 04/14/12 10:01:19  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   01394:CR   -CMOGDU60L03A462L
 04/14/12 10:01:20  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   03069:16102137-NSCMRN62E68E058Y
 04/14/12 10:01:27  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   01284:PV   -TTCGNR59L13F704O
 04/14/12 10:01:30  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   20880:EH   -VRYDRA73M14L182W
 04/14/12 10:01:30  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   52551:EH   -RYRMDU69E61D969M
 04/14/12 10:01:32  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   04182:ET   -TCRBNR75D05A662Y
 04/14/12 10:01:33  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   00794:NZ   -NRNGPP82A28I564C
 04/14/12 10:01:35  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   04811:EH   -BRSMRA69B11F205T
 04/14/12 10:01:36  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   63026:EH   -NSSLDN76C49D969B
 04/14/12 10:01:38  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   00425:ET   -CZZMRP70L65H703D
 04/14/12 10:01:38  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   04182:ET   -TCRBNR75D05A662Y
 04/14/12 10:01:38  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   73032:EH   -BLCMRA80D65B774L
 04/14/12 10:01:40  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   15364:EH   -TVSMOZ63C64C623L
 04/14/12 10:01:42  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   68740:EH   -QSCGLL73E57L727P
 04/14/12 10:01:42  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   00399:RF   -QRNPRZ59C06E169F
 04/14/12 10:01:43  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   03069:10644770-RMNMRA72M28C618Z
 04/14/12 10:01:45  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   34399:EH   -GRLGMN66L51F205W
 04/14/12 10:01:48  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   04811:EH   -BRSMRA69B11F205T
 04/14/12 10:01:48  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   07264:IG   -ZRMGRG63D14G224F
 04/14/12 10:01:48  SYS3   ATPMW81  ARY4FLD@ T0144516   DOC   51020:EH   -TCRRNT59S09D472B

...

See Other Sample SMF Reports