And as would be expected, this is as accurate as your DNS is. If systems aren't auto-registering properly (or DHCP in Windows 2000 isn't handling it properly for clients that can't themselves) and/or if the WINS-R lookups aren't setup, then you will have some holes. Also, keep in mind the IP isn't in sysprocesses. You'll have to use a trace or something of that sort to capture the IP as they connect (though I believe it captures the hostname which can be forged).
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/
K. Brian Kelley
@kbriankelley