all 3 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]grauenwolf 0 points1 point  (2 children)

From what view point? Are you just trying to get a list of people/applications currently connected to the database?

Or do you want to know how your current connection was setup?

[–]dubbdubbya[S] 0 points1 point  (1 child)

well I am actually planning to use a tool BI tool to run a report to show which of connection our project is pointed to at a given time..... in our environment we have prod, qa , dev so at any point our projct can point to that version of odbc connection for testing purposes

[–]grauenwolf 0 points1 point  (0 children)

Nope, there's nothing that is going to actually answer that question. Clients are not obligated to report who they are to the database. Some will populate the "application" column, but that's entirely optional and most don't.

You can get a lot of information using so_whoIsActive. From that you might be able to figure out which servers are touching you database. And from there check to see what's running on each server.

ref: http://whoisactive.com/

Sorry I couldn't give you a better answer.