/build/static/layout/Breadcrumb_cap_w.png

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)

Posted by: airwolf 14 years ago
Red Belt
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%'
Posted by: GillySpy 14 years ago
7th Degree Black Belt
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.]'
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