+ Post New Thread
Results 1 to 13 of 13
How do you do....it? Thread, Automated Mac Address Retrieval in Technical; Retrieve mac address from all machines on an ip range or in a domain, and produce something like a csv ...
  1. #1

    Join Date
    Feb 2007
    Location
    Lincolnshire
    Posts
    120
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Automated Mac Address Retrieval

    Retrieve mac address from all machines on an ip range or in a domain, and produce something like a csv file or a text file with them in ?

    any ideas?

    without having to go to each machine would be great as i will need to use this tool on multiple networks

    Thanks in advance

  2. #2
    tscnmuk's Avatar
    Join Date
    Jan 2007
    Location
    Lincolnshire
    Posts
    216
    Thank Post
    5
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Automated Mac Address Retrieval

    Use the DHCP table on the DHCP server.

    Right click on the scope lease folder and export, export as a CSV, sorted. Easy.

    Tom

  3. #3
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    5,013
    Thank Post
    120
    Thanked 282 Times in 260 Posts
    Rep Power
    108

    Re: Automated Mac Address Retrieval

    If you use DHCP just export the leases list to a csv.

  4. #4


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339

    Re: Automated Mac Address Retrieval

    nmap if good for this sort of thing
    http://insecure.org/nmap/
    Code:
     sudo nmap 192.168.1.0/24

  5. #5

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,406
    Thank Post
    640
    Thanked 961 Times in 661 Posts
    Blog Entries
    2
    Rep Power
    324

    Re: Automated Mac Address Retrieval

    There's also a command-line app on Windows servers to export the DHCP list if you need to run it as part of a script.

  6. #6

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,816
    Thank Post
    517
    Thanked 2,473 Times in 1,916 Posts
    Blog Entries
    24
    Rep Power
    836

    Re: Automated Mac Address Retrieval

    Or you could make use of a program called SoftPerfect Network Scanner. I find it a nice useful tool.

  7. #7

    Join Date
    Mar 2006
    Posts
    537
    Thank Post
    2
    Thanked 3 Times in 2 Posts
    Rep Power
    19

    Re: Automated Mac Address Retrieval

    The DHCP lease export only covers dynamicaly addressed machines. In most cases e.g that will be enough but if you need information for static address then you may have to go down the nmap route as above.

    Alternatively you could ping and arp to the same info.

  8. #8
    Norphy's Avatar
    Join Date
    Jan 2006
    Location
    Harpenden
    Posts
    2,370
    Thank Post
    54
    Thanked 312 Times in 242 Posts
    Blog Entries
    6
    Rep Power
    119

    Re: Automated Mac Address Retrieval

    You could probably use a WMI script to retreive the MAC address to. Make it scan all the addresses on your subnet or something. Assuming all your servers and clients are Windows based of course.

  9. #9

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,804
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224

    Re: Automated Mac Address Retrieval

    Also if the machine is running SNMP (which is true here for anything using a static IP, Print servers, W2k3 & Linux servers, switches) you can grab the MAC address from that.

    Secondly, you can get this information passively with the correct monitoring software. For example there's a tool called 'arpwatch' on Linux that will passively monitor the network and work out IP:MAC address pairs based on ARP traffic.

  10. #10
    Guest

    Re: Automated Mac Address Retrieval

    http://www.angryziber.com/ipscan/

    Will do what you want too.

  11. #11

    Join Date
    Feb 2007
    Location
    Lincolnshire
    Posts
    120
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Automated Mac Address Retrieval

    Thanks guys i will give some of your suggestions a try later

  12. #12

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,679
    Thank Post
    661
    Thanked 1,626 Times in 1,455 Posts
    Rep Power
    422

    Re: Automated Mac Address Retrieval

    OCS NG will also list mac address of all discovered computers.

    Ben

  13. #13
    gwendes's Avatar
    Join Date
    Jan 2007
    Location
    London
    Posts
    1,495
    Thank Post
    161
    Thanked 30 Times in 29 Posts
    Rep Power
    26

    Re: Automated Mac Address Retrieval

    LanView does this to use the WOL feature - not to a csv but it's handy if the reason you want MACs is for WOL!

SHARE:
+ Post New Thread

Similar Threads

  1. Automated CMIS Backup
    By mark80 in forum MIS Systems
    Replies: 10
    Last Post: 30th September 2008, 12:40 PM
  2. MySQL automated backup
    By contink in forum *nix
    Replies: 6
    Last Post: 4th January 2008, 09:35 PM
  3. Automated PC Naming
    By Mr_M_Cox in forum Windows
    Replies: 8
    Last Post: 31st May 2007, 06:40 PM
  4. Automated build testing
    By ITWombat in forum Windows
    Replies: 0
    Last Post: 20th January 2007, 11:54 PM
  5. Automated Printer Server Migration
    By Dos_Box in forum How do you do....it?
    Replies: 1
    Last Post: 5th September 2005, 08:10 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •