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
37 stars 17 forks source link

Add table `azure_maintenance_configuration` + items #724

Closed Shr3ps closed 6 months ago

Shr3ps commented 8 months ago

Azure is now pushing up the new service Update Center. We would like to have a new table to list all update maintenance configurations in place and also would be great to be able to list all items (vm) attached with their update "state".

SDK model I found: https://github.com/Azure/azure-sdk-for-go/blob/v58.0.0/services/maintenance/mgmt/2021-05-01/maintenance/models.go

image

ParthaI commented 7 months ago

Hello @Shr3ps, thank you for bringing this issue to our attention.

I've raised a PR to introduce a new table, azure_maintenance_configuration which will provide us the information about the Maintenance Configuration.

Currently, there is no direct API to fetch the update status of VMs along with the count of critical, missing, and other updates as depicted in the snapshot provided in the issue description.

I came across this article which, unfortunately, doesn't fully meet our needs.

We plan to revisit this once Azure extends their API support to cover these requirements.

Thank you!

Shr3ps commented 7 months ago

Thanks for this first PR and table @ParthaI ! I hope you will be able to find a way to list attached items to configuration even without statuses (list of VM for example).