Overview
This article provides information on the following tables of the Component Tables:
ComponentStateComponentTypeComponentTypeStateUtilizationComponentTypeStateDrawDeviceComponentStateDraw
Information
ComponentState: This table contains the various states in which a component can exist. It is preconfigured and should not be modified.
| Column | Description |
| ComponentStateId | The primary key. |
| Name | Active, On, Off, Idle, Suspend, Unknown, Hibernate, EnergyWisePowerLevel(0 - 10), Database24HrEvent. |
| ComponentTypeId | 100 (CPU), 200 (User), 300 (Display), 1000 (EnergyWise) |
ComponentType
| Column | Description |
| ComponentTypeId | 100 (CPU), 200 (User), 300 (Display), 1000 (EnergyWise) |
| Name | CPU, User, Display, EnergyWise |
ComponentTypeStateUtilization: This table stores the default values for usage percentages of computers and displays in their various states (On, Off, Sleep). These values correspond to values defined under the CPU and Display Baseline Percentages section in the Global Settings page of the Sustainability Dashboard Administrator console and are used to calculate the baseline value.
| Column | Description |
| ComponentTypeStateUtilizationId | The database-generated key for the row. |
| Utilization | The usage percentage for the specific ComponentState and ComponentType combination. |
| ComponentStateId | The ComponentState, such as CPU On (100), Display Sleep (301). |
| componentTypeId | The ComponentType, such as CPU (100) and Display (300). |
DeviceComponentStateDraw: Update this table to record a device’s watt draw for a particular state. If not used, the defaults of ComponentTypeStateDraw are used. This is not relevant for EnergyWise devices.
| Column | Description |
| DeviceId | Key from Device table. |
| ComponentTypeId | Key from ComponentType table. |
| ComponentStateId | Key from ComponentState table. |
| Wattage | The watt draw for the Device/ComponentType/ComponentState combination. |
Comments
0 comments
Article is closed for comments.