Determining the database schema version for DataCenter Security Server (DCS)
Article ID: 165277
Updated On:
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.
Feedback
Yes
No
Powered by
