How to Extract Certain data fields



All about SAF, RACF, encryption, Firewall, Risk assessment and integrity concepts

How to Extract Certain data fields

Postby ak1153 » Wed Jun 12, 2013 9:51 pm

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
ak1153
 
Posts: 3
Joined: Wed Jun 12, 2013 9:44 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to Extract Certain data fields

Postby Pedro » Wed Jun 12, 2013 9:54 pm

users profile

Can you elaborate? There are various user profiles.
Pedro Vera
User avatar
Pedro
 
Posts: 684
Joined: Thu Jul 31, 2008 9:59 pm
Location: Silicon Valley
Has thanked: 0 time
Been thanked: 53 times

Re: How to Extract Certain data fields

Postby steve-myers » Wed Jun 12, 2013 9:55 pm

What tool / programming language are you using? What environment? TSO? Batch?
steve-myers
Global moderator
 
Posts: 2105
Joined: Thu Jun 03, 2010 6:21 pm
Has thanked: 4 times
Been thanked: 243 times

Re: How to Extract Certain data fields

Postby Akatsukami » Wed Jun 12, 2013 9:59 pm

Is this not a RACF question?
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: How to Extract Certain data fields

Postby ak1153 » Wed Jun 12, 2013 10:08 pm

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!
ak1153
 
Posts: 3
Joined: Wed Jun 12, 2013 9:44 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to Extract Certain data fields

Postby BillyBoyo » Wed Jun 12, 2013 10:46 pm

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.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: How to Extract Certain data fields

Postby ak1153 » Wed Jun 12, 2013 11:13 pm

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"
ak1153
 
Posts: 3
Joined: Wed Jun 12, 2013 9:44 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to Extract Certain data fields

Postby Akatsukami » Wed Jun 12, 2013 11:33 pm

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.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: How to Extract Certain data fields

Postby Robert Sample » Wed Jun 12, 2013 11:51 pm

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.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times


Return to Mainframe Security

 


  • Related topics
    Replies
    Views
    Last post