AWS API Changes

2025/11/17 - Amazon Elastic Compute Cloud - 4 new api methods

Changes This release introduces new APIs: DescribeInstanceSqlHaStates, DescribeInstanceSqlHaHistoryStates, EnableInstanceSqlHaStandbyDetections and DisableInstanceSqlHaStandbyDetections on Amazon EC2, allowing customers to enroll and monitor SQL Server licensing fee savings for their SQL HA EC2 instances.

DescribeInstanceSqlHaHistoryStates (new)

Link ¶

Describes the historical SQL Server High Availability states for Amazon EC2 instances that are enabled for Amazon EC2 High Availability for SQL Server monitoring.

See also: AWS API Documentation

Request Syntax

client.describe_instance_sql_ha_history_states(
    InstanceIds=[
        'string',
    ],
    StartTime=datetime(2015, 1, 1),
    EndTime=datetime(2015, 1, 1),
    NextToken='string',
    MaxResults=123,
    Filters=[
        {
            'Name': 'string',
            'Values': [
                'string',
            ]
        },
    ],
    DryRun=True|False
)

type InstanceIds:

list

param InstanceIds:

The IDs of the SQL Server High Availability instances to describe. If omitted, the API returns historical states for all SQL Server High Availability instances.

(string) --

type StartTime:

datetime

param StartTime:

The start data and time of the period for which to get the historical SQL Server High Availability states. If omitted, the API returns all available historical states.

Timezone: UTC

Format: YYYY-MM-DDThh:mm:ss.sssZ

type EndTime:

datetime

param EndTime:

The end data and time of the period for which to get historical SQL Server High Availability states. If omitted, the API returns historical states up to the current date and time.

Timezone: UTC

Format: YYYY-MM-DDThh:mm:ss.sssZ

type NextToken:

string

param NextToken:

The token to use to retrieve the next page of results.

type MaxResults:

integer

param MaxResults:

The maximum number of results to return for the request in a single page. The remaining results can be seen by sending another request with the returned nextToken value.

type Filters:

list

param Filters:

One or more filters to apply to the results. Supported filters include:

tag:<key> - The tag key and value pair assigned to the instance. For example, to find all instances tagged with Owner:TeamA, specify tag:Owner for the filter name and TeamA for the filter value.
tag-key - The tag key assigned to the instance.
haStatus - The SQL Server High Availability status of the SQL Server High Availability instance ( processing | active | standby | invalid).
sqlServerLicenseUsage - The license type for the SQL Server license ( full | waived).

(dict) --

A filter name and value pair that is used to return a more specific list of results from a describe operation. Filters can be used to match a set of resources by specific criteria, such as tags, attributes, or IDs.

If you specify multiple filters, the filters are joined with an AND, and the request returns only results that match all of the specified filters.

For more information, see List and filter using the CLI and API in the Amazon EC2 User Guide.
- Name (string) --
  
  The name of the filter. Filter names are case-sensitive.
- Values (list) --
  
  The filter values. Filter values are case-sensitive. If you specify multiple values for a filter, the values are joined with an OR, and the request returns all results that match any of the specified values.
  - (string) --

type DryRun:

boolean

param DryRun:

Checks whether you have the required permissions for the action, without actually making the request, and provides an error response. If you have the required permissions, the error response is DryRunOperation. Otherwise, it is UnauthorizedOperation.

rtype:

dict

returns:

Response Syntax

{
    'Instances': [
        {
            'InstanceId': 'string',
            'SqlServerLicenseUsage': 'full'|'waived',
            'HaStatus': 'processing'|'active'|'standby'|'invalid',
            'ProcessingStatus': 'string',
            'LastUpdatedTime': datetime(2015, 1, 1),
            'SqlServerCredentials': 'string',
            'Tags': [
                {
                    'Key': 'string',
                    'Value': 'string'
                },
            ]
        },
    ],
    'NextToken': 'string'
}

Response Structure

