IPAM custom alert for IP Address OnChange status message.
SELECT IPAddress,FromValue,IntoValue,Time FROM [dbo].[IPAM_IPHistory] WHERE Time > dateAdd(minute,-2 ,getutcdate()) order by Time DESC”
This will look for all records that were changed in last minute (standard alerting time) and show you the initial and new state of the IP address:
