Learn How We Can Help You Keep Teleworkers Protected During the COVID-19 Crisis

Reporting

Reply
Highlighted

License Pool Utilization Report

Adviser
Posts: 244
1469     1
<form>
  <label>License Pool Utilization</label>
  <description>System-created dashboard: Please clone before editing.</description>
  <fieldset submitButton="true" autoRun="true">
    <input type="time" token="time">
      <label>Time</label>
      <default>
        <earliest>-7d@d</earliest>
        <latest>now</latest>
      </default>
    </input>
    <input type="dropdown" token="license_pool">
      <label>License Pool</label>
      <choice value="All">All</choice>
      <default>All</default>
      <search>
        <query>sourcetype=ib:reserved2 source=ib:license:license_pool_utilizations index=ib_license
          | rex field=license_pool "(?&lt;LICENSE_TYPE&gt;^.+)\.(?&lt;limit&gt;.+)\.(?&lt;model&gt;.*$)"
          | lookup license_type_lookup LICENSE_TYPE output LICENSE_TYPE_GUI
          | eval license_pool_gui = LICENSE_TYPE_GUI." ".model
          | stats count by license_pool_gui</query>
        <earliest>$time.earliest$</earliest>
        <latest>$time.latest$</latest>
      </search>
      <fieldForLabel>license_pool_gui</fieldForLabel>
      <fieldForValue>license_pool_gui</fieldForValue>
      <change>
        <condition value="All">
          <set token="license_pool_str">| noop</set>
        </condition>
        <condition value="*">
          <set token="license_pool_str">| where (license_pool_gui=="$value$")</set>
        </condition>
      </change>
    </input>
    <input type="link" token="view" searchWhenChanged="true">
      <label>View</label>
      <choice value="chart">Line Chart</choice>
      <choice value="table">Table</choice>
      <choice value="both">Both</choice>
      <default>chart</default>
      <change>
        <condition value="table">
          <set token="show_table">true</set>
          <unset token="show_chart"></unset>
        </condition>
        <condition value="chart">
          <set token="show_chart">true</set>
          <unset token="show_table"></unset>
        </condition>
        <condition value="both">
          <set token="show_chart">true</set>
          <set token="show_table">true</set>
        </condition>
      </change>
    </input>
  </fieldset>
  <row>
    <panel>
      <search id="base_search">
        <query>sourcetype=ib:reserved2 source=ib:license:license_pool_utilizations index=ib_license
            | convert ctime(_time) as Time
            | rex field=license_pool "(?&lt;LICENSE_TYPE&gt;^.+)\.(?&lt;limit&gt;.+)\.(?&lt;model&gt;.*$)"
            | lookup license_type_lookup LICENSE_TYPE output LICENSE_TYPE_GUI      
            | eval license_pool_gui = LICENSE_TYPE_GUI." ".model 
            $license_pool_str$
            | rename license_count as "License Count", utilization as "Utilization", license_pool_gui as "License Pool"</query>
        <earliest>$time.earliest$</earliest>
        <latest>$time.latest$</latest>
      </search>
      <table depends="$show_table$">
        <search base="base_search">
          <query>| sort -_time, "License Pool"
            | table _time "License Pool" "License Count" Utilization
            | rename _time as Time
            | eval Time=strftime(Time, "%Y-%m-%d %H:%M:%S %Z")</query>
        </search>
        <option name="wrap">true</option>
        <option name="rowNumbers">true</option>
        <option name="dataOverlayMode">none</option>
        <option name="drilldown">none</option>
        <option name="count">10</option>
      </table>
      <chart depends="$show_chart$">
        <search base="base_search">
          <query>| timechart limit=0 max(Utilization) by "License Pool"</query>
        </search>
        <option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option>
        <option name="charting.axisLabelsX.majorLabelStyle.rotation">0</option>
        <option name="charting.axisTitleX.text">Time</option>
        <option name="charting.axisTitleX.visibility">visible</option>
        <option name="charting.axisTitleY.text">License Pool Utilization</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.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">none</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>
If you appreciate my efforts, please give me a kudo ↓ or Accept as solution to help others find it faster.
Showing results for 
Search instead for 
Do you mean 

Recommended for You