Solved

host name from apps in sybase

Posted on 2004-10-26
1,774 Views
Last Modified: 2008-02-01

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
Question by:vijadon
    5 Comments
     
    LVL 10

    Assisted Solution

    by:bret
    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
     
    LVL 14

    Accepted Solution

    by:
    I'll just add, that if you want to get information about current connection use:

    select * from master..sysprocesses where spid = @@spid
    0
     
    LVL 1

    Author Comment

    by:vijadon
    Thank you , but I was actually looking for the exact ip address.
    0
     
    LVL 13

    Expert Comment

    by:alpmoon
    Which version are you using? I can see ip addresses in ipaddr column of sysprocesses (using version 12.5.0.2).
    0
     
    LVL 29

    Expert Comment

    by:leonstryker
    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Know what services you can and cannot, should and should not combine on your server.
    SSL stands for “Secure Sockets Layer” and an SSL certificate is a critical component to keeping your website safe, secured, and compliant. Any ecommerce website must have an SSL certificate to ensure the safe handling of sensitive information like…
    With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
    Want to pick and choose which updates you receive? Feel free to check out this quick video on how to manage your email notifications.

    933 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now