Customer experience | Sales, Customer Insights,...

What are the steps to use Deletion Service for cleanup of Principal Object Access (POA) in MS D365?

(0) Share

Report

Posted on by Community Member Microsoft Employee

I want to cleanup the POA data in D365 and I read that deletion service will delete those records who's AccessRightMask value is 0, but I don't know how to use that. What are the steps to use Deletion Service for cleanup of Principal Object Access (POA) in MS D365?

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: What are the steps to use Deletion Service for cleanup of Principal Object Access (POA) in MS D365?

Hi,

But, if deletion service isn't in running status then how can I make that service in running service?

Please tell me with steps.

Regards,

Sougata
Suggested answer

Steven RH JIANG on at

Like (1)

Report

RE: What are the steps to use Deletion Service for cleanup of Principal Object Access (POA) in MS D365?

You can use below query to check inside DB whether the Deletion Service is running regularly. If it's running, then leave it to Deletion Service as it will have these POA records deleted.

USE MSCRM_CONFIG

select * from ScaleGroupOrganizationMaintenanceJobs where OperationType = 14

Besides, you can also use below script to check out inside the POA table to confirm how many records having 0 for both fields (accessrightsmask and inheritedaccessrightsmask). You can delete these records manually, so just leave it to Deletion Service to have them deleted (usually, these records will stay there for 90 days, and then Deletion Service will remove them).

select objecttypecode,accessrightsmask,inheritedaccessrightsmask,count(*) as Total

from PrincipalObjectAccess with (nolock)

group by objecttypecode,accessrightsmask,inheritedaccessrightsmask

order by total desc