AWS Excel Definitions

Field

Description

EC2 Instance Name

EC2 instance Name

Amazon Elastic Compute Cloud (EC2) provides scalable computing capacity in the AWS cloud

EC2 Instance ID

The ID of the EC2 instance

State

The state of the EC2 instance:

Pending: The instance is preparing to enter the running state. An instance enters the pending state when it launches for the first time, or when it is started after being in the stopped state.

Running: The instance is running and ready for use.

Stopping: The instance is preparing to be stopped or stop-hibernated.

Stopped: The instance is shut down and cannot be used. The instance can be started at any time.

Shutting Down: The instance is preparing to be terminated.

Terminated: The instance has been permanently deleted.

Instance Type

The EC2 instance Type

The instance type that you specify determines the hardware of the host computer used for your instance. Each instance type offers different compute, memory, and storage capabilities and are grouped in instance families based on these capabilities.

CPU Cores

The number of CPU Cores configured for the EC2 Instance

ThreadsPerCPUCore

The number of threads per CPU Core

Memory (MB)

The total Memory in Megabytes

Capacity (MB)

The total Capacity in Megabytes

AMI ID

The Amazon Machine Image template used to create the EC2 instance

An Amazon Machine Image (AMI) is a template that contains a software configuration (for example, an operating system, an application server, and applications). 

Tenancy

The EC2 instance tenancy type

       Shared : which run on shared hardware where the isolation is logical

       Dedicated Instances/Dedicated Hosts: which run in single-tenant hardware where the isolation is physical.

Region

The Region in which the EC2 instance was created in.

 Region: is a separate geographic area.

Availability Zone

The availability Zone in which the EC2 instance is running

Availability Zones: are multiple, isolated locations within each Region.

VPC ID

The Virtual Private Cloud ID

Amazon Virtual Private Cloud (Amazon VPC) enables you to define a virtual network in your own logically isolated area within the AWS cloud.

Subnet ID

The ID of the subnet that the EC2 Instance is in.

Subnet: A range of IP addresses in your VPC.

Public DNS

The instance public DNS hostnames

Private DNS

The instance private DNS hostnames

Public IP

The Instance Public IP address

Private IP

The instance Private IP address

AutoScalingGroupName

The name of the Auto Scaling group this instance is a member of.

AutoScalingGroupMin

The minimum number of instances configured for the Auto Scaling Group.

AutoScalingGroupMax

The maximum number of instances configured for the Auto Scaling Group

AutoScalingGroupDesired

The Auto Scaling group desired number of instances

Field

Description

EC2 Instance Name

EC2 instance Name

Amazon Elastic Compute Cloud (EC2) provides scalable computing capacity in the AWS cloud

EC2 Instance ID

The ID of the EC2 instance

State

The state of the EC2 instance

       Pending: The instance is preparing to enter the running state. An instance enters the pending state when it launches for the first time, or when it is started after being in the stopped state.

       Running: The instance is running and ready for use.

       Stopping: The instance is preparing to be stopped or stop-hibernated.

       Stopped: The instance is shut down and cannot be used. The instance can be started at any time.

       Shutting Down: The instance is preparing to be terminated.

       Terminated: The instance has been permanently deleted.

Instance Type

The EC2 instance Type

The instance type that you specify determines the hardware of the host computer used for your instance. Each instance type offers different compute, memory, and storage capabilities and are grouped in instance families based on these capabilities.

Volume ID

The ID of the volume.

IsBoot

Indicates whether the volume is a boot volume

Capacity (MB)

The size of the volume, in Megabytes

PeakSupportedIOPS

The max number of I/O operations per second (IOPS) that the volume supports.

For Provisioned IOPS SSD volumes, this represents the number of IOPS that are provisioned for the volume. For General Purpose SSD volumes, this represents the baseline performance of the volume and the rate at which the volume accumulates I/O credits for bursting.

