/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide 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.
Answer this question or Comment on this question for clarity

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