Hi all,

I'm new here and have a question regarding Consul tool report generation. If I generate a report of userids, names, dfltgrp, owner & creadate, they currently go to a dataset that I allocate in the batch job. Can someone tell me what's required to generate the report as a csv file?

Thanks.

Laura Bolz

Hi Laura

The NEWLIST command can be used to control output format using the HEADER parameter:

CSV - comma separated variables

CSVT - CVS with a title line

TSV - tab separated variables

TSVT - TSV with a title line

zSecure put the column header into the title line, so you can influence this value using overriding headers in the SORTLIST command.

For example

newlist type=racf dd=ckr2pass header=csvt

s class=user special

sortlist key("userid") dfltgrp owner creadate("created")

generates

userid,DfltGrp,Owner,created

AES,OMVS,ROOT,"29 Jun 2007"

ALOG,SYS1,SYS1,"10 Feb 2021"

BL,OMVS,IBMUSER," 7 Jul 2003"

BPXROOT,OMVS,IBMUSER,"23 May 2014"

Field values with spaces and special characters are quoted, so if you want your spreadsheet to interpret these as dates, select a format or length that doesn't contain spaces, and preferably only contains numbers, such as USDATE or $DATE.

You might actually prefer HEADER=TSVT because this uses the TAB character between fields, so quotes are much less of an issue. Spreadsheets know how to interpret TSV files.

Hi Rob, so if I run the above newlist commands from the Consul tool under co (run commands from library), C (type in any carla command), I get below message:

CKR0981 12 Invalid NEWLIST_HEADER "CSVT  "    

CKR0000 12 CKRCARLA terminated due to input errors 

Am I missing something here? Thanks so much for replying.

HEADER=CSV was first shipped in 2017 as a PTF on zSecure 2.3.0, and later in 2.3.1. There are so many improvements and new functions in new releases that it is worthwhile to keep up to date with zSecure, even if you do not upgrade z/OS.

Thanks Rob. So we're up to date on Z/OS, but apparently, not on zSecure Admin & Audit Tool. Thanks for this. I'll get with our systems programmers and have them get the newest one installed. We're apparently only on 2.2.0.

Please remind the sysprogs:

• typically you can run the newest zSecure release on any supported z/OS release
• you should always download installation materials and all available maintenance from shop Z
• order the documentation kit from shop Z or go to Documentation to get access to licensed documentation

Perfect! Thanks so much Rob!