turbot / steampipe-plugin-aws

Use SQL to instantly query AWS resources across regions and accounts. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/aws
Apache License 2.0
189 stars 104 forks source link

Can't list associated CF distributions for aws_wafv2_web_acl #1762

Closed mverzier-tmg closed 1 year ago

mverzier-tmg commented 1 year ago

Describe the bug the associated_resources in aws_wafv2_web_acl table does not contain cloudfront distributions associated with the waf.

Steampipe version (steampipe -v) v0.20.5

Plugin version (steampipe plugin list) v0.105.0

To reproduce associate a global wafv2 with a cloudfront distribution, the associated_resources column will be null

Expected behavior the associated_resources column should include the associated cloudfront distrubution(s)

Additional context The ListDistributionsByWebAclId should reference the web acl by its full arn rather than its id:

$ aws cloudfront list-distributions-by-web-acl-id --web-acl-id <truncated-web-acl-id> --query DistributionList.Quantity
0
$ aws cloudfront list-distributions-by-web-acl-id --web-acl-id <truncated-web-acl-arn> --query DistributionList.Quantity
1
misraved commented 1 year ago

Welcome to Steampipe @mverzier-tmg and apologies for the inconvenience!!

Thanks for reporting this issue 👍.