Constraints:

       Range is 100-16,000 IOPS for gp2 volumes

       100 to 64,000 IOPS for io1 and io2 volumes, in most Regions. The maximum IOPS for io1 and io2 of 64,000 is guaranteed only on Nitro-based instances.

       Other instance families guarantee performance up to 32,000 IOPS.

CreatedFromSnapShotID

The snapshot from which the volume was created, if applicable.

VolumeType

The type of the volume attached to the EC2 instance; this can be:

       gp2: for General Purpose SSD

       io1 or io2: for Provisioned IOPS SSD

       st1: for Throughput Optimized HDD

       sc1: for Cold HDD

       standard: for Magnetic volumes.

VolumeAvailabilityZone

The Availability Zone for the volume.

Encrypted

Indicates whether the volume is encrypted.

Field

Description

EC2 Instance Name

EC2 instance Name

Amazon Elastic Compute Cloud (EC2) provides scalable computing capacity in the AWS cloud

EC2 Instance ID

The ID of the EC2 instance

Region

 The Region the EC2 instance was created

State

The state of the EC2 instance 

       Pending: The instance is preparing to enter the running state. An instance enters the pending state when it launches for the first time, or when it is started after being in the stopped state.

       Running: The instance is running and ready for use.

       Stopping: The instance is preparing to be stopped or stop-hibernated.

       Stopped: The instance is shut down and cannot be used. The instance can be started at any time.

       Shutting Down: The instance is preparing to be terminated.

       Terminated: The instance has been permanently deleted.

Instance Type

The EC2 instance Type

The instance type that you specify determines the hardware of the host computer used for your instance. Each instance type offers different compute, memory, and storage capabilities and are grouped in instance families based on these capabilities.

Load Balancer Version

Indicates whether it is a ELBv1 or a ELBv2 load balancer.

Load Balancer Name

The name of the load balancer.

Load Balancer ARN

Amazon Resource Names (ARNs) uniquely identify AWS resources. (Load balancer)

Load Balancer Type

The type of load balancer.

Possible values include:

       application

       network

Load Balancer Region

The region the load balancer was created.

Target Groups Names

The name of the target group.

A target group tells a load balancer where to direct traffic to : EC2 instances, fixed IP addresses; or AWS Lambda functions, amongst others. When creating a load balancer, you create one or more listeners and configure listener rules to direct the traffic to one target group.

Field

Description

VolumeID

The Orphaned Volume ID

IsBoot

 Indicates whether the volume is a boot volume

Capacity (MB)

The size of the Orphaned volume, in Megabytes

PeakSupportedIOPS

The max number of I/O operations per second (IOPS) that the volume supports.

For Provisioned IOPS SSD volumes, this represents the number of IOPS that are provisioned for the volume. For General Purpose SSD volumes, this represents the baseline performance of the volume and the rate at which the volume accumulates I/O credits for bursting.

Constraints:

       Range is 100-16,000 IOPS for gp2 volumes

       100 to 64,000 IOPS for io1 and io2 volumes, in most Regions. The maximum IOPS for io1 and io2 of 64,000 is guaranteed only on Nitro-based instances.

       Other instance families guarantee performance up to 32,000 IOPS.

CreatedFromSnapShotID

The snapshot from which the volume was created, if applicable.

Region

The region the volume was created

VolumeType

The type of the volume attached to the EC2 instance; this can be:

       gp2: for General Purpose SSD

       io1 or io2: for Provisioned IOPS SSD

       st1: for Throughput Optimized HDD

       sc1: for Cold HDD

       standard: for Magnetic volumes.

VolumeAvailabilityZone

The Availability Zone for the volume.

Encrypted

Indicates whether the volume is encrypted.

Field

Description

Bucket Name

The S3 Bucket Name.

A bucket is a container for objects stored in Amazon S3. Every object is contained in a bucket.

Region

The Region in which the bucket is created in.

You can choose the geographical AWS Region where Amazon S3 will store the buckets that you create. Objects stored in a Region never leave the Region unless you explicitly transfer them to another Region.

