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]



Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.