Splunk Search

HTML - Style - remove the extra lin eof black

robertlynch2020
Influencer

Hi 

I have the below code to produce this table - but does anyone know how to get rid of the part in red (I have added this with paint) - it's just taking up too much real estate on the screen. It is like an extra line of black that I don't want.

Thanks so much in advance 🙂

robertlynch2020_1-1732127184787.png

 

 <panel>
      <title>Process Resources</title>
      <html depends="$alwaysHideCSSStyle$">
         <style>
           #tableWithHiddenHeader6  th[data-sort-key=label] {
             width: 40% !important;
             text-align: left;
           }
           #tableWithHiddenHeader6  th[data-sort-key=value] {
             width: 20% !important;
             text-align: left;
           }
            #tableWithHiddenHeader6  th[data-sort-key=threshold] {
             width: 20% !important;
             text-align: left;
           }
            #tableWithHiddenHeader6  th[data-sort-key=limit] {
             width: 20% !important;
             text-align: left;
           }
           #tableWithHiddenHeader6  td {
              text-align: left;
            }
           #tableWithHiddenHeader7 thead{
             visibility: hidden;
             height: min-content;
           }
           #tableWithHiddenHeader7  th[data-sort-key=label] {
             width: 40% !important;
           }
           #tableWithHiddenHeader7  th[data-sort-key=value] {
             width: 20% !important;
           }
            #tableWithHiddenHeader7  th[data-sort-key=threshold] {
             width: 20% !important;
           }
            #tableWithHiddenHeader7  th[data-sort-key=limit] {
             width: 20% !important;
           }
            #tableWithHiddenHeader7  td {
              text-align: left;
            }
            #tableWithHiddenHeader8 thead{
             visibility: hidden;
             height: min-content;
           }
           #tableWithHiddenHeader8  th[data-sort-key=label] {
             width: 40% !important;
           }
           #tableWithHiddenHeader8  th[data-sort-key=value] {
             width: 20% !important;
           }
            #tableWithHiddenHeader8  th[data-sort-key=threshold] {
             width: 20% !important;
           }
            #tableWithHiddenHeader8  th[data-sort-key=limit] {
             width: 20% !important;
           }
            #tableWithHiddenHeader8  td {
              text-align: left;
            }
            #tableWithHiddenHeader9 thead{
             visibility: hidden;
             height: min-content;
           }
           #tableWithHiddenHeader9  th[data-sort-key=label] {
             width: 40% !important;
           }
           #tableWithHiddenHeader9  th[data-sort-key=value] {
             width: 20% !important;
           }
            #tableWithHiddenHeader9  th[data-sort-key=threshold] {
             width: 20% !important;
           }
            #tableWithHiddenHeader9  th[data-sort-key=limit] {
             width: 20% !important;
           }
            #tableWithHiddenHeader9  td {
              text-align: left;
            }
            #tableWithHiddenHeader10 thead{
             visibility: hidden;
             height: min-content;
           }
           #tableWithHiddenHeader10  th[data-sort-key=label] {
             width: 40% !important;
           }
           #tableWithHiddenHeader10  th[data-sort-key=value] {
             width: 20% !important;
           }
            #tableWithHiddenHeader10  th[data-sort-key=threshold] {
             width: 20% !important;
           }
            #tableWithHiddenHeader10  th[data-sort-key=limit] {
             width: 20% !important;
           }
            #tableWithHiddenHeader10  td {
              text-align: left;
            }
         </style>
       </html>
      <table id="tableWithHiddenHeader6">
        <search id="twenty_one">
          <done>
            <set token="tokStatus20">$result.threshold$</set>
            <set token="tokStatus30">$result.limit$</set>
          </done>
          <query>| mstats max("mx.database.space.usage") as value WHERE "index"="murex_metrics" AND "mx.env"="*" AND process.pid ="*" span=10s BY degraded.threshold down.threshold process.pid 
