pastaguy
asked on
formatting RACF Listuser output
i requested a user list and within the output the user record is split across two or three rows and no common delimiter that i could use to pull the data into a spreadsheet/database to analyze.
here are three examples of user records as they appear in the output; based on the user having privileges or not, I'm getting 3 different record formats for users within the same output
USER=ASCHINT NAME=S-ASCHINT STC OWNER=DC CREATED=01.190
INSTALLATION-DATA=IBM 903361
USER=ATTDAEMN NAME=S-BROWN.MATTHEW OWNER=$MVSST CREATED=10.064
INSTALLATION-DATA=IBM 903361 897
UID= 0000000000
USER=BMUC061 NAME=B-RICHARDT.NICK OWNER=GP CREATED=00.003
ATTRIBUTES=OPERATIONS
INSTALLATION-DATA=IBM 8A8348 897
need a script to make the above look like (structured column and row data)
here are three examples of user records as they appear in the output; based on the user having privileges or not, I'm getting 3 different record formats for users within the same output
USER=ASCHINT NAME=S-ASCHINT STC OWNER=DC CREATED=01.190
INSTALLATION-DATA=IBM 903361
USER=ATTDAEMN NAME=S-BROWN.MATTHEW OWNER=$MVSST CREATED=10.064
INSTALLATION-DATA=IBM 903361 897
UID= 0000000000
USER=BMUC061 NAME=B-RICHARDT.NICK OWNER=GP CREATED=00.003
ATTRIBUTES=OPERATIONS
INSTALLATION-DATA=IBM 8A8348 897
need a script to make the above look like (structured column and row data)
user name owner created attributes installation-data UID
ASCHINT S-ASCHINT STC DC 01.190 IBM 903361
ATTDAEMN S-BROWN.MATTHEW $MVSST 10.064 IBM 903361 897 0000000000
BMUC061 B-RICHARDT.NICK GP 00.003 OPERATIONS IBM 8A8348 897
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@arober11
That's a nice approach, but pastaguy would still need to align the columns.
That's a nice approach, but pastaguy would still need to align the columns.
I usually associate RACF with mainframe operating systems. How are you using RACF in a Windows environment?