steampipe-plugin-aws
steampipe-plugin-aws copied to clipboard
EBS volume attachments for unattached volume is not null
Describe the bug I'm querying for unattached EBS volumes daily. select volume_id, size, attachments from aws_all.aws_ebs_volume as v where state = 'available' and attachments is null
I've copied it from the examples in the steampipe.io site. It used to work until last update Now attachments is no longer null it is empty array instead, so I modified the script to be: select volume_id, size, attachments from aws_all.aws_ebs_volume as v where state = 'available' and attachments = '[]' The example still on site https://hub.steampipe.io/mods/turbot/aws_thrifty/queries/unattached_ebs_volumes
Steampipe version (steampipe -v
)
steampipe version 0.16.4
Plugin version (steampipe plugin list
)
+--------------------------------------------------+---------+----------------------------+
| Name | Version | Connections |
+--------------------------------------------------+---------+----------------------------+
| hub.steampipe.io/plugins/turbot/aws@latest | 0.80.0 | aws_dev,aws_sanity,aws_all |
| hub.steampipe.io/plugins/turbot/steampipe@latest | 0.6.0 | steampipe |
+--------------------------------------------------+---------+----------------------------+
To reproduce select volume_id, size, attachments from aws_all.aws_ebs_volume as v where state = 'available' and attachments is null
Expected behavior It should list the unattached volumes and instead I'm getting an empty result
Additional context Add any other context about the problem here.