Page 1 of 1

How to Extract Certain data fields

PostPosted: Wed Jun 12, 2013 9:51 pm
by 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

Re: How to Extract Certain data fields

PostPosted: Wed Jun 12, 2013 9:54 pm
by Pedro
users profile

Can you elaborate? There are various user profiles.

Re: How to Extract Certain data fields

PostPosted: Wed Jun 12, 2013 9:55 pm
by steve-myers
What tool / programming language are you using? What environment? TSO? Batch?

Re: How to Extract Certain data fields

PostPosted: Wed Jun 12, 2013 9:59 pm
by Akatsukami
Is this not a RACF question?

Re: How to Extract Certain data fields

PostPosted: Wed Jun 12, 2013 10:08 pm
by 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!

Re: How to Extract Certain data fields

PostPosted: Wed Jun 12, 2013 10:46 pm
by 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.

Re: How to Extract Certain data fields

PostPosted: Wed Jun 12, 2013 11:13 pm
by 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"

Re: How to Extract Certain data fields

PostPosted: Wed Jun 12, 2013 11:33 pm
by Akatsukami
ak1153 wrote: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.

Re: How to Extract Certain data fields

PostPosted: Wed Jun 12, 2013 11:51 pm
by 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.