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

Add table azure_data_protection_backup_job Closes #782 #786

Closed ParthaI closed 2 weeks ago

ParthaI commented 2 weeks ago

Integration test logs

Logs ``` N/A ```

Example query results

Results ``` > select * from azure_data_protection_backup_job { "rows": [ { "_ctx": { "connection_name": "azure", "steampipe": { "sdk_version": "5.10.1" } }, "activity_id": "3c59479b-3a7e-4e7b-aa8a-da0b6dd7d04a-Ibz", "akas": [ "azure:///subscriptions/********-****-****-****-************/resourceGroups/turbottest85362/providers/Microsoft.DataProtection/backupVaults/turbottest85362/backupJobs/9c395c24-ce22-4724-a1db-ad6321606c89", "azure:///subscriptions/********-****-****-****-************/resourcegroups/turbottest85362/providers/microsoft.dataprotection/backupvaults/turbottest85362/backupjobs/9c395c24-ce22-4724-a1db-ad6321606c89" ], "backup_instance_friendly_name": "turbottest85362", "backup_instance_id": "/subscriptions/********-****-****-****-************/resourceGroups/turbottest85362/providers/Microsoft.DataProtection/backupVaults/turbottest85362/backupInstances/turbottest85362", "cloud_environment": "AzurePublicCloud", "data_source_id": "/subscriptions/********-****-****-****-************/resourceGroups/turbottest85362/providers/Microsoft.Compute/disks/turbottest85362", "data_source_location": "eastus", "data_source_name": "turbottest85362", "data_source_set_name": null, "data_source_type": "Microsoft.Compute/disks", "destination_data_store_name": null, "duration": "00:00:00", "end_time": null, "error_details": null, "etag": "W/\"datetime'2024-06-18T12%3A46%3A47.8085272Z'\"", "extended_info": null, "id": "/subscriptions/********-****-****-****-************/resourceGroups/turbottest85362/providers/Microsoft.DataProtection/backupVaults/turbottest85362/backupJobs/9c395c24-ce22-4724-a1db-ad6321606c89", "is_user_triggered": true, "name": "9c395c24-ce22-4724-a1db-ad6321606c89", "operation": "Backup", "operation_category": "Backup", "policy_id": "/subscriptions/********-****-****-****-************/resourceGroups/turbottest85362/providers/Microsoft.DataProtection/backupVaults/turbottest85362/backupPolicies/turbottest85362", "policy_name": "turbottest85362", "progress_enabled": false, "progress_url": null, "region": "eastus", "resource_group": "turbottest85362", "restore_type": null, "source_data_store_name": null, "source_resource_group": "turbottest85362", "source_subscription_id": "********-****-****-****-************", "sp_connection_name": "azure", "sp_ctx": { "connection_name": "azure", "steampipe": { "sdk_version": "5.10.1" } }, "start_time": "2024-06-18T18:16:47+05:30", "status": "InProgress", "subscription_id": "********-****-****-****-************", "supported_actions": [ "" ], "title": "9c395c24-ce22-4724-a1db-ad6321606c89", "type": "Microsoft.DataProtection/backupVaults/backupJobs", "vault_name": "turbottest85362" } ], "metadata": { "duration_ms": 131, "scans": [ { "connection": "azure", "table": "azure_data_protection_backup_job", "cache_hit": true, "rows_fetched": 1, "hydrate_calls": 0, "start_time": "2024-06-18T18:17:36+05:30", "duration_ms": 16, "columns": [ "backup_instance_friendly_name", "progress_enabled", "destination_data_store_name", "error_details", "status", "etag", "policy_id", "title", "akas", "cloud_environment", "name", "operation", "operation_category", "source_resource_group", "source_subscription_id", "start_time", "data_source_set_name", "sp_ctx", "_ctx", "id", "data_source_name", "restore_type", "resource_group", "type", "backup_instance_id", "extended_info", "activity_id", "supported_actions", "subscription_id", "data_source_id", "data_source_location", "source_data_store_name", "sp_connection_name", "region", "vault_name", "data_source_type", "is_user_triggered", "duration", "end_time", "policy_name", "progress_url" ] } ], "scan_count": 1, "rows_returned": 1, "uncached_rows_fetched": 0, "cached_rows_fetched": 1, "hydrate_calls": 0, "connection_count": 1 } } ```