Collection feature service schema

ArcGIS Monitor collections allow you to serve feature service tables over the internet or your intranet. This allows you to make your 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	The network address of the host.	False	String
agent_id	The unique ID of the ArcGIS Monitor Agent machine responsible for monitoring the component.	False	Integer
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
description	The long-form description of the host component.	True	String
location	The host component's cloud region, if applicable.	True	String
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
version	The host component's OS version.	True	String

Databases

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

Name	Description	Nullable	Type
address	The network address of the database component.	False	String
agent_id	The unique ID of the Monitor Agent machine responsible for monitoring the component.	False	Integer
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
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, SQL Server).	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 within a collection.

Name	Description	Nullable	Type
address	The network address of the Portal for ArcGIS component.	False	String
agent_id	The unique ID of the Monitor Agent machine responsible for monitoring the component.	False	Integer
cert_expires_at	The expiration date and time of the configured SSL certificate for Portal.	True	Datetime
description	The long-form description of the Portal for ArcGIS component.	True	String
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
version	The Portal for ArcGIS component's software version.	True	String

ArcGIS Servers

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

Name	Description	Nullable	Type
address	The network address of ArcGIS Server.	False	String
agent_id	The unique ID of the Monitor Agent machine responsible for monitoring the component.	False	Integer
cert_expires_at	The expiration date and time of the configured SSL certificate for ArcGIS Server.	True	Datetime
description	The long-form description of the ArcGIS Server component.	True	String
instances_shared_max	The configured max shared instance pool for ArcGIS Server, if applicable.	True	Integer
instances_shared_min	The configured min shared instance pool for ArcGIS Server, if applicable.	True	Integer
license_expires_at	The most recent expiration date and time across all configured ArcGIS Server licenses.	True	Datetime
name	The name of 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
version	The ArcGIS Server software version.	True	String

Services

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

Name	Description	Nullable	Type
address	The network address of the service.	False	String
agent_id	The unique ID of the Monitor Agent responsible for monitoring the component.	False	Integer
configured_state	The configured state of the service (stopped or running).	True	String
idle_time_max	The service's configured SOC idle timeout, if applicable.	True	Integer
instance_type	The underlying service provider (shared, dedicated, or hosted).	True	String
instances_max	The service's configured max SOC instances, if applicable.	True	Integer
instances_min	The service's configured min SOC instances, if applicable.	True	Integer
is_service_cached	Specifies if 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
wait_time_max	The service's configured SOC wait timeout, if applicable.	True	Integer

Metrics

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

Name	Description	Nullable	Type
aggregation	The mathematical function used to aggregate metric samples for comparison against the alert rule.	True	String
component_id	The unique ID of the component associated with the metric.	False	Integer
critical_threshold	The metric threshold value that results in a critical alert being opened.	True	Float
description	The long-form description of the metric.	True	String
info_threshold	The metric threshold value that results in an info alert being opened.	True	Float
is_alerting_enabled	Specifies if the metric is configured to alert.	False	Boolean
name	The name of the metric.	False	String
observer_id	The unique ID of the observer that recorded the metric.	False	Integer
operator	The mathematical operator used to compare the aggregated metric samples against the alert thresholds.	True	String
r_id	The namespaced reference ID of the metric.	False	String
samples	The total number of consecutive historical metric samples used to determine the alert status.	True	Integer
status	The current alert status of the metric.	False	Integer
unit	The unit of measure used to describe the metric, if applicable.	True	String
warning_threshold	The metric threshold value that results in a warning alert being opened.	True	Float

Alerts

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

Name	Description	Nullable	Type
aggregation	The mathematical function used to aggregate metric samples for comparison against the alert rule.	True	String
closed_at	The date and time that the alert was closed.	True	Datetime
component_address	The IP address, hostname, 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 component associated with the alert.	False	String
component_type	The type of component associated with the alert.	False	String
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
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
observer_id	The unique ID of the observer associated with the component that triggered the alert.	False	Integer
observer_name	The name of the observer associated with the alert.	False	String
opened_at	The date and time that 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