Is there a way to track IP address changes in Kace1000?

Scenario: User has workstation with IP A.B.C.D. User moves workstation to another location and now has IP D.C.B.A.

Thanks,

Dave
Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

1
Thanks @chucksteel - you pushed me in the right direction.

I looked through the machine history for a workstation that I know changed IP addresses. I was able to find the change in the history and then was able to find the change in the ASSET_HISTORY table.

To extend this a bit, I created a new SQL script to grab the info I want. I added values from the MACHINE table, so I could get the current IP address and set a time frame of, basically, yesterday:

Select MACHINE.NAME As Name, MACHINE.IP As "Current IP". ASSET_HISTORY.TIME As Time, ASSET_HISTORY.FIELD_NAME, ASSET_HISTORY.VALUE1, ASSET_HISTORY.VALUE2 

From MACHINE,ASSET_HISTORY

WHERE 

ASSET_HISTORY.NAME = MACHINE.NAME AND ASSET_HISTORY.FIELD_NAME = "IP" AND

TIME > Date_Sub(Now(), Interval 1 Day)

I'm no SQL guru, so if there is a way to clean this up, I'd be very open to suggstions. I know ASSET_HISTORY.FIELD_NAME isn't needed, but it serves to remind me that other names are avaialble.

Thanks for the help.
Answered 11/12/2014 by: dteetz
Senior Yellow Belt

Please log in to comment

Answers

0
You can sometimes see this in the machine history but KACE does not always seem to report the IP address that a machine has checked in with in the history.
Answered 11/12/2014 by: chucksteel
Red Belt

Please log in to comment
0
I don't believe it's tracked, but it should be relatively simple to set up a script and custom inventory rule to return the data.

A script could run something like this:

ipconfig | findstr /R /C:"IPv4 Address" > C:\ProgramData\Dell\KACE\ipaddress.txt

Then, a custom inventory rule:

ShellCommandTextReturn(type C:\ProgramData\Dell\KACE\ipaddress.txt)

Some other ideas:

http://stackoverflow.com/questions/5898763/how-do-i-get-the-ip-address-into-a-batch-file-variable
Answered 11/12/2014 by: jknox
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity

Share