Collection feature service schema

ArcGIS Monitor collections allow you to make collection data available for use in other ArcGIS applications, such as ArcGIS Dashboards. The following sections list the tables available in the collection feature service.

Hosts

The Hosts table contains attributes for all host components within a collection.

Name	Description	Nullable	Type
address_internal	The network address of the host	False	String
class	The underlying classification and size of the host, if applicable	True	String
cpu_cores_logical	The CPU's total number of logical cores as reported by the host component's operating system (OS)	True	Float
cpu_cores_physical	The CPU's total number of physical cores as reported by the host component's OS	True	Integer
cpu_name	The CPU's vendor and type as reported by the host component's OS	True	String
cpu_speed	The CPU speed as reported by the host component's OS	True	Float
created_at	The date and time the host component was registered	False	Datetime
description	The long-form description of the host component	True	String
id	The primary key for the host component	False	Integer
location	The host component's cloud region, if applicable	True	String
memory_page_total	The total pagefile or swap memory resources available	True	Float
memory_total	The total amount of physical memory as reported by the host component's OS	True	Float
name	The name of the host component	False	String
network_speed	The negotiated network speed as reported by the host component's OS	True	Float
started_at	The last boot time recorded by the host component's OS	True	Datetime
status	The current alert status of the host component	False	Integer
subtype	The host component's OS type (Windows or Linux)	False	String
system_id	The ID used to uniquely identify the host component within its monitoring scope	False	String
type	The primary category used to categorize the host component	False	String
version	The host component's OS version	True	String

Databases

The Databases table contains attributes for all database and geodatabase components in a collection.

Name	Description	Nullable	Type
address_internal	The network address of the database component	False	String
connections_max	The maximum number of connections	False	Integer
created_at	The date and time the database component was registered	False	Datetime
description	The long-form description of the database component	True	String
gdb_version	The underlying geodatabase schema version of the database component, if applicable	True	String
id	The primary key for the database component	False	Integer
last_backup_at	The date and time the database was last backed up	True	Datetime
memory_total	The total amount of physical memory allocated as reported by the database software	True	Float
name	The name of the database component	False	String
started_at	The last start time recorded by the database software	True	Datetime
status	The current alert status of the database component	False	Integer
subtype	The general database vendor classification (PostgreSQL, Oracle, or SQL Server)	False	String
system_id	The ID used to uniquely identify the database component within its monitoring scope	False	String
system_mode	Specifies the state of the system as configured in the database instance: Read Read Write	False	String
type	The primary category used to categorize the database component	False	String
version	The database component's database software version	True	String

ArcGIS Portals

The ArcGIS Portals table contains attributes for all Portal for ArcGIS components in a collection.

Name	Description	Nullable	Type
address_internal	The network address of the Portal for ArcGIS component	False	String
cert_expires_at	The expiration date and time of the configured SSL certificate for Portal	True	Datetime
created_at	The date and time the Portal for ArcGIS component was registered	False	Datetime
description	The long-form description of the Portal for ArcGIS component	True	String
id	The primary key for the Portal for ArcGIS component	False	Integer
license_expires_at	The most recent expiration date and time across all configured Portal licenses	True	Datetime
name	The name of the Portal for ArcGIS component	False	String
started_at	The last start time recorded by Portal	True	Datetime
status	The current alert status of the Portal for ArcGIS component	False	Integer
subtype	The secondary category used to categorize the Portal for ArcGIS component	True	String
system_id	The ID used to uniquely identify the Portal for ArcGIS component within its monitoring scope	False	String
type	The primary category used to categorize the Portal for ArcGIS component	False	String
version	The Portal for ArcGIS component's software version	True	String

Web Applications

The Web Applications table contains attributes for web applications from all Portal for ArcGIS components in a collection.

Attribute name	Description	Nullable	Data type
access_level	The shared access level of the web application	True	String
address_internal	The network address of the web application	False	String
content_status	The content status of the web application	True	String
created_at	The date and time the web application was registered	False	Datetime
description	The long-form description of the web application	True	String
id	The primary key for the web application	False	Integer
last_modified_at	The data and time the web application was last modified	True	Datetime
name	The name of the web application	False	String
owner	The owner of the web application	False	String
status	The current alert status of the web application	False	Integer
subtype	The secondary category used to categorize the web application	True	String
system_created_at	The date and time the web application was created	True	Datetime
system_id	The ID used to uniquely identify the web application within its monitoring scope	False	String
type	The primary category used to categorize the web application	False	String

Web Maps

The Web Maps table contains attributes for web maps from all Portal for ArcGIS components in a collection.

Attribute name	Description	Nullable	Data type
access_level	The shared access level of the web map	True	String
address_internal	The network address of the web map	False	String
content_status	The content status of the web map	True	String
created_at	The date and time the web map was registered	False	Datetime
description	The long-form description of the web map	True	String
id	The primary key for the web map	False	Integer
last_modified_at	The data and time the web map was last modified	True	Datetime
name	The name of the web map	False	String
owner	The owner of the web map	False	String
status	The current alert status of the web map	False	Integer
subtype	The secondary category used to categorize the web map	True	String
system_created_at	The date and time the web map was created	True	Datetime
system_id	The ID used to uniquely identify the web map within its monitoring scope	False	String
type	The primary category used to categorize the web map	False	String

ArcGIS Servers

The ArcGIS Servers table contains attributes for all ArcGIS Server components in a collection.

Name	Description	Nullable	Type
address_internal	The network address of the ArcGIS Server component	False	String
cert_expires_at	The expiration date and time of the configured SSL certificate for ArcGIS Server	True	Datetime
created_at	The date and time the ArcGIS Server component was registered	False	Datetime
description	The long-form description of the ArcGIS Server component	True	String
id	The primary key for the ArcGIS Server component	False	Integer
instances_shared_max	The configured maximum shared instance pool for ArcGIS Server, if applicable	True	Integer
instances_shared_min	The configured minimum shared instance pool for ArcGIS Server, if applicable	True	Integer
is_remote	Specifies whether the ArcGIS Server component is remote	False	Boolean
license_expires_at	The most recent expiration date and time across all configured ArcGIS Server licenses	True	Datetime
name	The name of the ArcGIS Server component	False	String
started_at	The last start time recorded by ArcGIS Server	True	Datetime
status	The current alert status of the ArcGIS Server component	False	Integer
subtype	The secondary category used to categorize the ArcGIS Server component	True	String
system_id	The ID used to uniquely identify the ArcGIS Server component within its monitoring scope	False	String
type	The primary category used to categorize the ArcGIS Server component	False	String
version	The ArcGIS Server software version	True	String

Services

The Services table contains attributes for GIS services from all ArcGIS Server components in a collection.

Name	Description	Nullable	Type
address_internal	The network address of the service	False	String
created_at	The date and time the service was registered	False	Datetime
description	The long-form description of the service	True	String
id	The primary key for the service	False	Integer
idle_time_max	The service's configured SOC idle time-out, if applicable	True	Integer
instance_type	The underlying service provider (shared, dedicated, or hosted)	True	String
instances_max	The service's configured maximum SOC instances, if applicable	True	Integer
instances_min	The service's configured minimum SOC instances, if applicable	True	Integer
is_remote	Specifies whether the service is remote	False	Boolean
is_service_cached	Specifies whether the service is a map or a vector cache	True	Boolean
name	The name of the service	False	String
status	The current alert status of the service	False	Integer
subtype	The general service classification (map, geoprocessing, and so on)	False	String
system_id	The ID used to uniquely identify the service within its monitoring scope	False	String
system_state	The configured state of the service (stopped or running)	True	String
type	The primary category used to categorize the service	False	String
wait_time_max	The service's configured SOC wait time-out, if applicable	True	Integer

Metrics

The Metrics table contains attributes for metrics that are associated with components in a collection.

