You’re offline. This is a read only version of the page.
645
I have shared views and dashboards and I need to know who are the users who these views and dashboards shared with using SQL, how do I do that? what is the name of the column this data is saved in.
Refer this C# Code for more clarity about share object in Dynamic CRM.
vjcity.blogspot.com/.../how-to-migrate-personal-views-dashboard.html
Refer and follow Blog : https://vjcity.blogspot.com/
Get Latest updates of Dynamic CRM from Group : www.facebook.com/.../
Please mark answer correct if you are happy
Hi,
Refer these tables to know what objects are being shared.
QueryExpression userSavedQueries = new QueryExpression("userquery") { ColumnSet = new ColumnSet() { AllColumns = true }, NoLock = true }; // Personal Views
QueryExpression query1 = new QueryExpression("userqueryvisualization") { ColumnSet = new ColumnSet() { AllColumns = true }, NoLock = true }; // Personal Charts
QueryExpression query2 = new QueryExpression("userform") { ColumnSet = new ColumnSet() { AllColumns = true }, NoLock = true }; // Personal Dashboard
Make a Inner Join with systemuser table to get the user details.
I created a C# Console App to migrate these object to another environment, as OOB was not supported for some reasons.
Refer and follow Blog : https://vjcity.blogspot.com/
Get Latest updates of Dynamic CRM from Group : https://www.facebook.com/groups/554941725236365/
Please refer below url for your reference:
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (