CRM2015: Where are the users personal dashboards, charts and views stored in the DB?

Currently working with a customer that has a shared user dashboard that we are unable to see who it is owned by. What makes matters worse is that the users its likely to have been owned by have been removed previously!

Below outlines the locations of the personal views, charts and dashboards

--User Owned Dashboards
SELECT * FROM [MSGCRM_MSCRM].[dbo].[UserFormBase] 
--User Owned Views
SELECT * FROM [MSGCRM_MSCRM].[dbo].[UserQueryBase]
--User Owned Charts
SELECT * FROM [MSGCRM_MSCRM].[dbo].[UserQueryVisualizationBase]
-- System Charts 
SELECT * FROM [MSGCRM_MSCRM].[dbo].[SavedQueryVisualizationBase]

 

Tags

Leave a Reply

Your email address will not be published.