Name	Description	Nullable	Type
component_id	The unique ID of the component associated with the metric	False	Integer
component_name	The name of the component associated with the metric	False	String
description	The long-form description of the metric	True	String
id	The primary key of the metric	False	Integer
name	The name of the metric	False	String
observed_at	The date and time the metric was measured	False	Datetime
observer_id	The unique ID of the observer that recorded the metric	False	Integer
r_id	The namespaced reference ID of the metric	False	String
status	The current alert status of the metric	False	Integer
unit	The unit of measure used to describe the metric, if applicable	True	String
value	The metric's measured value	False	Float

Alerts

The Alerts table contains attributes for alerts that are associated with components in a collection.

Name	Description	Nullable	Type
aggregation	The mathematical function used to aggregate metric samples for comparison with the alert rule	True	String
closed_at	The date and time the alert was closed	True	Datetime
component_address	The IP address, host name, or URL of the component associated with the alert	False	String
component_id	The unique ID of the component associated with the alert	False	Integer
component_name	The name of the component associated with the alert	False	String
component_subtype	The subtype of component associated with the alert	False	String
component_type	The type of component associated with the alert	False	String
created_at	The date and time the alert was created	False	Datetime
critical_threshold	The metric threshold value that results in a critical alert being opened	True	Float
duration	The alert's duration in minutes	False	Integer
id	The primary key of the alert	False	Integer
info_threshold	The metric threshold value that results in an info alert being opened	True	Float
metric_id	The unique ID of the metric associated with the alert	False	Integer
metric_name	The name of the metric associated with the alert	False	String
metric_r_id	The reference ID of the metric associated with the alert	False	String
metric_unit	The ID of the metric associated with the alert	False	String
observer_id	The unique ID of the observer associated with the component that triggered the alert	False	Integer
opened_at	The date and time the alert was first opened	False	Datetime
operator	The mathematical operator used to compare the aggregated metric samples against the alert thresholds	True	String
samples	The total number of consecutive historical metric samples used to determine the alert's status	True	Integer
state	The current state of the alert	False	String
status	The status of the alert when it was opened	False	Integer
warning_threshold	The metric threshold value that results in a warning alert being opened	True	Float

Connectors

The Connectors table contains attributes for connector components in a collection.

Name	Description	Nullable	Type
address_internal	The network address of the connector	False	String
created_at	The date and time the connector was registered	False	Datetime
description	The long-form description of the connector	True	String
id	The primary key of the connector	False	Integer
name	The name of the connector	False	String
status	The current alert status of the connector	False	Integer
subtype	The secondary category used to categorize the connector	True	String
system_id	The ID used to uniquely identify the connector within its monitoring scope	False	String
system_state	The state of the connector	False	String
type	The primary category used to categorize the connector	False	String

Storage

The Storage table contains attributes for storage components in a collection.

Name	Description	Nullable	Type
address_internal	The network address of the storage component	False	String
created_at	The date and time the storage component was registered	False	Datetime
description	The long-form description of the storage component	True	String
id	The primary key of the storage component	False	Integer
name	The name of the storage component	False	String
status	The current alert status of the storage component	False	Integer
storage_total	The total amount of storage space	False	Float
subtype	The secondary category used to categorize the storage component	True	String
system_id	The ID used to uniquely identify the storage component within its monitoring scope	False	String
type	The primary category used to categorize the storage component	False	String

ArcGIS Data Stores

The Data Stores table contains attributes for ArcGIS Data Store components in a collection.

Name	Description	Nullable	Type
address_internal	The network address of the Data Store component	False	String
connections_max	The maximum number of connections that can be open at one time	False	Integer
created_at	The date and time the Data Store component was registered	False	Datetime
description	The long-form description of the Data Store component	True	String
id	The primary key of the Data Store component	False	Integer
last_backup_at	The last time Data Store was backed up	True	Datetime
memory_total	The total amount of memory (RAM) allocated to Data Store	False	Integer
name	The name of the Data Store component	False	String
started_at	The date and time Data Store was last started	False	Datetime
status	The current alert status of the Data Store component	False	Integer
subtype	The secondary category used to categorize the Data Store component	True	String
system_id	The ID used to uniquely identify the Data Store component within its monitoring scope	False	String
system_mode	Specifies the mode of the system: read read/write	False	String
type	The primary category used to categorize the Data Store component	False	String
version	The software version of Data Store	False	String