Metrics Dashboard / Grid Review 6.1

THelaire · ‎11-01-2022

Your Solutions Architect may reach out to you to conduct a Grid Review to help understand how your Infoblox infrastructure is performing. Included are two additional reports that were added to the Metrics Dashboard. It's also a great tool for capacity planning.

DHCP Usage Last Year (8.5 or newer)
DNS QPS Usage Last Year (8.5 or newer)
Active IP Addresses per Day
DNS Daily Peak Hour Query Rate by Member
DNS Daily Query Rate by Member
DNS Query Rate by Member
Total Zones in Grid
CPU Trend per Member
Memory Trend per Member

The dashboard is easy to install and run:

Click Reporting -> Dashboards -> Create New Dashboard
Enter a temporary value for Title (this will be overwritten in a subsequent step) -> click Create Dashboard
Click Source or Edit Source (depending on the NIOS version you are running)
Copy the entire contents of the XML below and completely replace the XML source of the newly created Dashboard
Optionally change the value of the <label> and <description> tags at the top of the XML. By default the Dashboard will be called "Metrics Collection 6.1" with a description of "Value Metrics Collections and Capacity Planning".
Click Save

<label>Metrics Collection 6.1 / Grid Review</label>

<description>Value Metrics Collections and Capacity Planning</description>

<row>

<panel>

<title>DNS Daily Peak Hour Query Rate by Member - Last 365 Days</title>

<chart>

<query>index=ib_dns_summary report=si_dns_member_qps_trend_per_hour | lookup dns_viewkey_displayname_lookup VIEW output display_name | rename orig_host as host | msservers MS_SERVER | eval source_host=if(MS_SERVER !="", coalesce(ms_resolved_names,ms_resolved_ips),host) | stats avg(QCOUNT) as avg_COUNT, max(QCOUNT) as max_COUNT by _time source_host VIEW | bucket span=1d _time | streamstats max(avg_COUNT) as MAX_AVG_COUNT by _time, source_host, VIEW | eval avg_COUNT = if (avg_COUNT == MAX_AVG_COUNT, avg_COUNT, 0) | eval max_COUNT = if (avg_COUNT == MAX_AVG_COUNT, max_COUNT, 0) | stats max(avg_COUNT) as avg_COUNT, max(max_COUNT) as max_COUNT by _time, source_host, VIEW | timechart span=1d eval(max(max_COUNT)/600) by source_host where max in top500 useother=f | interpolate 172800</query>

</search>

<option name="charting.chart.stackMode">stacked</option>

</chart>

</panel>

</row>

<row>

<panel>

<title>DNS Query Rate by Member - Last 30 Days</title>

<chart>

<query>index=ib_dns_summary report=si_dns_member_qps_trend | lookup dns_viewkey_displayname_lookup VIEW output display_name | rename orig_host as host | msservers MS_SERVER | eval source_host=if(MS_SERVER !="", coalesce(ms_resolved_names,ms_resolved_ips),host) | stats sum(QCOUNT) as QCOUNT by _time source_host | timechart bins=1000 eval(avg(QCOUNT)/600) by source_host where max in top500 useother=f | interpolate 1200</query>

</search>

<option name="charting.chart.stackMode">stacked</option>

</chart>

</panel>

</row>

<row>

<panel>

<title>Active IP Addresses Per Day - Last 365 Days</title>

<chart>

<query>index=ib_ipam_summary report=si_ipam_address_usage_trend_per_5days | eval Peak_IPV4=IPV4_COUNT, Peak_IPV6=IPV6_COUNT, Peak_Total=TOTAL_COUNT | eval "Time"=strftime(_time, "%m/%d/%Y:%H:%M:%S") | streamstats window=5 avg(Peak_IPV4) as Avg_IPv4_Count, avg(Peak_IPV6) as Avg_IPv6_Count, avg(Peak_Total) as Avg_Total_Count | sort _time | rename IPV4_COUNT as "IPv4 Count", IPV6_COUNT as "IPv6 Count", TOTAL_COUNT as "Total Count" | table "Time", "IPv4 Count", "IPv6 Count", "Total Count"</query>

</search>

<option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option>

<option name="charting.axisTitleX.visibility">visible</option>

<option name="charting.axisTitleY.visibility">visible</option>

<option name="charting.axisTitleY2.visibility">visible</option>

<option name="charting.axisX.scale">linear</option>

<option name="charting.axisY.scale">linear</option>

<option name="charting.axisY2.scale">inherit</option>

<option name="charting.chart.stackMode">default</option>

<option name="charting.chart.style">shiny</option>

<option name="charting.legend.labelStyle.overflowMode">ellipsisMiddle</option>

