AWS Systems Manager Tables
The AWS Systems Manager integration uses the following tables
Tables
AWSSSMCommandInvocations
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | A unique identifier for the configuration of the command. |
| Status | string | The current status of the command (e.g., Pending, InProgress, Success, Failed). |
| InstanceName | string | The name of the instance that the command was run on. |
| Comment | string | A description or comment about the command. |
| DocumentName | string | The name of the Systems Manager document (SSM document) that was used to run the command. |
| DocumentVersion | string | The version of the SSM document used. |
| RequestedDateTime | datetime | The date and time when the command was requested. |
| StatusDetails | string | A detailed status message, explaining the status of the command (e.g., error messages). |
| TraceOutput | string | The trace output from the command execution, if available. |
| StandardOutputUrl | string | The URL of the Amazon S3 location where the standard output of the command is stored. |
| StandardErrorUrl | string | The URL of the Amazon S3 location where the standard error output of the command is stored. |
| CommandPluginsJson | string | JSON format data for the plugins used in the command execution. |
| BatchDate | datetime | The date the command was executed in batch mode, if applicable. |
| AWSSSMCommandID | string | A unique identifier for the command within AWS Systems Manager. |
| CommandID | string | A unique identifier for the specific command that was executed. |
| ID | integer | The identifier associated with the command entry in AWS Systems Manager. |
| InstanceID | string | The unique identifier of the instance on which the command was executed. |
AWSSSMCommands
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | A unique identifier for the configuration of the command. |
| DocumentName | string | The name of the Systems Manager document (SSM document) that defines the actions executed by the command. |
| DocumentVersion | string | The version of the SSM document used to execute the command. |
| Comment | string | A description or comment about the command that was run. |
| ExpiresAfter | datetime | The timestamp when the command expires and will no longer be executed. |
| ParametersJson | string | A JSON object that defines the parameters provided to the document during the command execution. |
| TargetsJson | string | A JSON object that defines the targets (instances) for the command execution. |
| RequestedDateTime | datetime | The date and time when the command was requested. |
| Status | string | The current status of the command (e.g., Pending, InProgress, Success, Failed). |
| StatusDetails | string | A detailed status message providing additional information about the current status of the command. |
| OutputS3Region | string | The AWS region where the S3 bucket that holds the command output is located. |
| OutputS3BucketName | string | The name of the S3 bucket where the output of the command is stored. |
| OutputS3KeyPrefix | string | The prefix for the S3 object key where the command output is stored. |
| MaxConcurrency | string | The maximum number of targets (instances) that can run the command concurrently. |
| MaxErrors | string | The maximum number of errors that are allowed before the command is considered a failure. |
| TargetCount | integer | The total number of target instances that the command was executed on. |
| CompletedCount | integer | The number of targets where the command completed successfully. |
| ErrorCount | integer | The number of targets where the command failed to execute properly. |
| DeliveryTimedOutCount | integer | The number of targets where the command delivery timed out. |
| ServiceRole | string | The IAM role assumed by the Systems Manager service to execute the command on the target instances. |
| NotificationConfigJson | string | A JSON object that contains the configuration for command notifications (e.g., SNS notifications). |
| CloudWatchOutputConfigJson | string | A JSON object containing the configuration for sending command output to Amazon CloudWatch Logs. |
| BatchDate | datetime | The date when the command was executed in batch mode, if applicable. |
| CommandID | string | A unique identifier for the command. |
| InstanceIDsJson | string | A JSON object that contains the IDs of the instances on which the command was executed. |
AWSSSMParameters
| Name | Type | Description |
|---|---|---|
| ARN | string | The Amazon Resource Name (ARN) of the parameter, which uniquely identifies it within AWS. |
| ConfigID | integer | A unique identifier for the configuration of the parameter. |
| Name | string | The name of the parameter. |
| Type | string | The type of the parameter (e.g., String, SecureString, StringList). |
| Value | string | The value of the parameter, which can be a simple string or a JSON-encoded string for more complex data. |
| LastModifiedDate | datetime | The date and time when the parameter was last modified. |
| Version | bigint | The version number of the parameter. |
| DataType | string | The data type of the parameter value (e.g., text, string, json). |
| BatchDate | datetime | The date when the parameter was processed in batch mode, if applicable. |
Updated over 1 year ago
Learn more...
Did this page help you?