AWS Panorama Service Tables
The AWS Panorama Service integration uses the following tables
Tables
AWSPanoramaApplicationInstances
| Name | Type | Description |
|---|---|---|
| ARN | string | The Amazon Resource Name (ARN) that uniquely identifies the application instance. |
| AWSPanoramaDefaultRuntimeContextDeviceConfigID | integer | Internal identifier linking the application instance to its default runtime context device configuration. |
| ConfigID | integer | Internal configuration identifier used to track this record. |
| AWSPanoramaDefaultRuntimeContextDeviceARN | string | The ARN of the device that serves as the default runtime context for the application instance. |
| CreatedTime | datetime | The timestamp when the application instance was created. |
| LastUpdatedTime | datetime | The timestamp when the application instance was last updated. |
| Name | string | The name assigned to the application instance. |
| Description | string | A description of the application instance. |
| HealthStatus | string | The health status of the application instance. Valid values include RUNNING, ERROR, and NOT_AVAILABLE. |
| Status | string | The current deployment status of the application instance. Possible values include DEPLOYMENT_PENDING, DEPLOYMENT_REQUESTED, DEPLOYMENT_IN_PROGRESS, DEPLOYMENT_ERROR, DEPLOYMENT_SUCCEEDED, REMOVAL_PENDING, REMOVAL_REQUESTED, REMOVAL_IN_PROGRESS, REMOVAL_FAILED, REMOVAL_SUCCEEDED, and DEPLOYMENT_FAILED. |
| StatusDescription | string | A description providing additional details about the current status of the application instance. |
| BatchDate | datetime | The timestamp when the application instance data was retrieved or recorded. |
| RuntimeRoleARN | string | The ARN of the IAM role assigned to the application instance for runtime operations. |
| ApplicationInstanceIDToReplace | string | The ID of the application instance that this instance is intended to replace. |
| ID | string | Unique internal identifier for the application instance record. |
AWSPanoramaDeviceJobs
| Name | Type | Description |
|---|---|---|
| AWSPanoramaDeviceConfigID | integer | Internal identifier linking the device job to a specific AWS Panorama device configuration. |
| ConfigID | integer | Internal configuration identifier used to track this record. |
| AWSPanoramaDeviceARN | string | The Amazon Resource Name (ARN) of the AWS Panorama device associated with the job. |
| Type | string | The type of job to run on the device. Valid values include OTA (Over-the-Air update) and REBOOT. |
| ImageVersion | string | For an OTA job, the target version of the device software to be installed. |
| Status | string | The current status of the device job. Possible values include PENDING, IN_PROGRESS, COMPLETED, and FAILED. |
| CreatedTime | datetime | The timestamp when the device job was created. |
| OTAJobConfigAllowMajorVersionUpdate | bit | A boolean indicating whether to apply the update if it is a major version change. This setting is part of the OTA job configuration. |
| BatchDate | datetime | The timestamp when the device job data was retrieved or recorded. |
| ID | string | Unique internal identifier for the device job record. |
AWSPanoramaDevices
| Name | Type | Description |
|---|---|---|
| ARN | string | The Amazon Resource Name (ARN) that uniquely identifies the Panorama device. |
| ConfigID | integer | Internal identifier for tracking the configuration. |
| Brand | string | The brand or manufacturer of the device. |
| Name | string | The name assigned to the Panorama device. |
| CurrentSoftware | string | The currently running version of the device software. |
| LatestSoftware | string | The latest available version of the software for this device. |
| LatestAlternateSoftware | string | The latest alternate software version available for fallback or testing. |
| Description | string | A user-provided description of the device. |
| CreatedTime | datetime | The timestamp when the device was created in AWS Panorama. |
| LastUpdatedTime | datetime | The most recent time the device record was updated. |
| LeaseExpirationTime | datetime | The expiration timestamp of the current lease assigned to the device. |
| AggregatedStatus | string | The combined status of the device based on hardware, software, and network components. |
| ConnectionStatus | string | General connectivity status of the device (e.g., CONNECTED, DISCONNECTED). |
| CurrentEthernet0ConnectionStatus | string | Status of the Ethernet 0 interface connection. |
| CurrentEthernet0HwAddress | string | MAC address of the Ethernet 0 interface. |
| CurrentEthernet0IpAddress | string | IP address currently assigned to Ethernet 0. |
| CurrentEthernet1ConnectionStatus | string | Status of the Ethernet 1 interface connection. |
| CurrentEthernet1HwAddress | string | MAC address of the Ethernet 1 interface. |
| CurrentEthernet1IpAddress | string | IP address currently assigned to Ethernet 1. |
| CurrentNTPConnectionStatus | string | Current connection status to the configured NTP server. |
| CurrentNTPServerName | string | The hostname or domain of the NTP server the device is using. |
| CurrentNTPIpAddress | string | IP address of the connected NTP server. |
| Ethernet0PayloadConnectionType | string | Configuration of Ethernet 0 (DHCP or STATIC). |
| Ethernet0PayloadStaticIPDefaultGateway | string | Default gateway for static IP on Ethernet 0. |
| Ethernet0PayloadStaticIPDNSJson | string | JSON-encoded list of DNS servers for static IP config on Ethernet 0. |
| Ethernet0PayloadStaticIPAddress | string | static IP address assigned to Ethernet 0. |
| Ethernet0PayloadStaticIPMask | string | Subnet mask for static IP on Ethernet 0. |
| Ethernet1PayloadConnectionType | string | Configuration of Ethernet 1 (DHCP or STATIC). |
| Ethernet1PayloadStaticIPDefaultGateway | string | Default gateway for static IP on Ethernet 1. |
| Ethernet1PayloadStaticIPDNSJson | string | JSON-encoded list of DNS servers for static IP config on Ethernet 1. |
| Ethernet1PayloadStaticIPAddress | string | static IP address assigned to Ethernet 1. |
| Ethernet1PayloadStaticIPMask | string | Subnet mask for static IP on Ethernet 1. |
| NTPPayloadServersJson | string | JSON-encoded list of configured NTP server addresses. |
| CurrentNetworkingStatusLastUpdatedTime | datetime | Timestamp of the last update to the networking status. |
| ProvisioningStatus | string | Status of the provisioning process for the device. |
| AlternateSoftwareVersionsJson | string | JSON list of alternate software versions available to the device. |
| SerialNumber | string | The manufacturer-assigned serial number of the device. |
| Region | string | AWS region in which the device is registered. |
| Type | string | The type or model classification of the Panorama device. |
| BatchDate | datetime | The timestamp of when the data was recorded or synced. |
| ID | string | Unique internal identifier for the record. |
AWSPanoramaNodeInputPorts
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Internal identifier for tracking the configuration of the input port. |
| MaxConnections | integer | The maximum number of allowed connections to this input port. |
| DefaultValue | string | The default value assigned to the input port if no connection is made. |
| Name | string | The name of the input port. |
| Type | string | The data type expected by this input port (e.g., STRING, INT, etc.). |
| Description | string | A textual description of the purpose or usage of the input port. |
| BatchDate | datetime | The timestamp indicating when this data was collected or processed. |
| ID | integer | Unique internal identifier for this input port entry. |
AWSPanoramaNodeOutputPorts
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | A unique identifier referencing the configuration associated with the output port. |
| Name | string | The name assigned to the output port. This helps identify the port in a node graph or application. |
| Type | string | The data type of the output port, such as boolean, int32, string, etc. |
| Description | string | A brief explanation of what the output port does or what data it emits. |
| BatchDate | datetime | The date when the data related to this port configuration was collected or recorded. |
| ID | integer | A unique identifier for the output port record. |
AWSPanoramaNodes
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | A unique identifier referencing the node configuration. |
| CurrentStatus | string | The current status of the node (e.g., DEPLOYED, PENDING, ERROR). |
| Category | string | The type or classification of the node, such as application, model, or camera. |
| Name | string | The name assigned to the node. |
| AssetName | string | The asset or resource name associated with the node. |
| Description | string | A description of what the node represents or does. |
| OwnerAccount | string | The AWS account ID that owns the node. |
| CreatedTime | datetime | The timestamp when the node was created. |
| LastUpdatedTime | datetime | The timestamp of the last update to the node. |
| BatchDate | datetime | The date when the data for this node was recorded. |
| ID | string | A unique identifier for the node record. |
| InstanceID | string | The identifier of the application instance the node is associated with. |
AWSPanoramaPackages
| Name | Type | Description |
|---|---|---|
| ARN | string | The Amazon Resource Name that uniquely identifies the Panorama package. |
| ConfigID | integer | The internal configuration identifier for this package. |
| ReadAccessPrincipalARNJson | string | A JSON list of ARNs that have read access to the package. |
| PatchVersion | string | The patch version number of the package. |
| Version | string | The overall version number of the package. |
| Name | string | The name of the Panorama package. |
| CreatedTime | datetime | The timestamp when the package was created. |
| StorageLocationBinaryPrefixLocation | string | The S3 prefix location where the binary files for the package are stored. |
| StorageLocationGeneratedPrefixLocation | string | The S3 prefix location for generated files related to the package. |
| StorageLocationManifestPrefixLocation | string | The S3 prefix location where the package manifest is stored. |
| StorageLocationRepoPrefixLocation | string | The S3 prefix location for the package repository files. |
| StorageLocationBucket | string | The name of the S3 bucket containing the package resources. |
| BatchDate | datetime | The date when this data was batched or ingested. |
| ID | string | A unique identifier for the Panorama package record. |
| WriteAccessPrincipalARNJson | string | A JSON list of ARNs that have write access to the package. |
AWSPanoramaReportedRuntimeContextStates
| Name | Type | Description |
|---|---|---|
| AWSPanoramaApplicationInstanceConfigID | integer | Identifier linking the runtime context state to the configuration of a Panorama application instance. |
| AWSPanoramaApplicationInstanceARN | string | The Amazon Resource Name of the Panorama application instance reporting the context state. |
| ConfigID | integer | Internal configuration identifier for the reported runtime context state. |
| DesiredState | string | The intended or desired operational state for the runtime context (e.g., RUNNING, STOPPED). |
| DeviceReportedStatus | string | The current status of the context as reported by the device (e.g., RUNNING, ERROR). |
| DeviceReportedTime | datetime | The timestamp of when the device reported this status. |
| BatchDate | datetime | The date the data was ingested or processed. |
| ID | integer | Unique identifier for the runtime context state entry. |
Bridge Tables
AWSPanoramaApplicationInstances_AWSPanoramaNodes
| Name | Type | Description |
|---|---|---|
| AWSPanoramaApplicationInstanceConfigID | integer | Internal configuration identifier used to track the application instance. |
| AWSPanoramaNodeConfigID | integer | A unique identifier referencing the node configuration. |
| AWSPanoramaApplicationInstanceARN | string | The Amazon Resource Name (ARN) that uniquely identifies the application instance. |
| AWSPanoramaNodeID | string | A unique identifier for the node record. |
| AWSPanoramaNodeInstanceID | string | A unique identifier for the node instance record. |
AWSPanoramaNodes_AWSPanoramaNodeInputPorts
| Name | Type | Description |
|---|---|---|
| AWSPanoramaNodeConfigID | integer | A unique identifier referencing the node configuration. |
| AWSPanoramaNodeInputPortConfigID | integer | Internal identifier for tracking the configuration of the input port. |
| AWSPanoramaNodeID | string | A unique identifier for the node record. |
| AWSPanoramaNodeInputPortID | integer | Unique internal identifier for this input port entry. |
| AWSPanoramaNodeInstanceID | string | A unique identifier for the node instance record. |
AWSPanoramaNodes_AWSPanoramaNodeOutputPorts
| Name | Type | Description |
|---|---|---|
| AWSPanoramaNodeConfigID | integer | A unique identifier referencing the node configuration. |
| AWSPanoramaNodeOutputPortConfigID | integer | Internal identifier for tracking the configuration of the input port. |
| AWSPanoramaNodeID | string | A unique identifier for the node record. |
| AWSPanoramaNodeInstanceID | string | A unique identifier for the node instance record. |
| AWSPanoramaNodeOutputPortID | integer | A unique identifier for the output port record. |
AWSPanoramaNodes_AWSPanoramaPackages
| Name | Type | Description |
|---|---|---|
| AWSPanoramaNodeConfigID | integer | A unique identifier referencing the node configuration. |
| AWSPanoramaPackageConfigID | integer | Internal identifier for tracking the configuration of the input port. |
| AWSPanoramaPackageARN | string | The Amazon Resource Name that uniquely identifies the Panorama package. |
| AWSPanoramaPackageVersion | string | The overall version number of the package. |
| AWSPanoramaPackagePatchVersion | string | The patch version number of the package. |
| AWSPanoramaNodeID | string | A unique identifier for the node record. |
| AWSPanoramaNodeInstanceID | string | A unique identifier for the node instance record. |
Updated over 1 year ago
Learn more...
Did this page help you?