TEKVOX TekManager Comprehensive - Manual (Page 48)

48
SQL Server (Express) Setup
The file InstallTekReporter.sql located in the TekManager directory (C:\Program
Files\TekVox\TekManager) creates the database, tables and stored procedures. This should be run on
the SQL Server instance that will be used to store the logging records. To load the installer program run
SQL Server Management Studio Express and select File Open with the above mentioned file. Press the
Execute button on the toolbar to create the databases. To view the databases, exit SQL Management
and run it again.
MySQL Server Setup
The file MySqlInstallTekReporter.sql located in the TekManager directory (C:\Program
Files\TekVox\TekManager) creates the database, tables and stored procedures. This should be run on
the MySQL Server instance that will be used to store the logging records. To load the installer program
run MySQL Workbench and open a connection to the desired server instance. Select
“Open SQL Script”
from the File menu with the above mentioned file. Select the Execute button on the toolbar or select the
“Execute All” from the Query menu item to create the databases. This setup requires the MySQL ODBC
driver be present on the host system to operate. The ODBC option should be selected with the
appropriate driver nomenclature in the Report Setup/Database panel of TekManager.
This installer file creates the following:
Databases:
TekReporter – default name, can be changed to anything. The database name will be entered on the
Reports Setup / Database panel.
Note: The information for more than one project can be stored in the same database.
Tables:
TekMonitorAsset – information about individual monitors
TekMonitorEventLog – raw logging information. Gets processed and deleted daily after adding
processed records to:
TekMonitorEvents – processed log records, current up to the most recent running of the
TekMonitorDailySummary procedure, usually at midnight.
Stored Procedures:
(These stored procedures are initiated from TekManager)
TekMonitorAssetUpdate – whenever a project file is saved, the monitor information in this file is
refreshed.
TekMonitorEventLogInsert – adds records to TekMonitorEventLog whenever an event occurs.
The current status of all event and status indicators is written whenever the TekManager
application starts and right before and after the daily summary processing.
TekMonitorDailySummary – processes all the raw log records for a particular project, calculates
durations for each of the events and writes it to the TekMonitorEvents table. The processed raw
records are purged.
tvEvents
– used by the Event History Display in TekManager to select records for display. Parameters
are date range and current project name.