Checking Enforce and Schema versions in the database

book

Article ID: 169811

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Issue/Introduction

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

Environment

DLP 14.x and 15.x

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