EC2 instance has SQL installed-CodePudding

How to identify if an EC2 instance has SQL installed. Through the AWS portal ?

Systems Manager alarm

This image is an example of where I'm looking to identify whether or not the instance has a database installed.

CodePudding user response：

You cannot do that through the AWS portal as the portal has no insight into what applications you are running on your instance.

You must SSH into your instance, perhaps using Systems Manager and check is SQL is installed.

mysql -V will allow you to check if MySql is installed, other types of databases will have similar commands.

As you are installing from a preconfigured OS you can see whats included in the instance details tab from the EC2 Web Console.

Or you can run the following command from your CLI:

aws ec2 describe-instances --instance-id <your instance id> --query 'Reservations[*].Instances[*].PlatformDetails'

[
    [
        "Windows with SQL Server Standard"
    ]
]