Please enable JavaScript.
Coggle requires JavaScript to display documents.
Solutions of Deleting message based on RPS (Tag (Apply Policy (Include…
Solutions of
Deleting message
based on RPS
Tag
Input
Stored in
RetentionPolicyTag
Apply Policy
Create a temp table to generate the folder id by folder names
Work by join
Include sub folder
Check box
Column
Is standard folder?
Ask for support whether it is necessary to have this functionality
Changes
DB Schema
Add a table
index for folder name
Stored Procedures
RetentionPolicyUpdateAll2
RetentionRunPolicyApply
Join
Group/OUName/Mailbox
Apply Policy
Extract entries to
RetentionRunPolicyTarget
When executing
RetentionRunBegin
Work by
Join
Changes
DB Schema
Add a column in
RetentionPolicyTarget
RetentionRunPolicyTarget
Add a column in it
Too many entries stored
Add a new table
Stored Procedures
RetentionRunBegin
RetentionRunPolicyResolveTargets
4 Conditions
MailboxID
FolderID
RetentionRunPolicyApply
Join
MailboxID
FolderID
RetentionPolicyUpdateAll2
Input
Stroed in
RetentionPolicyTarget