Hai Friends,
Need your help in getting more idea about below topics.
In cell level drilldown. When i click a value in a cell, instead of showing single drilldown panel its showing me two drilldown panels. Because the cell(column) where i click have some decency with another cell(column) before it .. So both the drilldown panels are showing up.
Even though it has dependency i don't want two panel to be shown at the same time when i click single cell value .. when i click a particular cell . I want that particular drilldown panel need to be shown.
I know i can resolve this with condition and unset token option as advised by one of my good friend . But I'm unable to achieve it.
can someone please help me with a example or sample code for it ..
code provided below is sample code .
<form>
<label>shankar cell level drill down search by frn</label>
<row>
<panel>
<table>
<search>
<query>index="_internal" sourcetype="splunkd" log_level!="INFO"
| bin span=1h _time
| stats count by _time log_level component</query>
<earliest>-24h@h</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>
<drilldown>
<set token="log_level">$row.log_level$</set>
<set token="component">$row.component$</set>
<set token="count">$row.count$</set>
</drilldown>
</table>
</panel>
</row>
<row>
<panel>
<title>$component$ Summary</title>
<input type="checkbox" token="tokReset" searchWhenChanged="true">
<label></label>
<change>
<unset token="log_level"></unset>
<unset token="form.tokReset"></unset>
</change>
<choice value="hide">Hide Details</choice>
<delimiter> </delimiter>
</input>
<table depends="$log_level$,$component$">
<search>
<query>
index="_internal" sourcetype="splunkd" log_level!="INFO"
| bin span=1h _time
| where log_level="$log_level$" AND component ="$component$"
| stats count by _time log_level component
| table log_level component _time count
</query>
<earliest>-24h@h</earliest>
<latest>now</latest>
</search>
<option name="count">10</option>
<option name="dataOverlayMode">none</option>
<option name="drilldown">cell</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>
<drilldown>
<link target="_blank">
</link>
</drilldown>
</table>
</panel>
</row>
<row>
<panel>
<title>$log_level$ Summary</title>
<table depends="$log_level$">
<search>
<query>
index="_internal" sourcetype="splunkd" log_level!="INFO"
| bin span=1h _time
| where log_level="$log_level$"
| stats count by _time log_level component
| table log_level component _time count
</query>
<earliest>-24h@h</earliest>
<latest>now</latest>
</search>
<option name="count">10</option>
<option name="dataOverlayMode">none</option>
<option name="drilldown">cell</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>
<drilldown>
<link target="_blank">
</link>
</drilldown>
</table>
</panel>
</row>
</form>
Thanks in advance
Hi ,
Are you looking for something like this? I removed extra check box and added drilldown in detailed table itself to hide - click on detailed table to hide it.
<form>
<label>shankar cell level drill down search by frn</label>
<fieldset submitButton="false"></fieldset>
<row>
<panel>
<table>
<search>
<query>index="_internal" sourcetype="splunkd" log_level!="INFO"
| bin span=1h _time
| stats count by _time log_level component</query>
<earliest>-15m</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="refresh.display">progressbar</option>
<option name="rowNumbers">false</option>
<option name="totalsRow">false</option>
<option name="wrap">true</option>
<drilldown>
<condition field="log_level">
<set token="log_depend">true</set>
<set token="log_level">$row.log_level$</set>
<set token="component">$row.component$</set>
<unset token="component_depend"></unset>
</condition>
<condition field="component">
<set token="component">$row.component$</set>
<set token="component_depend">true</set>
<set token="log_level">$row.log_level$</set>
<unset token="log_depend"></unset>
</condition>
</drilldown>
</table>
</panel>
</row>
<row>
<panel>
<title>Component $component$ Summary</title>
<table depends="$component_depend$">
<search>
<query>
index="_internal" sourcetype="splunkd" log_level!="INFO"
| bin span=1h _time
| where log_level="$log_level$" AND component ="$component$"
| stats count by _time log_level component
| table log_level component _time count
</query>
<earliest>-24h@h</earliest>
<latest>now</latest>
</search>
<option name="count">10</option>
<option name="dataOverlayMode">none</option>
<option name="drilldown">cell</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>
<drilldown>
<unset token="component_depend"></unset>
</drilldown>
</table>
</panel>
</row>
<row>
<panel>
<title>Log Level $log_level$ Summary</title>
<table depends="$log_depend$">
<search>
<query>
index="_internal" sourcetype="splunkd" log_level!="INFO"
| bin span=1h _time
| where log_level="$log_level$"
| stats count by _time log_level component
| table log_level component _time count
</query>
<earliest>-24h@h</earliest>
<latest>now</latest>
</search>
<option name="count">10</option>
<option name="dataOverlayMode">none</option>
<option name="drilldown">cell</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>
<drilldown>
<unset token="log_depend"></unset>
</drilldown>
</table>
</panel>
</row>
</form>
Hi ,
Are you looking for something like this? I removed extra check box and added drilldown in detailed table itself to hide - click on detailed table to hide it.
<form>
<label>shankar cell level drill down search by frn</label>
<fieldset submitButton="false"></fieldset>
<row>
<panel>
<table>
<search>
<query>index="_internal" sourcetype="splunkd" log_level!="INFO"
| bin span=1h _time
| stats count by _time log_level component</query>
<earliest>-15m</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="refresh.display">progressbar</option>
<option name="rowNumbers">false</option>
<option name="totalsRow">false</option>
<option name="wrap">true</option>
<drilldown>
<condition field="log_level">
<set token="log_depend">true</set>
<set token="log_level">$row.log_level$</set>
<set token="component">$row.component$</set>
<unset token="component_depend"></unset>
</condition>
<condition field="component">
<set token="component">$row.component$</set>
<set token="component_depend">true</set>
<set token="log_level">$row.log_level$</set>
<unset token="log_depend"></unset>
</condition>
</drilldown>
</table>
</panel>
</row>
<row>
<panel>
<title>Component $component$ Summary</title>
<table depends="$component_depend$">
<search>
<query>
index="_internal" sourcetype="splunkd" log_level!="INFO"
| bin span=1h _time
| where log_level="$log_level$" AND component ="$component$"
| stats count by _time log_level component
| table log_level component _time count
</query>
<earliest>-24h@h</earliest>
<latest>now</latest>
</search>
<option name="count">10</option>
<option name="dataOverlayMode">none</option>
<option name="drilldown">cell</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>
<drilldown>
<unset token="component_depend"></unset>
</drilldown>
</table>
</panel>
</row>
<row>
<panel>
<title>Log Level $log_level$ Summary</title>
<table depends="$log_depend$">
<search>
<query>
index="_internal" sourcetype="splunkd" log_level!="INFO"
| bin span=1h _time
| where log_level="$log_level$"
| stats count by _time log_level component
| table log_level component _time count
</query>
<earliest>-24h@h</earliest>
<latest>now</latest>
</search>
<option name="count">10</option>
<option name="dataOverlayMode">none</option>
<option name="drilldown">cell</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>
<drilldown>
<unset token="log_depend"></unset>
</drilldown>
</table>
</panel>
</row>
</form>
@renjith.nair Thank you very much for your response :-).. Yes i expect this one ..
I need to add one more column in the drilldown option. How to achieve it ..
I need help in achieving it ..
If i need to go with two more column filter in same drill down how can i achieve it ..
<form>
<label>shankar cell level drill down search by frn</label>
<fieldset submitButton="false"></fieldset>
<row>
<panel>
<table>
<search>
<query>index="_internal" sourcetype="splunkd" log_level!="INFO"
| bin span=1h _time
| stats count by _time log_level component</query>
<earliest>-15m</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="refresh.display">progressbar</option>
<option name="rowNumbers">false</option>
<option name="totalsRow">false</option>
<option name="wrap">true</option>
<drilldown>
<condition field="log_level">
<set token="log_depend">true</set>
<set token="log_level">$row.log_level$</set>
<set token="component">$row.component$</set>
<unset token="component_depend"></unset>
</condition>
<condition field="component">
<set token="component">$row.component$</set>
<set token="component_depend">true</set>
<set token="log_level">$row.log_level$</set>
<unset token="log_depend"></unset>
</condition>
<condition field="_time">
<set token="_time">$row._time$</set>
<set token="tracktime">true</set>
<set token="log_level">$row.log_level$</set>
<unset token="log_depend"></unset>
</condition>
</drilldown>
</drilldown>
</table>
</panel>
</row>
<row>
<panel>
<title>$_time$ Summary</title>
<table depends="$tracktime$">
<search>
<query>
index="_internal" sourcetype="splunkd" log_level!="INFO"
| bin span=1h _time
| where log_level="$log_level$" AND _time ="$_time$"
| stats count by _time log_level component
| table log_level component _time count
</query>
<earliest>-24h@h</earliest>
<latest>now</latest>
</search>
<option name="count">10</option>
<option name="dataOverlayMode">none</option>
<option name="drilldown">cell</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>
<drilldown>
<unset token="tracktime"></unset>
</drilldown>
</table>
</panel>
</row>
<row>
<panel>
<title>Component $component$ Summary</title>
<table depends="$component_depend$">
<search>
<query>
index="_internal" sourcetype="splunkd" log_level!="INFO"
| bin span=1h _time
| where log_level="$log_level$" AND component ="$component$"
| stats count by _time log_level component
| table log_level component _time count
</query>
<earliest>-24h@h</earliest>
<latest>now</latest>
</search>
<option name="count">10</option>
<option name="dataOverlayMode">none</option>
<option name="drilldown">cell</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>
<drilldown>
<unset token="component_depend"></unset>
</drilldown>
</table>
</panel>
</row>
<row>
<panel>
<title>Log Level $log_level$ Summary</title>
<table depends="$log_depend$">
<search>
<query>
index="_internal" sourcetype="splunkd" log_level!="INFO"
| bin span=1h _time
| where log_level="$log_level$"
| stats count by _time log_level component
| table log_level component _time count
</query>
<earliest>-24h@h</earliest>
<latest>now</latest>
</search>
<option name="count">10</option>
<option name="dataOverlayMode">none</option>
<option name="drilldown">cell</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>
<drilldown>
<unset token="log_depend"></unset>
</drilldown>
</table>
</panel>
</row>
</form>
Are you looking for something similar? If not just mention which token should go where
<form>
<label>shankar cell level drill down search by frn</label>
<fieldset submitButton="false"></fieldset>
<row>
<panel>
<table>
<search>
<query>index="_internal" sourcetype="splunkd" log_level!="INFO"
| bin span=1h _time
| stats count by _time log_level component</query>
<earliest>-24h</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="refresh.display">progressbar</option>
<option name="rowNumbers">false</option>
<option name="totalsRow">false</option>
<option name="wrap">true</option>
<drilldown>
<condition field="log_level">
<set token="log_depend">true</set>
<set token="log_level">$row.log_level$</set>
<set token="component">$row.component$</set>
<unset token="component_depend"></unset>
<unset token="tracktime"></unset>
</condition>
<condition field="component">
<set token="component">$row.component$</set>
<set token="component_depend">true</set>
<set token="log_level">$row.log_level$</set>
<unset token="log_depend"></unset>
<unset token="tracktime"></unset>
</condition>
<condition field="_time">
<set token="time">$row._time$</set>
<set token="tracktime">true</set>
<set token="log_level">$row.log_level$</set>
<unset token="log_depend"></unset>
<unset token="component_depend"></unset>
</condition>
</drilldown>
</table>
</panel>
</row>
<row>
<panel>
<title>$time$ Summary</title>
<table depends="$tracktime$">
<search>
<query>
index="_internal" sourcetype="splunkd" log_level!="INFO"
| bin span=1h _time
| where log_level="$log_level$" AND _time =strptime("$time$","%Y-%m-%dT%H:%M:%S.%3N%:z")
| stats count by _time log_level component
| table log_level component _time count
</query>
<earliest>-24h@h</earliest>
<latest>now</latest>
</search>
<option name="count">10</option>
<option name="dataOverlayMode">none</option>
<option name="drilldown">cell</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>
<drilldown>
<unset token="tracktime"></unset>
</drilldown>
</table>
</panel>
</row>
<row>
<panel>
<title>Component $component$ Summary</title>
<table depends="$component_depend$">
<search>
<query>
index="_internal" sourcetype="splunkd" log_level!="INFO"
| bin span=1h _time
| where log_level="$log_level$" AND component ="$component$"
| stats count by _time log_level component
| table log_level component _time count
</query>
<earliest>-24h@h</earliest>
<latest>now</latest>
</search>
<option name="count">10</option>
<option name="dataOverlayMode">none</option>
<option name="drilldown">cell</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>
<drilldown>
<unset token="component_depend"></unset>
</drilldown>
</table>
</panel>
</row>
<row>
<panel>
<title>Log Level $log_level$ Summary</title>
<table depends="$log_depend$">
<search>
<query>
index="_internal" sourcetype="splunkd" log_level!="INFO"
| bin span=1h _time
| where log_level="$log_level$"
| stats count by _time log_level component
| table log_level component _time count
</query>
<earliest>-24h@h</earliest>
<latest>now</latest>
</search>
<option name="count">10</option>
<option name="dataOverlayMode">none</option>
<option name="drilldown">cell</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>
<drilldown>
<unset token="log_depend"></unset>
</drilldown>
</table>
</panel>
</row>
</form>
@ renjith.nair -- Thank you very much for your detail explanation 🙂 ..
Yes i got what i needed ..