Reply

System Reporting Capacity Dashboard

[ Edited ]
maxonic
Techie
Posts: 3
3391     2

This dashboard helps administrators get better visibility into the index utilization and overall capacity of the reporting server.

 

Screenshot 1

 

Screenshot 2

 

 

<dashboard>
<label>System Reporting Capacity Dashboard</label>
<row>
<panel>
<table>
<title>Disk Usage by Index</title>
<search>
<query>|rest /services/data/indexes |eval space=round((maxTotalDataSizeMB-currentDBSizeMB)/1024 ,2)|table title minTime currentDBSizeMB space | where minTime!=""| rename currentDBSizeMB to "Current Size in MB" , minTime to "Oldest Event" , title to "Index" ,space to "Space Left in GB"</query>
<earliest>1455691606.000</earliest>
<latest></latest>
</search>
<option name="wrap">true</option>
<option name="rowNumbers">false</option>
<option name="dataOverlayMode">none</option>
<option name="drilldown">cell</option>
<option name="count">20</option>
</table>
</panel>
</row>
<row>
<panel>
<single>
<title>Total Disk Usage</title>
<search>
<query>index=_internal source=*metrics.log group=per_index_thruput | eval totalMB = round(kb/1024,2) | chart sum(totalMB) as MB</query>
<earliest>1455691606.000</earliest>
<latest></latest>
</search>
<option name="colorBy">value</option>
<option name="colorMode">none</option>
<option name="numberPrecision">0</option>
<option name="rangeColors">["0x65a637","0x6db7c6","0xf7bc38","0xf58f39","0xd93f3c"]</option>
<option name="rangeValues">[0,30,70,100]</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">1</option>
<option name="trendColorInterpretation">standard</option>
<option name="trendDisplayMode">absolute</option>
<option name="trendInterval">auto</option>
<option name="underLabel">Megabytes</option>
<option name="useColors">0</option>
<option name="useThousandSeparators">1</option>
</single>
</panel>
<panel>
<chart>
<title>Index utilization comparison</title>
<search>
<query>index=_internal source=*metrics.log group=per_index_thruput | eval totalMB = round(kb/1024,2) | chart sum(totalMB) as MB by series</query>
<earliest>1455691606.000</earliest>
<latest></latest>
</search>
<option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option>
<option name="charting.axisLabelsX.majorLabelStyle.rotation">0</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.enabled">0</option>
<option name="charting.axisY2.scale">inherit</option>
<option name="charting.chart">pie</option>
<option name="charting.chart.bubbleMaximumSize">50</option>
<option name="charting.chart.bubbleMinimumSize">10</option>
<option name="charting.chart.bubbleSizeBy">area</option>
<option name="charting.chart.nullValueMode">gaps</option>
<option name="charting.chart.showDataLabels">none</option>
<option name="charting.chart.sliceCollapsingThreshold">0.01</option>
<option name="charting.chart.stackMode">default</option>
<option name="charting.chart.style">shiny</option>
<option name="charting.drilldown">all</option>
<option name="charting.layout.splitSeries">0</option>
<option name="charting.layout.splitSeries.allowIndependentYRanges">0</option>
<option name="charting.legend.labelStyle.overflowMode">ellipsisMiddle</option>
<option name="charting.legend.placement">right</option>
</chart>
</panel>
</row>
<row>
<panel>
<chart>
<title>Index Usage Trend</title>
<search>
<query>index=_internal source=*metrics.log group=per_index_thruput | eval MB=kb/1024
| timechart span=1d sum(MB) by series | fields - VALUE_*</query>
<earliest></earliest>
<latest></latest>
</search>
<option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option>
<option name="charting.axisLabelsX.majorLabelStyle.rotation">0</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.enabled">0</option>
<option name="charting.axisY2.scale">inherit</option>
<option name="charting.chart">area</option>
<option name="charting.chart.bubbleMaximumSize">50</option>
<option name="charting.chart.bubbleMinimumSize">10</option>
<option name="charting.chart.bubbleSizeBy">area</option>
<option name="charting.chart.nullValueMode">gaps</option>
<option name="charting.chart.showDataLabels">none</option>
<option name="charting.chart.sliceCollapsingThreshold">0.01</option>
<option name="charting.chart.stackMode">stacked</option>
<option name="charting.chart.style">shiny</option>
<option name="charting.drilldown">all</option>
<option name="charting.layout.splitSeries">0</option>
<option name="charting.layout.splitSeries.allowIndependentYRanges">0</option>
<option name="charting.legend.labelStyle.overflowMode">ellipsisMiddle</option>
<option name="charting.legend.placement">right</option>
</chart>
</panel>
</row>
<row>
<panel>
<html>
<div style="text-align: right;margin-top:0;;margin-bottom:0">
<h1>Developed by <a href="http://www.maxonic.com" target="_blank"><img src="http://maxonic.com/wp-content/uploads/2016/06/maxonic_logo_small.png"/></a>
</h1>
</div>
</html>
</panel>
</row>
</dashboard>

 

 

Re: System Reporting Capacity Dashboard

Adviser
Posts: 47
3392     2

Great one, works in a single step. Very interesting to see the impact of the 7.3.200/7.4 Syslog redirection to the reporting.

 

Note: the three last reports can take a while to be fully rendered when reporting is deployed for months

 

Screenshot 1

 

Screenshot 2

Check out our new Tech docs website at http://docs.infobox.com for latest documentation on Infoblox products.

Re: System Reporting Capacity Dashboard

atul
Techie
Posts: 1
3392     2

How we can check current DDI memebr hardware configuration like

Total / Numbers CPU cores -

Total memory-

Showing results for 
Search instead for 
Do you mean 

Recommended for You