Splunk Search

Dashboard panels with shared base search stopped working...

unitedmarsupial
Path Finder

Some years ago I've created a (beautiful!) dashboard, with multiple panels, which presented related data at different angles. Some upgrades of the Splunk-server later (currently using Splunk Enterprise 9.1.5), all of the panels -- except for the one, that shows the raw results of the base search -- stopped working...

The common base-search is defined as:

 

<form version="1.1" theme="dark">
  <label>Curve Calibration Problems</label>
  <search id="common">
    <query>index=$mnemonic$
      AND sourcetype="FOO"
      ...
      | eval Curve=replace(Description, ".* curve ([^\(]+) \(.*", "\1")
    </query>
    <earliest>$range.earliest$</earliest>
    <latest>$range.latest$</latest>
  </search>

 

 And then the panels add to it like this, for one example:

 

    <panel>
      <title>Graph of count of errors for $mnemonic$</title>
      <chart>
        <search base="common">
          <query>top limit=50 Curve</query>
        </search>
     ...

 

Note, how the base search's ID is "common", which is exactly the value referred to as base.

Again, the base search itself works correctly. But, when I attempt to edit the panel now, the search-expression is shown only as just that query, that used to be added to the base:

unitedmarsupial_0-1729788449827.png

If I click on the "Run Search" link in the above window, I see, that, indeed, only that expression is searched for, predictably yielding no results.

It seems like something has changed in Splunk, how do I restore this dashboard to working order?

Labels (2)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Try adding a table command to your base search listing the fields you want to be used in your subsequent panels.

unitedmarsupial
Path Finder

@ITWhisperer wrote:

Try adding a table command to your base search listing the fields you want to be used in your subsequent panels.


Yes, adding "| table *" to the base-search expression, restored the panels. Could someone explain, why this quietly became necessary?

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Looking back through the documentation, back to 7.0.0 which is as far back as I can find, it has been recommended that base searches are transforming searches

https://docs.splunk.com/Documentation/Splunk/7.0.0/Viz/Savedsearches#Post-process_searches_2

 

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Take Action Automatically on Splunk Alerts with Red Hat Ansible Automation Platform

 Are you ready to revolutionize your IT operations? As digital transformation accelerates, the demand for ...

Calling All Security Pros: Ready to Race Through Boston?

Hey Splunkers, .conf25 is heading to Boston and we’re kicking things off with something bold, competitive, and ...

Beyond Detection: How Splunk and Cisco Integrated Security Platforms Transform ...

Financial services organizations face an impossible equation: maintain 99.9% uptime for mission-critical ...