Contains data required for the FusionAnalytics reports.
| Column Name | Data Type | Unique | Nullable | Description |
|---|---|---|---|---|
| ID | bigint | x | The primary key column | |
| REPORT_ENTRY_ID | bigint | The related report_entry_id | ||
| VIEW_NAME | varchar(255) | The Analytics perspective name | ||
| JDBC_ID | bigint | The FusionReactor JDBC ID | ||
| SERVER | smallint | The Server ID taken from ServerMap | ||
| DT | bigint | The number of milliseconds since the epoch. Timezone adjustments can be made with the timezone attribute of the DataCollector that provided the data. | ||
| VERSION | smallint | The version of the log files being imported. | ||
| SRVSTARTTS | bigint | The time (in milliseconds since the epoch) that the server last came online. | ||
| REQID | bigint | The FusionReactor request ID | ||
| THREADID | varchar(35) | The name of the thread responsible for responding to this request. | ||
| CLIENTIP | varchar(39) | The IP of the client making the request. | ||
| REQMETHOD | varchar(20) | The request HTTP method (GET/POST) | ||
| REQURL | varchar(2048) | The full URL of the request | ||
| DBTIMEFROM | bigint | The time (in milliseconds since the epoch) when the JDBC query started on the database. | ||
| DBTIMETO | bigint | The time (in milliseconds since the epoch) when the JDBC query finished with the database. | ||
| TOTALTIMETO | bigint | The time (in milliseconds) at which the query was completely finished. | ||
| DBTIME | bigint | The total time (in milliseconds) that the query spent on the database. | ||
| TOTALTIME | bigint | The total amount of time (in milliseconds) it took to complete this query. | ||
| ROW_COUNT | bigint | The number of rows returned by this query. | ||
| PREPSTMT | varchar(5) | Boolean describing whether this was a prepared statement. | ||
| ROWLIMITED | varchar(5) | Boolean describing whether the query was row limited. | ||
| DATASOURCE | varchar(255) | If you have assigned a name to your data source wrapper then it will appear here. | ||
| STMT | long varchar | The actual statement which ran. | ||
| STACKTRACE | long varchar | The stack trace which was stored when the query was run. | ||
| QUERYSTRING | varchar(4096) | The query string from the request running the JDBC statement. | ||
| MESSAGE | long varchar | For Notifications and Reminders, this will contain the notification or reminder message. |