Number of Objects

The number of objects saved on the bucket.

Objects are the fundamental entities stored in Amazon S3. Objects consist of object data and metadata. You can store as many objects as you want, and each object can be up to 5 TB in size.

Total Size (MB)

The total bucket size in (MB)

Standard Storage Size (MB)

The size of the objects in Megabytes stored in this bucket in the Standard Storage Class

S3 Standard: The default storage class. If you don't specify the storage class when you upload an object, Amazon S3 assigns the S3 Standard storage class. (used for frequently accessed objects)

Intelligent Tiering FA Storage Size (MB)

The size of the objects in Megabytes stored in this bucket in the Intelligent Tiering FA Storage Class

The Intelligent-Tiering storage class: stores objects in two access tiers: one tier that is optimized for frequent access and another lower-cost tier that is optimized for infrequently accessed data.

Standard IA Storage size (MB)

The size of the objects in Megabytes stored in this bucket in the Standard IA Storage Class

S3 Standard-IA: Storage classes are designed for long-lived and infrequently accessed data. Amazon S3 stores the object data redundantly across multiple geographically separated Availability Zones (similar to the S3 Standard storage class).

One Zone IA Storage Size (MB)

The size of the objects in Megabytes stored in this bucket in the One Zone IA Storage Class

One Zone IA: Storage classes are designed for long-lived and infrequently accessed data. Amazon S3 stores the object data in only one Availability Zone, which makes it less expensive than S3 Standard-IA. However, the data is not resilient to the physical loss of the Availability Zone.

Glacier Storage Size (MB)

The size of the objects in Megabytes stored in this bucket in the Glacier Storage Class

S3 Glacier—Use for archives where portions of the data might need to be retrieved in minutes. Data stored in the S3 Glacier storage class has a minimum storage duration period of 90 days and can be accessed in as little as 1-5 minutes using expedited retrieval

Glacier Deep Archive Storage Size (MB)

The size of the objects in Megabytes stored in this bucket in the Glacier Deep Archive Storage Class.

Glacier Deep Archive: Use for archiving data that rarely needs to be accessed. Data stored in the S3 Glacier Deep Archive storage class has a minimum storage duration period of 180 days and a default retrieval time of 12 hours.

Redundancy Redundancy Storage size (MB)

The size of the objects in Megabytes stored in this bucket in the Redundancy Redundancy Storage Class

Reduced Redundancy—The Reduced Redundancy Storage (RRS) storage class is designed for noncritical, reproducible data that can be stored with less redundancy than the S3 Standard storage class.

Default Encryption Algorithm

The default encryption configuration for an Amazon S3 bucket.

Amazon S3 default encryption provides a way to set the default encryption behavior for an S3 bucket. You can set default encryption on a bucket so that all new objects are encrypted when they are stored in the bucket. The objects are encrypted using server-side encryption with either Amazon S3-managed keys (SSE-S3) or customer master keys (CMKs) stored in AWS Key Management Service (AWS KMS).

Server-side encryption is the encryption of data at its destination by the application or service that receives it. Amazon S3 encrypts your data at the object level as it writes it to disks in its data centers and decrypts it for you when you access it

Versioning Status

The versioning state of a bucket.

Amazon S3 Versioning allows users to keep multiple versions of an object in one bucket. S3 Versioning protects you from the consequences of unintended overwrites and deletions. You can also use it to archive objects so that you have access to previous versions.

Website Type

The website configuration for a bucket. To host website on Amazon S3, you can configure a bucket as website by adding a website configuration.

You can use Amazon S3 to host a static website. On a static website, individual webpages include static content. They might also contain client-side scripts.

Is Life Cycle Enabled

Shows the lifecycle configuration information set on the bucket. 

An S3 Lifecycle configuration is a set of rules that define actions that Amazon S3 applies to a group of objects. There are two types of actions:

Transition actions—Define when objects transition to another storage class. For example, you might choose to transition objects to the S3 Standard-IA storage class 30 days after you created them, or archive objects to the S3 Glacier storage class one year after creating them.

