EDGJAUDW examples

See the reports that you can produce using the EDGJAUDW sample JCL in Figure 1, Figure 2, and Figure 3.

Figure 1 is sorted by volume serial number and date. The sample report includes all SMF audit records for the week.

Figure 1. EDGJAUDW: Sample Report of a weekly audit Report sorted by volume

 DFSMSrmm - Volume Audit Report Consolidation        11/27/12        17:56:44        - 1 -

 VOLUME RACK-#    OWNER     ACTIVITY    USERID       DATE      TIME   SYS     EXP-DATE  SEC   STATUS LOCATION    LOAN-LOC
 -------------   --------   --------   --------   ------------------------   --------------   ----------------   --------
 111001 111001   RDRHSME    UPDATE     BJK        26/11/2012 01:00:32 E4E4   19/11/2012 U     VITAL   REMOTE
 111002 111002   RDRHSME    UPDATE     DENZEL     26/11/2012 01:00:32 E4E4   19/11/2012 U     VITAL   REMOTE
 111004 111004   RDROPCA    UPDATE     GILLPAT    26/11/2012 01:00:32 E4E4   18/11/2012 U     VITAL   SHELF
 111008 111008   RDRHSME    UPDATE     MOREY      26/11/2012 01:00:33 E4E4   06/12/2012 U     VITAL   SHELF
 111009 111009   RDRHSME    UPDATE     PALMER     26/11/2012 01:00:33 E4E4   19/11/2012 U     VITAL   REMOTE
 111015 111015   RDROPCA    UPDATE     PENDLTN    26/11/2012 01:00:33 E4E4   21/05/2012 U     VITAL   SHELF
 111016 111016   RDRHSME    UPDATE     RDRHSME    26/11/2012 01:00:33 E4E4   29/08/2012 U     VITAL   SHELF
 111017 111017   RDRHSME    UPDATE     STCHSM     26/11/2012 01:00:33 E4E4   30/11/2012 U     VITAL   SHELF
 111018 111018   RDRHSME    UPDATE     TAUBER     26/11/2012 01:00:34 E4E4   22/10/2012 U     VITAL   SHELF
 111019 111019   RDROPCA    UPDATE     WHEELER    26/11/2012 01:00:34 E4E4   25/06/2012 U     VITAL   REMOTE
 111020 111020   RDRHSME    UPDATE     WRIGHT     26/11/2012 01:00:34 E4E4   14/03/2012 U     VITAL   SHELF
 111021 111021   RDROPCA    UPDATE     ZOUNEK     26/11/2012 01:00:34 E4E4   25/06/2012 U     VITAL   REMOTE

The data columns are:

VOLUME

The Volume serial number (VOLSER).

Rack-#

The rack number, which is the identifier that corresponds to a specific volume's shelf location.

OWNER

The user ID of the volume owner.

ACTIVITY

The action that was the cause for this record. ACTIVITY can be: CREATE, DELETE, or UPDATE.

USERID

User ID of the person who caused the last change.

DATE

The last change date.

TIME

The last change time.

SYS

The system ID of the system where the last change occurred.

EXP-DATE

The date that the volume should be considered for release.

SEC

The security classification level.

STATUS

The status of the volume, which can be one of the following:

VITAL
SCRATCH
LOAN
OPEN
MASTER
USER

LOCATION

The name of the volume's location.

LOAN.LOC

The loan location, which is the location of the volume if it is on loan.

Figure 2 is sorted by rack number and date. The report includes all the SMF audit records for the week.

