6.14 Produce Detail User TSO and Batch Audit Trail

Reporting Examples › 6.14 Produce Detail User TSO and Batch Audit Trail

6.14 Produce Detail User TSO and Batch Audit Trail


PROBLEM:

    From time to time you may need to thoroughly analyze the
    activity of an individual user for reasons of personnel
    management, security, performance, and so on.  To do
    this, you need a list of every batch program executed,
    the TSO resources used by periodic intervals (for
    example, every five minutes), every program executed
    interactively through TSO, and the TSO commands that have
    been used.

DATABASE FILES TO BE ACCESSED:

    &PBATX..BATPGM01
        Yesterday's Batch User Program Activity File
    &PTSOX..TSOTSU01
        Yesterday's TSO User Activity File
    &PTSOX..TSOTSI01
        Yesterday's TSO User Interactive Usage File
    &PTSOX..TSOTSC01
        Yesterday's TSO User Command Counts File


SUGGESTED SAS FACILITIES TO BE USED FOR REPORTING:

    PROC PRINT may be used to list the required data.

SAS CODE EXAMPLE:

************************************************************;
* DETAIL USER BATCH/TSO AUDIT                              *;
************************************************************;

DATA;
SET &PBATX..BATPGM01;
IF JOB='AXB009';
PROC PRINT; VAR JOB PROGRAM STARTTS ENDTS PGMSERVU;
TITLE "DETAIL USER BATCH/TSO AUDIT";
TITLE2 "BATCH PROGRAM EXECUTION LIST FOR USER AXB";
DATA;
SET &PTSOX..TSOTSU01;
IF USER='AXB009';
PROC PRINT; VAR USER STARTTS ENDTS TSUSERVU;
TITLE "DETAIL USER BATCH/TSO AUDIT";
TITLE2 "HOURLY TSO USAGE FOR USER AXB";
DATA;
SET &PTSOX..TSOTSI01;
IF USER='AXB009';
PROC PRINT; VAR USER PROGRAM STARTTS ENDTS TSISERVU;
TITLE "DETAIL USER BATCH/TSO AUDIT";
TITLE2 "TSO PROGRAM EXECUTION LIST FOR USER AXB";
DATA;
SET &PTSOX..TSOTSC01;
IF USER='AXB009';
PROC SORT; BY STARTTS COMMAND;
PROC PRINT; VAR USER COMMAND STARTTS ENDTS TSCCOUNT;
TITLE "DETAIL USER BATCH/TSO AUDIT";
TITLE2 "TSO COMMAND INVOCATION LIST FOR USER AXB";


GENERATED OUTPUT REPORT:

    Figure 6-12 illustrates the output reports produced by
the SAS code illustrated above.

DETAIL USER BATCH/TSO AUDIT 16:18 THURSDAY, APRIL 20, yyyy BATCH PROGRAM EXECUTION LIST FOR USER AXB OBS JOB PROGRAM STARTTS ENDTS PGMSERVU 1 AXB009 IKJEFT01 16APR09:21:48:08.64 17APR09:00:10:17.03 357879 2 AXB009 IKJEFT01 17APR09:10:12:06.43 17APR09:10:13:52.77 15007 3 AXB009 IKJEFT01 17APR09:10:14:10.78 17APR09:10:33:25.71 23234 4 AXB009 SORT 17APR09:10:33:59.13 17APR09:10:34:39.46 3200 5 AXB009 SORT 17APR09:13:01:18.70 17APR09:13:43:38.86 75122 6 AXB009 IKJEFT01 17APR09:13:48:29.41 17APR09:13:58:42.06 39394 DETAIL USER BATCH/TSO AUDIT 16:18 THURSDAY, APRIL 20, yyyy HOURLY TSO USAGE FOR USER AXB OBS USER STARTTS ENDTS TSUSERVU 1 AXB009 17APR09:00:07:15.11 17APR09:00:12:15.12 43913 2 AXB009 17APR09:10:16:18.85 17APR09:10:16:18.85 15007 3 AXB009 17APR09:10:16:18.85 17APR09:10:16:18.85 9052 4 AXB009 17APR09:10:21:19.46 17APR09:10:21:19.46 8624 5 AXB009 17APR09:10:26:19.90 17APR09:10:26:19.90 1549 6 AXB009 17APR09:10:31:20.68 17APR09:10:31:20.68 2702 7 AXB009 17APR09:10:36:21.40 17APR09:10:36:21.40 1307 8 AXB009 17APR09:10:36:21.40 17APR09:10:36:21.40 3200 9 AXB009 17APR09:13:01:45.48 17APR09:13:01:45.48 10407 10 AXB009 17APR09:13:06:45.98 17APR09:13:06:45.98 9185 11 AXB009 17APR09:13:11:46.65 17APR09:13:11:46.65 20619 12 AXB009 17APR09:13:16:47.15 17APR09:13:16:47.15 15701 13 AXB009 17APR09:13:21:48.13 17APR09:13:21:48.13 2989 14 AXB009 17APR09:13:26:48.72 17APR09:13:26:48.72 287 15 AXB009 17APR09:13:31:49.36 17APR09:13:36:49.95 1621 16 AXB009 17APR09:13:41:51.11 17APR09:13:41:51.11 8705 17 AXB009 17APR09:13:46:51.79 17APR09:13:46:51.79 5608 18 AXB009 17APR09:13:46:51.79 17APR09:13:51:52.36 17123 19 AXB009 17APR09:13:51:52.36 17APR09:13:56:53.77 17531 20 AXB009 17APR09:14:01:54.96 17APR09:14:01:54.96 4740 DETAIL USER BATCH/TSO AUDIT 16:18 THURSDAY, APRIL 20, yyyy TSO PROGRAM EXECUTION LIST FOR USER AXB OBS USER PROGRAM STARTTS ENDTS TSISERVU 1 AXB009 STARTREK 16APR09:21:48:08.64 17APR09:00:10:17.03 7079 2 AXB009 SORT 17APR09:10:12:06.43 17APR09:10:13:52.77 5607 3 AXB009 SAS 17APR09:10:14:10.78 17APR09:10:33:25.71 934 DETAIL USER BATCH/TSO AUDIT 16:18 THURSDAY, APRIL 20, yyyy TSO COMMAND INVOCATION LIST FOR USER AXB OBS USER COMMAND STARTTS ENDTS TSCCOUNT 1 AXB009 LOGOFF 17APR09:00:07:15.11 17APR09:00:12:15.12 1 2 AXB009 RELEASE 17APR09:00:07:15.11 17APR09:00:12:15.12 7 4 AXB009 ALLOCATE 17APR09:10:16:18.85 17APR09:10:36:21.40 13 5 AXB009 DELETE 17APR09:10:16:18.85 17APR09:10:16:18.85 2 6 AXB009 END 17APR09:10:16:18.85 17APR09:10:16:18.85 2 7 AXB009 EXECUTE 17APR09:10:16:18.85 17APR09:10:36:21.40 10

Figure 6-12.  Detail User Batch/TSO Audit