Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere, on-demand edition 1.0 Support Package 3 » SAP Sybase SQL Anywhere, on-demand edition 1.0 » Search queries » Cloud object attributes

 

Cloud attributes

Cloud attributes describe settings and characteristics of the cloud.

Attribute name Description
object_id

A unique ID identifying the object within the cloud.

object_type

The object type.

The following values are supported:

  • Object   All cloud objects.

  • AgentAction   An agent action.

  • Backup   A backup.

  • Cloud   The cloud.

  • Database   A database.

  • DatabaseCopy   A copy of a database.

  • DataType   Internal use only.

  • Event   An event.

  • EventType   An event type.

  • Filter   A filter.

  • Host   A host.

  • MaintenancePlan   A maintenance plan.

  • Rule   A rule.

  • Schedule   A schedule.

  • Server   A cloud server.

  • StagingDirectory   A staging directory.

  • Tag   A tag.

  • Task   A task.

  • TaskDefinition   A task definition.

  • User   A cloud user.

  • InstallImage   Internal use only.

  • BackupCopy   A copy of a backup.

  • MaintPlanExecution   An execution of a maintenance plan.

  • MaintPlanExecutionDetail   A database backup from a maintenance plan.

object_uri

The relative URI to this object.

unique_id

A GUID that uniquely identifies the object across all clouds.

object_status

The object status.

The following values are supported:

  • VALID   The object has not been deleted.

  • DISABLED   The object is in the process of being created or deleted.

  • DELETED   The object has been deleted. The information about the object is retained for historical purposes for a period of time.

object_name

The object name.

creation_time

The time (with timezone) when the object was created.

last_log_modified_time

The time (with timezone) when the object was last modified.

resource_uri

A relative URI to the feed containing objects of this type.

modifying_task

The ID of the task currently modifying the object, or NULL.

title

The title of the object. For object types with a name, this is the same as the object_name attributes. For other types such as Event, Backup, and Task, the title attribute is set to a human-readable string generated to be short (one line).

summary

A description of the object. For object types that support a user-edited description, this is the user-edited description. For other types such as Event, Backup and Task, this is a longer descriptive string (one or more paragraphs).

running_status

The current status of the object.

The following values are supported:

  • stopped   Not running.

  • starting   In the process of being started.

  • running   Running and responding to requests.

  • stopping   In the process of being stopped.

  • disconnected   Inaccessible, but expected to be running.

  • dropping   In the process of being dropped.

  • dropped   Dropped.

  • waiting_for_uid_pwd   Waiting for the correct user ID and/or password.

  • stopped_unconditionally   Stopped when the parent object was stopped unconditionally.

  • failed   Not running (failed).

  • unresponsive   Running but not responding to requests.

run_mode

The expected status of the object.

The following values are supported:

  • stop   The object should not be running.

  • run   The object should be running and accepting requests.

  • maintenance   The object is being maintained.

start_time

The time when the object's running_status is set to "running".

max_active_event_severity

The highest severity level among all active events on this object.

The following values are supported:

  • Critical   The event is an error that may affect the proper functioning of the cloud.

  • Error   The event is an error associated with a task or single object.

  • Warning   The event is an unusual or anomalous condition that may cause future errors. (For example, when the free disk space on a host is low, a warning event is recorded.)

  • Info   The event is normal, and recorded for information only.

  • Debug   Internal use only.

retention_period_num

The length of time that historical data is retained.

retention_period_unit

The units that the retention_period_num column is expressed in: S - seconds, M - minutes, H - hours, D - days, W - weeks.

The following values are supported:

  • L   Milliseconds.

  • S   Seconds.

  • M   Minutes.

  • H   Hours.

  • D   Days.

  • W   Weeks.

last_permission_to_run

The most recent time that the Usage Server indicated this cloud has permission to run.

utility_enabled

Set to 1 if utility billing has been enabled for the cloud.

licensed_by_cores

Set to 1 if the cloud is licensed by perpetual and/or utility cores; 0 if the cloud is licensed by another method.

usage_server_enabled

Set to 1 if usage information uploads to the Usage Server are enabled; 0 otherwise.

utility_cores_authorized

The number of variable cores authorized for the cloud.

perpetual_cores_assigned

The number of perpetual core licenses assigned to this cloud.

total_core_hours_used

The total number of core hours accumulated to this cloud over its lifetime.

license_state

A value that specifies whether the cloud is within the terms of its license.

The following values are supported:

  • inactive   The cloud is not owned by a usage server account.

  • reduced_inactive   The cloud is not owned by a usage server account and has run for longer than the evaluation period.

  • active   The cloud is owned by a usage server account in good standing.

  • too_many_cores   The cloud is using more cores than it is authorized for.

  • reduced_too_many_cores   The cloud is using more cores than it is authorized for and has been placed in reduced-functionality mode.

  • account_problem   The usage server account that owns this cloud is not in good standing. Please contact SAP.

  • reduced_account_problem   The usage server account that owns this cloud is not in good standing, and the cloud has been placed in reduced-functionality mode. Please contact SAP.

  • no_usage_upload   The cloud has not been able to connect to the SAP usage server recently.

  • reduced_no_usage_upload   The cloud has not been able to connect to the SAP usage server recently and has been placed in reduced-functionality mode.

smtp_from_address

The sending email address.

smtp_server

The host name or IP address of the SMTP server.

smtp_port

The port number of the SMTP server.

smtp_certificate

The certificate for validating the SMTP server if a TLS connection is used.

smtp_username

The user name for the SMTP server.

tcp_ports

The TCP/IP port numbers and/or a set of port ranges separated by commas.

http_ports

The HTTP port numbers and/or a set of port ranges separated by commas.

https_ports

The HTTPS port numbers and/or a set of port ranges separated by commas.

language

The language code for the cloud.

The following values are supported:

  • cloud   Cloud default language.

  • de   German.

  • en   English.

  • fr   French.

  • ja   Japanese.

  • zh   Chinese.

time_zone_adjustment

The time zone used when formatting time strings.

upgrade_start_time

The time when the UpgradeCloudInfrastructure task started. This column is NULL if no upgrade is in progress.

upgrade_percent_complete

The approximate percentage of the UpgradeCloudInfrastructure task that has completed. This column is NULL if no upgrade is in progress.

upgrade_stage

The current stage of the UpgradeCloudInfrastructure task. Each stage can have a percent complete ranging from 0 to 100. This column is NULL if no upgrade is in progress.

upgrade_progress_detail

A description of the current step of the UpgradeCloudInfrastructure. This column is NULL if no upgrade is in progress.

fips_mode

A value indicating whether the cloud is in FIPS mode.

unload_patch_build

The patch level of the unload software.

usage_proxy

The proxy server to use for connecting to the usage server.

autostart_timeout

The maximum time in seconds to attempt to autostart a database during a client connection attempt. This only applies to databases that have autostart enabled.

cloud_history

A summary of significant operations for the cloud.

 See also