Track IP Address changes
11/12/2014 2532 views
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.
Community Chosen Answer
Please log in to answer
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
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