Collective table (PICOLLECTIVE)
- Last UpdatedFeb 27, 2023
- 1 minute read
- PI System
- PI Server
The PICOLLECTIVE table contains information about the Data Archive collective that the server belongs to, including the collective's name, description, and status. Use this table along with the PISERVER table to determine configuration and status information for each server in a Data Archive collective.
Normally, the table contains one row for the Data Archive collective that the server belongs to. The Name attribute links entries in the PISERVER table to entries in the PICOLLECTIVE table. Data Archive presents the CollectiveID as its server identifier to client applications through PI SDK. This allows client applications to connect to any server in a collective without changing displays.
The primary key is NAME.
|
PICOLLECTIVE Attribute |
Type |
Editable |
Example |
Description |
|---|---|---|---|---|
|
Name |
String |
Primary |
"uc-s1" |
Name of the collective to which the server belongs. Must match collective name defined in PISERVER table. |
|
CollectiveID |
String |
Primary |
"08675309-0007-0007-0007-000000001001" |
UID that uniquely represents the Data Archive collective. |
|
Description |
String |
Primary |
"UC 2006 Demo Collective" |
Optional description of the collective. |
|
LastCollectiveConfigChangeTime |
TimeStamp |
No |
12-Apr-06 14:00:17 |
Time stamp of last change to collective configuration. |
|
Status |
Int32 |
No |
0 |
Overall status of the collective (0 = good). Use the pidiag -e command to look up the status as an error code. If the status is not good, at least one member of the collective has a bad CommStatus or SyncStatus in the PISERVER table. |
|
NewName |
String |
Used to rename an existing Data Archive collective. |