cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 7

How to provide Alert when changing MAC Address of IPAM Node

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')

 

1233.JPG

 

 

-------------------------------------------------------------------------------------------------------------------------------------------------

If there is another way, please guide. Thank you for reading.

0 Kudos
0 Replies