ihEnumeratedSets Table | Historian for Cloud 2024 Documentation

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 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.

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