No announcement yet.

IP addresses of each machine

  • Filter
  • Time
  • Show
Clear All
new posts

  • IP addresses of each machine

    Is there any way to get Heyna (currently 5.4b) to list each IP address that each machine is using ( leaving room for multiple IP address machines), but heres the kicker, I want to either export it to an excel spreadsheet or use that lovely access reporting feature...

    Any ideas guys?

  • #2
    Re: IP addresses of each machine

    We are working on enhancing reporting/exporting that should help with this.

    For now, here is a post that shows a way to create a Custom Tool to do this:


    • #3
      Re: IP addresses of each machine

      looking forward to a neater soloution.. thanks :-)
      (will be renewing licence contract soon, so I hope to see it in a post Ver 5 )


      • #4
        Re: IP addresses of each machine

        Boy, that sounded like a..."eh-hem"...

        I think what you're looking for is contained in WMI.

        On Error Resume Next
        strComputer = "."
        Set objWMIService = GetObject("winmgmts:\" & strComputer & "\root\cimv2")
        Set colItems = objWMIService.ExecQuery("Select * from Win32_NetworkAdapterConfiguration where IPEnabled=TRUE")
        For Each objItem in colItems
        for j = 0 to UBound(objItem.IPAddress)
        WScript.Echo Trim(objItem.IPAddress(j))

        Change "." to be whatever computer you want (try it on both single and multi-homed computers).

        One caveat. Win2K, XP and up. Works on NT and 9x if you have the WMI client software installed...but it's hokey at best.

        Hope this helps you along your way. You can drop these into an database by replacing the ("Script.Echo Trim(objItem.IPAddress(j)") portion.