Announcements in Dynamics CRM are used to broadcast the important news to all the system users in an Organization.
Run the below query to get all the users details under all the Teams available in CRMS.
Team.name [Team Name],
SysUser.Fullname [User Name],
SysUser.mobilephone [Mobile Phone],
SysUser.internalemailaddress [Primary Email]
on SysUser.Systemuserid = TeamMem.Systemuserid
Inner join dbo.FilteredTeam Team
on Team.TeamID = TeamMem.TeamID
–where Team.name in –Uncomment this where condition to specify the required Team names
order by Team.NAME
Got the below error, while updating the Merged plugin dll in SIT environment.
Started comparing the differences between Dev and SIT environments by navigating to
Microsoft Dynamics CRM -> Settings -> Customization -> Customize the System -> Plug-in Assemblies.
Clicked on the required Plug-in Assembly and started comparing the number of plug-in class files in it.
Found that, in the SIT environment have extra plug-in class files, which were imported in the beginning of the project and which were not present now in the updated Merged Plug-in Assembly Dll (Removed as per client requirement from the Dev code).
Finally, deleted those files manually in the SIT environment by connecting to the Plugin Registration tool and unregistered them.
Updated the required plugin assembly in SIT. It worked and issue resolved :):):)
Use the below query to get all the list of Entities Display Name, Logical Name and Object Type Code.
SELECT DISPLAYNAME.LABEL 'Display Name', EV.NAME 'Logical Name', ObjectTypeCode 'Object Type Code' FROM ENTITYVIEW EV INNER JOIN LOCALIZEDLABELLOGICALVIEW DISPLAYNAME ON (EV.ENTITYID = DISPLAYNAME.OBJECTID) AND (DISPLAYNAME.OBJECTCOLUMNNAME = 'LOCALIZEDNAME') WHERE LANGUAGEID = 1033 -- Add this if you want to filter records using language Id. For Example : LANGUAGEID 1033 is English --AND ISCUSTOMENTITY = 1 -- Remove this if you want to show the system entities as well --AND ISACTIVITY = 0 -- Add this if you want to filter out the activity entity --AND EN.NAME NOT LIKE '%MSDYN%' -- Add this if you want to remove like post album, filter, etc ORDER BY 1
Follow the below steps to get the volume of Tables,
Step 1: Open MSCRM SQL Database.
Step 2: Under Databases, select the required <CRM_Org_Name>_MSCRM database. Right click on it and click on Reports -> Standard Reports -> Disk Usage by Table.
Step 3: Disk Usage by Table report will be displayed as shown below.
Other way to do the same is,
Step 1: Select the required MSCRM database. Click on F7 or View -> Object Explorer Details.
Step 2: Object Explorer will be opened in a new window. Right click on the header to select the required data columns to be displayed as shown below.
Hope you got the results successfully :):):)
Follow the below steps to Install/ Uninstall Sample Data from Dynamics 365 CRM Online,
Step 1: Open Dynamics 365 Online. Goto Settings -> Data Management and click on Sample Data.
Step 2: If you have not installed any Sample Data earlier, it will show Sample Data button. Click on it to import sample data given by CRM OOB.
Step 3: After clicking on it, Goto Imports under Data Management to see the Sample Data import records Status.
Step 4: Once all the records Status Reason change to Completed, we can Sample records in the Entities Specified in the Import Name.
For an Instance, below is the Contacts Sample Data imported during this operation,
Step 5: If you want to Uninstall the same data imported during this operation, Goto Settings -> Data Management and click on Sample Data.
Then click on Remove Sample Data button.
Step 6: Records deletion status can be seen under Settings -> Data Management -> Bulk Record Deletion.
Hope you learned this feature in CRM :):):)