Volume information

results.txt

*************************** 1. row ***************************
         created_at: 2013-03-28 13:49:46
         updated_at: 2013-04-25 18:02:08
         deleted_at: NULL
            deleted: 0
                 id: 386
             ec2_id: NULL
            user_id: 790e3caa38984fccb158b05571e1bc6c
         project_id: 3ab47e19d21c4672973e57e7a8c85c83
               host: cloud-desa03
               size: 2
  availability_zone: nova
        instance_id: 2214
         mountpoint: /dev/vdbmydaty
        attach_time: NULL
             status: in-use
      attach_status: attached
       scheduled_at: 2013-03-28 13:49:47
        launched_at: 2013-03-28 13:50:00
      terminated_at: NULL
       display_name: mydaty
display_description: Volume created by CloudIA
  provider_location: 4075
      provider_auth: NULL
        snapshot_id: NULL
     volume_type_id: NULL
1 row in set (0.00 sec)

mysql> select * from block_device_mapping where volume_id = 386 and deleted = 0\G 
*************************** 1. row ***************************
           created_at: 2013-04-25 18:02:08
           updated_at: NULL
           deleted_at: NULL
              deleted: 0
                   id: 559
          instance_id: 2214
          device_name: /dev/vdbmydaty
delete_on_termination: 0
         virtual_name: NULL
          snapshot_id: NULL
            volume_id: 386
          volume_size: NULL
            no_device: NULL
      connection_info: {"driver_volume_type": "iscsi", "data": {"device_path": "/dev/disk/by-path/ip-10.1.1.125:3260-iscsi-iqn.1992-08.com.netapp:sn.135043481-lun-2", "target_discovered": false, "target_iqn": "iqn.1992-08.com.netapp:sn.135043481", "target_portal": "10.1.1.125:3260", "volume_id": 386, "target_lun": "2"}}
1 row in set (0.00 sec)