Hello!!!.... please, I need a query that returns me the ip addrress of the PCs connected at this time
Printable View
Hello!!!.... please, I need a query that returns me the ip addrress of the PCs connected at this time
Windows:
C:\ipconfig
Unix:
$nslookup server_name
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 ...
OS check is the best way to check your IPS
Sam