[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


host name from apps in sybase

Posted on 2004-10-26
Medium Priority
Last Modified: 2008-02-01


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
Question by:vijadon
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 10

Assisted Solution

bret earned 200 total points
ID: 12413271
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

LVL 14

Accepted Solution

Jan Franek earned 300 total points
ID: 12415590
I'll just add, that if you want to get information about current connection use:

select * from master..sysprocesses where spid = @@spid

Author Comment

ID: 12417296
Thank you , but I was actually looking for the exact ip address.
LVL 13

Expert Comment

ID: 12418186
Which version are you using? I can see ip addresses in ipaddr column of sysprocesses (using version
LVL 29

Expert Comment

ID: 12616413
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

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

WooCommerce is becoming the most powerful e-commerce plugin for Wordpress. And why not. The platform comprises of numerous core plugins that may come in handy, powerful options to make your website development task much easier.
Geo-targeting is the practice of distributing content based on a person’s location, as best as you can determine it. Let’s look at some ways you could successfully use this tactic. The following tips and case studies could lead to meaningful results.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

656 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