Creating customized reports

You can create your own reports using the RACFICE PROC by following these steps:

Identify the records that you want for the report.
1. Define the DFSORT statements for the record selection criteria.
2. Place them in the RACFICE data set with a unique member name consisting of a 1-4 character report identifier followed by CNTL.
If there is an existing RACFICE report that has similar selection criteria, use it as a model. For example, if you want to report all the access records created when users PATTY, MAXINE, and LAVERNE accessed resources, you need to create DFSORT selection statements that look like Figure 1 and store them in your RACFICE report data set as the PMLCNTL member.
Figure 1. Customized Record Selection Criteria.
```
INCLUDE COND=(63,8,CH,EQ,C'PATTY',OR,
        63,8,CH,EQ,C'MAXINE',OR,
        63,8,CH,EQ,C'LAVERNE')
OPTION  VLSHRT
```
Note the similarity of this record selection criteria to the "Selected User" record selection criteria shown in Figure 1.

For complete details about the DFSORT statements, see DFSORT Application Programming Guide.
Identify the report format you want to use.
1. Define the ICETOOL statements for the report format.
2. Place them in the RACFICE data set with a 1-4 character report identifier that you chose.
If there is an existing RACFICE report that has similar report format, use it as a model. For example, if you wanted your report to contain the user ID, job name, date, time, and status of the access you could use the ICETOOL report statments shown in Figure 2, and store them in your RACFICE report data set as the PML member.
Figure 2. Customized Report Format
```
COPY    FROM(ADUDATA) TO(TEMP0001) USING(RACF)
DISPLAY FROM(TEMP0001) LIST(PRINT) -
        PAGE -
        TITLE('Patty, Maxine, and Laverne''s Accesses')-
        DATE(YMD/) -
        TIME(12:)  -
        BLANK -
        ON(63,8,CH)  HEADER('User ID') -
        ON(5,8,CH)   HEADER('Event') -
        ON(12,8,CH)  HEADER('Qualifier') -
        ON(23,8,CH)  HEADER('Time') -
        ON(32,10,CH) HEADER('Date') -
        ON(184,8,CH) HEADER('Job Name')
```
Note the similarity of this report format to the "Selected User" report format shown in Figure 1.

For complete details about the ICETOOL statements, see DFSORT Application Programming Guide.
Update the report JCL to invoke the RACFICE PROC with the 1-4 character report identifier you chose, as shown in Figure 3.
Figure 3. Customized Report JCL
```
//jobname  JOB  Job card...
//stepname EXEC RACFICE,REPORT=PML
```