Hi,
When the MAC ADDRESS of each NETWORK NODE is changed in IPAM, ALERT is set and closed.
Or I want to express it as an IP conflict.
Is there a way?
Additionally, ALERT is currently set through the following SQL. In addition, I want to express the scan time or TIME of MAC History in the message displayed when this alert is triggered.
-------------------------------------------------------------------------------------------------------------------------------------------------
WHERE ipnodeid in (
SELECT a.ipnodeid
FROM IPAM_IPHistoryReport a
INNER JOIN
(
SELECT
ipnodeid,
max(IPAM_IPHistoryReport.Time) as tt
from IPAM_IPHistoryReport
Group by ipnodeid
) b
on a.IPNodeId=b.IPNodeId
and
a.Time=b.tt
where a.FromValue like '%-%' and a.IntoValue like '%-%' and a.HistoryType = 'MAC')
-------------------------------------------------------------------------------------------------------------------------------------------------
If there is another way, please guide. Thank you for reading.