Overview

This article provides information on the DeviceComponentStatePeriod and DeviceSample tables, which contain low-level data. The summary tables are consolidated from these tables.

Information

• DeviceComponentStatePeriod: This table contains watt-consuming computer events.
  
  

  Column	Description
  DeviceId	The device key.
  ComponentTypeId	The component type key.
  ComponentStateId	The component state key.
  StartDeviceEventSerialNumber	The starting serial number for this event.
  EndDeviceEventSerialNumber	The ending serial number for this event. Is null for events which are still active.
  StartTimeStampLocal	The event starting time in local time.
  EndTimeStampLocal	The event ending time in local time. Is null for events which are still active.
  EndTimeStampAssigned	The time when the ending time was assigned. Is null for events which are still active.

  
  
  
• DeviceSample: This table contains watt-consuming EnergyWise events.
  
  

  Column	Description
  DeviceSampleId	The primary key.
  SampleTimeUtc	The time of the sample in UTC.
  SampleTimeLocal	The time of the sample in local time.
  SampleIntervalMs	The duration of the same sample in milliseconds.
  PowerDrawWatts	The watt draw of the sample.
  BaselineDrawWatts	The baseline energy draw of the device.
  EnergyLevel	The EnergyWise energy level.
  DeviceId	The device key.
  DeviceFamilyId	The device family key.
  InsertDate	The date the sample was inserted.