September 7, 2005 at 7:10 am
In Sysprocesses table corresponding to net_address colum values, how to find the corresponding ip addresss. I have tried with arp -a at command prompt to relate net_address and IP. But corresponding to most of the entiries in net_address column am not able to find matching ip address with arp -a..
can anybody help me in resolving all net_address column values to ip address
subhash
subban
September 7, 2005 at 8:05 am
You could write a batch file to loop though and ping all IPs on your network, which would then fill the arp cache with IP to MAC address mappings...
September 8, 2005 at 1:48 am
But for most of the entries in net_address column there is no matchin entry in app -a command
subban
September 8, 2005 at 8:25 am
entries in the arp table get removed every 2 min or so (on win 2000), if no traffic from host to the net_address. you may need to run arp -a while the connection from the net_address in question is active, or very soon after.
September 12, 2005 at 11:23 pm
i have tried running both the command at the same time (arp -a), still i couldn't find a matching
subban
January 28, 2009 at 4:10 pm
If IP address is the one u want, try using the sys.dm_exec_connections. This can be joined with Sys.SysProcesses to identify the IP address. (..... SQL 2005)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply