Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 607
  • 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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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