Dashboard creation with a query

Elastic Stack Kibana
1

Hi Team,
Could you please let me know how to create a dashboard using a query. I have a query, i am supposed to create a dashboard.
Query:
select type_cd,status_cd, count(row_id) from siebel.s_loy_txn
where TXN_DT >= (sysdate-1) and
type_cd = 'Accrual'
group by type_cd,status_cd;

2

Hi @Haneesha,

Welcome to the community! Kibana dashboards are created using the UI rather than a specific query. I would check out the below sections of the query to create your first dashboard:

  1. Create your first dashboard
  2. Create custom tables

When creating visualization panels for your dashboard you can see what query is being sent to Elastic using the Inspect option:

image
image2538×1740 509 KB

Hope that helps.

3

Hi Carly,
Actually i have created multiple dashboards previously. But now instead of the log annotations which we generally use for creating a dashboard through GUI, now we have a query. Our requirement is to create a new dashboard for the query i mentioned. What should be our step to proceed. Means should we create any new conf.d file and then parse and then get logs to kibana once and then create a dashboard or what?. Could you please help.

4

Hi @Haneesha,

It sounds like you are using Logstash to ingest data and then build your own dashboards. Is that correct? Can you explain a bit more about what source of logs you're trying to ingest and create a dashboard over?

5

Yes Carly.You are right. We are using filebeat, logstash, Elasticsearch and kibana. But now I just got a mail with this mentioned query saying they need dashboard for that query. Usually i create dashboard with the data already present in kibana( discover tab in GUI) . If the data is present in discover, i will just create visualisation and then dashboard. If it is not present, we will parse the data and all those grok, conf file creation follows. Then we will make dashboard. But using query i never created and in my team there is no one right now who knows regarding this to proceed. So i request you to help if you know something.

6

Ok, where is this query pulling data from though? Since it's SQL, is it pulling from a DB?

7

Hi Carly,
Yes. It's from DB.

8

Ok, since you're familiar with Logstash, have you had a look at the JDBC input plugin to see if that fits with what you want to do and the DB that you're using? If you pull the data into Elasticsearch you can then build dashboards on top just like you do currently with your other sources.

9

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.