Determining the database schema version for DataCenter Security Server (DCS)

Products

• Critical System Protection
• Data Center Security Monitoring Edition
• Data Center Security Server
• Data Center Security Server Advanced

Issue/Introduction

You want to find out the version of the database schema the DCS server is using.

Resolution

On the SQL server run this query :

use SCSPDB

SELECT TOP 1000 [USERRID],[SECTION],[PROPNAME],[PROPVAL],[PROPFLAGVAL],[PROPBIGINTVAL],[PROPINTVAL],[PROPDATEVAL],[CREATETIME],[MODTIME]FROM [SCSPDB].[dbo].[SYSPROP] where PROPNAME like 'db.%'

The output will give you the exact build of the schema.