I am unable to view the changes in IP address under my Asset History, I remember i was able to find this information in Kbox version 4.0. can anyone tell me how can i monitor the IP address changes.
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
IP address changes are still tracked in Asset History. I used this quick test query to verify:

SELECT CAST(DESCRIPTION AS CHAR(1000)) FROM ASSET_HISTORY
WHERE DESCRIPTION like 'Ip changed%'
Answered 02/10/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
0
Since IP is not guaranteed to be the first change in an entry you need to use a wildcard at the beginning as well:

SELECT CAST(DESCRIPTION AS CHAR(1000)) FROM ASSET_HISTORY
WHERE DESCRIPTION like '%Ip changed%'


I hope no other fields en in "IP". Maybe this would be more reliable

SELECT CAST(DESCRIPTION AS CHAR(1000)) FROM ASSET_HISTORY
WHERE DESCRIPTION like RLIKE 'ip changed from \'[0-2][0-9][0-9][.period.]'
Answered 02/12/2010 by: GillySpy
Seventh Degree Black Belt

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