Dashboards & Visualizations

dbquery not work in dashboard

coope84
New Member

hello, here is my query string: | dbquery dbcenter "select (1 - (phy.value / (cur.value + con.value))) *100 \"HIT RATIO\" from v$sysstat cur, v$sysstat con, v$sysstat phy where cur.name = 'db block gets' and con.name = 'consistent gets' and phy.name = 'physical reads'" ,It's worked in the search app,but I cannot see results when use dbquery in dashboard, here is my xml





data buffer
| dbquery dbcenter "select (1 - (phy.value / (cur.value + con.value))) *100 \"HIT RATIO\" from v$sysstat cur, v$sysstat con, v$sysstat phy where cur.name = 'db block gets' and con.name = 'consistent gets' and phy.name = 'physical reads'"
0
now
true
false
none
row
10
visible
visible
linear
linear
radialGauge
gaps
0.01
default
shiny
all
0
ellipsisMiddle
right


Tags (3)
0 Karma

martin_mueller
SplunkTrust
SplunkTrust

Without grasping the entirety of your post due to bad formatting, I see single dollar signs in your query. Escape those with another dollar sign to get $$, to avoid Splunk trying to replace $foo$ tokens.

0 Karma
Get Updates on the Splunk Community!

CX Day is Coming!

Customer Experience (CX) Day is on October 7th!! We're so excited to bring back another day full of wonderful ...

Strengthen Your Future: A Look Back at Splunk 10 Innovations and .conf25 Highlights!

The Big One: Splunk 10 is Here!  The moment many of you have been waiting for has arrived! We are thrilled to ...

Now Offering the AI Assistant Usage Dashboard in Cloud Monitoring Console

Today, we’re excited to announce the release of a brand new AI assistant usage dashboard in Cloud Monitoring ...