IBM Mainframe Forum

[ak1153]

hello All -

First post here, so please go easy on me.

I am trying to extract certain data fields from a users profile.
Here is what I want from my logic:
1. All IDs that begin with "UA" (i.e whois UA)
2. Within each ID Profile, there is a field called INSTDATA = ___________
3. I want to extract the ID along with this INSTDATA field.

How can I accomplish that?

Thank you in advance for all the anticipated support.
-AK

[Pedro]

users profile

Can you elaborate? There are various user profiles.

[steve-myers]

What tool / programming language are you using? What environment? TSO? Batch?

[Akatsukami]

Is this not a RACF question?

[ak1153]

Good question. I am an end user using TSO environment.

I am going to upload a screenshot of the information I am trying to extract. Please see the attached pdf.

Hopefully, this will offer some clarity into my question.

Thanks!

[BillyBoyo]

Please do not post images. Not everyone is able to, or wants to, download them, so it reduces the chance of you getting replies.

If showing anything from any sort of security system, please think very, very, carefully, and err on the side of caution.

Remember also that your site's "data protection policy" must be observed at all times.

[ak1153]

Understood. Sorry about that!

So to recap I am using TSO. I can extract a list of all user ids using the "WHOIS" command.

However, when I 'F4" into each user id, there is a "INSTDATA" field for that particular record and I would like to extract that for all User ids that being with "UA"

[Akatsukami]

Understood. Sorry about that!

So to recap I am using TSO. I can extract a list of all user ids using the "WHOIS" command.

However, when I 'F4" into each user id, there is a "INSTDATA" field for that particular record and I would like to extract that for all User ids that being with "UA"

You must realize that WHOIS is not a TSO command, but a locally-written CLIST or exec. "WHOIS" is a popular enough name that most sites probably have something with it, but they by no means function the same; my shop has a WHOIS exec, but it merely looks up the user name corresponding to a TSO ID on a DB2 table.

If you are serious about pursuing this, I suggest that you first find WHOIS in the SYSPROC and SYSEXEC concatenations for your ID (I'll start by assuming that it is either a CLIST or an exec) and post -- by copying and pasting from your terminal emulator, enclosed in Code tags -- the relevant code here.

[Robert Sample]

ak1153:

Even though you posted your question in the TSO/ISPF section of the forum, what you are asking is information stored in the RACF data base, not within TSO. As such, you would be better off asking your site support group for assistance in pulling out the data you want (it may already be available in a report or file). People who independently start doing things with employee security system data (which is what RACF data is), tend to become ex-employees rather rapidly.