|
In this topic: |
Database
The Spector 360 Database is a SQL Server instance that allows the recorded Client data to be searched and filtered by the Dashboard. Spector 360 uses Microsoft SQL Server 2005 or 2005 Express as its SQL Server database management system. If your Spector 360 purchase includes MS SQL Server 2005 Express, an additional Job Agent service (Spector360 SQL Agent) is included to handle certain database tasks. An Administrator manages the Database from the Spector 360 Dashboard.
Guidelines for estimating and planning for the amount of disk space the database will requrie are provided in the Spector 360 Deployment Guide.
The Data Vault Server must communicate with the Database (Microsoft SQL Server and the Spector 360 Databases). The default setup installs the Data Vault service on the same physical computer as SQL Server, but direct network access with appropriate service account credentials permit a distributed setup.
The Spector 360 SQL Server instance must be directly accessible by Dashboard installations.
The SQL Server service must be up and running.
The Spector 360 SQL Server instance has a default location of C:\Program Files\Microsoft SQL Server\MSSQL$SPECTOR360\ and includes these databases:
ADMIN DB - Contains programming scripts needed for Spector 360 processing that are not customer specific.
CUSTOMER DB - Contains customer-specific data, such as login profiles.
DATA VAULT DB - Contains raw event data the Data Vault Server has received from Clients but not yet processed.
LOOKUP DB - Contains the domain names, computer names, and other fields from the data required for Dashboard queries. There can be multiple active LOOKUP databases, depending on the size of your data.
SEARCH DB - Used to cache searches performed with the Dashboard Search tool.
STORAGE DB - Contains the data processed by the Data Vault that can be queried and viewed by the Dashboard. There can be multiple active STORAGE databases, depending on the size of your data.
WFS FILTER DB - Contains the category, group, and time profile data that define the web filtering policy.
WFS SYSTEM DB - Provides predefined categories that can be used to block or allow URLs. SpectorSoft upgrades this data on a regular basis.
On a Full Backup of the database, all databases are backed up. On an Archive of the database, only the STORAGE data (Client recordings) are archived. Monitor and manage the databases from the Dashboard application. See the Spector 360 Dashboard Guide.
The Dashboard application has read-only privileges to the database and the Data Vault Service uses insert privileges.
The data tables are secure in the Database, which cannot be queried or viewed by any application other than the Dashboard.
Email attachments and Snapshot files are stored in encrypted format in separate directories and can be viewed only from the Dashboard.
Varying types of Dashboard "login accounts" help to control access by role. For example, Database Management functions are available only to a "Master" login account with database maintenance privileges.
Dashboard accounts can be defined to access recorded data only from specified users or user groups and/or specified event types.
The System Administrator (SA) login has initial, "root" access to the Database and the Dashboard. Guard the password for this account carefully.
Requirements to Run