Expiration actions—Define when objects expire. Amazon S3 deletes expired objects on your behalf.

Field

Description

Vault Name

The name of the vault.

ARN

The Amazon Resource Name (ARN) of the vault.

Region

The vault region.

Number of Archives

The number of archives in the vault as of the last inventory date. This field will return null if an inventory has not yet run on the vault, for example if you just created the vault.

Total Size (MB)

Total size, in Megabytes, of the archives in the vault as of the last inventory date. This field will return null if an inventory has not yet run on the vault, for example if you just created the vault.

Field

Description

Name

The name of the EFS

Region

The Region in which the EFS was created in.

ARN

Amazon Resource Names (ARNs) uniquely identify AWS resources.

Performance Mode

The Performance Mode of the EFS instance.

Amazon EFS is designed to provide the throughput, IOPS, and low latency needed for a broad range of workloads and offers two performance modes:

       General Purpose: provides the lowest latency per file system operation and can achieve this for random or sequential IO patterns.

       Max I/O : can scale to higher levels of aggregate throughput and operations per second and is ideal for highly parallelized applications that can scale out to thousands of Amazon EC2 instances.

Throughput Mode

The Throughput Mode of the EFS instance

The throughput mode helps determine the overall throughput a file system can achieve.

       Bursting Throughput: The throughput scales with the size of the file system, dynamically bursting as needed to support the spiky nature of many file-based workloads.

       Provisioned Throughput: Is designed to support applications that require higher dedicated throughput than the default Bursting mode and can be configured independently of the amount of data stored on the file system.

Standard Size (MB)

The Size of the data in Megabytes stored in the EFS standard class

Standard: The Standard storage class is used to store frequently accessed files.

Infrequent Access Size (MB)

The Size of the data in Megabytes stored in the EFS Infrequent Access class

Infrequent Access: The Infrequent Access (IA) storage class is a lower-cost storage class that's designed for storing long-lived, infrequently accessed files cost-effectively.

Total Size MB)

The total size of Data in Megabytes stored on the EFS instance

Standard Size + Infrequent Size

Field

Description

InstanceIdentifier

A user-supplied database identifier. This identifier is the unique key that identifies a DB instance.

InstanceARN

The Amazon Resource Name (ARN) for the DB instance.

Engine

Provides the name of the database engine to be used for this DB instance.

AllocatedStorage (GB)

Specifies the allocated storage size specified in gibibytes.

Note: For all database engines except Amazon Aurora, AllocatedStorage specifies the allocated storage size in gibibytes (GiB). For Aurora, AllocatedStorage always returns 1, because Aurora DB cluster storage size isn't fixed, but instead automatically adjusts as needed.

MaxAllocatedStorage (GB)

The upper limit to which Amazon RDS can automatically scale the storage of the DB instance

Note: that will always give zero for Aurora instances since it is dynamic.

Region

Specifies the name of the Region the DB instance is located in.

AvailabilityZone

Specifies the name of the Availability Zone the DB instance is located in.

InstanceClass

The name of the compute and memory capacity class of the DB instance.

StorageEncrypted

Specifies whether the DB instance is encrypted.

BackupRetentionPeriodInDays

Specifies the number of days for which automatic DB snapshots are retained.

Field

Description

ClusterIdentifier

Contains a user-supplied DB cluster identifier. This identifier is the unique key that identifies a DB cluster.

ClusterARN

The Amazon Resource Name (ARN) for the DB cluster.

Status

Specifies the current state of this DB cluster. For more information on DB Cluster status visit  HERE

Engine

Provides the name of the database engine to be used for this DB cluster. 

ClusterRegion

The Region of the Aurora Cluster.

InstanceIdentifier

This will list all the instances in The Aurora DB cluster.

Specifies the instance identifier for this member of the DB cluster.

Note: (If there is more than one instance in a cluster all will be listed in the Excel with a comma between each instance identifier)