Forum Discussion

daniel_guerra's avatar
daniel_guerra
Data Storage
06-21-2023

Get all data models (ECs and live) used in a dashboard, for all dashboards

Hello, community!! We are wondering if there is a way we can extract all the data sources in a dashboard, for all dashboards... The goal is to cleanse all those orphan data models. (Not related t...
Elasticube
On cloud
HamzaJ's avatar
HamzaJ
Data Integration
06-22-2023

Hey daniel_guerra 

As an admin you could use the rest-api to get this info. Log in and go to the following URL:

https://XXXX/api/v1/dashboards/admin?dashboardType=owner&asObject=false&fields=_id%2Coid%2Ctitle%2Cdatasource.title

This will generate a JSON of all dashboards with their ID, title and datasource. Import this into Excel and you will have a nice overview. 

If you have a lot of dashboards in your system, you could also use SKIP and LIMIT to page through them. Go to Admin > RESTAPI > V1 > Admin > Get all dashboards

Hamza