Scan IP address, obtain info

Ted Penner
Ted Penner used Ask the Experts™
on
I need some VBASCRIPT that will scan an IPv4 address in column A of an Excel Spreadsheet and output the mac-address in column b, the name of the device in column c, and whether it is IPv6 compliant in column D.

Assistance is greatly appreciated
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Dave BaldwinFixer of Problems
Most Valuable Expert 2014

Commented:
You can only get MAC addresses on your local network segment from devices and computers you are directly connected to.  What does 'IPv6 compliant' mean?
Ted PennerSoftware Engineer

Author

Commented:
That's a good question.  At least we need to know as much about what the device is as possible.
Ted PennerSoftware Engineer

Author

Commented:
Whether it could be configured with an IPv6 address perhaps.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Fixer of Problems
Most Valuable Expert 2014
Commented:
The FastResolver program on this page http://www.nirsoft.net/utils/fastresolver.html seems to do a good job.
Dave BaldwinFixer of Problems
Most Valuable Expert 2014

Commented:
Whether it could be configured with an IPv6 address perhaps.
I don't believe the IPv4 address can tell you anything about that.
Ted PennerSoftware Engineer

Author

Commented:
Must be able to see source in order to run in our environment.
Dave BaldwinFixer of Problems
Most Valuable Expert 2014

Commented:
I think it is unlikely that Nir Soft will give you the source.  It is probably written in C++ and it includes a Code Signing Certificate to verify their identity.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial