Scan IP address, obtain info

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
frugalmuleAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
The FastResolver program on this page http://www.nirsoft.net/utils/fastresolver.html seems to do a good job.
0
 
Dave BaldwinFixer of ProblemsCommented:
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?
0
 
frugalmuleAuthor Commented:
That's a good question.  At least we need to know as much about what the device is as possible.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
frugalmuleAuthor Commented:
Whether it could be configured with an IPv6 address perhaps.
0
 
Dave BaldwinFixer of ProblemsCommented:
Whether it could be configured with an IPv6 address perhaps.
I don't believe the IPv4 address can tell you anything about that.
0
 
frugalmuleAuthor Commented:
Must be able to see source in order to run in our environment.
0
 
Dave BaldwinFixer of ProblemsCommented:
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.
0
All Courses

From novice to tech pro — start learning today.