IBM Security Z Security

Expand all | Collapse all

Displaying only certain values in a CARLA report

  • 1.  Displaying only certain values in a CARLA report

    Posted Thu August 27, 2020 10:13 AM

    Using CARLA to write a report by userids that are connected to groups that begin with for example "AB" and want it listed by ID and owned by group.  I used zSecure to write the report and that worked well to get me mostly there.  The problem I have is on the report I only want to see the connected groups that begin "AB" and it shows all the groups the ID is connected to.  Is there a way to filter off the values you don't want to see.  I just want to see the values that begin wit "AB."         



    ------------------------------
    Chad Long
    ------------------------------


  • 2.  RE: Displaying only certain values in a CARLA report

    Posted Thu August 27, 2020 10:49 AM
    Edited by Tom Zeehandelaar Thu August 27, 2020 10:50 AM
    Hi Chad,

    Yes there is.
    Currently your report selects all user IDs that are connected to groups starting with "AB". That selection will select all user IDs where at least one of their connected groups starts with AB. These user IDs are selected including their connection groups.
    What you want to do is define a variable that sub selects the list of connected groups to select only the connected groups that start with "AB".

    DEFINE #stripcon subselect connects(group=AB*)​


    Next, you must replace the variable connects with #stripconin your SORTLIST statement.
    That should result in that all selected user ID by your SELECT statement are now reported with only their connection groups that start with "AB".
    I hope this helps.

    Best regards, Tom


    ​​​

    ------------------------------
    Tom Zeehandelaar
    z/OS Security Enablement Specialist - zSecure developer
    IBM
    Delft
    +31643351728
    ------------------------------



  • 3.  RE: Displaying only certain values in a CARLA report

    Posted Thu August 27, 2020 07:17 PM
    Thank you I was able to use that define statement to make the report work

    ------------------------------
    Chad Long
    ------------------------------



  • 4.  RE: Displaying only certain values in a CARLA report

    Posted Thu August 27, 2020 10:55 AM
    Hi Chad,

    If I am reading you correctly you have something like

    newlist type=racf
    select class=user segment=base cggrpnm=AB*
    sortlist key(8) owner connects

    And you are looking for something like

    newlist type=racf
    select class=user segment=base cggrpnm=AB*
    def limited subselect connects(group=AB*)
    sortlist key(8) owner limited

    Does that help?

    Regards,
    Jeroen

    ------------------------------
    Jeroen Tiggelman
    Software Development and Level 3 Support Manager IBM Security zSecure Suite
    IBM
    Delft
    ------------------------------



  • 5.  RE: Displaying only certain values in a CARLA report

    Posted Thu August 27, 2020 07:19 PM
    Thank you I used the define statement you suggested def limited subselect connects(group=AB*) and I got the results I wanted.  Thank you again for your help 

    ------------------------------
    Chad Long
    ------------------------------