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!

More Ways To Control Your Costs With Archived Metrics | Register for Tech Talk

Tuesday, May 14, 2024  |  11AM PT / 2PM ET Register to Attend Join us for this Tech Talk and learn how to ...

.conf24 | Personalize your .conf experience with Learning Paths!

Personalize your .conf24 Experience Learning paths allow you to level up your skill sets and dive deeper ...

Threat Hunting Unlocked: How to Uplevel Your Threat Hunting With the PEAK Framework ...

WATCH NOWAs AI starts tackling low level alerts, it's more critical than ever to uplevel your threat hunting ...