Track IP Address changes
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
Dave
1 Comment
[ + ] Show comment
-
Thanks dteetz. I found myself needing a report just like this. Your SQL worked like a charm. - ArroyoD 5 years ago
Answers (3)
Answer Summary:
Please log in to answer
Posted by:
dteetz
9 years ago
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.
Posted by:
chucksteel
9 years ago
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.
Posted by:
jknox
9 years ago
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
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