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.
Re: SQL for dashboards/portlets/datasource for 6.0
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