Skip to content

WmiInstanceHistoryProperty

See WmiInstanceProperty for description of the columns.

erDiagram
    WmiClassProperty ||--o{ WmiInstanceHistoryProperty : "WmiClassPropertyID"
    WmiInstanceHistory ||--o{ WmiInstanceHistoryProperty : "WmiInstanceHistoryID"
    WmiInstanceHistoryProperty ||--o{ WmiInstanceHistoryPropertyArray : "WmiInstanceHistoryPropertyID"

Fields

Field Type Description
BooleanValue boolean Boolean representation of the value or null. Provided for easier use in queries, for calculations etc.
DateTimeValue datetime DateTime representation of the value or null. Provided for easier use in queries, for calculations etc.
ID numeric Internal ID for the WmiInstanceHistoryProperty entity (Primary Key)
IntegerValue numeric Integer representation of the value or null. Provided for easier use in queries, for calculations etc.
Value string The value of the property
WmiClassPropertyID numeric Internal ID that references the WmiClassProperty entity (Foreign Key)
WmiInstanceHistoryID numeric Internal ID that references the WmiInstanceHistory entity (Foreign Key)

References

Column Name Referenced Table Description
WmiClassPropertyID WmiClassProperty Holds a row for each unique property per class scanned
WmiInstanceHistoryID WmiInstanceHistory Each entity is an instance of a class scanned in a particular MachineUserHistory context. This table together with WmiInstanceHistoryProperty holds historized WMI data for each scan. See WmiInstance for description of the columns.

Referenced by

Table Column Name Description
WmiInstanceHistoryPropertyArray WmiInstanceHistoryPropertyID For multi-valued (array) properties, each entity is an item in the array