Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2009
    Posts
    1

    Unanswered: onstat -u (login about 3 month ago)

    Hello Board-Members,

    i'm looking for an opportunity to figure out user logins backwards, not only the currently logged in users on an ibm informix database.

    "onstat -u" displays all the information i need (user and tty) but i need to find out, from where (different computer - tty) i logged in in the past. i know the log-in time exactly.

    maybe onstat ist the wrong way, but it was my first idea.

    thanks for your hints,
    cetera

  2. #2
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    To do this you need to active the auditing tool , onaudit to capture all logins.
    But this tools don't provide much useful information, so, based on audit information (date/time + user) maybe you can get the information on the OS , with last command .
    Remember the last command log only who do a login on the machine, not connection from TCP/IP port in the database....
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

Posting Permissions

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