Customizing Reports › Modify Selection Criteria

Modify Selection Criteria

Use the SELECT statement to specify the records used for the report. In the original report, all records with a RECTYPE of P (indicating password violation) are reported.

You can use the SELECT statement for complex selection criteria. For example, you can select a particular logonid, on a particular CPU, from a specific source, on a given day. The following example selects all records that have a record type of P (RECTYPE 'P') and where the program is not SSD5 (PROGRAM NOT SSD5) for reporting.

SELECT RECTYPE  'P'  AND PROGRAM NOT 'SSD5'

The above program modification produces the following changes in this report.

03/29/02                           LOGON AND PASSWORD VIOLATIONS

                 STARTING DATE: 03‑29‑02    ENDING DATE: 03‑29‑02 
                 STARTING TIME: 10.59       ENDING TIME:  3.04 
‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑
     DATE   TIME         LOGONID   JOBNAME   SUBMITTOR  SOURCE     PROGRAM    REA 
                                             LID/PROC                           C 
‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑‑ 
03‑29‑02  10.59.30  AM  AUEJJV                         H06L84F 
03‑29‑02  11.09.55  AM  TLCISO    STARMAN   STARMAN    USCHGOVB 
03‑29‑02  11.21.50  AM  TLCISO    TLCISO    LOGON      V4L3ED 
03‑29‑02   1.24.58  PM  SSESWB    SSESWB    LOGON      V4L3E0 
03‑29‑02   2.02.48  PM  SVNSKS    SVNSKS    LOGON      V4L3EA 
03‑29‑02   2.20.10  PM  TSTRJM                         H06L867 
03‑29‑02   2.48.36  PM  AUEDRL                         H06L83D