Checking Enforce and Schema versions in the database

Products

• Data Loss Prevention Enforce

Issue/Introduction

How do we check Enforce and Schema versions in the database?

Environment

DLP 15.x, 16.0

Resolution

Log into the DLP database as the protect user and running the following SQL queries to determine your current enforce and database schema version

SQL> select version,dateinstalled from enforceversion where iscurrentversion='Y';

Sample output :

VERSION              DATEINSTALLED
-------------------- -------------------------
15.0.0.45009         22-AUG-17 08.30.20.544000 AM

SQL> select dlpversion,dateinstalled from dbschemaversion where iscurrentversion ='Y';

Sample output :

DLPVERSION           DATEINSTALLED
-------------------- -------------------------
15.0                 22-AUG-17