Project and Portfolio Management Practitioners Forum
cancel

SQL for dashboards/portlets/datasource for 6.0

Highlighted
Tracy Crawford
Regular Contributor.

SQL for dashboards/portlets/datasource for 6.0

Hi, does anyone have a query to find what portlets are on a dashboard and/or what the datasource is for the portlet? Or, if you can tell me which tables contain dashboards, modules, portlets, and datasources.

Thanks!
1 REPLY
Claudio Stöckli
Contributor.

Re: SQL for dashboards/portlets/datasource for 6.0

Hi Tracy

You'll find all the information about the tables in the 'Mercury IT Governance Technical Reference Manual' for 6.0. Some of the tables you will probably need are:
DSH_MODULES
DSH_PAGES
DSH_PORTLETS
DSH_PORTLET_DEFS
KDSH_DATA_SOURCES

Regards,
Claudio