Cloud Data to Automation in Minutes

# AWS EC2 Utilization Metrics for all EC2 Instances
query MyQuery {
  EC2_Utilization {
    CPUUtilization
    DiskReadOps
    DiskWriteOps
    NetworkIn
    NetworkOut
    cpu_harmonic_mean
    cpu_variance
    disk_read_harmonic_mean
    disk_write_harmonic_mean
    mem_harmonic_mean
    mem_used_percent
    mem_variance
    network_in_harmonic_mean
    network_out_harmonic_mean
  }
}

{
  "data": {
    "EC2_Utilization": [
      {
        "CPUUtilization": 5.99,
        "DiskReadOps": null,
        "DiskWriteOps": null,
        "NetworkIn": 227,
        "NetworkOut": 61,
        "cpu_harmonic_mean": 0.63,
        "cpu_variance": 59.85,
        "disk_read_harmonic_mean": null,
        "disk_write_harmonic_mean": null,
        "mem_harmonic_mean": null,
        "mem_used_percent": null,
        "mem_variance": null,
        "network_in_harmonic_mean": 0.32,
        "network_out_harmonic_mean": 0.21
      },
      {
        "CPUUtilization": 9.13,
        "DiskReadOps": null,
        "DiskWriteOps": null,
        "NetworkIn": 91,
        "NetworkOut": 2,
        "cpu_harmonic_mean": 4.67,
        "cpu_variance": 87.56,
        "disk_read_harmonic_mean": null,
        "disk_write_harmonic_mean": null,
        "mem_harmonic_mean": null,
        "mem_used_percent": null,
        "mem_variance": null,
        "network_in_harmonic_mean": 0.04,
        "network_out_harmonic_mean": 0.51
      },
      {
        "CPUUtilization": 81.79,
        "DiskReadOps": null,
        "DiskWriteOps": null,
        "NetworkIn": 28863,
        "NetworkOut": 10651,
        "cpu_harmonic_mean": 70.68,
        "cpu_variance": 669.75,
        "disk_read_harmonic_mean": null,
        "disk_write_harmonic_mean": null,
        "mem_harmonic_mean": null,
        "mem_used_percent": null,
        "mem_variance": null,
        "network_in_harmonic_mean": 20103.2,
        "network_out_harmonic_mean": 7999.71
      },
      {
        "CPUUtilization": 41.26,
        "DiskReadOps": null,
        "DiskWriteOps": null,
        "NetworkIn": 2229,
        "NetworkOut": 186,
        "cpu_harmonic_mean": 39.37,
        "cpu_variance": 107.21,
        "disk_read_harmonic_mean": null,
        "disk_write_harmonic_mean": null,
        "mem_harmonic_mean": null,
        "mem_used_percent": null,
        "mem_variance": null,
        "network_in_harmonic_mean": 714.06,
        "network_out_harmonic_mean": 180.72
      }
    ]
  }
}

# Unencrypted EBS volumes with extra relations to VPC and EC2
query MyQuery {
  EC2_Instances(where: {EBS_Volume: {encrypted: {_eq: false}}}) {
    EBS_Volume {
      name
      product_name
      size
      type
      create_time
      VPC_Instance {
        dhcp_options_id
        cidr_block
        instance_tenancy
        resource_id
      }
    }
    region
    private_ip_address
    resource_id
    launch_time
  }
}

{
  "data": {
    "EC2_Instances": [
      {
        "EBS_Volume": {
          "name": "",
          "product_name": "Amazon Elastic Compute Cloud",
          "size": 120,
          "type": "ebs",
          "create_time": "2020-02-05T21:29:01.679+00:00",
          "VPC_Instance": {
            "dhcp_options_id": "dopt-d1d91fba",
            "cidr_block": "10.7.0.0/16",
            "instance_tenancy": "default",
            "resource_id": "vpc-5fd281df3a"
          }
        },
        "region": "us-west-2",
        "private_ip_address": "10.7.3.23",
        "resource_id": "i-08eece54ry5d40f2d80",
        "launch_time": "2020-02-05T21:29:00+00:00"
      },
      {
        "EBS_Volume": {
          "name": "",
          "product_name": "Amazon Elastic Compute Cloud",
          "size": 50,
          "type": "ebs",
          "create_time": "2020-02-05T21:29:01.585+00:00",
          "VPC_Instance": {
            "dhcp_options_id": "dopt-d1d91fba",
            "cidr_block": "10.7.0.0/16",
            "instance_tenancy": "default",
            "resource_id": "vpc-5fd281df3a"
          }
        },
        "region": "us-west-2",
        "private_ip_address": "10.7.3.23",
        "resource_id": "i-08eec05rgrty0f2d80",
        "launch_time": "2020-02-05T21:29:00+00:00"
      }
   ]
  }
}

# Unused AWS EBS Volume including total cost
query MyQuery {
  EBS_Volumes(
    where: {_or: [{attached: {_is_null: true}},
      {EC2_Instance: {state: {_neq: "running"}}}], active: {_eq: true}}
  ) {
    resource_id
    name
    EC2_Instance {
      region
      total_cost
      private_ip_address
      availability_zone
    }
  }
}

{
  "data": {
    "EBS_Volumes": [
      {
        "resource_id": "vol-0ace54617a2dbcc",
        "name": "cms-webserver",
        "EC2_Instance": {
          "region": "us-west-2",
          "total_cost": 1046.6847,
          "private_ip_address": "172.30.0.78",
          "availability_zone": "us-west-2a"
        }
      },
      {
        "resource_id": "vol-038erytdga8488175",
        "name": "VPN_SERVER",
        "EC2_Instance": {
          "region": "us-west-2",
          "total_cost": 15.740887,
          "private_ip_address": "10.2.1.89",
          "availability_zone": "us-west-2a"
        }
      }
    ]
  }
}