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
Get Updates on the Splunk Community!

Monitoring MariaDB and MySQL

In a previous post, we explored monitoring PostgreSQL and general best practices around which metrics to ...

Financial Services Industry Use Cases, ITSI Best Practices, and More New Articles ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Splunk Federated Analytics for Amazon Security Lake

Thursday, November 21, 2024  |  11AM PT / 2PM ET Register Now Join our session to see the technical ...