Submit a ticketCall us

AnnouncementsChange Is Inevitable

Get valuable help when it comes to tracking and monitoring changes. SolarWinds® Server Configuration Monitor (SCM) is designed to help you: detect, track, and receive alerts when changes occur, correlate system performance against configuration changes, compare server and application configuration against custom baselines, and verify application and system changes.

Learn more.

Home > Success Center > IP Address Manager (IPAM) > IPAM - Knowledgebase Articles > 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