All Apps and Add-ons
Highlighted

In DBXquery nothing come in visualization tab.

Path Finder

alt text
Hi Experts,

I want to create a pie chart , but in my dbxquery output come in statistics tab, and nothing come in visualization tab.
For fix it what I need to do ?

my search string is :

| dbxquery query="SELECT username , sum(memorykb) as memorykb from ( SELECT NVL(a.username,'(oracle)') AS username, a.module, a.program, Trunc(b.value/1024) AS memory_kb FROM v$session a, v$sesstat b, v$statname c WHERE a.sid = b.sid AND b.statistic# = c.statistic# AND c.name = 'session pga memory' AND a.program IS NOT NULL) group by username " connection="SplunkReadOnly"

0 Karma
Highlighted

Re: In DBXquery nothing come in visualization tab.

Legend

@arunkantsharma, since you are showing a pie chart visualization, you should ensure that dbxquery returns two fields First should be Label field for name of each slice. Second should be the value of each pie slice.

Following is the run anywhere search which you can try out as an example:

index=_internal sourcetype=splunkd
| top log_level



| eval message="Happy Splunking!!!"


0 Karma