SELECT instances.created_at AS instances_created_at,
instances.updated_at AS instances_updated_at,
instances.deleted_at AS instances_deleted_at,
instances.deleted AS instances_deleted,
instances.id AS instances_id,
instances.user_id AS instances_user_id,
instances.project_id AS instances_project_id,
instances.image_ref AS instances_image_ref,
instances.kernel_id AS instances_kernel_id,
instances.ramdisk_id AS instances_ramdisk_id,
instances.server_name AS instances_server_name,
instances.launch_index AS instances_launch_index,
instances.key_name AS instances_key_name,
instances.key_data AS instances_key_data,
instances.power_state AS instances_power_state,
instances.vm_state AS instances_vm_state,
instances.task_state AS instances_task_state,
instances.memory_mb AS instances_memory_mb,
instances.vcpus AS instances_vcpus,
instances.local_gb AS instances_local_gb,
instances.hostname AS instances_hostname,
instances.host AS instances_host,
instances.instance_type_id AS
instances_instance_type_id,
instances.user_data AS instances_user_data,
instances.reservation_id AS instances_reservation_id,
instances.scheduled_at AS instances_scheduled_at,
instances.launched_at AS instances_launched_at,
instances.terminated_at AS instances_terminated_at,
instances.availability_zone AS
instances_availability_zone,
instances.display_name AS instances_display_name,
instances.display_description AS
instances_display_description,
instances.launched_on AS instances_launched_on,
instances.locked AS instances_locked,
instances.os_type AS instances_os_type,
instances.architecture AS instances_architecture,
instances.vm_mode AS instances_vm_mode,
instances.uuid AS instances_uuid,
instances.root_device_name AS
instances_root_device_name,
instances.default_local_device AS
instances_default_local_device,
instances.default_swap_device AS
instances_default_swap_device,
instances.config_drive AS instances_config_drive,
instances.access_ip_v4 AS instances_access_ip_v4,
instances.access_ip_v6 AS instances_access_ip_v6,
security_groups_1.created_at AS
security_groups_1_created_at,
security_groups_1.updated_at AS
security_groups_1_updated_at,
security_groups_1.deleted_at AS
security_groups_1_deleted_at,
security_groups_1.deleted AS security_groups_1_deleted
,
security_groups_1.id AS
security_groups_1_id,
security_groups_1.name AS security_groups_1_name,
security_groups_1.description AS
security_groups_1_description,
security_groups_1.user_id AS security_groups_1_user_id
,
security_groups_1.project_id AS
security_groups_1_project_id,
networks_1.created_at AS networks_1_created_at,
networks_1.updated_at AS networks_1_updated_at,
networks_1.deleted_at AS networks_1_deleted_at,
networks_1.deleted AS networks_1_deleted,
networks_1.id AS networks_1_id,
networks_1.label AS networks_1_label,
networks_1.injected AS networks_1_injected,
networks_1.cidr AS networks_1_cidr,
networks_1.cidr_v6 AS networks_1_cidr_v6,
networks_1.multi_host AS networks_1_multi_host,
networks_1.gateway_v6 AS networks_1_gateway_v6,
networks_1.netmask_v6 AS networks_1_netmask_v6,
networks_1.netmask AS networks_1_netmask,
networks_1.bridge AS networks_1_bridge,
networks_1.bridge_interface AS
networks_1_bridge_interface,
networks_1.gateway AS networks_1_gateway,
networks_1.broadcast AS networks_1_broadcast,
networks_1.dns1 AS networks_1_dns1,
networks_1.dns2 AS networks_1_dns2,
networks_1.vlan AS networks_1_vlan,
networks_1.vpn_public_address AS
networks_1_vpn_public_address,
networks_1.vpn_public_port AS
networks_1_vpn_public_port,
networks_1.vpn_private_address AS
networks_1_vpn_private_address,
networks_1.dhcp_start AS networks_1_dhcp_start,
networks_1.project_id AS networks_1_project_id,
networks_1.priority AS networks_1_priority,
networks_1.host AS networks_1_host,
networks_1.uuid AS networks_1_uuid,
instances_1.created_at AS instances_1_created_at,
instances_1.updated_at AS instances_1_updated_at,
instances_1.deleted_at AS instances_1_deleted_at,
instances_1.deleted AS instances_1_deleted,
instances_1.id AS instances_1_id,
instances_1.user_id AS instances_1_user_id,
instances_1.project_id AS instances_1_project_id,
instances_1.image_ref AS instances_1_image_ref,
instances_1.kernel_id AS instances_1_kernel_id,
instances_1.ramdisk_id AS instances_1_ramdisk_id,
instances_1.server_name AS instances_1_server_name,
instances_1.launch_index AS instances_1_launch_index,
instances_1.key_name AS instances_1_key_name,
instances_1.key_data AS instances_1_key_data,
instances_1.power_state AS instances_1_power_state,
instances_1.vm_state AS instances_1_vm_state,
instances_1.task_state AS instances_1_task_state,
instances_1.memory_mb AS instances_1_memory_mb,
instances_1.vcpus AS instances_1_vcpus,
instances_1.local_gb AS instances_1_local_gb,
instances_1.hostname AS instances_1_hostname,
instances_1.host AS instances_1_host,
instances_1.instance_type_id AS
instances_1_instance_type_id,
instances_1.user_data AS instances_1_user_data,
instances_1.reservation_id AS
instances_1_reservation_id,
instances_1.scheduled_at AS instances_1_scheduled_at,
instances_1.launched_at AS instances_1_launched_at,
instances_1.terminated_at AS instances_1_terminated_at
,
instances_1.availability_zone AS
instances_1_availability_zone,
instances_1.display_name AS instances_1_display_name,
instances_1.display_description AS
instances_1_display_description,
instances_1.launched_on AS instances_1_launched_on,
instances_1.locked AS instances_1_locked,
instances_1.os_type AS instances_1_os_type,
instances_1.architecture AS instances_1_architecture,
instances_1.vm_mode AS instances_1_vm_mode,
instances_1.uuid AS instances_1_uuid,
instances_1.root_device_name AS
instances_1_root_device_name,
instances_1.default_local_device AS
instances_1_default_local_device,
instances_1.default_swap_device AS
instances_1_default_swap_device,
instances_1.config_drive AS instances_1_config_drive,
instances_1.access_ip_v4 AS instances_1_access_ip_v4,
instances_1.access_ip_v6 AS instances_1_access_ip_v6,
virtual_interfaces_1.created_at AS
virtual_interfaces_1_created_at,
virtual_interfaces_1.updated_at AS
virtual_interfaces_1_updated_at,
virtual_interfaces_1.deleted_at AS
virtual_interfaces_1_deleted_at,
virtual_interfaces_1.deleted AS
virtual_interfaces_1_deleted,
virtual_interfaces_1.id AS virtual_interfaces_1_id,
virtual_interfaces_1.address AS
virtual_interfaces_1_address,
virtual_interfaces_1.network_id AS
virtual_interfaces_1_network_id,
virtual_interfaces_1.instance_id AS
virtual_interfaces_1_instance_id,
virtual_interfaces_1.uuid AS virtual_interfaces_1_uuid
,
networks_2.created_at AS
networks_2_created_at,
networks_2.updated_at AS networks_2_updated_at,
networks_2.deleted_at AS networks_2_deleted_at,
networks_2.deleted AS networks_2_deleted,
networks_2.id AS networks_2_id,
networks_2.label AS networks_2_label,
networks_2.injected AS networks_2_injected,
networks_2.cidr AS networks_2_cidr,
networks_2.cidr_v6 AS networks_2_cidr_v6,
networks_2.multi_host AS networks_2_multi_host,
networks_2.gateway_v6 AS networks_2_gateway_v6,
networks_2.netmask_v6 AS networks_2_netmask_v6,
networks_2.netmask AS networks_2_netmask,
networks_2.bridge AS networks_2_bridge,
networks_2.bridge_interface AS
networks_2_bridge_interface,
networks_2.gateway AS networks_2_gateway,
networks_2.broadcast AS networks_2_broadcast,
networks_2.dns1 AS networks_2_dns1,
networks_2.dns2 AS networks_2_dns2,
networks_2.vlan AS networks_2_vlan,
networks_2.vpn_public_address AS
networks_2_vpn_public_address,
networks_2.vpn_public_port AS
networks_2_vpn_public_port,
networks_2.vpn_private_address AS
networks_2_vpn_private_address,
networks_2.dhcp_start AS networks_2_dhcp_start,
networks_2.project_id AS networks_2_project_id,
networks_2.priority AS networks_2_priority,
networks_2.host AS networks_2_host,
networks_2.uuid AS networks_2_uuid,
fixed_ips_1.created_at AS fixed_ips_1_created_at,
fixed_ips_1.updated_at AS fixed_ips_1_updated_at,
fixed_ips_1.deleted_at AS fixed_ips_1_deleted_at,
fixed_ips_1.deleted AS fixed_ips_1_deleted,
fixed_ips_1.id AS fixed_ips_1_id,
fixed_ips_1.address AS fixed_ips_1_address,
fixed_ips_1.network_id AS fixed_ips_1_network_id,
fixed_ips_1.virtual_interface_id AS
fixed_ips_1_virtual_interface_id,
fixed_ips_1.instance_id AS fixed_ips_1_instance_id,
fixed_ips_1.allocated AS fixed_ips_1_allocated,
fixed_ips_1.leased AS fixed_ips_1_leased,
fixed_ips_1.reserved AS fixed_ips_1_reserved,
fixed_ips_1.host AS fixed_ips_1_host,
floating_ips_1.created_at AS floating_ips_1_created_at
,
floating_ips_1.updated_at AS
floating_ips_1_updated_at,
floating_ips_1.deleted_at AS floating_ips_1_deleted_at
,
floating_ips_1.deleted AS
floating_ips_1_deleted,
floating_ips_1.id AS floating_ips_1_id,
floating_ips_1.address AS floating_ips_1_address,
floating_ips_1.fixed_ip_id AS
floating_ips_1_fixed_ip_id,
floating_ips_1.project_id AS floating_ips_1_project_id
,
floating_ips_1.host AS
floating_ips_1_host,
floating_ips_1.auto_assigned AS
floating_ips_1_auto_assigned,
instance_metadata_1.created_at AS
instance_metadata_1_created_at,
instance_metadata_1.updated_at AS
instance_metadata_1_updated_at,
instance_metadata_1.deleted_at AS
instance_metadata_1_deleted_at,
instance_metadata_1.deleted AS
instance_metadata_1_deleted,
instance_metadata_1.id AS instance_metadata_1_id,
instance_metadata_1.`key` AS instance_metadata_1_key,
instance_metadata_1.VALUE AS instance_metadata_1_value
,
instance_metadata_1.instance_id AS
instance_metadata_1_instance_id,
networks_3.created_at AS networks_3_created_at,
networks_3.updated_at AS networks_3_updated_at,
networks_3.deleted_at AS networks_3_deleted_at,
networks_3.deleted AS networks_3_deleted,
networks_3.id AS networks_3_id,
networks_3.label AS networks_3_label,
networks_3.injected AS networks_3_injected,
networks_3.cidr AS networks_3_cidr,
networks_3.cidr_v6 AS networks_3_cidr_v6,
networks_3.multi_host AS networks_3_multi_host,
networks_3.gateway_v6 AS networks_3_gateway_v6,
networks_3.netmask_v6 AS networks_3_netmask_v6,
networks_3.netmask AS networks_3_netmask,
networks_3.bridge AS networks_3_bridge,
networks_3.bridge_interface AS
networks_3_bridge_interface,
networks_3.gateway AS networks_3_gateway,
networks_3.broadcast AS networks_3_broadcast,
networks_3.dns1 AS networks_3_dns1,
networks_3.dns2 AS networks_3_dns2,
networks_3.vlan AS networks_3_vlan,
networks_3.vpn_public_address AS
networks_3_vpn_public_address,
networks_3.vpn_public_port AS
networks_3_vpn_public_port,
networks_3.vpn_private_address AS
networks_3_vpn_private_address,
networks_3.dhcp_start AS networks_3_dhcp_start,
networks_3.project_id AS networks_3_project_id,
networks_3.priority AS networks_3_priority,
networks_3.host AS networks_3_host,
networks_3.uuid AS networks_3_uuid,
networks_4.created_at AS networks_4_created_at,
networks_4.updated_at AS networks_4_updated_at,
networks_4.deleted_at AS networks_4_deleted_at,
networks_4.deleted AS networks_4_deleted,
networks_4.id AS networks_4_id,
networks_4.label AS networks_4_label,
networks_4.injected AS networks_4_injected,
networks_4.cidr AS networks_4_cidr,
networks_4.cidr_v6 AS networks_4_cidr_v6,
networks_4.multi_host AS networks_4_multi_host,
networks_4.gateway_v6 AS networks_4_gateway_v6,
networks_4.netmask_v6 AS networks_4_netmask_v6,
networks_4.netmask AS networks_4_netmask,
networks_4.bridge AS networks_4_bridge,
networks_4.bridge_interface AS
networks_4_bridge_interface,
networks_4.gateway AS networks_4_gateway,
networks_4.broadcast AS networks_4_broadcast,
networks_4.dns1 AS networks_4_dns1,
networks_4.dns2 AS networks_4_dns2,
networks_4.vlan AS networks_4_vlan,
networks_4.vpn_public_address AS
networks_4_vpn_public_address,
networks_4.vpn_public_port AS
networks_4_vpn_public_port,
networks_4.vpn_private_address AS
networks_4_vpn_private_address,
networks_4.dhcp_start AS networks_4_dhcp_start,
networks_4.project_id AS networks_4_project_id,
networks_4.priority AS networks_4_priority,
networks_4.host AS networks_4_host,
networks_4.uuid AS networks_4_uuid,
virtual_interfaces_2.created_at AS
virtual_interfaces_2_created_at,
virtual_interfaces_2.updated_at AS
virtual_interfaces_2_updated_at,
virtual_interfaces_2.deleted_at AS
virtual_interfaces_2_deleted_at,
virtual_interfaces_2.deleted AS
virtual_interfaces_2_deleted,
virtual_interfaces_2.id AS virtual_interfaces_2_id,
virtual_interfaces_2.address AS
virtual_interfaces_2_address,
virtual_interfaces_2.network_id AS
virtual_interfaces_2_network_id,
virtual_interfaces_2.instance_id AS
virtual_interfaces_2_instance_id,
virtual_interfaces_2.uuid AS virtual_interfaces_2_uuid
,
fixed_ips_2.created_at AS
fixed_ips_2_created_at,
fixed_ips_2.updated_at AS fixed_ips_2_updated_at,
fixed_ips_2.deleted_at AS fixed_ips_2_deleted_at,
fixed_ips_2.deleted AS fixed_ips_2_deleted,
fixed_ips_2.id AS fixed_ips_2_id,
fixed_ips_2.address AS fixed_ips_2_address,
fixed_ips_2.network_id AS fixed_ips_2_network_id,
fixed_ips_2.virtual_interface_id AS
fixed_ips_2_virtual_interface_id,
fixed_ips_2.instance_id AS fixed_ips_2_instance_id,
fixed_ips_2.allocated AS fixed_ips_2_allocated,
fixed_ips_2.leased AS fixed_ips_2_leased,
fixed_ips_2.reserved AS fixed_ips_2_reserved,
fixed_ips_2.host AS fixed_ips_2_host,
floating_ips_2.created_at AS floating_ips_2_created_at
,
floating_ips_2.updated_at AS
floating_ips_2_updated_at,
floating_ips_2.deleted_at AS floating_ips_2_deleted_at
,
floating_ips_2.deleted AS
floating_ips_2_deleted,
floating_ips_2.id AS floating_ips_2_id,
floating_ips_2.address AS floating_ips_2_address,
floating_ips_2.fixed_ip_id AS
floating_ips_2_fixed_ip_id,
floating_ips_2.project_id AS floating_ips_2_project_id
,
floating_ips_2.host AS
floating_ips_2_host,
floating_ips_2.auto_assigned AS
floating_ips_2_auto_assigned,
virtual_storage_arrays_1.created_at AS
virtual_storage_arrays_1_created_at,
virtual_storage_arrays_1.updated_at AS
virtual_storage_arrays_1_updated_at,
virtual_storage_arrays_1.deleted_at AS
virtual_storage_arrays_1_deleted_at,
virtual_storage_arrays_1.deleted AS
virtual_storage_arrays_1_deleted,
virtual_storage_arrays_1.id AS
virtual_storage_arrays_1_id,
virtual_storage_arrays_1.display_name AS
virtual_storage_arrays_1_display_name,
virtual_storage_arrays_1.display_description AS
virtual_storage_arrays_1_display_description,
virtual_storage_arrays_1.project_id AS
virtual_storage_arrays_1_project_id,
virtual_storage_arrays_1.availability_zone AS
virtual_storage_arrays_1_availability_zone,
virtual_storage_arrays_1.instance_type_id AS
virtual_storage_arrays_1_instance_type_id,
virtual_storage_arrays_1.image_ref AS
virtual_storage_arrays_1_image_ref,
virtual_storage_arrays_1.vc_count AS
virtual_storage_arrays_1_vc_count,
virtual_storage_arrays_1.vol_count AS
virtual_storage_arrays_1_vol_count,
virtual_storage_arrays_1.status AS
virtual_storage_arrays_1_status,
instance_types_1.created_at AS
instance_types_1_created_at,
instance_types_1.updated_at AS
instance_types_1_updated_at,
instance_types_1.deleted_at AS
instance_types_1_deleted_at,
instance_types_1.deleted AS instance_types_1_deleted,
instance_types_1.id AS instance_types_1_id,
instance_types_1.name AS instance_types_1_name,
instance_types_1.memory_mb AS
instance_types_1_memory_mb,
instance_types_1.vcpus AS instance_types_1_vcpus,
instance_types_1.local_gb AS instance_types_1_local_gb
,
instance_types_1.flavorid AS
instance_types_1_flavorid,
instance_types_1.swap AS instance_types_1_swap,
instance_types_1.rxtx_quota AS
instance_types_1_rxtx_quota,
instance_types_1.rxtx_cap AS instance_types_1_rxtx_cap
FROM instances
LEFT OUTER JOIN security_group_instance_association AS
security_group_instance_association_1
ON security_group_instance_association_1.instance_id = instances.id
AND instances.deleted = 0
LEFT OUTER JOIN security_groups AS security_groups_1
ON security_groups_1.id =
security_group_instance_association_1.security_group_id
AND security_group_instance_association_1.deleted = 0
AND security_groups_1.deleted = 0
LEFT OUTER JOIN virtual_interfaces AS virtual_interfaces_1
ON instances.id = virtual_interfaces_1.instance_id
LEFT OUTER JOIN networks AS networks_1
ON networks_1.id = virtual_interfaces_1.network_id
LEFT OUTER JOIN instances AS instances_1
ON instances_1.id = virtual_interfaces_1.instance_id
LEFT OUTER JOIN fixed_ips AS fixed_ips_1
ON virtual_interfaces_1.id = fixed_ips_1.virtual_interface_id
LEFT OUTER JOIN networks AS networks_2
ON networks_2.id = fixed_ips_1.network_id
LEFT OUTER JOIN floating_ips AS floating_ips_1
ON floating_ips_1.fixed_ip_id = fixed_ips_1.id
AND floating_ips_1.deleted = 0
LEFT OUTER JOIN instance_metadata AS instance_metadata_1
ON instance_metadata_1.instance_id = instances.id
AND instance_metadata_1.deleted = 0
LEFT OUTER JOIN fixed_ips AS fixed_ips_2
ON fixed_ips_2.instance_id = instances.id
AND fixed_ips_2.deleted = 0
LEFT OUTER JOIN networks AS networks_3
ON networks_3.id = fixed_ips_2.network_id
LEFT OUTER JOIN virtual_interfaces AS virtual_interfaces_2
ON virtual_interfaces_2.id = fixed_ips_2.virtual_interface_id
LEFT OUTER JOIN networks AS networks_4
ON networks_4.id = virtual_interfaces_2.network_id
LEFT OUTER JOIN floating_ips AS floating_ips_2
ON floating_ips_2.fixed_ip_id = fixed_ips_2.id
AND floating_ips_2.deleted = 0
LEFT OUTER JOIN instance_types AS instance_types_1
ON instances.instance_type_id = instance_types_1.id
LEFT OUTER JOIN virtual_storage_arrays AS virtual_storage_arrays_1
ON virtual_storage_arrays_1.instance_type_id = instance_types_1.id
ORDER BY instances.created_at DESC