Submit a ticketCall us

AnnouncementsWeb Help Desk Integrations eCourse

Looking to reduce response times? Sign up for our eCourse to learn how integrating Web Help Desk with Dameware Remote Support, Network Configuration Manager, Network Performance Monitor, and Server & Application Monitor can improve communication efficiencies.

Register here.

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