ODBC queries can be performed against the VHS HistoricalValues table and VHS HistoricalStats table. See Running ODBC Batch Files for more information.
The following table lists the fields in the VHS HistoricalStats table.
| Field |
|---|
|
EarliestTime |
|
EntryCount |
|
ExpirationDays |
|
LatestTime |
|
PointId |
|
PointIdLong |
|
Service |
|
Site |
The following table lists the fields in the VHS HistoricalValues Table.
| Field |
|---|
|
AlarmPriorityCategory |
|
AlarmSuppressed |
|
AnalogPoint |
|
ConfigBit1 |
|
ConfigBit2 |
|
ConfigBit3 |
|
ConfigBit4 |
|
ConfigBit5 |
|
ConfigBit6 |
|
ConfigBit7 |
|
ConfigBit8 |
|
ConfigBit9 |
|
ConfigBit10 |
|
ConfigBit11 |
|
ConfigBit12 |
|
ConfigBit13 |
|
ConfigBit14 |
|
ConfigBit15 |
|
DigitalPoint |
|
EnumPoint\ |
|
ExternalValue |
|
InitedFlag |
|
PointId |
|
PointIdLong |
|
PointScheme |
|
PointTime |
|
RecordTime |
|
Service |
|
Site |
|
StringPoint |
|
UDC |
|
Unreliable Flag |
|
UpdatedFlag |
|
UserBit1 |
|
UserBit2 |
|
UserBit3 |
|
UserBit4 |
|
UserBit5 |
|
UserBit6 |
|
UserBit7 |
|
UserBit8 |
|
UserBit9 |
|
UserBit10 |
|
UserBit11 |
|
UserBit12 |
|
UserBit13 |
|
UserBit14 |
|
UserBit15 |
|
UserBit16 |
|
Value |
|
VhsValueDeleted |
|
VhsValueEdited |
|
|
|