| rename degraded.threshold as T_CpuPerc 
| rename down.threshold as limit 
| sort - _time 
| head 1 
| eval value = round(value,1) 
| eval label="Database space" 
| eval threshold=T_CpuPerc 
| eval limit=limit 
| table label value threshold limit 
| appendpipe 
    [ stats count 
    | eval "label"="No results Found" 
    | where count=0 
    | table "label"]</query>
          <earliest>$time_token.earliest$</earliest>
          <latest>$time_token.latest$</latest>
          <sampleRatio>1</sampleRatio>
          <refresh>5s</refresh>
          <refreshType>delay</refreshType>
        </search>
        <option name="count">20</option>
        <option name="dataOverlayMode">none</option>
        <option name="drilldown">none</option>
        <option name="percentagesRow">false</option>
        <option name="refresh.display">progressbar</option>
        <option name="rowNumbers">false</option>
        <option name="totalsRow">false</option>
        <option name="wrap">true</option>
        <format type="color" field="value">
          <colorPalette type="expression">if(value &gt; $tokStatus30$, "$TOKEN_RED$",if(value &gt; $tokStatus20$, "$TOKEN_YELLOW$", "$TOKEN_GREEN$"))</colorPalette>
        </format>
      </table>


etc,, for each row of the table

 

 

 

 

 

 

0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust

Try like this

           #tableWithHiddenHeader7 thead{
             display: none;
           }
           #tableWithHiddenHeader7  tr td:nth-child(1) {
             width: 40% !important;
           }
           #tableWithHiddenHeader7  tr td:nth-child(2) {
             width: 20% !important;
           }
            #tableWithHiddenHeader7 tr td:nth-child(3) {
             width: 20% !important;
           }
            #tableWithHiddenHeader7 tr td:nth-child(4) {
             width: 20% !important;
           }
            #tableWithHiddenHeader7  td {
              text-align: left;
            }
            #tableWithHiddenHeader8 thead{
             display: none;
           }
           #tableWithHiddenHeader8  tr td:nth-child(1) {
             width: 40% !important;
           }
           #tableWithHiddenHeader8  tr td:nth-child(2) {
             width: 20% !important;
           }
            #tableWithHiddenHeader8 tr td:nth-child(3) {
             width: 20% !important;
           }
            #tableWithHiddenHeader8 tr td:nth-child(4) {
             width: 20% !important;
           }
            #tableWithHiddenHeader8  td {
              text-align: left;
            }
            #tableWithHiddenHeader9 thead{
             display: none;
           }
           #tableWithHiddenHeader9  tr td:nth-child(1) {
             width: 40% !important;
           }
           #tableWithHiddenHeader9  tr td:nth-child(2) {
             width: 20% !important;
           }
            #tableWithHiddenHeader9 tr td:nth-child(3) {
             width: 20% !important;
           }
            #tableWithHiddenHeader9 tr td:nth-child(4) {
             width: 20% !important;
           }
            #tableWithHiddenHeader9  td {
              text-align: left;
            }
            #tableWithHiddenHeader10 thead{
             display: none;
           }
           #tableWithHiddenHeader10  tr td:nth-child(1) {
             width: 40% !important;
           }
           #tableWithHiddenHeader10  tr td:nth-child(2) {
             width: 20% !important;
           }
            #tableWithHiddenHeader10 tr td:nth-child(3) {
             width: 20% !important;
           }
            #tableWithHiddenHeader10 tr td:nth-child(4) {
             width: 20% !important;
           }
            #tableWithHiddenHeader10  td {
              text-align: left;
            }

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust

Please share the panel source including the search you have used

0 Karma

robertlynch2020
Influencer

Hi @ITWhisperer 