(dict) --
- Instances (list) --
  
  Information about the historical SQL Server High Availability states of the SQL Server High Availability instances.
  - (dict) --
    
    Describes an Amazon EC2 instance that is enabled for SQL Server High Availability standby detection monitoring.
    - InstanceId (string) --
      
      The ID of the SQL Server High Availability instance.
    - SqlServerLicenseUsage (string) --
      
      The license type for the SQL Server license. Valid values include:
      - full - The SQL Server High Availability instance is using a full SQL Server license.
      - waived - The SQL Server High Availability instance is waived from the SQL Server license.
    - HaStatus (string) --
      
      The SQL Server High Availability status of the instance. Valid values are:
      - processing - The SQL Server High Availability status for the SQL Server High Availability instance is being updated.
      - active - The SQL Server High Availability instance is an active node in an SQL Server High Availability cluster.
      - standby - The SQL Server High Availability instance is a standby failover node in an SQL Server High Availability cluster.
      - invalid - An error occurred due to misconfigured permissions, or unable to dertemine SQL Server High Availability status for the SQL Server High Availability instance.
    - ProcessingStatus (string) --
      
      A brief description of the SQL Server High Availability status. If the instance is in the invalid High Availability status, this parameter includes the error message.
    - LastUpdatedTime (datetime) --
      
      The date and time when the instance's SQL Server High Availability status was last updated, in the ISO 8601 format in the UTC time zone ( YYYY-MM-DDThh:mm:ss.sssZ).
    - SqlServerCredentials (string) --
      
      The ARN of the Secrets Manager secret containing the SQL Server access credentials for the SQL Server High Availability instance. If not specified, deafult local user credentials will be used by the Amazon Web Services Systems Manager agent.
    - Tags (list) --
      
      The tags assigned to the SQL Server High Availability instance.
      - (dict) --
        
        Describes a tag.
        
        Key (string) --
        
        The key of the tag.
        
        Constraints: Tag keys are case-sensitive and accept a maximum of 127 Unicode characters. May not begin with aws:.
        
        Value (string) --
        
        The value of the tag.
        
        Constraints: Tag values are case-sensitive and accept a maximum of 256 Unicode characters.
- NextToken (string) --
  
  The token to use to retrieve the next page of results. This value is null when there are no more results to return.

EnableInstanceSqlHaStandbyDetections (new)

Link ¶

Enable Amazon EC2 instances running in an SQL Server High Availability cluster for SQL Server High Availability instance standby detection monitoring. Once enabled, Amazon Web Services monitors the metadata for the instances to determine whether they are active or standby nodes in the SQL Server High Availability cluster. If the instances are determined to be standby failover nodes, Amazon Web Services automatically applies SQL Server licensing fee waiver for those instances.

To register an instance, it must be running a Windows SQL Server license-included AMI and have the Amazon Web Services Systems Manager agent installed and running. Only Windows Server 2019 and later and SQL Server (Standard and Enterprise editions) 2017 and later are supported. For more information, see Prerequisites for using SQL Server High Availability instance standby detection.

See also: AWS API Documentation

Request Syntax

client.enable_instance_sql_ha_standby_detections(
    InstanceIds=[
        'string',
    ],
    SqlServerCredentials='string',
    DryRun=True|False
)

type InstanceIds:

list

param InstanceIds:

[REQUIRED]

The IDs of the instances to enable for SQL Server High Availability standby detection monitoring.

(string) --

type SqlServerCredentials:

string

param SqlServerCredentials:

The ARN of the Secrets Manager secret containing the SQL Server access credentials. The specified secret must contain valid SQL Server credentials for the specified instances. If not specified, deafult local user credentials will be used by the Amazon Web Services Systems Manager agent. To enable instances with different credentials, you must make separate requests.

type DryRun:

boolean

param DryRun:

rtype:

dict

returns:

Response Syntax

{
    'Instances': [
        {
            'InstanceId': 'string',
            'SqlServerLicenseUsage': 'full'|'waived',
            'HaStatus': 'processing'|'active'|'standby'|'invalid',
            'ProcessingStatus': 'string',
            'LastUpdatedTime': datetime(2015, 1, 1),
            'SqlServerCredentials': 'string',
            'Tags': [
                {
                    'Key': 'string',
                    'Value': 'string'
                },
            ]
        },
    ]
}

Response Structure

(dict) --
- Instances (list) --
  
  Information about the instances that were enabled for SQL Server High Availability standby detection monitoring.
  - (dict) --
    
    Describes an Amazon EC2 instance that is enabled for SQL Server High Availability standby detection monitoring.
    - InstanceId (string) --
      
      The ID of the SQL Server High Availability instance.
    - SqlServerLicenseUsage (string) --
      
      The license type for the SQL Server license. Valid values include:
      - full - The SQL Server High Availability instance is using a full SQL Server license.
      - waived - The SQL Server High Availability instance is waived from the SQL Server license.
    - HaStatus (string) --
      
      The SQL Server High Availability status of the instance. Valid values are:
      - processing - The SQL Server High Availability status for the SQL Server High Availability instance is being updated.
      - active - The SQL Server High Availability instance is an active node in an SQL Server High Availability cluster.
      - standby - The SQL Server High Availability instance is a standby failover node in an SQL Server High Availability cluster.
      - invalid - An error occurred due to misconfigured permissions, or unable to dertemine SQL Server High Availability status for the SQL Server High Availability instance.
    - ProcessingStatus (string) --
      
      A brief description of the SQL Server High Availability status. If the instance is in the invalid High Availability status, this parameter includes the error message.
    - LastUpdatedTime (datetime) --
      
      The date and time when the instance's SQL Server High Availability status was last updated, in the ISO 8601 format in the UTC time zone ( YYYY-MM-DDThh:mm:ss.sssZ).
    - SqlServerCredentials (string) --
      
      The ARN of the Secrets Manager secret containing the SQL Server access credentials for the SQL Server High Availability instance. If not specified, deafult local user credentials will be used by the Amazon Web Services Systems Manager agent.
    - Tags (list) --
      
      The tags assigned to the SQL Server High Availability instance.
      - (dict) --
        
        Describes a tag.
        
        Key (string) --
        
        The key of the tag.
        
        Constraints: Tag keys are case-sensitive and accept a maximum of 127 Unicode characters. May not begin with aws:.
        
        Value (string) --
        
        The value of the tag.
        
        Constraints: Tag values are case-sensitive and accept a maximum of 256 Unicode characters.

