Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

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