ttajic
5/6/2016 - 9:44 AM

Get All Entities and Attributes in CRM solution

Get All Entities and Attributes in CRM solution

getallentitiyattributes.sql
content_copyfile_download
select 
       en.logicalname as 'EntityName', 
       av.logicalname as 'AttributeName' 
from attributeview as av
left join entityview en on av.entityid = en.entityid
left join solutioncomponent as sc on av.entityid = sc.objectid
where sc.solutionidName='CRMConnector'