DescribeInstanceSqlHaStates (new)

Link ¶

Describes the SQL Server High Availability states for Amazon EC2 instances that are enabled for Amazon EC2 High Availability for SQL Server monitoring.

See also: AWS API Documentation

Request Syntax

client.describe_instance_sql_ha_states(
    InstanceIds=[
        'string',
    ],
    NextToken='string',
    MaxResults=123,
    Filters=[
        {
            'Name': 'string',
            'Values': [
                'string',
            ]
        },
    ],
    DryRun=True|False
)

type InstanceIds:

list

param InstanceIds:

The IDs of the SQL Server High Availability instances to describe. If omitted, the API returns SQL Server High Availability states for all SQL Server High Availability instances.

(string) --

type NextToken:

string

param NextToken:

The token to use to retrieve the next page of results.

type MaxResults:

integer

param MaxResults:

The maximum number of results to return for the request in a single page. The remaining results can be seen by sending another request with the returned nextToken value.

type Filters:

list

param Filters:

One or more filters to apply to the results. Supported filters include:

tag:<key> - The tag key and value pair assigned to the instance. For example, to find all instances tagged with Owner:TeamA, specify tag:Owner for the filter name and TeamA for the filter value.
tag-key - The tag key assigned to the instance.
haStatus - The SQL Server High Availability status of the SQL Server High Availability instance ( processing | active | standby | invalid).
sqlServerLicenseUsage - The license type for the SQL Server license ( full | waived).

(dict) --

A filter name and value pair that is used to return a more specific list of results from a describe operation. Filters can be used to match a set of resources by specific criteria, such as tags, attributes, or IDs.

If you specify multiple filters, the filters are joined with an AND, and the request returns only results that match all of the specified filters.

For more information, see List and filter using the CLI and API in the Amazon EC2 User Guide.
- Name (string) --
  
  The name of the filter. Filter names are case-sensitive.
- Values (list) --
  
  The filter values. Filter values are case-sensitive. If you specify multiple values for a filter, the values are joined with an OR, and the request returns all results that match any of the specified values.
  - (string) --

type DryRun:

boolean

param DryRun:

rtype:

dict

returns:

Response Syntax

{
    'Instances': [
        {
            'InstanceId': 'string',
            'SqlServerLicenseUsage': 'full'|'waived',
            'HaStatus': 'processing'|'active'|'standby'|'invalid',
            'ProcessingStatus': 'string',
            'LastUpdatedTime': datetime(2015, 1, 1),
            'SqlServerCredentials': 'string',
            'Tags': [
                {
                    'Key': 'string',
                    'Value': 'string'
                },
            ]
        },
    ],
    'NextToken': 'string'
}

Response Structure

