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 i...
See more...
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 <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 > $tokStatus30$, "$TOKEN_RED$",if(value > $tokStatus20$, "$TOKEN_YELLOW$", "$TOKEN_GREEN$"))</colorPalette>
</format>
</table>
etc,, for each row of the table