steampipe-plugin-aws icon indicating copy to clipboard operation
steampipe-plugin-aws copied to clipboard

EBS volume attachments for unattached volume is not null

Open eyalliss opened this issue 1 year ago • 0 comments

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.

eyalliss avatar Oct 27 '22 07:10 eyalliss