+ 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
    4,756
    Thank Post
    85
    Thanked 203 Times in 186 Posts
    Rep Power
    81

    Re: Automated Mac Address Retrieval

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

  4. #4


    Join Date
    Jan 2006
    Posts
    5,990
    Thank Post
    290
    Thanked 645 Times in 480 Posts
    Rep Power
    162

    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,272
    Blog Entries
    2
    Thank Post
    595
    Thanked 877 Times in 615 Posts
    Rep Power
    277

    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
    Bristol
    Posts
    12,330
    Blog Entries
    24
    Thank Post
    425
    Thanked 1,373 Times in 1,091 Posts
    Rep Power
    397

    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
    540
    Thank Post
    2
    Thanked 3 Times in 2 Posts
    Rep Power
    14

    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
    Dunstable
    Posts
    1,255
    Thank Post
    13
    Thanked 36 Times in 27 Posts
    Rep Power
    26

    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
    10,963
    Blog Entries
    1
    Thank Post
    104
    Thanked 422 Times in 365 Posts
    Rep Power
    109

    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
    8,925
    Thank Post
    276
    Thanked 795 Times in 715 Posts
    Rep Power
    188

    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,326
    Thank Post
    79
    Thanked 16 Times in 16 Posts
    Rep Power
    19

    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, 01:40 PM
  2. MySQL automated backup
    By contink in forum *nix
    Replies: 6
    Last Post: 4th January 2008, 10:35 PM
  3. Automated PC Naming
    By Mr_M_Cox in forum Windows
    Replies: 8
    Last Post: 31st May 2007, 07:40 PM
  4. Automated build testing
    By ITWombat in forum Windows
    Replies: 0
    Last Post: 21st January 2007, 12:54 AM
  5. Automated Printer Server Migration
    By Dos_Box in forum How do you do....it?
    Replies: 1
    Last Post: 5th September 2005, 09: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
  •