Sample reports for Cleanup for Top Secret

Products

• Cleanup

Issue/Introduction

Are there any sample reports for Cleanup for Top Secret?

• What can be done with these samples?
  
  
• Is there a way to customize the reports?

Environment

Release:
Component: ETCLNT

Resolution

Yes, the Cleanup for Top Secret CAKOJCL0 library contains some sample JCL to run reports. These are only samples. They must be modified to meet your shop standards.

• DBRPT - This sample job can be used to report on the Cleanup database.
  
  
  • Change all occurrences of "CAI" and "CAI.ETCL" to indicate the data set name of your Cleanup tracking database.
    
    
  • Update the PARM= statement to indicate your threshold number of days for selecting either referenced or unreferenced items.
    
    Example:
    Code PARM='REF=5' to report items referenced within the past 5 days. Code PARM='UNREF=30' to report items unreferenced over 30 days.
    
    
  • PARM='BOTH' reports the entire tracking file. Both referenced and unreferenced items, without producing commands.
    
    To generate a selective report, add an INCLUDE statement specifying those entries you want reported. Or, add an EXCLUDE statement specifying those entries you do not want reported.
    
    Sample INCLUDE statement:

        //INCLUDE DD *    USERID1    CLASS(OTRAN)    /*

    Sample EXCLUDE statement:

        //EXCLUDE DD *    USERID2    CLASS(DSN) NAME(SYS)    /*

  
  
  

• DBRPTC - This sample job can be used to report on the Cleanup database and build commands files to remove unused Security File entries. The first step refreshes the Cleanup database so that obsolete entries are removed before command generation.
  
  
  • Change "CAI" and "CAI.ETCL" to indicate the data set name of your Cleanup tracking database.
    
    
  • Change all occurrences of "??????" to an appropriate volume for output datasets.
    
    
  • Update the PARM= statement to indicate your threshold number of days for selection of either referenced or unreferenced items.
    
    Example:
    Code PARM='REF=5' to report items referenced within the past 5 days. Code PARM='UNREF=30' to report items unreferenced over 30 days.
  
  
  
• DBRPTC36 - This sample job can be used to report on the Cleanup database and build the command file to remove unused security entries.
  
  
  • Change all occurrences of "CAI" and "CAI.ETCL" to appropriate data set names.
    
    
  • Change all occurrences of "??????" to an appropriate volume for output datasets.
    
    
  • Update the '//CFILE' statement to point to your latest complete security file unload built by TSSCFILE.
    
    
  • Update the PARM= statement to indicate your threshold number of days for selection either referenced or unreferenced items.
    
    Example:
    Code PARM='REF=5' to report items referenced within the past 5 days. Code PARM='UNREF=30' to report items unreferenced over 30 days.
  
  
  
• DBRPT01 - This sample job will split ETCL#RPT output into "GROUPS" of output. The GROUPIN file specifies ACIDs and assigns each a "GROUP NAME" for reporting. ETCL#RPT output will be reorganized and presented by each assigned GROUP NAME. ACIDs with no assigned reporting group will appear under a GROUP NAME of $$NONE$$. Each group is printed to a separate dynamically allocated SYSOUT file.
  
  
  • Change all occurrences of "CAI" and "CAI.ETCL" to appropriate data set names.
    
    
  • Change the following 'xx' to the reporting threshold in number of days or "ALL":
    
    SET UNREF=XX
    
    Example:
    SET UNREF=60
  
  
  
• DBRPT02 - This sample job will rearrange ETECL#RPT output into "GROUPS" of output. The GROUPIN file specifies ACIDs and assigns each "GROUP NAME" for reporting. ETCLN#RPT output will be reorganized and presented by each assigned GROUP NAME. ACIDs with no assigned reporting group will appear under the GROUP NAME of $$NONE$$. The output is then written as one file to SYSPRINT. Each group is separated by a page break. Many report distribution systems can route these groups to various recipients.
  
  
  • Change all occurrences of "CAI" and "CAI.ETCL" to appropriate data set names.
    
    Change the following 'xx' to the reporting threshold in number of days or "ALL"
    
    SET UNREF=XX
    
    Example:
    SET UNREF=60
  
  
  
• DBRPT03 - This sample job allows Cleanup reporting on resources instead of ACIDs and PROFILES.
  
  
  • Change all occurrences of "CAI" and "CAI.ETCL" to appropriate data set names.
    
    
  • Change the following 'xx' to the reporting threshold in number of days or "ALL"
    
    SET UNREF=XX
    
    Example:
    SET UNREF=02
    
    
  • Specify your selection criteria. Selection criteria can be a list of ACIDs, Class Names or Resource Names. You can use any or all of the keywords and can specify one of more of each. The keyword format is:
    
    
    • CLASS(class_name) NAME(resource_name_prefix)
      
      
    • Class Names are exactly matched.
      
      
    • Resource names are matched as a prefix value. That is, only the number of characters specified as input are compared. Match an exact name by adding a trailing blank in the input keyword.
      
      Example:
      NAME(ABC ) matches only resource ABC, while NAME(ABC) Matches any resource that starts with ABC.
  
  
  
• DBRPT04 - This sample job will run a selective Cleanup report for all ACIDS within a DEPARTMENT, DIVISION or ZONE.
  
  
  • Change all occurrences of "CAI" and "CAI.ETCL" to appropriate data set names.
    
    
  • Change the following 'xx' to the reporting threshold in number of days or "ALL":
    
    SET UNREF=XX
    
    Example:
    SET UNREF=ALL
    
    
    • Modify the SORT control statements to specify the DEPT, DIVISION or ZONE Name.
  
  
  
• DBRPT36 - This sample job will report on the entire Cleanup database.
  
  
  • Change all occurrences of "CAI" and "CAI.ETCL" to appropriate data set names.
    
    
  • Update the PARM= statement to indicate your threshold number of days for selection either referenced or unreferenced items.
    
    Example:
    Code PARM='REF=5' to report items referenced within the past 5 days.
    Code PARM='UNREF=30' to report items unreferenced over 30 days.

Yes, you can customize any of the Cleanup for Top Secret reports.

To create a custom report, add an //UNLOAD DD statement to your JCL. This file can then be fed into a report product, such as EASYTRIEVE to customize. The DCB information is not needed for the file creation, just the dataset name, space, volume, etc.