Overview
This document outlines the definitions used in the AWS Excel.
EC2 Instances Tab
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 |
EC2 Volumes Tab
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. |
EC2 Load Balancers
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. |
Orphaned Volume
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. |
S3
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. |
Glacier Values
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. |
EFS
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 |
RDS Instances
That will list all RDS instances included the Aurora instances even if it is a cluster member.
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. |
Aurora DB Clusters
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) |