systeminfo

The systeminfo table stores data about Report server. This data is entered via the Administration screen of the Report server Administration Console.

Note:

Although the systeminfo table does not store Vocera usage data, it is commonly used by the standard Report Server reports to display system information.

Table 1. systeminfo table
Column Description
CompanyName

varchar(150) default '0'

The CompanyName column stores the name of the company where Vocera is installed.

ServerIp

varchar(120) default NULL

The ServerIp column stores the comma-separated list of IP addresses or DNS names of the Vocera server. If the Vocera server is not clustered, this column contains only one IP address or DNS name. The report server uses this information to fetch data from the Vocera server. Example values: 12.123.11.1, 127.0.0.1, myserver

BackupInfo

text

The BackupInfo column specifies how often Report server data is backed up. The value represents information entered in the following fields of the Backup page of the Administration screen: Enable Automatic Scheduled Backups, Backup Frequency, Backup Time, and Maximum Number of Backup Files to Save.

The field values are separated by a vertical bar ( | ). Backup times are presented in milliseconds from midnight. For example, the following value specifies automatic backups every 2 days at 2:00 a.m., retaining a maximum of 5 backup files:

true|2|7200000|5

DataLoadInfo

text

The DataLoadInfo column specifies how often the Report server loads data from the Vocera server. The value represents information entered in the following fields of the Data Load page of the Administration screen: Enable Automatic Scheduled Data Load, Load Data Frequency, and Data Load Time.

The field values are separated by a vertical bar ( | ). For example, the following value specifies automatic data loading every day at 4:00 a.m.

true|1|14400000|

Data load times are presented in milliseconds from midnight. Note the trailing vertical bar after the time.

Password

varchar(100) default NULL

The Password column stores the Administrator password for the Report server. This value is encrypted.

MailInfo

text

Specifies mail server information. The values are separated by a vertical bar ( | ).

SweepInfo

text

Specifies server sweep information. The values are separated by a vertical bar ( | ).