Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 609
  • Last Modified:

CRM 2011 - Audit trail for entity creation.

Is there any audit trail available I can see who create  the entity not the entiry record.
0
tommym121
Asked:
tommym121
  • 2
  • 2
3 Solutions
 
Feridun KadirPrincipal ConsultantCommented:
I believe not. As you can see in this article: http://msdn.microsoft.com/en-us/library/gg309664.aspx
auditing of metadate changes (which is what creating an entity is) is not supported.
0
 
tommym121Author Commented:
I am trying to find out who create a particular custom entity.  
Can we go direct to the SQL server to find out.
0
 
Chinmay PatelEnterprise ArchitectCommented:
Hi tommym121,

I feel you just want to figure out who created this entity then

Try this SQL statement
select dbo.systemuser.DomainName from dbo.EntityMapBase, dbo.SystemUser
 WHERE TargetEntityName like 'entityname'

Open in new window


Regards,
Chinmay.
0
 
Chinmay PatelEnterprise ArchitectCommented:
Please note that the SQL given above is a workaround, you will have to study the results to findout who created this entity.
0
 
tommym121Author Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now