Tracing Recorded Data

To manage the Spector 360 data successfully, it is important to understand what happens to the data from the time it is recorded until the time it is archived.

 

Note: The SQL Server service is installed to either use the local system authority or use a network account to access data from the Data Vault computer. This is important in setting up access to the File Storage location and when you recover and restore a database to a new computer.

 To record and process the data:

  1. The Client records and stores data.
    The Client Recorder, installed on each network computer, detects and records all events, storing the data temporarily on the Client computer hard drive.

  2. The Clients push data to the Data Vault.
    Once every four minutes, the Client attempts to deliver the data across the network through an established port to the Data Vault service.

  3. The Data Vault accepts the data.
    The Data Vault service listens on the established port and responds to the Client communication.  When the recorded events are received by the Data Vault service,  the Client deletes them from the local client hard drive.

  4. The data goes into the DATA VAULT DB.
    The Data Vault Service receives the data and it directly into the DATA VAULT database, where it is held on "raw" format. It passes files (email attachments or screen snapshots) to the specified File Storage location.  

  5. Data is processed for the STORAGE DB.
    The Data Vault then runs a Process Data Vault job, which formats the data and places it into the current STORAGE database(s).  

  1. The Dashboard accesses the data.
    Once the data is in the STORAGE database(s), a user can log into the Dashboard, connect to the SQL Server instance of the Spector 360 database, and query, retrieve, and view the data.

  2. New databases are automatically created.
    Each STORAGE database stores a maximum of 2 GB of data records.  When a database exceeds the maximum size, a new database is automatically created.

  3. Full databases can be archived.
    You can archive older STORAGE databases, removing them from the Data Vault computer with the potential to restore them if needed.