Retrieving OldRolePrivileges and NewRolePrivileges

(0) Share

Report

Posted on by Josephkm_lim

Hi All

I am trying to do some analysis on the audit table using Power BI.

I am able to make various web api calls and functions like RetrieveRecordChangeHistory, and have successfully worked on the field changes (stored as column number in attributemask column of the audit table).

However, I am stuck with the role and privilege changes. These are stored as GUID in the attributemask column.

Which web api and function calls can I make to retrieve the RolePrivilegeAuditDetail in order to retrieve the OldRolePrivileges and NewRolePrivileges, as described on https://docs.microsoft.com/en-us/dynamics365/customer-engagement/web-api/roleprivilegeauditdetail?view=dynamics-ce-odata-9 ?

Any help is appreciated.

I am using v9.2

Thanks!

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

meelamri 13,216 User Group Leader on at

Like (1)

Report
Hi Josephkm,

I tried to do the same thing on my test environment, I got the following result.

In order to have RolePrivilegeAuditDetail you will need to execute the Microsoft.Dynamics.CRM.RetrieveAuditDetails() function on an audit with the event "Replace Privileges In Role".

Example:

The audit record related to this update:

https://xxxx.crm.dynamics.com/api/data/v9.1/audits?$filter=action eq 59 and Microsoft.Dynamics.CRM.Today(PropertyName='createdon')

Then when you perform your function Microsoft.Dynamics.CRM.RetrieveAuditDetails():

https://xxxx.crm.dynamics.com/api/data/v9.2/audits(e5e448e9-566c-eb11-9889-281878f0b22c)/Microsoft.Dynamics.CRM.RetrieveAuditDetails()

Was this reply helpful? Yes No
Josephkm_lim on at

Like (0)

Report
Hi Medhi

Many thanks for your advice. It's great and useful!

However, I encountered an error when I execute:

https://xxxx.crm.dynamics.com/api/data/v9.2/audits(auditid GUID)/Microsoft.Dynamics.CRM.RetrieveAuditDetails()

"Object reference not set to an instance of an object."

I don't understand what could have caused it since I have the audit record when I execute:

https://xxxx.crm.dynamics.com/api/data/v9.2/audits(auditid GUID)

And I can see the data via the Audit Summary View:

Would you have any experience regarding this too?

Thanks in advance!

Was this reply helpful? Yes No
meelamri 13,216 User Group Leader on at

Like (1)

Report

Hi Josephkm,

I will investigate into other environments and keep you informed.

Was this reply helpful? Yes No
Suggested answer

meelamri 13,216 User Group Leader on at

Like (1)

Report
I've replayed the same scenario in two other instances:

it works for the following versions:

2020 release wave 2 enabled/ Server version: 9.2.20123.00153/ Client version: 1.4.2135-2012.3

2021 release wave 1 enabled/Server version: 9.2.20123.00153/Client version: 1.4.2135-2012.3

it doesn't work for the next version (same error as yours)

2020 release wave 2 enabled/Server version: 9.2.21012.00146/Client version: 1.4.2134-2101.2

I recommend opening a support ticket. Looks like the implementation is not completed for some version.

Was this reply helpful? Yes No
Josephkm_lim on at

Like (1)

Report

Hi Medhi

This is amazing discovery. Thank you for your kind advice. Have a great weekend!

--

Yours

Was this reply helpful? Yes No
meelamri 13,216 User Group Leader on at

Like (0)

Report

You are welcome ! Have a good weekend

Was this reply helpful? Yes No