SEO

#1 (**permalink**) 02-29-2008, 04:42 AM

Hi,

Is it possible to know workstation name from data in column
net_address from master..sysprocesses?

TIA

#2 (**permalink**) 02-29-2008, 04:42 AM

Hi

The hostname column in sysprocesses will contain the workstation name,
net_address is a MAC address which you would have to resolve through
something like arp.

John

"Eric Yang" <ericyang1991@hotmail.com> wrote in message
news:7a8340df.0410291523.6df9385e@posting.google.c om...
> Hi,
>
> Is it possible to know workstation name from data in column
> net_address from master..sysprocesses?
>
> TIA

#3 (**permalink**) 02-29-2008, 04:42 AM

Eric Yang (ericyang1991@hotmail.com) writes:
> Is it possible to know workstation name from data in column
> net_address from master..sysprocesses?

As John said, you can use the hostname column. However, this column is
not 100% reliable, as this is set through application code, and the
application can lie about it.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

How to find out workstation name from net_address