ihEnumeratedStates Table

The ihEnumeratedStates table contains information about enumerated sets that are defined in the system. The following table describes the columns of the ihEnumeratedStates table.

Table 1. ihEnumeratedStates Table
Column Name Data Type Description
SetName VT_BSTR The name of the set.
Description VT_BSTR The description of the set.
NumberofStates VT_I4 The number of states a set contains.
NumberofTagReferences VT_I4 The number of tags with which a set is associated.
SetDataType VT_BSTR The data type of the set.
AdministratorSecurityGroup VT_BSTR The security group to which the set belongs.
LastModifiedUser VT_BSTR Indicates which user last modified the set.
LastModifiedTime VT_DBTimeStamp Indicates the last time the set was modified.
RowCount VT_I4 Indicates the maximum number of rows that can be returned. A value of 0 indicates that there is no limit to the number of rows returned.

ihEnumeratedStates Examples

Sample SQL statements for the ihEnumeratedStates table are outlined in the following examples.

Example 1: Retrieve All States That Belong to a Specific Set

SELECT * FROM ihEnumeratedStates
WHERE setname=plcset1 order by statelowvalue ascending

Example 2: Retrieve All States From a Specific Set

SELECT * FROM ihEnumeratedStates
WHERE setname = 'setname'