v1.0 for Steampipe, Powerpipe, Flowpipe, 116 plugins, and 44 mods →

Plugins Docs Home

turbot/digitalocean_insights

0Controls

0Variables

blockstorage_volume_1_year_count blockstorage_volume_24_hours_count blockstorage_volume_30_90_days_count blockstorage_volume_30_days_count blockstorage_volume_90_365_days_count blockstorage_volume_age_table blockstorage_volume_attached_droplets blockstorage_volume_attached_droplets_count blockstorage_volume_by_droplet_attached blockstorage_volume_by_filesystem_type blockstorage_volume_by_region blockstorage_volume_count blockstorage_volume_creation_month blockstorage_volume_droplet_attached_count blockstorage_volume_filesystem_type blockstorage_volume_input blockstorage_volume_overview blockstorage_volume_storage blockstorage_volume_storage_by_filesystem_type blockstorage_volume_storage_creation_month blockstorage_volume_tags blockstorage_volume_total_storage blockstorage_volume_volume_by_region blockstorage_volumes_for_droplet database_cluster_1_year_count database_cluster_24_hours_count database_cluster_30_90_days_count database_cluster_30_days_count database_cluster_90_365_days_count database_cluster_age_table database_cluster_by_creation_month database_cluster_by_engine database_cluster_by_region database_cluster_by_status database_cluster_count database_cluster_engine_version database_cluster_firewall_enabled database_cluster_firewall_enabled_count database_cluster_firewall_rules database_cluster_input database_cluster_maintenance_window database_cluster_node_count database_cluster_overview database_cluster_private_connection database_cluster_ssl_enabled database_cluster_ssl_enabled_count database_cluster_status database_cluster_tags database_clusters_for_kubernetes_cluster database_clusters_for_network_vpc digitalocean_droplet_1_year_count digitalocean_droplet_24_hours_count digitalocean_droplet_30_90_days_count digitalocean_droplet_30_days_count digitalocean_droplet_90_365_days_count digitalocean_droplet_age_table digitalocean_project_count digitalocean_project_table droplet_attached_volumes droplet_backup_disabled droplet_backup_status droplet_by_backup_status droplet_by_distribution_type droplet_by_firewall_status droplet_by_monitoring_status droplet_by_public_access droplet_by_region droplet_by_ssl_status droplet_by_status droplet_count droplet_creation_month droplet_droplets_for_blockstorage_volume droplet_droplets_for_database_cluster droplet_droplets_for_network_firewall droplet_droplets_for_network_vpc droplet_firewall_configuration droplet_input droplet_monitoring_status droplet_monitoring_status_count droplet_network_vpc_details droplet_overview droplet_public_access droplet_publicly_accessible droplet_status droplet_storage droplet_tags droplet_total_size droplet_vcpus image_images_for_droplet kubernetes_cluster_1_year_count kubernetes_cluster_24_hours_count kubernetes_cluster_30_90_days_count kubernetes_cluster_30_days_count kubernetes_cluster_90_365_days_count kubernetes_cluster_age_table kubernetes_cluster_auto_upgrade_count kubernetes_cluster_auto_upgrade_status kubernetes_cluster_by_auto_upgrade_status kubernetes_cluster_by_region kubernetes_cluster_by_status kubernetes_cluster_by_surge_upgrade_status kubernetes_cluster_count kubernetes_cluster_creation_month kubernetes_cluster_degraded_count kubernetes_cluster_detail_status kubernetes_cluster_input kubernetes_cluster_network_vpc_details kubernetes_cluster_node_pool_details kubernetes_cluster_nodes_for_kubernetes_cluster kubernetes_cluster_overview kubernetes_cluster_registry_enabled kubernetes_cluster_status kubernetes_cluster_surge_upgrade_count kubernetes_cluster_surge_upgrade_status kubernetes_cluster_tags kubernetes_clusters_for_database_cluster kubernetes_clusters_for_network_vpc kubernetes_node_pools_for_kubernetes_cluster network_firewall_1_year_count network_firewall_24_hours_count network_firewall_30_90_days_count network_firewall_30_days_count network_firewall_90_365_days_count network_firewall_age_table network_firewall_attached network_firewall_by_status network_firewall_count network_firewall_creation_month network_firewall_inbound_analysis network_firewall_input network_firewall_outbound_analysis network_firewall_overview network_firewall_status network_firewall_tags network_firewall_unrestricted_inbound_rules network_firewall_unrestricted_inbound_rules_count network_firewall_unrestricted_inbound_status network_firewall_unrestricted_outbound_rules network_firewall_unrestricted_outbound_rules_count network_firewall_unrestricted_outbound_status network_firewalls_for_droplet network_firewalls_for_network_vpc network_floating_ips_for_blockstorage_volume network_floating_ips_for_droplet network_floating_ips_for_snapshot network_load_balancers_for_droplet network_load_balancers_for_network_vpc network_vpc_association network_vpc_by_region network_vpc_by_rfc1918_range network_vpc_count network_vpc_creation_month network_vpc_default_count network_vpc_default_status network_vpc_input network_vpc_ip_range network_vpc_is_default network_vpc_overview network_vpc_tags network_vpcs_for_database_cluster network_vpcs_for_droplet network_vpcs_for_kubernetes_cluster network_vpcs_for_network_firewall snapshot_1_year_count snapshot_24_hours_count snapshot_30_90_days_count snapshot_30_days_count snapshot_90_365_days_count snapshot_age_table snapshot_by_region snapshot_by_resource_type snapshot_count snapshot_creation_month snapshot_input snapshot_minimum_disk_size snapshot_overview snapshot_resource_type snapshot_size snapshot_snapshots_for_droplet snapshot_source_blockstorage_volume snapshot_source_droplet snapshot_tags snapshot_total_storage source_blockstorage_volumes_for_snapshot source_droplet_droplets_for_snapshot storage_snapshot_by_region storage_snapshot_by_resource_type storage_snapshot_creation_month target_droplet_droplets_for_snapshot target_snapshot_snapshots_for_blockstorage_volume

Query: snapshot_24_hours_count

Usage

powerpipe query digitalocean_insights.query.snapshot_24_hours_count

Steampipe Tables

digitalocean_snapshot

DigitalOcean plugin

SQL

select
  count(*) as value,
  '< 24 hours' as label
from
  digitalocean_snapshot
where
  created_at > now() - '1 days' :: interval;

Dashboards

The query is used in the dashboards:

DigitalOcean Snapshots Age Report