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

Add column `disable_local_auth` to table `azure_cosmosdb_account`. Closes #735 #736

Closed Priyanka-Chatterjee-2000 closed 6 months ago

Priyanka-Chatterjee-2000 commented 6 months ago

Integration test logs

Logs ``` Add passing integration test logs here ```

Example query results

Results ``` select a.id as resource, case when disable_local_auth then 'ok' else 'alarm' end as status, case when disable_local_auth then a.name || ' is using AAD and RBAC.' else a.name || ' is not using AAD and RBAC.' end as reason from azure_cosmosdb_account as a, azure_subscription as sub where sub.subscription_id = a.subscription_id; [ { "reason": "turbot-test-20200125-create-update is using AAD and RBAC.", "resource": "/subscriptions/dddddddd-bbbb-7777777777c/resourceGroups/turbot-test-20200125-create-update/providers/Microsoft.DocumentDB/databaseAccounts/turbot-test-20200125-create-update", "status": "ok" } ] ```