SQL query to list all active policies in DLP

Products

• Data Loss Prevention

Issue/Introduction

You are looking for an SQL query to get a list of all active policies.

Resolution

This query will return data for the active, enabled, policies in DLP.
This query will not modify the database, it will only return data that is already in the database.
Log into sqlplus as the protect user and run this query.

SELECT policyid
    ,name  
    ,createdate
    ,editdate
    ,activestatus
FROM POLICY
WHERE activestatus = '1';