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 table azure_alert_management Closes #665 #685

Closed ParthaI closed 10 months ago

ParthaI commented 11 months ago

Integration test logs

Logs ``` N/A ```

Example query results

Results ``` > select * from azure_alert_management where time_range = '7d' and resource_group = 'turbot_rg' Warning: failed to start 6 plugins using an incompatible sdk version, (required by 6 connections). To update, please run: steampipe plugin update twilio ibm chaos urlscan reddit zendesk +--------------------+--------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------+------------+---------+-------------------+------------+----------+---------> | name | id | type | sort_order | sort_by | custom_time_range | time_range | severity | signal_t> +--------------------+--------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------+------------+---------+-------------------+------------+----------+---------> | Delete Backup Data | /subscriptions/gdyr56jd-f95f-4771-bbb5-hsjfbg456938/providers/Microsoft.AlertsManagement/alerts/92ee9cfc-9276-c1bb-1072-18628b580008 | Microsoft.AlertsManagement/alerts | | | | 7d | Sev0 | Log > | | | | | | | | | > | Delete Backup Data | /subscriptions/gdyr56jd-f95f-4771-bbb5-hsjfbg456938/providers/Microsoft.AlertsManagement/alerts/322283b2-6ca4-4095-fa09-88cee5000008 | Microsoft.AlertsManagement/alerts | | | | 7d | Sev0 | Log > | | | | | | | | | > | Backup Failure | /subscriptions/gdyr56jd-f95f-4771-bbb5-hsjfbg456938/providers/Microsoft.AlertsManagement/alerts/a6e4b154-34a5-84ae-c4c4-b86e0e920008 | Microsoft.AlertsManagement/alerts | | | | 7d | Sev1 | Log > | | | | | | | | | > +--------------------+--------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------+------------+---------+-------------------+------------+----------+---------> > select * from azure_alert_management +--------------------+--------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------+----------> | name | id | type | sort_orde> +--------------------+--------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------+----------> | Delete Backup Data | /subscriptions/gdyr56jd-f95f-4771-bbb5-hsjfbg456938/providers/Microsoft.AlertsManagement/alerts/92ee9cfc-9276-c1bb-1072-18628b580008 | Microsoft.AlertsManagement/alerts | > | | | | > +--------------------+--------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------+----------> ```