IP addresses of each machine

[Guest]

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?

[cmccullough]

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:
http://www.systemtools.com/HyenaBoar...ML/000076.html

[Guest]

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 )

[Guest]

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))
Next
Next
'***************************************

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.

Joel