...
| Anchor | ||||
|---|---|---|---|---|
|
The DataStore is a database in which Uptime Infrastructure Monitor stores different types of information:
- configuration information for Uptime Infrastructure Monitor
- configuration and system information for the hosts that you are monitoring
- the performance data gathered by monitors, which is used for generating graphs and reports
- user information, including user names and passwords (encrypted if it is sensitive information)
- the settings for service monitors, Alert and Action Profiles, scheduled maintenance, and host checks
- reports that Monitoring Station users have saved, and are scheduled to run at specific intervals.
Like any other database, the DataStore consists of a number of tables. Data that you enter and save, or which Uptime Infrastructure Monitor collects from hosts, is written to specific tables in the DataStore.
Access to the DataStore is determined by one of the three installed user accounts: root, uptime, and reports. Each account gives users varying levels of access to the contents of the DataStore. For more information about these accounts, see the IDERA Uptime Knowledge Base article “Securing MySQL Database and Adding Users.”
Uptime Infrastructure Monitor can also use either an Oracle or MS SQL Server database as its DataStore.
Connecting to the DataStore Using ODBC
You can extract data from the DataStore for use in custom reporting or data warehousing by connecting to the DataStore using an ODBC connection. Once the connection is established, you can import the contents of the DataStore into such tools as MySQL Query Browser, Microsoft Excel and Crystal Reports.
Before you can connect to the DataStore using ODBC, the client system that is accessing the database must have the MySQL ODBC driver installed. The ODBC driver enables the client system to communicate with the DataStore.
For detailed information on installing and configuring the MySQL ODBC driver, see the IDERA Uptime Knowledge Base article “Connecting to the Uptime Infrastructure Monitor DataStore via ODBC.”
...
| Anchor | ||||
|---|---|---|---|---|
|
Uptime Infrastructure Monitor enables you to save some or all of the metrics that its monitors collect to the DataStore. You can use the retained data to generate a Service Metrics report (see Service Monitor Metrics Report) or a Service Metrics graph.
The data that you can retain varies from monitor to monitor. For example, with the Windows Service Check monitor you can save the Service Status and Response Time metrics. With the Exchange monitor you can save all Web Mail and SMTP metrics.
You can save data to the DataStore by clicking the Save for Graphing checkbox on a monitor template.