Solved

Scan IP address, obtain info

Posted on 2016-09-21
7
76 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
  • 4
  • 3
7 Comments
 
LVL 82

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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 82

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 82

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 82

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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Short answer to this question: there is no effective WiFi manager in iOS devices as seen in Windows WiFi or Macbook OSx WiFi management, but this article will try and provide some amicable solutions to better suite your needs.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

743 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now