Resolving IP address from MAC Address | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Resolving IP address from MAC Address

Greetings, I have a (simple?) question regarding MAC and IP Addresses on SQL 2000. My Initial problem was such:
Using a single Application Login I wanted to know the indentities of the users/machines using that Login at any instance in time. For example, a number of users may be using the Login, but each would have a seperate Process ID (PID). Investigation thus far:
From looking at the PID screen in SQl Ent Mgr., I see that the Network Address is an identifier, it therefore follows that for any given Database I can find the current PIDs and thus, the Network Address(es). My Server Admin informs me this is the MAC address, and to find the actual user, I would need to, somehow, resolve the IP address from the given MAC address and then find the User ID currently logged onto that machine on the network. I believe this is done via the DHCP server, and, I have again been informed, any user on the Network (inluding SQL server) may query the DHCP server names. Given the above, is there anyone out there that has achieved this? Or am I simply barking up the wrong tree and there is a better way of achieving this? Before you say it .. I know I could simply create Login Accounts for the users, and that would give me the users, or use trusted connection (Urrgghh), but this has become the ‘Holy Grail’ of this month, and we ALL need Holy Grails, don’t we? Thanks in anticipation, Logicalman
You can see the value in the hostname column in master..sysprocesses table. Gaurav
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

Also from EM —&gt; Management –&gt; Current Activity —&gt<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />rocess Info, long way to go.<br />Also using SP_WHO2 from QA.<br /><br />_________<br />Satya SKJ<br />Moderator<br />SQL-Server-Performance.Com<br />
For information refer to this link]. HTH _________
Satya SKJ