Get Data From Audit History

(0) Share

Report

Posted on by SamCRM1

247

We have a status field on the form and also Auditing is turned on for the forms. I need to create a report, which displays Status of all the records and last time the value was changed for the status field. Can someone please guide me how to query the Audit History tables.

Thank you

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Nishant Rana 11,325 Microsoft Employee on at

Like (0)

Report

RE: Get Data From Audit History

These are the different options when it comes to querying / exporting Audit Data

https://nishantrana.me/2021/08/31/audit-entity-table-few-key-points-dynamics-365-power-apps/

https://nishantrana.me/2016/10/24/using-retrieveentitychangerequest-to-track-changes-in-crm-2015-2016/

https://nishantrana.me/2018/10/08/using-kingswaysofts-cds-crm-source-component-to-get-audit-information-in-dynamics-365-ce-ssis/

Was this reply helpful? Yes No
Verified answer

SamCRM1 247 on at

Like (0)

Report

RE: Get Data From Audit History

Since I needed the history in the CSV file, I built the console application and got the result using following code:

CrmServiceClient crmConn = new CrmServiceClient(ConfigurationManager.ConnectionStrings["CRM"].ConnectionString);

IOrganizationService crmService = crmConn.OrganizationServiceProxy;

RetrieveAttributeChangeHistoryRequest request = new RetrieveAttributeChangeHistoryRequest();

var response = (RetrieveAttributeChangeHistoryResponse)crmService.Execute(request);

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: Get Data From Audit History

Hello,

You can use this fetch to get records from audit entity or use XRMtoolBox for this

<fetch top="50" >

<entity name="audit" >

<attribute name="useridname" />

<attribute name="attributemask" />

<attribute name="operation" />

<attribute name="objecttypecodename" />

<attribute name="objectid" />

<attribute name="operationname" />

<attribute name="transactionid" />

<attribute name="useradditionalinfo" />

<attribute name="regardingobjectidname" />

<attribute name="auditid" />

<attribute name="createdon" />

<attribute name="userid" />

<attribute name="callinguseridname" />

<attribute name="regardingobjectid" />

<attribute name="objecttypecode" />

<attribute name="action" />

<attribute name="actionname" />

<attribute name="objectidname" />

<attribute name="callinguserid" />

</entity>

</fetch>

You can filter on which entity you want to use.

Hope you can understand what I mean!

Was this reply helpful? Yes No
Suggested answer

Preeti Sharma 2,678 on at

Like (0)

Report

RE: Get Data From Audit History

Hi,

You can't query audit table if you are using CRM online as crm does not contain any audit entity.

If you are using on premise then you can query "AuditBase" table from SQL and get data as you required.

Hope this helps:)

Was this reply helpful? Yes No
Suggested answer

Mahendar Pal 45,095 on at

Like (0)

Report

RE: Get Data From Audit History

Hi,

it's not easy to write report on audit data, but you can start from here: marcuscrast.wordpress.com/.../dynamics-crm-2011-audit-report-in-ssrs

Was this reply helpful? Yes No