Add Query to list all AWS Accounts within mod resource 'input' and display all resources with the selected targeted aws account?

[ahkai86]

Is your feature request related to a problem? Please describe. It is not a problem but a feature request, trying to build a customize dashboard which has a mod resource 'input' to display what resources used within the selected AWS account.

Describe the solution you'd like As above, trying to build a customize dashboard which has a mod resource 'input' to display what resources used within the selected AWS account.

Describe alternatives you've considered using SQL cmd to display whole list of AWS accounts and from the selected aws account under "dropdown" input, shows the resources.

Additional context Add any other context or screenshots about the feature request here.

[ahkai86]

good to have feature for showing compliance and asset discovery under a single dashboard mod "input" =)

[rajlearner17]

@ahkai86 I Appreciate trying out Steampipe. Thank you!

Specifically, which specific report are you stating here from the existing set? Refer here

I understand that; you are building a custom dashboard to render resources for a specific configured account. As far as my understanding goes, it is possible to make such a report related to a single account-used asset as long as we can design the required query. Please provide more detailed information about your use case or sample code (omitting sensitive parts) to take a look and help you.

For more details, please refer to this doc.

[ahkai86]

Hi @rajlearner17 ! Good Day, appreciate your prompt reply. Had been using steampipe for a while and setup CloudFront, ALB into the Ubuntu configure with default Dashboard Mods for >80 aws accounts. Currently works good

Hence to have a customize dashboard , i am trying to code a custom dashboard which has "dropdown list" inputs mod and after selecting a target aws account, all the resources available will be displayed. Also to check on the CIS level of the AWS account for selected AWS account Mod, how do i leverage on other dashboards mod?

Thanks so much! Cheers

dashboard "dashboard_testing"  {
 title = "Dashboard - Testing"

  input "aws_account" {
   title = "AWS Accounts"
   sql   = query.aws_account_input.sql
    width = 4
    }

container {

 ??? What shall i input here ??? 

}

}

query "aws_account_input" {
  sql = <<-EOQ

    select
      distinct account_aliases as label,
      account_aliases as value
    from
      aws_account;

  EOQ
}

[bigdatasourav]

Apologies, @ahkai86, for the delay in getting back to you.

I believe you want to create a custom dashboard to list all the resources based on the account; here is a similar dashboard which you can refer, in this dashboard based on an EC2 arn the dashboard is listing its details. Here is another reporting dashboard which provides a report in table format of EC2 Instance Public Access.

You can also find some of the visual sample pages here.

Please try out the above and let us know if this works for you or if you need any other help on this.

[bigdatasourav]

Hey @ahkai86, We are closing this issue because we have not heard from you. Please feel free to reopen the issue if you want to share or discuss anything.