maj 31 blog

Need to lookup the used entities and attributes in a CRM 2011 solution?

Use the sql script below to lookup the attributes you have in your solution (is only working with direct SQL access):

SELECT
	Solution.solutionid,
	Solution.uniquename,
	Solution.version,
	EntityView.EntityId,
	EntityView.Name,
	EntityView.ObjectTypeCode,
	AttributeLogicalView.AttributeId,
AttributeLogicalView.Name AS AttributeName
FROM
	AttributeLogicalView RIGHT OUTER JOIN
EntityView ON AttributeLogicalView.EntityId = EntityView.EntityId RIGHT OUTER JOIN
Solution ON EntityView.SolutionId = Solution.solutionid
WHERE
	Solution.solutionid = '43A97910-078C-4CF1-B753-94C92B67C98D'

Just replace the solutionid GUID with the needed one

Share on FacebookTweet about this on TwitterShare on LinkedInShare on Google+