Figure 2. EDGJAUDW: Sample Report of a weekly audit Report sorted by rack number

 DFSMSrmm - Rack Audit Report Consolidation        11/27/12        17:56:52        - 1 -

 RACK/BIN VOLUME    OWNER     ACTIVITY    USERID       DATE      TIME   SYS     EXP-DATE  SEC   STATUS LOCATION    LOAN-L
 ---------------   --------   --------   --------   ------------------------   --------------   ----------------   ------
 000001   111001   RDRHSME    UPDATE     BJK        26/11/2012 01:00:32 E4E4   19/11/2012 U     VITAL   REMOTE
 000002   111019   RDROPCA    UPDATE     DENZEL     26/11/2012 01:00:34 E4E4   25/06/2012 U     VITAL   REMOTE
 000003   111137   RDRHSME    UPDATE     GILLPAT    26/11/2012 01:00:44 E4E4   26/11/2012 U     VITAL   REMOTE
 000004   111021   RDROPCA    UPDATE     MOREY      26/11/2012 01:00:34 E4E4   25/06/2012 U     VITAL   REMOTE
 000005   111023   RDROPCA    UPDATE     PALMER     26/11/2012 01:00:35 E4E4   25/06/2012 U     VITAL   REMOTE
 000006   111036   RDROPCA    UPDATE     PENDLTN    26/11/2012 01:00:35 E4E4   25/06/2012 U     VITAL   REMOTE
 000007   111044   RDROPCA    UPDATE     RDRHSME    26/11/2012 01:00:35 E4E4   25/06/2012 U     VITAL   REMOTE
 000008   111050   RDROPCA    UPDATE     STCHSM     26/11/2012 01:00:36 E4E4   25/06/2012 U     VITAL   REMOTE
 000009   111051   RDROPCA    UPDATE     TAUBER     26/11/2012 01:00:36 E4E4   25/06/2012 U     VITAL   REMOTE
 000010   111066   RDROPCA    UPDATE     WHEELER    26/11/2012 01:00:37 E4E4   25/06/2012 U     VITAL   REMOTE
 000011   111139   RDRHSME    UPDATE     WRIGHT     26/11/2012 01:00:44 E4E4   26/11/2012 U     VITAL   REMOTE
 000012   111140   RDRHSME    UPDATE     ZOUNEK     26/11/2012 01:00:44 E4E4   26/11/2012 U     VITAL   REMOTE

In addition to the data columns that are described in Figure 1, this sample report includes an additional data column:

RACK or BIN: The rack number, which is the identifier that corresponds to a specific volume's shelf location.

Figure 3 is sorted by user ID and date and time. The report includes all the SMF audit records for the day. See Figure 1 for the description of the data columns that are used in this report.

Figure 3. EDGJAUDW: Sample Report of a weekly audit Report sorted by userid

 DFSMSrmm - User Audit Report Consolidation        11/27/12        17:56:57        - 1 -

 USERID     VOLUME RACK-#   ACTIVITY    OWNER        DATE      TIME   SYS     EXP-DATE  SEC   STATUS LOCATION    LOAN-LOC
 --------   -------------   --------   --------   ------------------------   --------------   ----------------   --------
 BJK        111001 111001   UPDATE     RDRHSME    26/11/2012 01:00:32 E4E4   19/11/2012 U     VITAL   REMOTE
 DENZEL     111002 111002   UPDATE     RDRHSME    26/11/2012 01:00:32 E4E4   19/11/2012 U     VITAL   REMOTE
 GILLPAT    111004 111004   UPDATE     RDROPCA    26/11/2012 01:00:32 E4E4   18/11/2012 U     VITAL   SHELF
 MOREY      111008 111008   UPDATE     RDRHSME    26/11/2012 01:00:33 E4E4   06/12/2012 U     VITAL   SHELF
 PALMER     111009 111009   UPDATE     RDRHSME    26/11/2012 01:00:33 E4E4   19/11/2012 U     VITAL   REMOTE
 PENDLTN    111015 111015   UPDATE     RDROPCA    26/11/2012 01:00:33 E4E4   21/05/2012 U     VITAL   SHELF
 RDRHSME    111016 111016   UPDATE     RDRHSME    26/11/2012 01:00:33 E4E4   29/08/2012 U     VITAL   SHELF
 STCHSM     111017 111017   UPDATE     RDRHSME    26/11/2012 01:00:33 E4E4   30/11/2012 U     VITAL   SHELF
 TAUBER     111018 111018   UPDATE     RDRHSME    26/11/2012 01:00:34 E4E4   22/10/2012 U     VITAL   SHELF
 WHEELER    111019 111019   UPDATE     RDROPCA    26/11/2012 01:00:34 E4E4   25/06/2012 U     VITAL   REMOTE
 WRIGHT     111020 111020   UPDATE     RDRHSME    26/11/2012 01:00:34 E4E4   14/03/2012 U     VITAL   SHELF
 ZOUNEK     111021 111021   UPDATE     RDROPCA    26/11/2012 01:00:34 E4E4   25/06/2012 U     VITAL   REMOTE