VERIFIED SOLUTION i
X

How to use SQL to Identify a User's Default Dashboard in Confirm

UPDATED: July 20, 2017


Run this SQL against a Confirm Oracle or SQL Server database to identify a user's default Dashboard:

SELECT US.login_name
      ,US.setting_id
      ,US.setting_value
      ,DB.dash_name
FROM user_setting US, dashboard DB
  WHERE US.setting_id = 'DEFAULTDASHBOARD'
  AND US.login_name = '<Login Name Here>'
  AND US.setting_value = DB.dash_key

Environment Details

Product Feature: Application Infrastructure
                            Ad Hoc Reporting
 

Downloads

  • No Downloads