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_recovery_services_backup_job Closes #663 #681

Closed ParthaI closed 10 months ago

ParthaI commented 11 months ago

Integration test logs

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

Example query results

Results ``` > select name, properties from azure_backup_job where vault_name = 'test43-delete-me' +--------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> | name | properties > +--------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> | 4617f498-e84f-4236-9bb1-7dd4f9f3a6f7 | {"ActivityID":"7b55c0e3-38d5-4cc3-b4c8-33215d2ff010","BackupManagementType":"AzureIaasVM","EndTime":"2023-10-06T06:26:51.4907961Z","EntityFriendlyName":"test-backup","JobType":"AzureIaaSVMJob","Operation":"Undelete","StartTime":> | c4319ff5-9640-4090-84fb-1f70298fc0a5 | {"ActivityID":"7b55c0e3-38d5-4cc3-b4c8-33215d2ff019","BackupManagementType":"AzureIaasVM","EndTime":"2023-10-06T06:27:59.0919188Z","EntityFriendlyName":"test-backup","JobType":"AzureIaaSVMJob","Operation":"DeleteBackupData","Sta> | 9e81c8ba-df5a-4aa9-8e80-6906f0fecb58 | {"ActivityID":"346be913-6e41-4b61-902a-84993baf10d6","BackupManagementType":"AzureIaasVM","EndTime":"2023-10-04T15:15:45.1782379Z","EntityFriendlyName":"test-backup","JobType":"AzureIaaSVMJob","Operation":"ConfigureBackup","Star> | 0cde75e9-72d0-403a-9923-12c1baa2fe8f | {"ActivityID":"5c4398d6-45cd-48f1-9593-a3c2e567edae","BackupManagementType":"AzureIaasVM","EndTime":"2023-10-04T18:16:14.6749904Z","EntityFriendlyName":"test-backup","JobType":"AzureIaaSVMJob","Operation":"Backup","StartTime":"2> | c85988ea-c528-4b91-b683-ae99bdc35d5b | {"ActivityID":"5d3dc4bb-2899-456c-8464-75eb2fe7c017","BackupManagementType":"AzureIaasVM","EndTime":"2023-10-05T10:50:18.7032339Z","EntityFriendlyName":"test-backup","JobType":"AzureIaaSVMJob","Operation":"DisableBackup","StartT> | 86b76c54-f012-4832-97be-b9c184aa378b | {"ActivityID":"5d3dc4bb-2899-456c-8464-75eb2fe7c025","BackupManagementType":"AzureIaasVM","EndTime":"2023-10-05T10:52:26.74136Z","EntityFriendlyName":"test-backup","JobType":"AzureIaaSVMJob","Operation":"DeleteBackupData","Start> +--------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> ```
ParthaI commented 11 months ago

The PR is in draft state cause of we are encountering an error from Azure Go SDK side while making the API, An issue has been raised on Azure Go SDK side regarding this, once it will get resolved we will comeback to this issue and make it ready for review.

SDK issue reference: https://github.com/Azure/azure-sdk-for-go/issues/21690

ParthaI commented 11 months ago

As per the Azure SDK issue comment, the API is working fine with lated SDK version and it is returning the result as expected. This PR is good to review now. 👍