Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > IP Address Manager (IPAM) > IPAM DHCP Scope Macros for Alerts

IPAM DHCP Scope Macros for Alerts

Table of contents

Updated: November 1, 2017

Overview

This article provides DHCP Scope Macros that you can use for Alerting and Alert Execution in IPAM.

Environment

  • IPAM 4.3.4

Detail

 

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}}

 

If you need more Variables check our Content Exchange on Thwack.  For the specific Link of the forums, click the following link.

 

https://thwack.solarwinds.com/thread/71259

 

 

 

Last modified

Tags

Classifications

Public