Comments
-
I'm just adding here the code that made the magic happen (I think it's not elegant, but it works): where IPAM_NodeReportView.ipstatus = 'Transient' and IPAM_NodeReportView.IPAddress like '10.20.30.%' or IPAM_NodeReportView.IPAddress like '10.20.31.%' and IPAM_NodeReportView.ipstatus = 'Transient' I also tried to add…
-
Thanks for your suggestion, the result didn't change: the 10.20.31.% net (not the 10.20.30.% net) triggers the alarm for each and every IP address. That's super odd to me.
-
Thanks! I tried using the advices listed on that thread, really helpful, but I'm finding an issue on how to send an alarm on a subnet different from a /24. Let me explain better with the code I used: WHERE ipaddress in ( SELECT a.IPAddress FROM IPAM_IPHistoryReport a INNER JOIN ( SELECT ipnodeid,…