https://community.splunk.com/t5/Dashboards-Visualizations/dbquery-not-work-in-dashboard/m-p/117919#M6827 <P>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<BR /> <DASHBOARD><BR /> <LABEL>database center</LABEL><BR /> <DESCRIPTION></DESCRIPTION><BR /> <ROW><BR /> <CHART><BR /> <TITLE>data buffer</TITLE><BR /> <SEARCHSTRING>| 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'"</SEARCHSTRING><BR /> <EARLIESTTIME>0</EARLIESTTIME><BR /> <LATESTTIME>now</LATESTTIME><BR /> true<BR /> false<BR /> none<BR /> row<BR /> 10<BR /> visible<BR /> visible<BR /> linear<BR /> linear<BR /> radialGauge<BR /> gaps<BR /> 0.01<BR /> default<BR /> shiny<BR /> all<BR /> 0<BR /> ellipsisMiddle<BR /> right<BR /> </CHART><BR /> </ROW><BR /> </DASHBOARD></P> Fri, 17 Jan 2014 07:16:06 GMT coope84 2014-01-17T07:16:06Z https://community.splunk.com/t5/Dashboards-Visualizations/dbquery-not-work-in-dashboard/m-p/117919#M6827 <P>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<BR /> <DASHBOARD><BR /> <LABEL>database center</LABEL><BR /> <DESCRIPTION></DESCRIPTION><BR /> <ROW><BR /> <CHART><BR /> <TITLE>data buffer</TITLE><BR /> <SEARCHSTRING>| 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'"</SEARCHSTRING><BR /> <EARLIESTTIME>0</EARLIESTTIME><BR /> <LATESTTIME>now</LATESTTIME><BR /> true<BR /> false<BR /> none<BR /> row<BR /> 10<BR /> visible<BR /> visible<BR /> linear<BR /> linear<BR /> radialGauge<BR /> gaps<BR /> 0.01<BR /> default<BR /> shiny<BR /> all<BR /> 0<BR /> ellipsisMiddle<BR /> right<BR /> </CHART><BR /> </ROW><BR /> </DASHBOARD></P> Fri, 17 Jan 2014 07:16:06 GMT https://community.splunk.com/t5/Dashboards-Visualizations/dbquery-not-work-in-dashboard/m-p/117919#M6827 coope84 2014-01-17T07:16:06Z https://community.splunk.com/t5/Dashboards-Visualizations/dbquery-not-work-in-dashboard/m-p/117920#M6828 <P>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.</P> Fri, 17 Jan 2014 08:19:28 GMT https://community.splunk.com/t5/Dashboards-Visualizations/dbquery-not-work-in-dashboard/m-p/117920#M6828 martin_mueller 2014-01-17T08:19:28Z