+ Reply to Thread
Results 1 to 4 of 4

Thread: IP Address

  1. 02-26-2001 11:05 AM #1
    kpruza
    kpruza is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 02-26-2001 11:09 AM #2
    sreddy's Avatar
    sreddy
    sreddy is offline Senior Advisor
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Windows:

    C:\ipconfig

    Unix:

    $nslookup server_name
    Reddy,Sam
    Reply With Quote Reply With Quote
  3. 02-26-2001 11:09 AM #3
    pipo
    pipo is offline Senior Advisor
    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 ...
    Reply With Quote Reply With Quote
  4. 02-26-2001 11:12 AM #4
    sambavan
    sambavan is offline Senior Advisor
    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!

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width