Below is pannel to pannel - thanks for the help

  <row>
    <panel>
      <title>Process Resources</title>
      <html depends="$alwaysHideCSSStyle$">
         <style>
           #tableWithHiddenHeader6  th[data-sort-key=label] {
             width: 40% !important;
             text-align: left;
           }
           #tableWithHiddenHeader6  th[data-sort-key=value] {
             width: 20% !important;
             text-align: left;
           }
            #tableWithHiddenHeader6  th[data-sort-key=threshold] {
             width: 20% !important;
             text-align: left;
           }
            #tableWithHiddenHeader6  th[data-sort-key=limit] {
             width: 20% !important;
             text-align: left;
           }
           #tableWithHiddenHeader6  td {
              text-align: left;
            }
           #tableWithHiddenHeader7 thead{
             visibility: hidden;
             height: min-content;
           }
           #tableWithHiddenHeader7  th[data-sort-key=label] {
             width: 40% !important;
           }
           #tableWithHiddenHeader7  th[data-sort-key=value] {
             width: 20% !important;
           }
            #tableWithHiddenHeader7  th[data-sort-key=threshold] {
             width: 20% !important;
           }
            #tableWithHiddenHeader7  th[data-sort-key=limit] {
             width: 20% !important;
           }
            #tableWithHiddenHeader7  td {
              text-align: left;
            }
            #tableWithHiddenHeader8 thead{
             visibility: hidden;
             height: min-content;
           }
           #tableWithHiddenHeader8  th[data-sort-key=label] {
             width: 40% !important;
           }
           #tableWithHiddenHeader8  th[data-sort-key=value] {
             width: 20% !important;
           }
            #tableWithHiddenHeader8  th[data-sort-key=threshold] {
             width: 20% !important;
           }
            #tableWithHiddenHeader8  th[data-sort-key=limit] {
             width: 20% !important;
           }
            #tableWithHiddenHeader8  td {
              text-align: left;
            }
            #tableWithHiddenHeader9 thead{
             visibility: hidden;
             height: min-content;
           }
           #tableWithHiddenHeader9  th[data-sort-key=label] {
             width: 40% !important;
           }
           #tableWithHiddenHeader9  th[data-sort-key=value] {
             width: 20% !important;
           }
            #tableWithHiddenHeader9  th[data-sort-key=threshold] {
             width: 20% !important;
           }
            #tableWithHiddenHeader9  th[data-sort-key=limit] {
             width: 20% !important;
           }
            #tableWithHiddenHeader9  td {
              text-align: left;
            }
            #tableWithHiddenHeader10 thead{
             visibility: hidden;
             height: min-content;
           }
           #tableWithHiddenHeader10  th[data-sort-key=label] {
             width: 40% !important;
           }
           #tableWithHiddenHeader10  th[data-sort-key=value] {
             width: 20% !important;
           }
            #tableWithHiddenHeader10  th[data-sort-key=threshold] {
             width: 20% !important;
           }
            #tableWithHiddenHeader10  th[data-sort-key=limit] {
             width: 20% !important;
           }
            #tableWithHiddenHeader10  td {
              text-align: left;
            }
         </style>
       </html>
      <table id="tableWithHiddenHeader6">
        <search id="twenty_one">
          <done>
            <set token="tokStatus20">$result.threshold$</set>
            <set token="tokStatus30">$result.limit$</set>
          </done>
          <query>| mstats max("mx.database.space.usage") as value WHERE "index"="murex_metrics" AND "mx.env"="*" AND process.pid ="*" span=10s BY degraded.threshold down.threshold process.pid 
| rename degraded.threshold as T_CpuPerc 
| rename down.threshold as limit 
| sort - _time 
| head 1 
| eval value = round(value,1) 
| eval label="Database space" 
| eval threshold=T_CpuPerc 
| eval limit=limit 
| table label value threshold limit 
| appendpipe 
    [ stats count 
    | eval "label"="No results Found" 
    | where count=0 
    | table "label"]</query>
          <earliest>$time_token.earliest$</earliest>
          <latest>$time_token.latest$</latest>
          <sampleRatio>1</sampleRatio>
          <refresh>5s</refresh>
          <refreshType>delay</refreshType>
        </search>
        <option name="count">20</option>
        <option name="dataOverlayMode">none</option>
        <option name="drilldown">none</option>
        <option name="percentagesRow">false</option>
        <option name="refresh.display">progressbar</option>
        <option name="rowNumbers">false</option>
        <option name="totalsRow">false</option>
        <option name="wrap">true</option>
        <format type="color" field="value">
          <colorPalette type="expression">if(value &gt; $tokStatus30$, "$TOKEN_RED$",if(value &gt; $tokStatus20$, "$TOKEN_YELLOW$", "$TOKEN_GREEN$"))</colorPalette>
        </format>
      </table>
      <table id="tableWithHiddenHeader7">
        <search id="twenty_two">
          <done>
            <set token="tokStatus40">$result.threshold$</set>
            <set token="tokStatus50">$result.limit$</set>
          </done>
          <query>| mstats max("mx.database.statement.top_running.time") as value WHERE "index"="murex_metrics" AND "mx.env"="*" AND process.pid ="*" span=10s BY degraded.threshold down.threshold process.pid 
