0 Replies Latest reply on Oct 1, 2018 9:06 PM by hitnhrd

    I need to generate an alert on all IP's that changed status from Available to Used

    hitnhrd

      I am having problems generating an alert on all IP's that changed status from Available to Used. I could not find anything out of the box to get me what I need. However I was able to find an SQL script for SolarWinds alert . The script partly works. It does not provide the IP address from the alert. Please see attachment. I would like to see the IP address in the "Triggered by:" field. I need assistance with generating this type of alert.

       

      This is the script:

       

      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='Available' and a.IntoValue='Used')

       

      Thanks,

      Markus A.