This topic provides information on the ComponentState, ComponentType, ComponentTypeStateUtilization,ComponentTypeStateDraw, and DeviceComponentStateDraw tables.
ComponentState
The various states a component can exist in. 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) |
| Column | Description |
|---|---|
| ComponentTypeId | 100 (CPU), 200 (User), 300 (Display), 1000 (EnergyWise) |
| Name | CPU, User, Display, EnergyWise |
ComponentTypeStateUtilization
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 in 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 ComponenType, 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. |