Dashboards & Visualizations

index not working

Keerthi
Path Finder

Keerthi_0-1703070143786.png

Hi, i recently changes a SQL query in Splunk db connect to one of the dashboard. the query ran but i don't see the dashboard getting reflected to new data. as i was checking i see the index did not refresh after the new query is implemented. The last event of the index remians the day i changed the query. the new query had two new columns but i dont see it getting reflected. can anyone please help me with this. Its bit urgent !!!!!!!!!

Labels (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Try changing it back to how it was

0 Karma

Keerthi
Path Finder

you mean the SQL query?

 

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

If that's all you changed, then yes

0 Karma

Keerthi
Path Finder

ok but i have new columns to be added. if i do so the index stops working. so the data is not forwarding to the indexing.  is there nay option to run my index again?

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Please explain your full process as you haven't really provided sufficient information to determine what you are doing, what you changed, what your results were before the change, etc.

0 Karma

Keerthi
Path Finder

so initially my source is a SQL based query. i had modified my query by adding 2 new columns. so i ran my source. the dashboard has 2 reports which is linked to index and source (sql query).Their events are showing 0 from past 6 days. i ran this command
|index=<index name> it shows 0 event.

Keerthi_0-1703074763525.png

 

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Please provide more details about how the index is updated.

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...