ihEnumeratedSets Table

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

Table 1. ihEnumeratedSets Table
Column NameData TypeDescription
SetNameVT_BSTRThe name of the set.
DescriptionVT_BSTRThe description of the set.
NumberofStatesVT_I4The number of states a set contains.
NumberofTagReferencesVT_I4The number of tags with which a set is associated.
SetDataTypeVT_BSTRThe data type of the set.
AdministratorSecurityGroupVT_BSTRThe security group to which the set belongs.
LastModifiedUserVT_BSTRIndicates which user last modified the set.
LastModifiedTimeVT_DBTimeStampIndicates the last time the set was modified.
RowCountVT_I4Indicates 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.

ihEnumeratedSets Examples

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

Example 1: Retrieve All Sets By Using Integer States

SELECT * FROM ihEnumeratedSets
WHERE SetDataType=’integer’

Example 2: Retrieve a Set By Name From Sets

SELECT * FROM ihEnumeratedSets
WHERE setname like PLC1