Solved

Scan IP address, obtain info

Posted on 2016-09-21
7
122 Views
Last Modified: 2016-09-27
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
0
Comment
Question by:frugalmule
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 41809967
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
 

Author Comment

by:frugalmule
ID: 41809970
That's a good question.  At least we need to know as much about what the device is as possible.
0
 

Author Comment

by:frugalmule
ID: 41809971
Whether it could be configured with an IPv6 address perhaps.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 41809974
The FastResolver program on this page http://www.nirsoft.net/utils/fastresolver.html seems to do a good job.
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 41809976
Whether it could be configured with an IPv6 address perhaps.
I don't believe the IPv4 address can tell you anything about that.
0
 

Author Comment

by:frugalmule
ID: 41809979
Must be able to see source in order to run in our environment.
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 41810069
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

Featured Post

Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question