IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

User Details using USERID


IBM Mainframe Forums -> CLIST & REXX
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
hsk

New User


Joined: 28 Nov 2006
Posts: 69
Location: India

PostPosted: Thu Oct 29, 2009 9:41 am
Reply with quote

In my Rexx Exec I am using USERID to get the current user.

TSO WHOIS userid, displays the details of user like First Name, Last Name etc ....

Can get these details in my Exec,

something like

FNAME = (First name of user "USERID") ....

With name, WHOIS also gives details like DEPT,EXNT num.

I want to check if email-id of the user is stored anywhere,
and if it stores, is there any way to fetch that.

In Short when user executes my exec i want to display following details


USER ID -
Name - Lname Fname
Extn - (if any .... )
Email-Id - ...........
(normally this is fname.lname@organization.com .... but can be diff for diff users)


Is this possible
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Thu Oct 29, 2009 12:40 pm
Reply with quote

Quote:
In Short when user executes my exec i want to display following details

And the business requirement to find out this information is .......................
Back to top
View user's profile Send private message
hsk

New User


Joined: 28 Nov 2006
Posts: 69
Location: India

PostPosted: Thu Oct 29, 2009 12:54 pm
Reply with quote

expat wrote:
Quote:
In Short when user executes my exec i want to display following details

And the business requirement to find out this information is .......................



We are building some utility which will send some report to different user's. There is some std JCL which sends email thruo mail server, users have to pass email-id as parm and sub this jcl.

I am tring to execute the JCL thro' rexx exec. For this i need e-mail address. One option is to prmpt for email-id and let user specify. But in that case there is no way to validate the address. Also any user can send mail to anybody and utility will not have control.

Another option is identify the USERID. That HAS TO BE unique, get email id frmo that and send mail only to that id.

Hope that clarifies what i am trying to do !!!
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1742
Location: Tirupur, India

PostPosted: Thu Oct 29, 2009 6:15 pm
Reply with quote

Hi,

Maybe the email parameter is a customisation at your shop for the WHOIS command.(I may be wrong here)
In our shop the o/p would look like,


Code:
---------------------------------------------------- XK89                     
User XK89 is VASANTH SHANMUGAM                                                 
and is in RACF Group GCDDLTST  last used on  09-10-28                         
Notes : VASANTH SHANMUGAM,IT PERM C/O SUNDARA VINAYAGAM,CONNECT               
Status Flags : NO  NO  NO  NO                                                 
---------------------------------------------------- XK89



This data is being fetched from a dataset called RAL.USERLIST.DATA. Which looks like,

Code:
  MAINFRAME USERIDS                                                             
                                                                               
SURNAME        FORENAME       USERID   DFLTGRP  INSTDATA                       
                                                                               
               XXXX           AI52     GCUSERV8 HID=WAS JADE MARTIN , LEFT 8 - 2
               XXXX           AI96     GCUSERV6 WAS KEVIN DORWARD,DUNDEE LEAVER
               XXXX           AP67     GCUSERV6 WAS VALERIE WILLIAMSON,DUNDEE LE
               XXXX           AV06     GCUSERV6 WAS STEPHEN FORBES,DUNDEE LEAVER


You can try to get the data from RAL.USERLIST.DATA if a similar dataset exists at your place.

Thanks & Regards,
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1742
Location: Tirupur, India

PostPosted: Thu Oct 29, 2009 6:23 pm
Reply with quote

A More reliable method is,

Execute the command TS ISRDDN,
It will list all the datasets allocated to your ID.

Code:
SRS121   SHR,KEEP   >             SYS3.ISP.SISPTENU                           
SYSLB5   SHR,KEEP   >             ZZ.V1R1M0.ISPTLIB                           
KTSO10   MOD,CATLG  >    ISP12384 XK89.SPFLOG3.LIST                           
SYSLB5   SHR,KEEP   >    STEPLIB  ZZ.V1R1M0.ISPLLIB                           
SYSLB5   SHR,KEEP   >    SYSHELP  T****.HELP                                 
SRS121   SHR,KEEP   >             SYS1.HELP                                   
         NEW,DEL    >    SYSIN    ---------- Allocated to the terminal -------
         NEW,DEL    >    SYSPRINT ---------- Allocated to the terminal -------
KTSO14   SHR,KEEP   >    SYSPROC  XK89.XK.CLIST                               
PRODD2   SHR,KEEP   >             ZX.DEV.CLIST                               
SPCAT0   SHR,KEEP   >             T****.CMDPROC                               
SRS121   SHR,KEEP   >             SYS3.ISP.SISPCLIB                           
SRS121   SHR,KEEP   >             SYS3.ISP.SISPEXEC                           
SYSLB6   SHR,KEEP   >             ZA.DEV.CLIST                               
         NEW,DEL    >    SYSTERM  ---------- Allocated to the terminal -------


Look for all the datasets allocated under SYSPROC DD name.

Go inside them and search for WHOIS REXX memeber.
Inside the member you will have the source of the data.

Hope this helps. icon_smile.gif
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Thu Oct 29, 2009 6:30 pm
Reply with quote

Contact your site security group. The user id is tied to name in the security package (RACF, ACF2, TOP SECRET) and there may (or may not) be an email address associated with it (probably not but these days it could be). The security group can tell you how to retrieve name (if you're allowed to) and so forth.
Back to top
View user's profile Send private message
hsk

New User


Joined: 28 Nov 2006
Posts: 69
Location: India

PostPosted: Fri Oct 30, 2009 11:45 am
Reply with quote

Thanks TANSTAAFL, Vasanth ........ that helps !!!
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1742
Location: Tirupur, India

PostPosted: Fri Oct 30, 2009 3:40 pm
Reply with quote

Hi,

Quote:
Thanks TANSTAAFL, Vasanth ........ that helps !!!



TANSTAAFL = There ain't no such thing as a Free lunch.

He is Mr.Robert Sample. Its his caption icon_biggrin.gif

Thanks & Regards,
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Fri Oct 30, 2009 4:53 pm
Reply with quote

amazing ...

first...
Donald Knuth

now...
TANSTAAFL

quite a steep descending slope icon_biggrin.gif
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Fri Oct 30, 2009 5:02 pm
Reply with quote

enrico --
Un learning curve? icon_smile.gif

What can I say? It's been quite a week!
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Fri Oct 30, 2009 5:39 pm
Reply with quote

hsk wrote:
Thanks TANSTAAFL...
Finally... icon_lol.gif
Back to top
View user's profile Send private message
hsk

New User


Joined: 28 Nov 2006
Posts: 69
Location: India

PostPosted: Sat Oct 31, 2009 9:47 am
Reply with quote

as long as my "thanks" are conveyed to right person .............

"What's there in name" ............. that's Shakespeare, don't blame me !!!
icon_cool.gif

Anyway ......... Mr.Robert, thanks a ton !!
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CLIST & REXX

 


Similar Topics
Topic Forum Replies
No new posts PuTTY - "User is not a surrogate... IBM Tools 5
No new posts How to delete a user's alias from the... JCL & VSAM 11
No new posts user exit in IBM Infosphere Optim DB2 8
No new posts Running a Job with the Default User ID JCL & VSAM 2
No new posts JCL SORT to compress the student's de... DFSORT/ICETOOL 7
Search our Forums:

Back to Top