| rename degraded.threshold as T_CpuPerc 
| rename down.threshold as limit 
| sort - _time 
| head 1 
| eval value = round(value,1) 
| eval label="Top Running" 
| eval threshold=T_CpuPerc 
| eval limit=limit 
| table label value threshold limit 
| appendpipe 
    [ stats count 
    | eval "label"="No results Found" 
    | where count=0 
    | table "label"]</query>
          <earliest>$time_token.earliest$</earliest>
          <latest>$time_token.latest$</latest>
          <sampleRatio>1</sampleRatio>
          <refresh>5s</refresh>
          <refreshType>delay</refreshType>
        </search>
        <option name="count">20</option>
        <option name="dataOverlayMode">none</option>
        <option name="drilldown">none</option>
        <option name="percentagesRow">false</option>
        <option name="refresh.display">progressbar</option>
        <option name="rowNumbers">false</option>
        <option name="totalsRow">false</option>
        <option name="wrap">true</option>
        <format type="color" field="value">
          <colorPalette type="expression">if(value &gt; $tokStatus50$, "$TOKEN_RED$",if(value &gt; $tokStatus40$, "$TOKEN_YELLOW$", "$TOKEN_GREEN$"))</colorPalette>
        </format>
      </table>
      <table id="tableWithHiddenHeader8">
        <search id="twenty_three">
          <done>
            <set token="tokStatus60">$result.threshold$</set>
            <set token="tokStatus70">$result.limit$</set>
          </done>
          <query>| mstats max("mx.database.lock.top_blocking.time") as value WHERE "index"="murex_metrics" AND "mx.env"="*" AND process.pid ="*" span=10s BY degraded.threshold down.threshold process.pid 
| rename degraded.threshold as T_CpuPerc 
| rename down.threshold as limit 
| sort - _time 
| head 1 
| eval value = round(value,1) 
| eval label="Blocking Locks" 
| eval threshold=T_CpuPerc 
| eval limit=limit 
| table label value threshold limit 
| appendpipe 
    [ stats count 
    | eval "label"="No results Found" 
    | where count=0 
    | table "label"]</query>
          <earliest>$time_token.earliest$</earliest>
          <latest>$time_token.latest$</latest>
          <sampleRatio>1</sampleRatio>
          <refresh>30s</refresh>
          <refreshType>delay</refreshType>
        </search>
        <option name="count">20</option>
        <option name="dataOverlayMode">none</option>
        <option name="drilldown">none</option>
        <option name="percentagesRow">false</option>
        <option name="refresh.display">progressbar</option>
        <option name="rowNumbers">false</option>
        <option name="totalsRow">false</option>
        <option name="wrap">true</option>
        <format type="color" field="value">
          <colorPalette type="expression">if(value &gt; $tokStatus70$, "$TOKEN_RED$",if(value &gt; $tokStatus60$, "#ffae46", "$TOKEN_GREEN$"))</colorPalette>
        </format>
      </table>
      <table id="tableWithHiddenHeader9">
        <search id="twenty_four">
          <done>
            <set token="tokStatus80">$result.threshold$</set>
            <set token="tokStatus90">$result.limit$</set>
          </done>
          <query>| mstats max("mx.database.oracle.redo_switch.count") as value WHERE "index"="murex_metrics" AND "mx.env"="*" AND process.pid ="*" span=10s BY degraded.threshold down.threshold process.pid 
| rename degraded.threshold as T_CpuPerc 
| rename down.threshold as limit 
| sort - _time 
| head 1 
| eval value = round(value,1) 
| eval label="Redo Switch Count" 
| eval threshold=T_CpuPerc 
| eval limit=limit 
| table label value threshold limit 
| appendpipe 
    [ stats count 
    | eval "label"="No results Found" 
    | where count=0 
    | table "label"]</query>
          <earliest>$time_token.earliest$</earliest>
          <latest>$time_token.latest$</latest>
          <sampleRatio>1</sampleRatio>
          <refresh>30s</refresh>
          <refreshType>delay</refreshType>
        </search>
        <option name="count">20</option>
        <option name="dataOverlayMode">none</option>
        <option name="drilldown">none</option>
        <option name="percentagesRow">false</option>
        <option name="refresh.display">progressbar</option>
        <option name="rowNumbers">false</option>
        <option name="totalsRow">false</option>
        <option name="wrap">true</option>
        <format type="color" field="value">
          <colorPalette type="expression">if(value &gt; $tokStatus90$, "$TOKEN_RED$",if(value &gt; $tokStatus80$, "$TOKEN_YELLOW$", "$TOKEN_GREEN$"))</colorPalette>
        </format>
      </table>
      <table id="tableWithHiddenHeader10">
        <search id="twenty_five">
          <done>
            <set token="tokStatus100">$result.threshold$</set>
            <set token="tokStatus110">$result.limit$</set>
          </done>
          <query>| mstats max("mx.database.object.invalid.count") as value WHERE "index"="murex_metrics" AND "mx.env"="*" AND process.pid ="*" span=10s BY degraded.threshold down.threshold process.pid 
