forked from tonyprawiro/aws-config-inventory-report
-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathquery-autoscaling-group.sql
73 lines (73 loc) · 3.08 KB
/
query-autoscaling-group.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
SELECT
accountId,
arn,
availabilityZone,
awsRegion,
configuration.autoScalingGroupARN,
configuration.autoScalingGroupName,
configuration.availabilityZones.value,
configuration.createdTime,
configuration.defaultCooldown,
configuration.desiredCapacity,
configuration.enabledMetrics.granularity,
configuration.enabledMetrics.metric,
configuration.healthCheckGracePeriod,
configuration.healthCheckType,
configuration.instances.availabilityZone,
configuration.instances.healthStatus,
configuration.instances.instanceId,
configuration.instances.launchConfigurationName,
configuration.instances.launchTemplate.launchTemplateId,
configuration.instances.launchTemplate.launchTemplateName,
configuration.instances.launchTemplate.version,
configuration.instances.lifecycleState,
configuration.instances.protectedFromScaleIn,
configuration.launchConfigurationName,
configuration.launchTemplate.launchTemplateId,
configuration.launchTemplate.launchTemplateName,
configuration.launchTemplate.version,
configuration.loadBalancerNames,
configuration.maxSize,
configuration.minSize,
configuration.mixedInstancesPolicy.instancesDistribution.onDemandAllocationStrategy,
configuration.mixedInstancesPolicy.instancesDistribution.onDemandBaseCapacity,
configuration.mixedInstancesPolicy.instancesDistribution.onDemandPercentageAboveBaseCapacity,
configuration.mixedInstancesPolicy.instancesDistribution.spotAllocationStrategy,
configuration.mixedInstancesPolicy.instancesDistribution.spotInstancePools,
configuration.mixedInstancesPolicy.instancesDistribution.spotMaxPrice,
configuration.mixedInstancesPolicy.launchTemplate.launchTemplateSpecification.launchTemplateId,
configuration.mixedInstancesPolicy.launchTemplate.launchTemplateSpecification.launchTemplateName,
configuration.mixedInstancesPolicy.launchTemplate.launchTemplateSpecification.version,
configuration.mixedInstancesPolicy.launchTemplate.overrides.instanceType,
configuration.newInstancesProtectedFromScaleIn,
configuration.placementGroup,
configuration.serviceLinkedRoleARN,
configuration.status,
configuration.suspendedProcesses.processName,
configuration.suspendedProcesses.suspensionReason,
configuration.targetGroupARNs,
configuration.terminationPolicies,
configuration.vpczoneIdentifier,
configurationItemCaptureTime,
configurationItemStatus,
configurationStateId,
relationships.resourceId,
relationships.resourceName,
relationships.resourceType,
resourceCreationTime,
resourceId,
resourceName,
resourceType,
supplementaryConfiguration.LifeCycleHooks.autoScalingGroupName,
supplementaryConfiguration.LifeCycleHooks.defaultResult,
supplementaryConfiguration.LifeCycleHooks.globalTimeout,
supplementaryConfiguration.LifeCycleHooks.heartbeatTimeout,
supplementaryConfiguration.LifeCycleHooks.lifecycleHookName,
supplementaryConfiguration.LifeCycleHooks.lifecycleTransition,
supplementaryConfiguration.LifeCycleHooks.notificationMetadata,
supplementaryConfiguration.LifeCycleHooks.notificationTargetARN,
supplementaryConfiguration.LifeCycleHooks.roleARN,
tags,
version
WHERE
resourceType = 'AWS::AutoScaling::AutoScalingGroup'