DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: IP Address

  1. #1
    Join Date
    Feb 2001
    Posts
    4

    Exclamation

    Hello!!!.... please, I need a query that returns me the ip addrress of the PCs connected at this time

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Windows:

    C:\ipconfig

    Unix:

    $nslookup server_name
    Reddy,Sam

  3. #3
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    you can get the DNS name of the machine :

    select username, machine from v$session
    where audsid != 0

    (audsid = 0 is for Oracle BG processes)

    nevertheless to get the IP address, I guess you'll have to use an OS function ...

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    OS check is the best way to check your IPS

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

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


Click Here to Expand Forum to Full Width