| rename degraded.threshold as T_CpuPerc 
| rename down.threshold as limit 
| sort - _time 
| head 1 
| eval value = round(value,1) 
| eval label="Database space" 
| eval threshold=T_CpuPerc 
| eval limit=limit 
| table label value threshold limit 
| appendpipe 
    [ stats count 
    | eval "label"="No results Found" 
    | where count=0 
    | table "label"]</query>
          <earliest>$time_token.earliest$</earliest>
          <latest>$time_token.latest$</latest>
          <sampleRatio>1</sampleRatio>
          <refresh>30s</refresh>
          <refreshType>delay</refreshType>
        </search>
        <option name="count">20</option>
        <option name="dataOverlayMode">none</option>
        <option name="drilldown">none</option>
        <option name="percentagesRow">false</option>
        <option name="refresh.display">progressbar</option>
        <option name="rowNumbers">false</option>
        <option name="totalsRow">false</option>
        <option name="wrap">true</option>
        <format type="color" field="value">
          <colorPalette type="expression">if(value &gt; $tokStatus110$, "$TOKEN_RED$",if(value &gt; $tokStatus100$, "$TOKEN_YELLOW$", "$TOKEN_GREEN$"))</colorPalette>
        </format>
      </table>
    </panel>
  </row>

 

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Try like this

           #tableWithHiddenHeader7 thead{
             display: none;
           }
           #tableWithHiddenHeader7  tr td:nth-child(1) {
             width: 40% !important;
           }
           #tableWithHiddenHeader7  tr td:nth-child(2) {
             width: 20% !important;
           }
            #tableWithHiddenHeader7 tr td:nth-child(3) {
             width: 20% !important;
           }
            #tableWithHiddenHeader7 tr td:nth-child(4) {
             width: 20% !important;
           }
            #tableWithHiddenHeader7  td {
              text-align: left;
            }
            #tableWithHiddenHeader8 thead{
             display: none;
           }
           #tableWithHiddenHeader8  tr td:nth-child(1) {
             width: 40% !important;
           }
           #tableWithHiddenHeader8  tr td:nth-child(2) {
             width: 20% !important;
           }
            #tableWithHiddenHeader8 tr td:nth-child(3) {
             width: 20% !important;
           }
            #tableWithHiddenHeader8 tr td:nth-child(4) {
             width: 20% !important;
           }
            #tableWithHiddenHeader8  td {
              text-align: left;
            }
            #tableWithHiddenHeader9 thead{
             display: none;
           }
           #tableWithHiddenHeader9  tr td:nth-child(1) {
             width: 40% !important;
           }
           #tableWithHiddenHeader9  tr td:nth-child(2) {
             width: 20% !important;
           }
            #tableWithHiddenHeader9 tr td:nth-child(3) {
             width: 20% !important;
           }
            #tableWithHiddenHeader9 tr td:nth-child(4) {
             width: 20% !important;
           }
            #tableWithHiddenHeader9  td {
              text-align: left;
            }
            #tableWithHiddenHeader10 thead{
             display: none;
           }
           #tableWithHiddenHeader10  tr td:nth-child(1) {
             width: 40% !important;
           }
           #tableWithHiddenHeader10  tr td:nth-child(2) {
             width: 20% !important;
           }
            #tableWithHiddenHeader10 tr td:nth-child(3) {
             width: 20% !important;
           }
            #tableWithHiddenHeader10 tr td:nth-child(4) {
             width: 20% !important;
           }
            #tableWithHiddenHeader10  td {
              text-align: left;
            }

robertlynch2020
Influencer

wonderful - and thanks. 🙂

 

robertlynch2020_0-1732183492849.png

 

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Updated the accepted solution with the actual solution 😎

0 Karma
Get Updates on the Splunk Community!

Fall Into Learning with New Splunk Education Courses

Every month, Splunk Education releases new courses to help you branch out, strengthen your data science roots, ...

Super Optimize your Splunk Stats Searches: Unlocking the Power of tstats, TERM, and ...

By Martin Hettervik, Senior Consultant and Team Leader at Accelerate at Iver, Splunk MVPThe stats command is ...

How Splunk Observability Cloud Prevented a Major Payment Crisis in Minutes

Your bank's payment processing system is humming along during a busy afternoon, handling millions in hourly ...