Reference Guide > TDV and Business Directory System Tables > SYS_SITES
 
SYS_SITES
The SYS_SITES system table provides a list of site definitions.
Users see no rows unless they have the ACCESS_TOOLS right. If they have this right, they see all rows.
Note: Unlike most system tables, this table is under /system/deployment in the Studio resource tree.
Column
TDV
JDBC Data Type
Nullable
Description
SITE_NAME
VARCHAR(255)
 
Name of the site.
HOST_NAME
VARCHAR(255)
 
Name of the site host.
PORT
INTEGER
 
Host port through which to connect to the site.
DOMAIN
VARCHAR(255)
 
Domain of the user who can log in to the site host.
USER_NAME
VARCHAR(255)
 
Name of the user who can log in to the site host.
ANNOTATION
VARCHAR(2147483647)
 
Notes about the site.
STATUS
VARCHAR(2147483647)
 
Impact status.
MODIFY_TIME
TIMESTAMP
 
Time of last plan modification.
OFFLINE
BOOLEAN
 
Whether the site is offline (0) or online (1). (BD only.)