Computer names

[tlaksh]

Is there a select command in SQL by which I can get all the computer names on the network.

Thanks

Lakshmi

 

[tlbroadbent]

You can get a list if you can execute xp_cmdshell.

Create Table #t (CompName varchar(128))

Insert #t
Exec xp_cmdshell 'net view'

Select * From #t

Drop Table #t Terry

http://members.home.net/tlbroadbent/prog.htm

Neither success nor failure is ever final. -Roger Babson

 

[tlaksh]

Hey Terry

I did this but does net view give me all the computers or just the once that r on.

Thanks,

Laksh.

 

[tlbroadbent]

I'm sure NET VIEW only shows those that are turned on. Terry

http://members.home.net/tlbroadbent/prog.htm

Neither success nor failure is ever final. -Roger Babson

 

[tlaksh]

Hi Terry,

Is there a way to get all the computer names on the network irrespective of it being on or off.

Thanks,

Laksh

 

[tlbroadbent]

I'm not aware of any way to do so. I must defer to NT gurus on this question. If there is a command line function, you may be able to execute the command line in SQL via xp_cmdshell. Terry

http://members.home.net/tlbroadbent/prog.htm

Neither success nor failure is ever final. -Roger Babson