Server table (PISERVER)
- Last UpdatedFeb 27, 2023
- 2 minute read
This table contains Data Archive configuration and status information. If the Data Archive server is part of a Data Archive collective, the table contains one row for each server in the collective.
The primary key is NAME. The value in Collective must match the value of Name in the PICOLLECTIVE table.
This example displays the name, FQDN and server ID:
* (Ls - ) PIconfig> @mode list
* (Ls - ) PIconfig> @tabl pisys,piserver
* (Ls - PISYS,PISERVER) PIconfig> @ostr name,fqdn,serverid
* (Ls - PISYS,PISERVER) PIconfig> @sele name=*
* (Ls - PISYS,PISERVER) PIconfig> @ends
PiServer1,PiServer1.osisoft.dom,12db4fde-963d-4f47-bc43-65f9e026502c
* (Ls - PISYS,PISERVER) PIconfig>
|
Attribute |
Type |
Editable |
Example |
Description |
|---|---|---|---|---|
|
Name |
String |
Primary |
uc-s2 |
Computer host name (non-qualified). Unique key in the PISERVER table. Each server uses this to find its own entry in the table. |
|
Collective |
String |
Primary |
uc-s1 |
Name of the collective that the server belongs to. Must match collective name defined in PICOLLECTIVE table. |
|
CommPeriod |
Int32 |
Primary |
20 |
Frequency (in seconds) that secondary server checks that it can communicate with primary server. Default value is 5. |
|
CommStatus |
Int32 |
no |
0 |
Status of the last secondary Data Archive communication with the primary server (0 is good). |
|
Description |
String |
Primary |
UC 2006 Demo Server 2 |
Optional description for the server. |
|
FQDN |
String |
Primary |
uc-s2.mycomp.com |
FQDN or IP address used to connect to collective servers. |
|
IsAvailable |
BYTE |
no |
1 |
1 if available for client access, 0 otherwise. Derived from all other status fields in the table. |
|
IsConnectedToPrimary |
BYTE |
no |
1 |
1 indicates that the secondary Data Archive server is connected to the primary Data Archive server. Always 1 on the primary Data Archive server. |
|
IsCurrentServer |
BYTE |
no |
1 |
1 on the responding Data Archive server, 0 for all others. |
|
IsTCPListenerOpen |
BYTE |
no |
1 |
1 indicates this Data Archive server TCP/IP listener is open. |
|
LastCommTime |
TimeStamp |
no |
12-Apr-06 14:00:17 |
Last time the secondary Data Archive sever communicated status to the primary Data Archive server. |
|
LastSyncRecordID |
Uint64 |
no |
68 |
Number of changes each Data Archive server applied to the replicated tables. |
|
LastSyncTime |
TimeStamp |
no |
12-Apr-06 14:00:17 |
Last time synchronization succeeded on any secondary Data Archive server. |
|
NumConnections |
Uint32 |
no |
11 |
Total number of connections on the specific Data Archive server. |
|
PIVersion |
String |
no |
3.4.375.29 |
Version of PI Base Subsystem. |
|
Port |
Uint32 |
no |
5450 |
TCP/IP port number for communicating to Data Archive. |
|
Role |
Int32 |
Primary |
2 |
0 for non-replicated; 1 for primary; 2 for secondary. |
|
ServerID |
String |
Primary |
08675309-0007-0007-0007-000000001002 |
A UID representing the unique Data Archive server identification. |
|
SyncFailReason |
String |
No |
Reason that synchronization did not succeed. |
|
|
SyncPeriod |
Int32 |
Primary |
10 |
Frequency (in seconds) that secondary server checks for configuration updates from primary server. 0 indicates no automatic synchronization. |
|
SyncStatus |
Int32 |
no |
0 |
On secondary servers: the status the last time that synchronization was attempted (0 is good) |
|
UnavailableReason |
String |
no |
||
|
NewName |
String |
Used to rename an existing server. |