3 Replies Latest reply on Mar 29, 2016 1:25 PM by boballen

    Alerting on IP address utilization for specific DHCP scopes

    mr.e

      Hello,

       

      I received a request for alerting on IP address utilization for specific scopes on each of our DHCP servers. 

       

      The DHCP Scope on ${FriendlyName} (${Address}) had exceeded 90% threshold, currently at ${PercentUsed}% utilization. Unfortunately, used the IPAM Networks property seems to only show options for alerting on utilization for the overall DHCP utilization for a server, not on a per scope basis.  I would like to know if any of you have figured out how to do this. If you have, I'd very much appreciate for you to share.  Thanks!!!

        • Re: Alerting on IP address utilization for specific DHCP scopes
          dmbeckemeyer

          I am trying to build a report for the exact same thing (ever trying to specify by VLAN ID since this is a built in definition option now on a scope) and haven't found a way to do it. Did you figure it out?

          Thanks in advance!

           

          -Danielle

          • Re: Alerting on IP address utilization for specific DHCP scopes
            jblankjblank

            You should be able to specify the Alert condition to dictate an individual scope:

             

             

            And leverage alert notifications to provide the appropriate details:

             

            See if these variables assist:

             

            DHCP server variables:

            ======================

            DHCP server Available count:

            ${SQL: select distinct a.availablecount from [IPAM_DHCPServerReportView] a inner Join [IPAM_DhcpScopeReportView] b on b.ParentID= a.groupid and b.groupid = ${N=SwisEntity;M=NodeScope.GroupId}}

            DHCP server Address:

            ${SQL: select distinct a.address from [IPAM_DHCPServerReportView] a inner Join [IPAM_DhcpScopeReportView] b on b.ParentID= a.groupid and b.groupid = ${N=SwisEntity;M=NodeScope.GroupId}}

            DHCP server Friendly name:

            ${SQL: select distinct a.FriendlyName from [IPAM_DHCPServerReportView] a inner Join [IPAM_DhcpScopeReportView] b on b.ParentID= a.groupid and b.groupid = ${N=SwisEntity;M=NodeScope.GroupId}}

            DHCP server Type:

            ${SQL: select distinct a.ServerType from [IPAM_DHCPServerReportView] a inner Join [IPAM_DhcpScopeReportView] b on b.ParentID= a.groupid and b.groupid = ${N=SwisEntity;M=NodeScope.GroupId}}

            DHCP server Percent Used:

            ${SQL: select distinct a.PercentUsed from [IPAM_DHCPServerReportView] a inner Join [IPAM_DhcpScopeReportView] b on b.ParentID= a.groupid and b.groupid = ${N=SwisEntity;M=NodeScope.GroupId}}

            DHCP server Used count:

            ${SQL: select distinct a.UsedCount from [IPAM_DHCPServerReportView] a inner Join [IPAM_DhcpScopeReportView] b on b.ParentID= a.groupid and b.groupid = ${N=SwisEntity;M=NodeScope.GroupId}}

            DHCP server Total Count:

            ${SQL: select distinct a.TotalCount from [IPAM_DHCPServerReportView] a inner Join [IPAM_DhcpScopeReportView] b on b.ParentID= a.groupid and b.groupid = ${N=SwisEntity;M=NodeScope.GroupId}}

             

            DHCP scope variables:

            ====================

            DHCP scope Name:

            ${SQL: select distinct a.FriendlyName from [IPAM_DhcpScopeReportView] a inner Join [IPAM_DHCPServerReportView] b on a.ParentID= b.groupid and a.groupid = ${N=SwisEntity;M=NodeScope.GroupId}}

            DHCP scope Used percentage:

            ${SQL: select a.PercentUsed from [IPAM_DhcpScopeReportView] a inner Join [IPAM_DHCPServerReportView] b on a.ParentID= b.groupid and a.groupid = ${N=SwisEntity;M=NodeScope.GroupId}}

            DHCP scope Used count:

            ${SQL: select distinct a.UsedCount from [IPAM_DhcpScopeReportView] a inner Join [IPAM_DHCPServerReportView] b on a.ParentID= b.groupid and a.groupid = ${N=SwisEntity;M=NodeScope.GroupId}}

            DHCP scope Available count:

            ${SQL: select distinct a.AvailableCount from [IPAM_DhcpScopeReportView] a inner Join [IPAM_DHCPServerReportView] b on a.ParentID= b.groupid and a.groupid = ${N=SwisEntity;M=NodeScope.GroupId}}

            DHCP scope toatal count:

            ${SQL: select distinct a.TotalCount from [IPAM_DhcpScopeReportView] a inner Join [IPAM_DHCPServerReportView] b on a.ParentID= b.groupid and a.groupid = ${N=SwisEntity;M=NodeScope.GroupId}}

            DHCP scope Reserved count:

            ${SQL: select distinct a.ReservedCount from [IPAM_DhcpScopeReportView] a inner Join [IPAM_DHCPServerReportView] b on a.ParentID= b.groupid and a.groupid = ${N=SwisEntity;M=NodeScope.GroupId}}

            DHCP scope Start Address:

            ${SQL: select distinct a.StartAddress from [IPAM_DhcpScopeReportView] a inner Join [IPAM_DHCPServerReportView] b on a.ParentID= b.groupid and a.groupid = ${N=SwisEntity;M=NodeScope.GroupId}}

            DHCP scope End Address:

            ${SQL: select distinct a.EndAddress from [IPAM_DhcpScopeReportView] a inner Join [IPAM_DHCPServerReportView] b on a.ParentID= b.groupid and a.groupid = ${N=SwisEntity;M=NodeScope.GroupId}}

            1 of 1 people found this helpful
              • Re: Alerting on IP address utilization for specific DHCP scopes
                boballen

                I tried to setup an alert using the above instructions. But it is not working as expected.

                For example:

                We have a DHCP scope set up with 512 addresses, 152 used, 354 available, 6 reserved, 30.86% used.

                On one DHCP server there are 150 addresses, 117 used, 33 available, 78% used.

                On other DHCP server there are 310 addresses, 28 used, 282 available, 9% used.

                The alert is reporting the higher server usage of 78%, not the scope usage of 30.86%.

                How do I setup an alert that is triggered on the overall percentage used?