How to find which policies are assigned to an EDM

Products

• Data Loss Prevention

Issue/Introduction

When trying to delete an Exact Data Profile (EDM) in the Data Loss Prevention (DLP) Enforce Console, the following error appears.

"This registered content has policies that depend on it. Please remove those policies first."



How can we identify which policy is assigned to the EDM?

Cause

Error appears as DLP see's there's a policy assigned to the EDM

Environment

Data Loss Prevention 15.7 MP2
Oracle 19c

Resolution

Run the attached EDMPolicyAssignment.sql against the database to see:

• The EDM name
• Which policy is assigned to the EDM
• The rule/condition in the policy where the assignment can be found