IP Address of Client
657837Apr 21 2010 — edited Jan 29 2013Hi All,
I have forms and reports application running on 10g database. Users get access to application through Application Server 10g . I have a requirement to know the IP address of my clients machines.
But if i fire select osuser,machine from v$session where program ='frmweb.exe' I get the following output. Can anybody here suggest me how to get IP address of a particular client.
SQL> select osuser,machine from v$session where program ='frmweb.exe';
OSUSER MACHINE
------------------------------ ----------------------------------------------------------------
NT AUTHORITY\ANONYMOUS LOGON GIDC\GIDC-APP1
NT AUTHORITY\ANONYMOUS LOGON GIDC\GIDC-APP1