<option name="charting.legend.mode">standard</option>

<option name="charting.legend.placement">right</option>

<option name="trellis.size">medium</option>

</chart>

</panel>

</row>

<row>

<panel>

<table>

<title>Total DNS Zones</title>

<query>sourcetype=ib:dns:view index=ib_ipam | eval TotalZones=zones_forward+zones_ipv4+zones_ipv6 | stats sum(TotalZones) as TotalZones</query>

</search>

</table>

</panel>

</row>

<row>

<panel>

<table>

<title>DHCP Lease Counts - Last 30 Days</title>

<query>sourcetype=ib:dhcp:lease_history index=ib_dhcp_lease_history earliest=-30d dhcpd OR dhcpdv6 r-l-e | rename ACTION as "Action" | stats count(eval(Action="Issued")) AS ISSUED, count(eval(Action="Reserved")) AS RESERVED, count(eval(Action="Abandoned")) AS ABANDONED, count(eval(Action="Freed")) AS Freed, count(eval(Action="Renewed")) AS RENEWED, count(eval(Action="Fixed")) AS FIXED</query>

</search>

</table>

</panel>

</row>

<row>

<panel>

<table>

<title>DNS Query Count - Last 30 Days</title>

<query>index=ib_dns sourcetype=ib:dns:query:by_member | bucket _time |stats sum(QCOUNT) as QCOUNT | rename QCOUNT as "Query Total"</query>

</search>

</table>

</panel>

</row>

<row>

<panel>

<table>

<title>Reporting Disk Utilization</title>

<query>| rest /services/server/status/partitions-space | eval free = if(isnotnull(available), available, free) | eval usage = capacity - free | eval pct_usage = floor(usage / capacity * 100) | stats first(fs_type) as fs_type first(capacity) as capacity first(usage) as usage first(pct_usage) as pct_usage by mount_point | eval usage=round(usage / 1024, 2) | eval capacity=round(capacity / 1024, 2) | rename mount_point as "Mount Point", fs_type as "File System Type", usage as "Usage (GB)", capacity as "Capacity (GB)", pct_usage as "Usage (%)"</query>

</search>

</table>

</panel>

</row>

<row>

<panel>

<title>Total Allocated IP Addresses</title>

<table>

</search>

<option name="percentagesRow">false</option>

<option name="rowNumbers">false</option>

<option name="totalsRow">false</option>

</table>

</panel>

</row>

<row>

<panel>

<table>

<title>Total Number of Discovered IP Addresses (requires Discovery)</title>

<query>source=ib:ipam:ip_address_inventory index=ib_ipam | sort 0 -_time, +ip(ip_address) | fillnull value="" | dedup network_view ip_address | stats count(ip_address) as IPADDRCOUNT</query>

</search>

</table>

</panel>

</row>

<row>

<panel>

<table>

<title>Total Number of Discovered Networks (requires Discovery)</title>

<query>sourcetype=ib:ipam:network index=ib_ipam | sort 0 -_time, +ip(address) | fillnull value="" | dedup view address cidr | stats count(address) as NETWORKCOUNT</query>

</search>

</table>

</panel>

</row>

<row>

<panel>

<title>Discovered Device Type Count (requires Discovery)</title>

<table>

<query>source=ib:discovery:device_inventory index=ib_discovery | dedup ip_address | eval last_seen=strftime(last_seen,"%Y-%m-%d %H:%M:%S") | eval first_seen=strftime(first_seen,"%Y-%m-%d %H:%M:%S") | stats count by device_type</query>

</search>

<option name="percentagesRow">false</option>

<option name="rowNumbers">false</option>

<option name="totalsRow">false</option>

</table>

</panel>

</row>

<row>

<panel>

<title>DHCP Usage - Last 365 Days (Requires 8.5+)</title>

<chart>

<query>index=ib_usage_count report=si_usage_count_member_dhcp_lps_trend_per_5days

| stats max(LCOUNT) as stats_COUNT by _time

| sort _time

| streamstats window=5 avg(stats_COUNT) as Peak_LPM

| eval Date=strftime(_time, "%a %b %e"),"5-Day Average Peak LPS"=round((Peak_LPM/60),3)

| table Date, "5-Day Average Peak LPS"</query>

</search>

<option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option>

<option name="charting.axisTitleX.visibility">visible</option>

<option name="charting.axisTitleY.visibility">visible</option>

<option name="charting.axisTitleY2.visibility">visible</option>

<option name="charting.axisX.scale">linear</option>

<option name="charting.axisY.scale">linear</option>

<option name="charting.axisY2.scale">inherit</option>

<option name="charting.chart.stackMode">default</option>

<option name="charting.chart.style">shiny</option>

