• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1836
  • Last Modified:

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
0
vijadon
Asked:
vijadon
2 Solutions
 
bretCommented:
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
 
Jan FranekCommented:
I'll just add, that if you want to get information about current connection use:

select * from master..sysprocesses where spid = @@spid
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now