I am having problems generating an alert on all IP's that changed status from Available to Used. I could not find anything out of the box to get me what I need. However I was able to find an SQL script for SolarWinds alert . The script partly works. It does not provide the IP address from the alert. Please see attachment. I would like to see the IP address in the "Triggered by:" field. I need assistance with generating this type of alert.
This is the script:
WHERE ipnodeid in (
FROM IPAM_IPHistoryReport a
max(IPAM_IPHistoryReport.Time) as tt
Group by ipnodeid
where a.FromValue='Available' and a.IntoValue='Used')