IP Address Changes
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
Answers (2)
Please log in to answer
Posted by:
airwolf
14 years ago
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%'
Posted by:
GillySpy
14 years ago
Since IP is not guaranteed to be the first change in an entry you need to use a wildcard at the beginning as well:
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 '%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.]'
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
