Query to get all the Entity and Entity Field Name in Dynamics crm onpremisis

Query to get all the Entity and Entity Field Name in Dynamics crm onpremisis

USE Contoso_MSCRM
GO

SELECT  EntityView.Name AS EntityName, LocalizedLabelView_1.Label AS EntityDisplayName,
       AttributeView.Name AS AttributeName, LocalizedLabelView_2.Label AS AttributeDisplayName
FROM    LocalizedLabelView AS LocalizedLabelView_2 INNER JOIN
       AttributeView ON LocalizedLabelView_2.ObjectId = AttributeView.AttributeId RIGHT OUTER JOIN
       EntityView INNER JOIN
       LocalizedLabelView AS LocalizedLabelView_1 ON EntityView.EntityId = LocalizedLabelView_1.ObjectId ON
       AttributeView.EntityId = EntityView.EntityId
WHERE   LocalizedLabelView_1.ObjectColumnName = 'LocalizedName'
 AND LocalizedLabelView_2.ObjectColumnName = 'DisplayName'
 AND LocalizedLabelView_1.LanguageId = '1033'
 AND LocalizedLabelView_2.LanguageId = '1033'
 AND EntityView.Name IN ('Account','Contact') //comment this to get all entity 
ORDER BY EntityName, AttributeName

SQL Query to get the List of customized Entity in Dynamics CRM

SQL Query to get the List of customized Entity in Dynamics CRM onpremisis



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 EV.NAME NOT LIKE '%MSDYN%' -- Add this if you want to remove like post album, filter, etc
ORDER BY 2