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 :):):)