AWS MQ Service Tables
The AWS MQ Service integration uses the following tables
Tables
AWSMQBrokerInstances
| Name | Type | Description |
|---|---|---|
| AWSMQBrokerARN | string | The Amazon Resource Name (ARN) of the Amazon MQ broker associated with this instance. |
| ConfigID | integer | Internal configuration identifier used to track this record. |
| EndpointsJson | string | A JSON array of broker instance endpoints used to connect to the broker. |
| ConsoleURL | string | The URL of the AWS Management Console for accessing the broker instance. |
| IpAddress | string | The IP address assigned to the broker instance. |
| BatchDate | datetime | The timestamp when the broker instance data was retrieved or processed. |
| ID | integer | A unique identifier for the broker instance record. |
AWSMQBrokers
| Name | Type | Description |
|---|---|---|
| ARN | string | The Amazon Resource Name (ARN) that uniquely identifies the broker. |
| ConfigID | integer | Internal configuration identifier used to track this record. |
| CurrentConfigurationID | string | Identifier of the current configuration revision applied to the broker. |
| PendingEngineVersion | string | The engine version that is scheduled to be applied during the next maintenance window. |
| PendingAuthenticationStrategy | string | Authentication strategy that is pending update for the broker. |
| PendingSecurityGroupsJson | string | List of security group IDs that are pending update for the broker. |
| State | string | The current state of the broker (e.g., CREATION_IN_PROGRESS, RUNNING, etc.). |
| PendingDataReplicationMode | string | Data replication mode that is pending for update. |
| EngineType | string | Type of broker engine (e.g., ActiveMQ, RabbitMQ). |
| HostInstanceType | string | Broker's instance type (e.g., mq.t3.micro). |
| DataReplicationMode | string | The broker's current data replication mode (CRDR, NONE, etc.). |
| PubliclyAccessible | bit | Boolean indicating if the broker is publicly accessible. |
| LogAudit | bit | Boolean indicating if audit logging is enabled. |
| AuditLogGroup | string | CloudWatch log group name for audit logs. |
| LogGeneral | bit | Boolean indicating if general logging is enabled. |
| GeneralLogGroup | string | CloudWatch log group name for general logs. |
| PendingLogGeneral | bit | Boolean indicating if general logging will be enabled in the future. |
| PendingLogAudit | bit | Boolean indicating if audit logging will be enabled in the future. |
| LDAPRoleSearchMatching | string | LDAP role search filter used for matching roles. |
| LDAPRoleBase | string | Base DN for LDAP role search. |
| LDAPHostsJson | string | JSON list of LDAP server hostnames. |
| LDAPRoleName | string | The LDAP role name assigned for access control. |
| LDAPUserBase | string | Base DN for LDAP user search. |
| LDAPRoleSearchSubtree | bit | Boolean indicating if the LDAP role search should recursively search subtrees. |
| LDAPServiceAccountUsername | string | The LDAP service account username used for binding. |
| LDAPUserRoleName | string | LDAP role name that is assigned to users. |
| LDAPUserSearchMatching | string | LDAP search filter to match users. |
| LDAPUserSearchSubtree | bit | Boolean indicating if user search includes subtree. |
| PendingHostInstanceType | string | The broker instance type that will be applied in the next update. |
| EngineVersion | string | Current version of the broker engine. |
| MaintenanceWindowStartTimeDayOfWeek | string | Day of the week when maintenance window starts. |
| MaintenanceWindowStartTimeTimeZone | string | Time zone for the maintenance window. |
| MaintenanceWindowStartTimeTimeOfDay | string | Time of day when maintenance begins. |
| Created | datetime | The timestamp of when the broker was created. |
| DeploymentMode | string | Deployment mode (e.g., SINGLE_INSTANCE, ACTIVE_STANDBY_MULTI_AZ). |
| AuthenticationStrategy | string | The broker’s authentication strategy. |
| DataReplicationRole | string | IAM role used for data replication. |
| DataReplicationCounterpartRegion | string | Region of the data replication counterpart broker. |
| PendingLDAPRoleSearchMatching | string | Pending LDAP role search filter. |
| PendingLDAPRoleBase | string | Pending LDAP role search base DN. |
| PendingLDAPHostsJson | string | Pending list of LDAP server hostnames. |
| PendingLDAPRoleName | string | Pending LDAP role name. |
| PendingLDAPUserBase | string | Pending LDAP user base DN. |
| PendingLDAPRoleSearchSubtree | bit | Pending LDAP role search subtree flag. |
| PendingLDAPServiceAccountUsername | string | Pending LDAP service account username. |
| PendingLDAPUserRoleName | string | Pending LDAP user role name. |
| PendingLDAPUserSearchMatching | string | Pending LDAP user search filter. |
| PendingLDAPUserSearchSubtree | bit | Pending LDAP user search subtree flag. |
| EncryptionOptionsUseAWSOwnedKey | bit | Boolean indicating whether the broker uses an AWS owned KMS key for encryption. |
| PendingDataReplicationRole | string | IAM role that will be used for data replication after pending changes. |
| PendingDataReplicationCounterpartRegion | string | Region of the pending data replication counterpart broker. |
| StorageType | string | Storage type of the broker (EBS, EFS, etc.). |
| SecurityGroupsJson | string | JSON list of security group IDs associated with the broker. |
| Name | string | The name of the broker. |
| AutoMinorVersionUpgrade | bit | Boolean indicating if minor engine version upgrades are automatically applied. |
| BatchDate | datetime | The timestamp when the broker data was last retrieved. |
| DataReplicationCounterpartBrokerID | string | ID of the current replication counterpart broker. |
| EncryptionOptionsKMSeyID | string | KMS Key ID used for encryption at rest. |
| ID | string | Unique identifier for the broker metadata record. |
| PendingDataReplicationCounterpartBrokerID | string | ID of the replication counterpart broker in a pending state. |
| SubnetIDsJson | string | List of VPC subnet IDs attached to the broker. |
| PendingConfigurationID | string | ID of the broker configuration that is pending to be applied. |
AWSMQConfigurations
| Name | Type | Description |
|---|---|---|
| ARN | string | The Amazon Resource Name (ARN) that uniquely identifies the configuration. |
| AWSMQBrokerConfigID | integer | Internal identifier linking this configuration to a specific broker configuration version. |
| ConfigID | integer | Internal configuration identifier used to track this record. |
| AWSMQBrokerARN | string | ARN of the broker that uses or is associated with this configuration. |
| Name | string | Name assigned to the configuration. |
| LatestRevision | integer | The latest revision number of the configuration. |
| LatestRevisionCreated | datetime | Timestamp when the latest revision was created. |
| latestRevisionDescription | string | Description associated with the latest configuration revision. |
| AuthenticationStrategy | string | The authentication strategy (e.g., simple, LDAP) used in the configuration. |
| EngineType | string | Type of broker engine (e.g., ActiveMQ, RabbitMQ) the configuration is intended for. |
| Created | datetime | The date and time when the configuration was created. |
| EngineVersion | string | The broker engine version the configuration supports. |
| IsCurrent | bit | Boolean indicating whether this configuration is currently applied to the broker. |
| IsPending | bit | Boolean indicating whether this configuration is pending application to the broker. |
| BatchDate | datetime | The timestamp when the configuration data was retrieved or recorded. |
| ID | string | Unique internal identifier for the configuration record. |
AWSMQRequiredActions
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | Internal configuration identifier used to track this record. |
| Code | string | A short string or code representing the type of required action (e.g., RESTART, UPDATE). |
| Info | string | Additional information or context about the required action. |
| BatchDate | datetime | The timestamp when the required action data was retrieved or recorded. |
| ID | integer | Unique internal identifier for the required action record. |
AWSMQUsers
| Name | Type | Description |
|---|---|---|
| AWSMQBrokerConfigID | integer | Identifier for the MQ broker configuration associated with the user. |
| AWSMQBrokerARN | string | The Amazon Resource Name (ARN) of the MQ broker associated with the user. |
| ConfigID | integer | Internal configuration identifier tracking the state or version of the user. |
| Username | string | The username of the broker user. |
| ConsoleAccess | bit | A boolean indicating whether the user has access to the Amazon MQ console. |
| ReplicationUser | bit | Indicates if the user is designated for replication between brokers. |
| GroupsJson | string | JSON list of groups to which the user belongs. |
| PendingChangeType | string | Describes the type of change (e.g., add, modify, delete) that is pending for this user. |
| PendingConsoleAccess | bit | A boolean showing the console access setting that will take effect after the pending change. |
| PendingGroupsJson | string | JSON list of groups the user will be part of once the pending change is applied. |
| BatchDate | datetime | The date the data batch was created or recorded. |
| ID | integer | Unique identifier for the user record. |
Bridge Table
AWSMQBrokers_AWSMQRequiredActions
| Name | Type | Description |
|---|---|---|
| AWSMQBrokerConfigID | integer | Internal configuration identifier used to track the brokers configuration. |
| AWSMQRequiredActionConfigID | integer | Internal configuration identifier used to track the required actions. |
| AWSMQBrokerARN | string | The Amazon Resource Name (ARN) that uniquely identifies the broker. |
| AWSMQRequiredActionID | integer | Unique internal identifier for the required action record. |
Updated over 1 year ago
Learn more...
Did this page help you?