Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

Home > Success Center > IP Address Manager (IPAM) > How to set an alert for an IP address status change

How to set an alert for an IP address status change

Table of contents

Updated December 6, 2017


This article provides guidance on how to set up an alert that triggers when an IP address changes status. To create such an alert, you need to use a custom SQL alert that allows you to query the view IPAM_NodeReportView.


  • All versions of IPAM


  1. In the Orion Web Console, click Alerts&Activity > Alerts.
  2. Click Manage Alerts > Add New Alert.
  3. Set the Alert Properties, and click Next to access the Trigger Conditions.
  4. In the "I want to alert on:" drop-down menu, select Custom SQL Alert (Advanced).
  5. In the "Set up your SQL condition" drop-down menu, select IPAM Nodes.


  6. Enter the following commands in the text box under Set up your SQL condition:

    WHERE ipnodeid in (

    SELECT a.ipnodeid

    FROM IPAM_IPHistoryReport a





    max(IPAM_IPHistoryReport.Time) as tt

    from IPAM_IPHistoryReport

    Group by ipnodeid

    ) b

    on a.IPNodeId=b.IPNodeId


    where a.FromValue='Available' and a.IntoValue='Used')

    • To alert on all IP addresses that have changed from Available to Used, you need the values from the 'FromValue' and IntoValue' fields.
    • Using only WHERE FromValue ='Available' and IntoValue='Used' will trigger the alert on any IP address that had ever gone from Available to Used, regardless of when this happened.
    • You need to limit the scope of the alert to the most recent record for each IP address, selecting the maximum time for each IP address.
  7. Click Next and set up the rest of the tabs in the alert manager.





Last modified