Answered by:
Audit trial in crm 2011 ?

Question
-
Hello,
Any one knows in sql, audit trial record stored in which table ?? and also can we add records in that table from sql....
- Edited by P_Mundra Friday, September 16, 2011 9:39 AM
Friday, September 16, 2011 9:37 AM
Answers
-
Hi,
If you are upgrading CRM 4.0 to CRM 2011 then you can create a new SSRS report to refer or leave the entity as is for referencing the old audit trail data, you can not back end update (can only retrieve RetrieveAuditDetailsRequest Members, RetrieveAttributeChangeHistoryRequest) the Audit History table via supported customization and making direct changes into the table could corrupt CRM database.
Jehanzeb Javeed
http://worldofdynamics.blogspot.com
Linked-In Profile |CodePlex Profile
If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".- Proposed as answer by Jehanzeb.Javeed Friday, September 16, 2011 12:51 PM
- Marked as answer by P_Mundra Monday, November 14, 2011 11:36 AM
Friday, September 16, 2011 12:50 PM
All replies
-
Hi,
There is AuditBase table for audit entity, but adding record in CRM table directly is not supported(not recommended)
for audit features refer http://www.avanadeblog.com/xrm/2010/09/crm-2011-feature-of-the-week-9132010-auditing.html
Mahain : MS CRM Freelancer
- Edited by HIMBAPModerator Friday, September 16, 2011 9:50 AM
- Proposed as answer by HIMBAPModerator Friday, September 16, 2011 9:50 AM
Friday, September 16, 2011 9:50 AMModerator -
Thanks for the information.
But suppose i m going for upgrade crm 4.0 to crm 2011......so my audit trial which was created in crm 4.0 is not upgrade in crm 2011......in that case what can i do ????
So that's y i m asking for backend update audit history table .......
- Edited by P_Mundra Friday, September 16, 2011 10:23 AM
Friday, September 16, 2011 10:18 AM -
Hi,
If you are upgrading CRM 4.0 to CRM 2011 then you can create a new SSRS report to refer or leave the entity as is for referencing the old audit trail data, you can not back end update (can only retrieve RetrieveAuditDetailsRequest Members, RetrieveAttributeChangeHistoryRequest) the Audit History table via supported customization and making direct changes into the table could corrupt CRM database.
Jehanzeb Javeed
http://worldofdynamics.blogspot.com
Linked-In Profile |CodePlex Profile
If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".- Proposed as answer by Jehanzeb.Javeed Friday, September 16, 2011 12:51 PM
- Marked as answer by P_Mundra Monday, November 14, 2011 11:36 AM
Friday, September 16, 2011 12:50 PM -
Thanks JaveedSaturday, September 17, 2011 8:33 AM
-
Hi,
I am glad that it helps please if you found the reply helpful then Mark it as Answer.
Jehanzeb Javeed
http://worldofdynamics.blogspot.com
Linked-In Profile |CodePlex Profile
If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".Saturday, September 17, 2011 8:42 AM