User Review
( votes)We can specify Source Type as AuditLogs within the CDS Source Component Editor of KingswaySoft to fetch the Audit information.
Get the details :- https://nishantrana.me/2018/10/08/using-kingswaysofts-cds-crm-source-component-to-get-audit-information-in-dynamics-365-ce-ssis/
The Souce Type – AuditLogs includes Output type – Audit Details (Role Privileges), which can be used to fetch any audit information related to security roles.
Audit Details (Role Privileges) contains 4 columns, which we have mapped to columns in excel.
- AuditId
- OldRolePrivileges
- NewRolePrivileges
- InvalidRolePrivileges
Let us execute the package
The output à
Here, the 1st row is when a new security role was created, the 2nd row is when an existing security role was updated and 3rd row is when a security role was deleted.
To get the complete information we need to combine this information (id which is auditid – first column) with the Primary output.
The columns of the Primary Output
After mapping, let us run the package with the Primary Output type.
Here below we can see the complete details by combining both the output using the auditid column
Note – to get the Audit Details (Role Privileges), we need to use SOAP – Service End Point type.
Also refer –
http://mscrmshop.blogspot.com/2016/06/auditing-security-roles-in-crm.html
http://www.kingswaysoft.com/blog/2019/10/16/Extracting-Audit-Logs-for-Multiple-CRM-Entities
https://nishantrana.me/2018/11/26/ssis-and-microsoft-dynamics-365/
https://community.dynamics.com/crm/b/mscrmcustomization/posts/ms-crm-audit-database-table-details
Hope it helps..