Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2003
    Posts
    9

    Unanswered: operating system userid's of current users logged on

    Is there some utility of easy way of obtaining the list of operating system user id's (not auth ids) that I can manipulate via a script? We want to automatically send e-mail messages to users logged on to the system periodically. We are running UDB V7.2 on AIX. If I can get the OS UserID, I can generate the e-mail address. I notice in control center under client login ID that it displays it there. Does anyone know if there is a catalog table or an API that can be called to retrieve this information?

    Thanks,

    Cliff.

  2. #2
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170

    Re: operating system userid's of current users logged on

    Try This Command


    who | awk {'print $1'}




    Originally posted by chimes1967
    Is there some utility of easy way of obtaining the list of operating system user id's (not auth ids) that I can manipulate via a script? We want to automatically send e-mail messages to users logged on to the system periodically. We are running UDB V7.2 on AIX. If I can get the OS UserID, I can generate the e-mail address. I notice in control center under client login ID that it displays it there. Does anyone know if there is a catalog table or an API that can be called to retrieve this information?

    Thanks,

    Cliff.

  3. #3
    Join Date
    Feb 2003
    Posts
    9
    I need a list of the user id (operating system (windows, aix, etc.) user ids) that are CONNECTED TO UDB running under AIX.

    If I do a DB2 LIST APPLICATIONS, I can get a list of all the connections, their application ids, and auth IDs, but not the OS user ID.

    If you look at the connection object under databases in control center, it displays the client user id (which is the one I want); however, I need to be able to do it via a script or something so I can use that info to generate e-mail addresses.

    Thanks,

    Cliff.

  4. #4
    Join Date
    Dec 2002
    Posts
    134
    First get list of applications with agent id
    list applications
    then for every entry
    get snapshot for application agentid blah

    Or use Adminitsrative API

    regards,
    dmitri

  5. #5
    Join Date
    Nov 2002
    Location
    Rio de Janeiro - Brazil
    Posts
    78
    Hey,
    here´s a script I wrote few months ago. Take a look at it and change it as you need. In this, the OS user comes between brackets ('['):
    The variable $mlogin is the one with the OS user.

    Hope this Helps
    Fernando

    Originally posted by chuzhoi
    First get list of applications with agent id
    list applications
    then for every entry
    get snapshot for application agentid blah

    Or use Adminitsrative API

    regards,
    dmitri

  6. #6
    Join Date
    Mar 2012
    Posts
    1

    operating system userid's of current users logged on

    Hi,

    Could you please let me know the command/ script to find OS User in AIX..

    BR,
    Saumya

    Quote Originally Posted by F.OHANA View Post
    Hey,
    here´s a script I wrote few months ago. Take a look at it and change it as you need. In this, the OS user comes between brackets ('['):
    The variable $mlogin is the one with the OS user.

    Hope this Helps
    Fernando

  7. #7
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    Quote Originally Posted by saumya.bhadoriya View Post
    Could you please let me know the command/ script to find OS User in AIX..

    Not a DB2 question. You can use "lsuser ALL" or view /etc/passwd

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •