mysql> select * from vm_instance where id = 2\G
*************************** 1. row ***************************
                 id: 2
               name: s-2-VM
      instance_name: s-2-VM
              state: Expunging
     vm_template_id: 1
        guest_os_id: 15
private_mac_address: 06:35:92:00:00:05
 private_ip_address: 192.168.10.24
    private_netmask: NULL
             pod_id: 1
     data_center_id: 1
            host_id: NULL
       last_host_id: 1
           proxy_id: 1
  proxy_assign_time: 2011-07-12 20:07:00
       vnc_password: ac7e761b8983e95
         ha_enabled: 1
       update_count: 8
        update_time: 2011-07-19 13:40:59
            created: 2011-07-12 19:57:00
            removed: 2011-07-19 13:41:01
               type: SecondaryStorageVm
         account_id: 1
          domain_id: 1
service_offering_id: 7
     reservation_id: NULL
    hypervisor_type: XenServer
      limit_cpu_use: 0
            vm_type: SecondaryStorageVm
1 row in set (0.00 sec)