host name from apps in sybase


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
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
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

vijadonAuthor Commented:
Thank you , but I was actually looking for the exact ip address.
Which version are you using? I can see ip addresses in ipaddr column of sysprocesses (using version
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.

EE Cleanup Volunteer
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.