Network Discovery Alert Question

martian_monster

I have network discovery setup for all my various domains and networking equipment.

What I need to figure out is how to have the alert go off only if it finds new nodes while running.  Right now when the discovery runs if it finds something or does not find anything it sends me an email.  I would like to set it up to email only when something new is added not when it runs. 

This should be easy but right now it is not making sense to me.  I remember looking at this years ago and I could not figure it out.   Thanks!!! -Dave

bobmarley

The nodes that were added by System are also in the AuditingEvents table. You could easily make a daily report.

SELECT AuditEventID, ToLocal (TimeLoggedUtc) as LocalTime, AccountID, AuditEventMessage
FROM Orion.AuditingEvents
Where AuditEventMessage LIKE '%User SYSTEM created node%' AND daydiff(TimeLoggedUtc ,getdate()) < 2 --past 2 days, adjust as needed
Order BY TimeLoggedUTC desc