(dict) --
- Instances (list) --
  
  Information about the SQL Server High Availability instances.
  - (dict) --
    
    Describes an Amazon EC2 instance that is enabled for SQL Server High Availability standby detection monitoring.
    - InstanceId (string) --
      
      The ID of the SQL Server High Availability instance.
    - SqlServerLicenseUsage (string) --
      
      The license type for the SQL Server license. Valid values include:
      - full - The SQL Server High Availability instance is using a full SQL Server license.
      - waived - The SQL Server High Availability instance is waived from the SQL Server license.
    - HaStatus (string) --
      
      The SQL Server High Availability status of the instance. Valid values are:
      - processing - The SQL Server High Availability status for the SQL Server High Availability instance is being updated.
      - active - The SQL Server High Availability instance is an active node in an SQL Server High Availability cluster.
      - standby - The SQL Server High Availability instance is a standby failover node in an SQL Server High Availability cluster.
      - invalid - An error occurred due to misconfigured permissions, or unable to dertemine SQL Server High Availability status for the SQL Server High Availability instance.
    - ProcessingStatus (string) --
      
      A brief description of the SQL Server High Availability status. If the instance is in the invalid High Availability status, this parameter includes the error message.
    - LastUpdatedTime (datetime) --
      
      The date and time when the instance's SQL Server High Availability status was last updated, in the ISO 8601 format in the UTC time zone ( YYYY-MM-DDThh:mm:ss.sssZ).
    - SqlServerCredentials (string) --
      
      The ARN of the Secrets Manager secret containing the SQL Server access credentials for the SQL Server High Availability instance. If not specified, deafult local user credentials will be used by the Amazon Web Services Systems Manager agent.
    - Tags (list) --
      
      The tags assigned to the SQL Server High Availability instance.
      - (dict) --
        
        Describes a tag.
        
        Key (string) --
        
        The key of the tag.
        
        Constraints: Tag keys are case-sensitive and accept a maximum of 127 Unicode characters. May not begin with aws:.
        
        Value (string) --
        
        The value of the tag.
        
        Constraints: Tag values are case-sensitive and accept a maximum of 256 Unicode characters.
- NextToken (string) --
  
  The token to use to retrieve the next page of results. This value is null when there are no more results to return.

DisableInstanceSqlHaStandbyDetections (new)

Link ¶

Disable Amazon EC2 instances running in an SQL Server High Availability cluster from SQL Server High Availability instance standby detection monitoring. Once disabled, Amazon Web Services no longer monitors the metadata for the instances to determine whether they are active or standby nodes in the SQL Server High Availability cluster.

See also: AWS API Documentation

Request Syntax

client.disable_instance_sql_ha_standby_detections(
    InstanceIds=[
        'string',
    ],
    DryRun=True|False
)

type InstanceIds:

list

param InstanceIds:

[REQUIRED]

The IDs of the instances to disable from SQL Server High Availability standby detection monitoring.

(string) --

type DryRun:

boolean

param DryRun:

rtype:

dict

returns:

Response Syntax

{
    'Instances': [
        {
            'InstanceId': 'string',
            'SqlServerLicenseUsage': 'full'|'waived',
            'HaStatus': 'processing'|'active'|'standby'|'invalid',
            'ProcessingStatus': 'string',
            'LastUpdatedTime': datetime(2015, 1, 1),
            'SqlServerCredentials': 'string',
            'Tags': [
                {
                    'Key': 'string',
                    'Value': 'string'
                },
            ]
        },
    ]
}

Response Structure

(dict) --
- Instances (list) --
  
  Information about the instances that were disabled from SQL Server High Availability standby detection monitoring.
  - (dict) --
    
    Describes an Amazon EC2 instance that is enabled for SQL Server High Availability standby detection monitoring.
    - InstanceId (string) --
      
      The ID of the SQL Server High Availability instance.
    - SqlServerLicenseUsage (string) --
      
      The license type for the SQL Server license. Valid values include:
      - full - The SQL Server High Availability instance is using a full SQL Server license.
      - waived - The SQL Server High Availability instance is waived from the SQL Server license.
    - HaStatus (string) --
      
      The SQL Server High Availability status of the instance. Valid values are:
      - processing - The SQL Server High Availability status for the SQL Server High Availability instance is being updated.
      - active - The SQL Server High Availability instance is an active node in an SQL Server High Availability cluster.
      - standby - The SQL Server High Availability instance is a standby failover node in an SQL Server High Availability cluster.
      - invalid - An error occurred due to misconfigured permissions, or unable to dertemine SQL Server High Availability status for the SQL Server High Availability instance.
    - ProcessingStatus (string) --
      
      A brief description of the SQL Server High Availability status. If the instance is in the invalid High Availability status, this parameter includes the error message.
    - LastUpdatedTime (datetime) --
      
      The date and time when the instance's SQL Server High Availability status was last updated, in the ISO 8601 format in the UTC time zone ( YYYY-MM-DDThh:mm:ss.sssZ).
    - SqlServerCredentials (string) --
      
      The ARN of the Secrets Manager secret containing the SQL Server access credentials for the SQL Server High Availability instance. If not specified, deafult local user credentials will be used by the Amazon Web Services Systems Manager agent.
    - Tags (list) --
      
      The tags assigned to the SQL Server High Availability instance.
      - (dict) --
        
        Describes a tag.
        
        Key (string) --
        
        The key of the tag.
        
        Constraints: Tag keys are case-sensitive and accept a maximum of 127 Unicode characters. May not begin with aws:.
        
        Value (string) --
        
        The value of the tag.
        
        Constraints: Tag values are case-sensitive and accept a maximum of 256 Unicode characters.