Home » SQL & PL/SQL » SQL & PL/SQL » system name
system name [message #244285] Tue, 12 June 2007 04:37 Go to next message
ganesh_jadhav0509
Messages: 63
Registered: May 2007
Location: Chester
Member

how can i get current system name while runtime or with sql query.
Re: system name [message #244287 is a reply to message #244285] Tue, 12 June 2007 04:39 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
What do you call the "system name"?

MHE
Re: system name [message #244292 is a reply to message #244287] Tue, 12 June 2007 04:52 Go to previous messageGo to next message
ganesh_jadhav0509
Messages: 63
Registered: May 2007
Location: Chester
Member

thanks for replying

its pc's name from where i m login.
not server
but client pc's name i want
i want to track from which pc my software get logged in
Re: system name [message #244294 is a reply to message #244292] Tue, 12 June 2007 05:05 Go to previous messageGo to next message
sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata
Senior Member

I think you can view it using

select distinct TERMINAL from v$session where MODULE= YOUR_SOFTWARE_NAME


But it shows all the terminals where your software is running.

Regards,
Sanka Cool
Re: system name [message #244299 is a reply to message #244294] Tue, 12 June 2007 05:16 Go to previous messageGo to next message
ganesh_jadhav0509
Messages: 63
Registered: May 2007
Location: Chester
Member

thanks i want that

but i want one more thing i want can i find his ipaddress?
Re: system name [message #244305 is a reply to message #244299] Tue, 12 June 2007 05:21 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Do what I do: search the board Wink.

MHE
Re: system name [message #244306 is a reply to message #244299] Tue, 12 June 2007 05:23 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> select UTL_INADDR.GET_HOST_ADDRESS(terminal) from v$session
  2  where sid=(select sid from v$mystat where rownum=1)
  3  /
UTL_INADDR.GET_HOST_ADDRESS(TERMINAL)
----------------------------------------------------------------------
184.0.106.113

1 row selected.

Regards
Michel
Previous Topic: Why true argument is used in Raise_application_error?
Next Topic: special character handling in translate query
Goto Forum:
  


Current Time: Sun Dec 11 02:43:37 CST 2016

Total time taken to generate the page: 0.10597 seconds