host name from apps in sybase


Hello,

How can I find the host name/ip address of the application connecting to the Sybase database.
I need help with the procedure . Like we have v$session in Oracle that would give us the machine name.
How would I get that in Sybase, I would appreciate your help.
Or Is there a Sored Procedure for this purpose.

thank you
Vinai
LVL 1
vijadonAsked:
Who is Participating?
 
Jan FranekConnect With a Mentor Commented:
I'll just add, that if you want to get information about current connection use:

select * from master..sysprocesses where spid = @@spid
0
 
bretConnect With a Mentor Commented:
If you are refering to the Sybase ASE product, that information is found in the sysprocesses table in the master database


select * from master..sysprocesses

0
 
vijadonAuthor Commented:
Thank you , but I was actually looking for the exact ip address.
0
 
alpmoonCommented:
Which version are you using? I can see ip addresses in ipaddr column of sysprocesses (using version 12.5.0.2).
0
 
leonstrykerCommented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned..
I will leave the following recommendation for this question in the Cleanup topic area:

Answered alpmoon

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

leonstryker
EE Cleanup Volunteer
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.