I am needing a script that will scan an IP range on our network and create an
Excel spreadsheet with a list of computernames. This will allow me to create
other scripts for our specific group and not the entire domain.
I am needing a script that will scan an IP range on our network and create an
Excel spreadsheet with a list of computernames. This will allow me to create
other scripts for our specific group and not the entire domain.
theres a program out called angry IP scanner that does the same thing basiclly and you can save it as a .xls file. its called angry IP scanner i used it before, i know its not a script but hopfully you get what you are looking for.
I wouldn't bother with a script. I'd simply use any of the many free network
scanner tools. Grab one that allows you to export results to a file.
Otherwise you'll have to use command line tools like NBTSTAT or NSLOOKUP and
do a lot of parsing.
For example, nbtstat -A ipaddress should show you the computer name, among
other information. If you have reverse lookup zones you could also call
nslookup and parse that output.
This is probably do-able in PowerShell as well, and maybe a little bit
easier if you're ready to go down that road.
--
Jeffery Hicks
Microsoft PowerShell MVP
http://www.scriptinganswers.com
http://www.powershellcommunity.org
Now Available: WSH and VBScript Core: TFM
Coming Soon: Windows PowerShell: TFM 2nd Ed.
"Rick Neely" <Rick Neely@discussions.microsoft.com> wrote in message
news:20B54905-E919-4A83-BE91-BBBA96BB77DE@microsoft.com...
>I am needing a script that will scan an IP range on our network and create
>an
> Excel spreadsheet with a list of computernames. This will allow me to
> create
> other scripts for our specific group and not the entire domain.
Alternately, if you just need to get a list of computers available for
remote scripting, and if you have a naming convention that is OU or
subnet-specific, you could filter the output from the "NET VIEW" command.
/Al
"Jeffery Hicks [MVP]" <jhicks@sapien.com> wrote in message
news:B32E3A69-1A73-4921-9FE0-944223A4725C@microsoft.com...
>I wouldn't bother with a script. I'd simply use any of the many free
>network scanner tools. Grab one that allows you to export results to a
>file. Otherwise you'll have to use command line tools like NBTSTAT or
>NSLOOKUP and do a lot of parsing.
> For example, nbtstat -A ipaddress should show you the computer name, among
> other information. If you have reverse lookup zones you could also call
> nslookup and parse that output.
>
> This is probably do-able in PowerShell as well, and maybe a little bit
> easier if you're ready to go down that road.
>
> --
> Jeffery Hicks
> Microsoft PowerShell MVP
> http://www.scriptinganswers.com
> http://www.powershellcommunity.org
>
> Now Available: WSH and VBScript Core: TFM
> Coming Soon: Windows PowerShell: TFM 2nd Ed.
>
> "Rick Neely" <Rick Neely@discussions.microsoft.com> wrote in message
> news:20B54905-E919-4A83-BE91-BBBA96BB77DE@microsoft.com...
>>I am needing a script that will scan an IP range on our network and create
>>an
>> Excel spreadsheet with a list of computernames. This will allow me to
>> create
>> other scripts for our specific group and not the entire domain.
>
Bookmarks