ihCalculationDependencies Table | Historian for Cloud 2024 Documentation

The ihCalculationDependencies table contains the calculation and server-to-server tags and their triggers. The following table describes the columns of the ihCalculationDependencies table.

Table 1. ihCalculationDependencies Table
Column Name	Data Type	Description
`Tagname`	`VT_BSTR`	A calculation or server-to-server tag with unsolicited collection and at least one dependent tag.
`DependentTagname`	`VT_BSTR`	A dependent tagname. If a tag has multiple dependent tags, there are multiple rows in the table for that tagname.
`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.

ihCalculationDependencies Examples

Example SQL statements for the ihCalculationDependencies table are outlined in the following examples.

Example 1: Show the Dependencies for a Specific Tag

SELECT * FROM ihcalculationdependencies WHERE tagname = c1

Example 2: Show the Dependencies for a Specific Dependent Tag

SELECT * FROM ihcalculationdependencies
WHERE dependenttagname=brahms.ai1.f_cv