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!

Observability Unlocked: Kubernetes Monitoring with Splunk Observability Cloud

 Ready to master Kubernetes and cloud monitoring like the pros? Join Splunk’s Growth Engineering team for an ...

Update Your SOAR Apps for Python 3.13: What Community Developers Need to Know

To Community SOAR App Developers - we're reaching out with an important update regarding Python 3.9's ...

October Community Champions: A Shoutout to Our Contributors!

As October comes to a close, we want to take a moment to celebrate the people who make the Splunk Community ...