query-ec2.sql

SELECT
  accountId,
  arn,
  availabilityZone,
  awsRegion,
  configuration.amiLaunchIndex,
  configuration.architecture,
  configuration.blockDeviceMappings.deviceName,
  configuration.blockDeviceMappings.ebs.attachTime,
  configuration.blockDeviceMappings.ebs.deleteOnTermination,
  configuration.blockDeviceMappings.ebs.status,
  configuration.blockDeviceMappings.ebs.volumeId,
  configuration.cpuOptions.coreCount,
  configuration.cpuOptions.threadsPerCore,
  configuration.ebsOptimized,
  configuration.elasticGpuAssociations.elasticGpuAssociationId,
  configuration.elasticGpuAssociations.elasticGpuAssociationState,
  configuration.elasticGpuAssociations.elasticGpuAssociationTime,
  configuration.elasticGpuAssociations.elasticGpuId,
  configuration.iamInstanceProfile.arn,
  configuration.iamInstanceProfile.id,
  configuration.imageId,
  configuration.instanceId,
  configuration.instanceLifecycle,
  configuration.instanceType,
  configuration.kernelId,
  configuration.keyName,
  configuration.launchTime,
  configuration.monitoring.state,
  configuration.networkInterfaces.association.ipOwnerId,
  configuration.networkInterfaces.association.publicDnsName,
  configuration.networkInterfaces.association.publicIp,
  configuration.networkInterfaces.attachment.attachTime,
  configuration.networkInterfaces.attachment.attachmentId,
  configuration.networkInterfaces.attachment.deleteOnTermination,
  configuration.networkInterfaces.attachment.deviceIndex,
  configuration.networkInterfaces.attachment.status,
  configuration.networkInterfaces.description,
  configuration.networkInterfaces.groups.groupId,
  configuration.networkInterfaces.groups.groupName,
  configuration.networkInterfaces.ipv6Addresses.ipv6Address,
  configuration.networkInterfaces.macAddress,
  configuration.networkInterfaces.networkInterfaceId,
  configuration.networkInterfaces.ownerId,
  configuration.networkInterfaces.privateDnsName,
  configuration.networkInterfaces.privateIpAddress,
  configuration.networkInterfaces.privateIpAddresses.association.ipOwnerId,
  configuration.networkInterfaces.privateIpAddresses.association.publicDnsName,
  configuration.networkInterfaces.privateIpAddresses.association.publicIp,
  configuration.networkInterfaces.privateIpAddresses.primary,
  configuration.networkInterfaces.privateIpAddresses.privateDnsName,
  configuration.networkInterfaces.privateIpAddresses.privateIpAddress,
  configuration.networkInterfaces.sourceDestCheck,
  configuration.networkInterfaces.status,
  configuration.networkInterfaces.subnetId,
  configuration.networkInterfaces.vpcId,
  configuration.placement.affinity,
  configuration.placement.availabilityZone,
  configuration.placement.groupName,
  configuration.placement.hostId,
  configuration.placement.spreadDomain,
  configuration.placement.tenancy,
  configuration.platform,
  configuration.privateDnsName,
  configuration.privateIpAddress,
  configuration.productCodes.productCodeId,
  configuration.productCodes.productCodeType,
  configuration.publicDnsName,
  configuration.publicIpAddress,
  configuration.ramdiskId,
  configuration.rootDeviceName,
  configuration.rootDeviceType,
  configuration.securityGroups.groupId,
  configuration.securityGroups.groupName,
  configuration.sourceDestCheck,
  configuration.spotInstanceRequestId,
  configuration.state.code,
  configuration.state.name,
  configuration.state.value,
  configuration.stateReason.code,
  configuration.stateReason.message,
  configuration.stateTransitionReason,
  configuration.subnetId,
  configuration.virtualizationType,
  configuration.vpcId,
  configurationItemCaptureTime,
  configurationItemStatus,
  configurationStateId,
  resourceCreationTime,
  resourceId,
  resourceName,
  resourceType,
  tags
WHERE
  resourceType = 'AWS::EC2::Instance'