Network Management
How to locate Node statistics in the Orion database
This article describes how to locate the node statistic in the Orion database. This data includes CPU, memory, Response Time, Interfaces and Volumes.
First published date
Last published date
Overview
Product section
Resolution
You can locate the node CPU, memory, availability, and pack data in the Orion database by table name.
| TABLE | DESCRIPTION |
|---|---|
| CPULoad_CS_* | Stores the node CPU and memory data. |
| ResponseTime_CS_* | Stores the node availability and packet loss data and response time |
| VolumeUsage_CS_* | Stores the node Volume data sorted by NodeID then VolumeID |
| InterfaceTraffic_CS_* | Stores the interface traffic utilization |
| InterfaceAvailability_CS_* | Stores the Interface status/availability |
| InterfaceErrors_CS_* | Stores the interface errors and discards |
| NodesStatistics |
Stores the last polling information for each node by Node ID. This data is also located in the Orion Web Console in the Nodes view. |
The tables that contain detailed information is the CPU Load Detail table (CPULoad_Detail_*). These tables contain the data for each poll. The Hourly and Daily tables are roll-ups from the Detail table.
The date in the table name is one day ahead of the actual polling data. The polling data in the table will have a date and time that is not adjusted for UTC time.
The database also contains similarly-named tables for interfaces and volumes.
For SAM polling data, see (SAM) Where component statistics are found in the database.