Technical Reference - Data Store Schema


The data stored by ServerAssist in the data store is divided across five tables. Note that ServerAssist will automatically create and correct the schema for the internal data store, and manual creation of the tables and indices should only be necessary when using an external data store via OLE DB.

Core Schema Scripts

Schema definition files for popular RDBMSs are included below.

SQL Server script

Jet database

Meta Data Scripts & Data

The ServerAssistAlert and ServerAssistEvent tables make use of numeric fields to store some information. A small meta-data database is available to assist in decoding these values to their textual description.

SQL Server script

Jet database