Connect to your up.time DataStore using an ODBC or database tool. Assuming that you have installed up.time in the default location, you can access the DataStore at the command line using the following commands:
Code Block language bashsql
«change to the up.time installation directory» cd mysql cd bin ./mysql -u uptime --password=uptime -P 3308 --protocol=TCP uptime
- After you login to the up.time DataStore, run a command to update the threshold that you want to use with all elements. The command format and an example are detailed below. Replace the «field» text in the example below with a value from the DataStore setting name column in the table above. Replace the «new value» text in the example below with your new threshold setting (decimal values are not permitted for thresholds).
Note: All mysql commands assume that you are using a MySQL DataStore. The format of the commands may differ slightly for Oracle or SQL Server databases.
mysql» update entity set «field»=«new value»;
mysql» update entity set gs_swap_warn=50
mysql» update entity set gs_swap_crit=75
- Run the command above for each threshold value that you want to change. When you are finished, use the exit; command to be returned to the command line.