IBM Security Z Security

 View Only

  • 1.  EMPTYLIST='NO DATA' date time needed

    Posted Tue April 16, 2024 08:00 PM

    Hello, not finding a way to have a date/time in a report when using EMPTYLIST and nothing is returned. I see toptitle, subtitle, page number and my text from the emptylist parm. Since there is nothing found, the "sortlist" with the "stamp" parm is not executed.

    I checked the CARLA guide but not finding anything i can use. Is there something i can add to the NEWLIST for a date/time to be added when emptylist is used  ?

    Thanks.



    ------------------------------
    Joseph Sumi
    ------------------------------


  • 2.  RE: EMPTYLIST='NO DATA' date time needed

    Posted Wed April 17, 2024 04:35 AM

    The page headers reflect the time stamp applying to the 1st record on the page. EMPTYLIST describes the case there is no record, so there is also nothing to decide what time stamp to display.

    I would suggest that you enrich the report with output from TYPE=RUN_DD that shows what input was used for the report, and what the timestamps are for the input CKFREEZE and UNLOAD files. For inspiration you can look in SCKRCARL(CKRLQEF).

    If in SE.T you tag "  _ Report files used by program  " it would include CKRDQEF on a display and CKRLQEF at the end of the print output for a print format background run.  But that might include more data sets than you want to see; CKR%QEF also include CARLa input data sets and output data sets.

    If you also want to know when and where the report was created there is also TYPE=RUN, see SCKRCARL(CKLQEV) for insipiration.



    ------------------------------
    Hans Schoone
    Chief Architect zSecure
    IBM - zSecure architect
    Delft
    ------------------------------

    Original Message


  • 3.  RE: EMPTYLIST='NO DATA' date time needed

    Posted Wed April 17, 2024 04:41 AM

    Actually, I M=CKRLQEF0 is probably the right imbed for you, since that just shows the security databases and snapshot files and their time stamps.



    ------------------------------
    Hans Schoone
    Chief Architect zSecure
    IBM - zSecure architect
    Delft
    ------------------------------

    Original Message


  • 4.  RE: EMPTYLIST='NO DATA' date time needed

    IBM Champion
    Posted Wed April 17, 2024 05:04 PM

    What kind of report are you writing?  SMF?  RACF profiles?

    As Hans pointed out, the time stamp information is related to the first record printed, or selected at least.  Take this CARLa:

    newlist type=racf emptylist='all special users are resumed'
      select class=user special revoked
      sortlist key(8) name

    I believe you could write this as 2 newlists:

    newlist type=racf
      define target_of_report count where  special revoked
      select class=user
      summary 'all special users are resumed' complex(nd) target_of_report(<1,nd)

    newlist type=racf
      select class=user special revoked
      sortlist key(8) name

    The first newlist counts the number of records the second newlist would print, but you have so write your critical selection as a where clause, as in, SELECT all users, and COUNT the ones you're interested in.  Then the SUMMARY command would print a literal if among the SELECTED profiles the target_of_report COUNT is equal to 0.  I've added COMPLEX(ND) because the summary command needs a field name, and I've used (ND) to suppress the field in the message (ND means non-display).  Since the SELECT command actually selects users, the page header should be filled in.

    If there are no users found, the second report is empty, and because there is no emptylist=' ' specified, the report is suppressed.

    Now, if there are users found, I believe the first newlist produces no output due to the threshold target_of_report<1.  And the second newlist has output.

    It is up to you to see if the page headers are as you want.

    Caveat: I have not tested the today, I remember having used it years ago.



    ------------------------------
    Rob van Hoboken
    ------------------------------

    Original Message