<option name="charting.legend.labelStyle.overflowMode">ellipsisMiddle</option>

<option name="charting.legend.mode">standard</option>

<option name="charting.legend.placement">right</option>

<option name="trellis.size">medium</option>

</chart>

</panel>

</row>

<row>

<panel>

<title>DNS kQPS Usage - Last 365 Days (requires 8.5+)</title>

<chart>

<query>index=ib_usage_count report=si_usage_count_member_qps_trend_per_5days

| stats max(QCOUNT) as stats_COUNT by _time |eval stats_COUNT = stats_COUNT/1000

| sort _time

| streamstats window=5 avg(stats_COUNT) as Peak_QPM

| eval Date=strftime(_time, "%a %b %e"),"5-Day Average Peak kQPS"=round((Peak_QPM/60),3)

| table Date, "5-Day Average Peak kQPS"</query>

</search>

<option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option>

<option name="charting.axisTitleX.visibility">visible</option>

<option name="charting.axisTitleY.visibility">visible</option>

<option name="charting.axisTitleY2.visibility">visible</option>

<option name="charting.axisX.scale">linear</option>

<option name="charting.axisY.scale">linear</option>

<option name="charting.axisY2.scale">inherit</option>

<option name="charting.chart.stackMode">default</option>

<option name="charting.chart.style">shiny</option>

<option name="charting.legend.labelStyle.overflowMode">ellipsisMiddle</option>

<option name="charting.legend.mode">standard</option>

<option name="charting.legend.placement">right</option>

<option name="trellis.size">medium</option>

</chart>

</panel>

</row>

<row>

<panel>

<title>IP Address Usage - Last 365 Days (requires 8.5+)</title>

<chart>

<query>index=ib_usage_count report=si_ipam_usage_count_address_usage_trend_per_5days

| streamstats window=5 avg(IPV4_COUNT) as Peak_IPV4, avg(IPV6_COUNT) as Peak_IPV6, avg(TOTAL_COUNT) as Peak_TOTAL

| sort _time

| eval Date=strftime(_time, "%a %b %e"), "5-Day Avg IPv4 Count"=round(Peak_IPV4,0), "5-Day Avg IPv6 Count"=round(Peak_IPV6,0), "5-Day Avg Total Count"=round(Peak_TOTAL,0)

| dedup the_date

| table Date, "5-Day Avg IPv4 Count","5-Day Avg IPv6 Count","5-Day Avg Total Count"

</query>

</search>

<option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option>

<option name="charting.axisTitleX.visibility">visible</option>

<option name="charting.axisTitleY.visibility">visible</option>

<option name="charting.axisTitleY2.visibility">visible</option>

<option name="charting.axisX.scale">linear</option>

<option name="charting.axisY.scale">linear</option>

<option name="charting.axisY2.scale">inherit</option>

<option name="charting.chart.stackMode">default</option>

<option name="charting.chart.style">shiny</option>

<option name="charting.legend.labelStyle.overflowMode">ellipsisMiddle</option>

<option name="charting.legend.mode">standard</option>

<option name="charting.legend.placement">right</option>

<option name="trellis.size">medium</option>

</chart>

</panel>

</row>

<row>

<panel>

<title>CPU Utilization Trend - Line</title>

<table>

<query>index=ib_system_summary report=si_cpu_usage | timechart bins=1000 avg(CPU_PERCENT) by orig_host where max in top5 useother=f | interpolate 1200</query>

</search>

<option name="percentagesRow">false</option>

<option name="rowNumbers">false</option>

<option name="totalsRow">false</option>

</table>

</panel>

</row>

<row>

<panel>

<title>CPU Utilization Trend - Chart</title>

<chart>

<query>index=ib_system_summary report=si_cpu_usage | timechart bins=1000 avg(CPU_PERCENT) by orig_host where max in top5 useother=f | interpolate 1200</query>

</search>

</chart>

</panel>

</row>

<row>

<panel>

<title>Memory Utilization Trend</title>

<table>

<query>index=ib_system_summary report=si_memory_utilization | rename orig_host as host | timechart bins=1000 avg(MEMORY_PERCENT) by host where max in top5 useother=f | interpolate 1200</query>

</search>

<option name="percentagesRow">false</option>

<option name="rowNumbers">false</option>

<option name="totalsRow">false</option>

</table>

</panel>

</row>

<row>

<panel>

<title>Memory Utilization Trend - Chart</title>

<chart>

<query>index=ib_system_summary report=si_memory_utilization | rename orig_host as host | timechart bins=1000 avg(MEMORY_PERCENT) by host where max in top20 useother=f | interpolate 1200</query>

</search>

</chart>

</panel>

</row>

</dashboard>