UNVERIFIED SOLUTION i

How to find out how often the Dashboards and widgets are used in Confirm

There are two bits of SQL below which can be set up as Data Sources (adding a Linked Table or two would make it easy to drill down into the Widget or Dashboard from one of them).

This first SQL will list Dashboard Widgets and how many Dashboards each appears on. So where the "number of dashboards" is 0, a Widget is not currently used. Where a Widget is used, one of the Dashboard Keys and Names is shown too.

SELECT
   dash_widget.dash_widget_key,
   dash_widget.dash_widget_name,
   ( SELECT COUNT( dash_widget_grid.dash_widget_key) FROM dash_widget_grid
      WHERE dash_widget.dash_widget_key = dash_widget_grid.dash_widget_key) as number_of_dashboards,
   ( SELECT MAX( dash_widget_grid.dash_key) FROM dash_widget_grid, dashboard
      WHERE dash_widget.dash_widget_key = dash_widget_grid.dash_widget_key
AND dashboard.dash_key = dash_widget_grid.dash_key) as dash_key,
   ( SELECT MAX( dashboard.dash_name) FROM dash_widget_grid, dashboard
      WHERE dash_widget.dash_widget_key = dash_widget_grid.dash_widget_key
AND dashboard.dash_key = dash_widget_grid.dash_key) as dash_name
FROM
   dash_widget

This second SQL will list Dashboards and how many Users have each as their default Dashboard. So where the "number of users" is 0, a Widget is not currently used (since a User may switch Dashboards freely, this does not guarantee it is never used). Where a Dashboard is referenced, one of the User login names is shown too.

SELECT
   dashboard.dash_key,
   dashboard.dash_name,
   ( SELECT COUNT( user_setting.login_name) FROM user_setting
      WHERE user_setting.setting_id = 'DEFAULTDASHBOARD'
        AND user_setting.setting_value = TO_CHAR( dashboard.dash_key)) as number_of_users,
   ( SELECT MAX( user_setting.login_name) FROM user_setting
      WHERE user_setting.setting_id = 'DEFAULTDASHBOARD'
        AND user_setting.setting_value = TO_CHAR( dashboard.dash_key)) as login_name
FROM
   dashboard

Note the first bit of SQL works for Oracle and SQL Server - the second uses a TO_CHAR so is Oracle specific, SQL Server version would need to be slightly modified.

 
UPDATED:  November 23, 2017