Hi Daniel
You can use an SMF report to identify users that have accessed data sets. These reports can be found under EV.D (events - data sets), but the layout of these reports is not very flexible. So it may be easier to write a trivial little CARLa program to get your report.
First, you need an SMF dump data set. You add this to an input set under SE.1, with input type SMF.
Next, you need a RACF database for input, and a CKFREEZE data set. The CKFREEZE is optional, but if you omit is, you MUST add a command SUPPRESS CKFREEZE in the CARLa program.
This is the whole program:
newlist type=smf
select class=dataset :owner=sysauth intent>=read
summary profile * userid intent(max)
summary userid intent(max) * profile
The :OWNER selection tells zSecure to look up the OWNER value from the RACF database. This supports SMF record types that do not contain RACF infos, like SMF 14 and 15.
There are 2 reports produced, one by profile, like so:
Profile User Intent
C2POLICE.*.** ALTER
IBMUSER UPDATE
C2PSUSER ALTER
This shows the profile and the highest access level anyone used, from the SMF records. Next it shows the user ids and the access they used.
The second report lists per user id, the profiles:
User Intent Profile
CKNSERVE READ
USER.*.**
CKQRADAR READ
SYS1.*.**
USER.*.**
Note, you may find entries with a missing (blank) user id, this may be due to an SMF record that did not contain a user id. You can suppress these with an extra command
EXCLUDE MISSING(USERID)
------------------------------
Rob van Hoboken
------------------------------
Original Message:
Sent: Tue September 15, 2020 12:39 AM
From: Daniel Vuceric
Subject: CARLa: Dataset Profiles accessed by userids
Hi,
I want to produce a report which is able to show me all the userids that have accessed certain dataset profiles. These dataset profiles are owned by a specific OWNER.
I currently have a CARLa program which produces me a report with all the dataset profiles that are owned by this OWNER. However, I would like for this report to also produce all the userids who have accessed each of these dataset profiles.
Is there a way in producing this?
Any advice would be much appreciated.
Thanks.
Daniel
------------------------------
Daniel Vuceric
------------------------------