Splunk Enterprise
×

Are you a member of the Splunk Community?

Sign in or Register with your Splunk account to get your questions answered, access valuable resources and connect with experts!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Ask a Question

How do I create a list of Indexes Data & License utilization. And project License usage over time please? Thx a million

SamHTexas
Builder
‎10-18-2021 07:18 AM

I appreciate any help in preventing license usage warnings ? One item I thought of was to create a Dashboard of Indexes Data & License utilization. What other items do I need to watch to prevent License usage warnings please? Thank u in advance.

Labels (2)
Tags (1)
0 Karma
Reply

ashvinpandey
Contributor
‎10-18-2021 07:31 AM

@SamHTexas Below dashboard code can be useful for you:

<form>
  <label>License Usage Monitor</label>
  <fieldset submitButton="false"></fieldset>
  <row>
    <panel>
      <single>
        <title>Today's License Usage In Bytes</title>
        <search>
          <query>index=_internal source=*license_usage.log type=Usage pool=* | stats sum(b) | rename poolsz as "Daily License Quota" sum(b) as "Daily License Quota Used"</query>
          <earliest>@d</earliest>
          <latest>now</latest>
        </search>alhost/<option name="colorBy">value</option>
        <option name="colorMode">block</option>
        <option name="drilldown">all</option>
        <option name="numberPrecision">0</option>
        <option name="rangeColors">["0x604E8F","0x604E8F"]</option>
        <option name="rangeValues">[0]</option>
        <option name="showSparkline">1</option>
        <option name="showTrendIndicator">1</option>
        <option name="trendColorInterpretation">standard</option>
        <option name="trendDisplayMode">absolute</option>
        <option name="underLabel">BYTES</option>
        <option name="unitPosition">after</option>
        <option name="useColors">1</option>
        <option name="useThousandSeparators">1</option>
      </single>
    </panel>
  </row>
  <row>
    <panel>
      <input type="radio" searchWhenChanged="true" token="NumberOfDays">
        <label>SELECT TIMESPAN:</label>
        <choice value="0">Today</choice>
        <choice value="6">Last 7 Days</choice>
        <choice value="13">Last 14 Days</choice>
        <choice value="29">Last 30 Days</choice>
        <choice value="89">Last 90 Days</choice>
        <default>6</default>
        <initialValue>6</initialValue>
      </input>
      <chart>
        <title>Daily License Quota Usage in TB's</title>
        <search>
          <query>index=_internal source=*license_usage.log type=Usage pool=* | rename _time as Date | eval Date=strftime(Date, "%m-%d-%y") | stats sum(b) as ub by Date | eval ub=round(ub/1024/1024/1024/1024,3) | rename ub as "Daily License Quota Used"</query>
          <earliest>-$NumberOfDays$d@d</earliest>
          <latest>now</latest>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option>
        <option name="charting.axisLabelsX.majorLabelStyle.rotation">45</option>
        <option name="charting.axisTitleX.visibility">visible</option>
        <option name="charting.axisTitleY.text">TB's Used</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">line</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.overlayFields">"Daily License Quota Used"</option>
        <option name="charting.chart.showDataLabels">all</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">top</option>
      </chart>
    </panel>
  </row>
  <row>
    <panel>
      <chart>
        <title>Index Usage - Today - Top 20</title>
        <search>
          <query>index=_internal source=*license_usage.log type=Usage pool=* | stats sum(b) as b by idx | eval MB's=round(b/1024/1024,2) | rename idx as Index MB's as "MB's Used" | fields Index "MB's Used" | sort 20 - "MB's Used"</query>
          <earliest>@d</earliest>
          <latest>now</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>
    <panel>
      <table>
        <title>Index Usage - Today</title>
        <search>
          <query>index=_internal source=*license_usage.log type=Usage pool=* | stats sum(b) as b by pool idx | eval MBs=round(b/1024/1024,2) | addcoltotals MBs labelfield=idx label="TOTAL MB's USED:" | rename idx as Index pool as "License Pool" MBs as "MB's Used" | fields "License Pool" Index "MB's Used" | sort - "MB's Used"</query>
          <earliest>@d</earliest>
          <latest>now</latest>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="count">20</option>
        <option name="dataOverlayMode">none</option>
        <option name="drilldown">cell</option>
        <option name="percentagesRow">false</option>
        <option name="rowNumbers">false</option>
        <option name="totalsRow">false</option>
        <option name="wrap">true</option>
        <format type="color" field="Index">
          <colorPalette type="map">{"TOTAL MB's USED:":#604E8F}</colorPalette>
        </format>
      </table>
    </panel>
  </row>
  <row>
    <panel>
      <chart>
        <title>SourceType Usage - Today - Top 20</title>
        <search>
          <query>index=_internal source=*license_usage.log type=Usage pool=* | stats sum(b) as b by st | eval MB's=round(b/1024/1024,2) | rename st as SourceType MB's as "MB's Used" | fields SourceType "MB's Used" | sort 20 - "MB's Used"</query>
          <earliest>@d</earliest>
          <latest>now</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>
    <panel>
      <table>
        <title>SourceType Usage - Today</title>
        <search>
          <query>index=_internal source=*license_usage.log type=Usage pool=* | stats sum(b) as b by pool st idx | eval MBs=round(b/1024/1024,2) | addcoltotals MBs labelfield=st label="TOTAL MB's USED:" | rename pool as "License Pool" st as SourceType idx as Index MBs as "MB's Used" | fields "License Pool" SourceType Index "MB's Used" | sort - "MB's Used"</query>
          <earliest>@d</earliest>
          <latest>now</latest>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="count">20</option>
        <option name="dataOverlayMode">none</option>
        <option name="drilldown">cell</option>
        <option name="percentagesRow">false</option>
        <option name="rowNumbers">false</option>
        <option name="totalsRow">false</option>
        <option name="wrap">true</option>
        <format type="color" field="SourceType">
          <colorPalette type="map">{"TOTAL MB's USED:":#604E8F}</colorPalette>
        </format>
      </table>
    </panel>
  </row>
  <row>
    <panel>
      <chart>
        <title>SourceType Usage - Last 7 Days</title>
        <search>
          <query>index=_internal source=*license_usage.log type=Usage pool=* | eval MBs=round(b/1024/1024,2) | timechart sum(MBs) by st</query>/run/media/draesner/USB30FD<earliest>-6d@d</earliest>
          <latest>now</latest>
          <sampleRatio>1</sampleRatio>
        </search>
        <option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option>
        <option name="charting.axisLabelsX.majorLabelStyle.rotation">45</option>
        <option name="charting.axisTitleX.text">Date</option>
        <option name="charting.axisTitleX.visibility">visible</option>
        <option name="charting.axisTitleY.text">MB's</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">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>
</form>

Also, if this reply helped you a thumbs-up would be appreciated!

0 Karma
Reply

SamHTexas
Builder
‎10-18-2021 08:48 AM

Need help running this Dashboard code please. I get :   

Error in 'SearchParser': Missing a search command before '"'. Error at position '704' of search query 'search <form> <label>License Usage Monitor</lab...{snipped} {errorcontext = eColors">["0x604E8F",}'.

When running this Dashboard code. I tried fixing the code but not working for me. I appreciate your help.

Tags (1)
0 Karma
Reply

SamHTexas
Builder
‎10-18-2021 07:47 AM

Thanks very much. How do I test this out in my Splunk environment?

Tags (1)
0 Karma
Reply
Get Updates on the Splunk Community!

Observability Unlocked: Kubernetes Monitoring with Splunk Observability Cloud

  Ready to master Kubernetes and cloud monitoring like the pros?Join Splunk’s Growth Engineering team for an ...

Wrapping Up Cybersecurity Awareness Month

October might be wrapping up, but for Splunk Education, cybersecurity awareness never goes out of season. ...

🌟 From Audit Chaos to Clarity: Welcoming Audit Trail v2

&#x1f5e3; You Spoke, We Listened  Audit Trail v2 wasn’t written in isolation—it was shaped by your voices.  In ...