Dashboards & Visualizations

Receiving "Error in 'TsidxStats': WHERE clause is not an exact query" in Cisco Networks app

mvasquez21
Explorer

I recently upgraded my Cisco Networks App from 2.3.4 to 2.5.7 but now all the dashboards are getting this error in historical mode. Here is the query from one of the modules:
| tstats values(nodename) AS nodename count FROM datamodel=Cisco_IOS_Event WHERE Cisco_IOS_Event.product IN (IOS) Cisco_IOS_Event.index IN (*) BY host Cisco_IOS_Event.index | rename Cisco_IOS_Event.index AS index | search nodename=Cisco_IOS_Event | stats sum(count)

0 Karma

begleyj1
Path Finder

Some suggestions:

  • removing the Cisco_IOS_Event.index IN (*). Change this to Cisco_IOS_Event.index=*.
  • Remove the nodename the search clause and leave it in the tstats. If your dataset is defaulted to Cisco_IOS_Event, then just leave it as so in the tstats clause:

from datamodel=Cisco_IOS_Event.Cisco_IOS_Event ...

0 Karma

blebit
Path Finder

anything new ?

0 Karma
Get Updates on the Splunk Community!

Take Your Breath Away with Splunk Risk-Based Alerting (RBA)

WATCH NOW!The Splunk Guide to Risk-Based Alerting is here to empower your SOC like never before. Join Haylee ...

SignalFlow: What? Why? How?

What is SignalFlow? Splunk Observability Cloud’s analytics engine, SignalFlow, opens up a world of in-depth ...

Federated Search for Amazon S3 | Key Use Cases to Streamline Compliance Workflows

Modern business operations are supported by data compliance. As regulations evolve, organizations must ...