We need a report from pa_dashboards that dashboards are not using pa widgets

[SivakumarG]

We are planning to migrate existing performance dashboards to platform analytics dashboards in the phase1 and phase 2

In phase 1 - Planning to migrate the dashboards which are not using PA widgets. 

For this, we need to prepare the list of dashboards need to migrate in phase 1 but we are unable to fetch it through script/reports/list view. Please share the details if anyone knows it.

[Ankur Bawiskar]

@SivakumarG 

you can check these tables and relationship between them and find

tables involved - pa_dashboards,pa_tabs,pa_widgets, pa_m2m_dashboard_tabs

Is there a way to find user created dashboards that are empty (no widgets)? 

Is there a way to see where PA widgets are being used? (ex: what dashboards) 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[SivakumarG]

Hi Ankur,

I have tried with all these tables -  pa_dashboards,pa_tabs,pa_widgets, pa_m2m_dashboard_tabs

I don't see any links with widgets and dashboard in these tables.

Thanks,

Sivakumar

[Ankur Bawiskar]

@SivakumarG 

did you check links above?

[SivakumarG]

Hi Ankur,

Links above doesn't help me. I am using Yokohama version.

Thanks,

Sivakumar