GetDBStatus Method
- Last UpdatedNov 06, 2025
- 2 minute read
'Declaration
Public Shared Function GetDBStatus() As DataSet
public static DataSet GetDBStatus()
Return Value
Returns a DataSet that contains all records in the Db_Status table. If no matching records are found, an empty DataSet is returned.
The columns of the returned DataSet are described below.
|
Column Name |
Description |
|---|---|
|
db_version |
A string that is the database version, from the Db_Status table. |
|
mw_db_user |
A string that is the database user ID used by the MES middleware, from the Db_Status table. |
|
mes_service_host_pref |
A string that identifies the host, using the fully qualified domain name, that is preferred to run the MES service and maintenance tasks. Set in the post-install Configurator when configuring the MES database middleware communication component. |
|
mes_service_host |
A string that identifies the host, using the fully qualified domain name, that is currently running the MES service and maintenance tasks. |
|
host_tz_id |
A string that identifies the timezone identifier of the middleware host that is currently running the maintenance activities. For example, US pacific standard time. |
|
def_tz_id |
A string that identifies the default time zone used to run daily maintenance tasks when entities or times are not related to any site. The value is set in the post-install Configurator when configuring the MES database-middleware communication component. |
|
service_last_ran |
A datetime (UTC) that identifies when the middleware last ran the daily maintenance tasks. |
|
upgrade_history |
A string that lists the MES upgrades since the first MES installation, including the intial installation. Entries, including the last one, are terminated by a semi-colon and a space. |
|
hotfix_history |
A string that lists the hotfixes applied on the current version of the database. Entries, including the last one, are terminated by a semi-colon and a space. |
|
wait_time |
An integer that is the number of minutes the MES service will wait prior to killing stale sessions. The default value is 0. |
|
wait_time_before_takeover |
An integer that, when the current middleware host stops processing the maintenance tasks, is the amount of time to wait (in minutes) before switching the maintenance tasks to another middleware host. The default value is 2. |
|
regen_samples |
A boolean that is true if all samples need to be regenerated by the MES service. The default value is false. |
|
install_date_utc |
A datetime (UTC) that is indicates when the current database version was installed. |
|
spare1 |
A string that is the contents of the user-defined spare1 field. |
|
spare2 |
A string that is the contents of the user-defined spare2 field. |
|
spare3 |
A string that is the contents of the user-defined spare3 field. |
|
spare4 |
A string that is the contents of the user-defined spare4 field. |