Dashboards & Visualizations

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

mvasquez21
Path Finder

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!

Splunk Decoded: Service Maps vs Service Analyzer Tree View vs Flow Maps

It’s Monday morning, and your phone is buzzing with alert escalations – your customer-facing portal is running ...

What’s New in Splunk Observability – September 2025

What's NewWe are excited to announce the latest enhancements to Splunk Observability, designed to help ITOps ...

Fun with Regular Expression - multiples of nine

Fun with Regular Expression - multiples of nineThis challenge was first posted on Slack #regex channel ...