turbot / steampipe-plugin-azure

Use SQL to instantly query Azure resources across regions and subscriptions. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/azure
Apache License 2.0
37 stars 17 forks source link

Unable to query azure_role_assignment from steampipe or turbot #808

Closed arnav13081994 closed 2 months ago

arnav13081994 commented 2 months ago

Describe the bug Unable to execute the following command:

select
  *
from
  azure_role_assignment;

Steampipe version (steampipe -v) v0.20.12

Plugin version (steampipe plugin list) azure, azuread

To reproduce Steps to reproduce the behavior (please include relevant code and/or commands).

I have tried to se the steampipe cli as well as turbot with valid credentials as I am able to pull data for other tables but this query always fails with the error

rpc error: code = Unknown desc = accuknox_azure: GET https://management.azure.com/subscriptions/6167e07f-ec68-49bf-aa2a-c2e2c4d5c3f8/providers/Microsoft.Authorization/roleAssignments

Expected behavior A clear and concise description of what you expected to happen.

The query should not fail.

Additional context Just that the turbot cloud product and the open source Steampipe azure plugins fail consistently with the same error