search

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
34 stars 15 forks source link

Warning: executeQueries: query 1 of 1 failed: ERROR: relation "azuread_user" does not exist (SQLSTATE 42P01) #752

Closed MathCarv closed 2 months ago

MathCarv commented 2 months ago

Describe the bug Hello, I'm trying to run a query in steampipe from azure users but it's giving an error, I changed the one from before to azure_ad_user because it was out of use, but this one isn't working either. can anybody help me?

Steampipe version (steampipe -v) Steampipe v0.21.4

Plugin version (steampipe plugin list) Installed: hub.steampipe.io/plugins/turbot/azure@latest Version: 0.56.0 Connections: Azure

To reproduce image

cbruno10 commented 2 months ago

Hi @MathCarv , the azuread_user table is in the Azure AD plugin, so if you install that plugin and setup the connection (can use the same creds in the configuration), then you can query the azuread_user table.

MathCarv commented 2 months ago

Hi @cbruno10, I installed azuread, updated it to make sure, but the error still persists, what could it be? image

MathCarv commented 2 months ago

Here worked, the error was in the .scp file, thank you!