I’ve checked the commit and review (https://reviews.apache.org/r/22354/). It
looks like there should be additional parameters returned in the response for
request with type=2
API Request:
command=listUsageRecords&response=json&startdate=2014-11-03&enddate=2014-11-03&type=2
API Response:
class stdClass#1 (1) {
public $listusagerecordsresponse =>
class stdClass#2 (2) {
public $count =>
int(6)
public $usagerecord =>
array(6) {
[0] =>
class stdClass#3 (16) {
public $account =>
string(6) "ISH001"
public $accountid =>
string(36) "e2104bd7-dc87-4528-9d69-7141c79d7879"
public $domainid =>
string(36) "8255b58c-39d1-4221-837f-3a6a8ed84a3f"
public $zoneid =>
string(36) "75cb86ef-d0e0-4459-b781-0a31002f2786"
public $description =>
string(55) "wolkvm01 allocated (ServiceOffering: 1) (Template: 201)"
public $usage =>
string(12) "0.166666 Hrs"
public $usagetype =>
int(2)
public $rawusage =>
string(8) "0.166666"
public $virtualmachineid =>
string(36) "5a2c057a-6aff-44ae-8b65-ff524c8c2007"
public $name =>
string(8) "wolkvm01"
public $offeringid =>
string(36) "39f423ca-9c83-4061-9ad6-4f5b48fa312c"
public $templateid =>
string(36) "92b60dfd-11a3-4b47-8a93-1a65cef9619f"
public $usageid =>
string(36) "5a2c057a-6aff-44ae-8b65-ff524c8c2007"
public $type =>
string(3) "KVM"
public $startdate =>
string(27) "2014-11-03'T'15:05:00+01:00"
public $enddate =>
string(27) "2014-11-03'T'15:15:00+01:00"
}
[1] =>
class stdClass#4 (16) {
public $account =>
string(6) "ISH001"
public $accountid =>
string(36) "e2104bd7-dc87-4528-9d69-7141c79d7879"
public $domainid =>
string(36) "8255b58c-39d1-4221-837f-3a6a8ed84a3f"
public $zoneid =>
string(36) "75cb86ef-d0e0-4459-b781-0a31002f2786"
public $description =>
string(55) "wolkvm01 allocated (ServiceOffering: 1) (Template: 201)"
public $usage =>
string(12) "0.166667 Hrs"
public $usagetype =>
int(2)
public $rawusage =>
string(8) "0.166667"
public $virtualmachineid =>
string(36) "5a2c057a-6aff-44ae-8b65-ff524c8c2007"
public $name =>
string(8) "wolkvm01"
public $offeringid =>
string(36) "39f423ca-9c83-4061-9ad6-4f5b48fa312c"
public $templateid =>
string(36) "92b60dfd-11a3-4b47-8a93-1a65cef9619f"
public $usageid =>
string(36) "5a2c057a-6aff-44ae-8b65-ff524c8c2007"
public $type =>
string(3) "KVM"
public $startdate =>
string(27) "2014-11-03'T'14:55:00+01:00"
public $enddate =>
string(27) "2014-11-03'T'15:05:00+01:00"
}
…
}}}
MySQL, cloud_usage:
mysql> select * from cloud_usage where usage_type = 2;
+--------+---------+------------+-----------+---------------------------------------------------------+---------------+------------+---------------------+----------------+----------+-------------+-------------+----------+------+------+------------+---------------------+---------------------+--------------+-----------+-----------+--------+
| id | zone_id | account_id | domain_id | description
| usage_display | usage_type | raw_usage |
vm_instance_id | vm_name | offering_id | template_id | usage_id | type | size
| network_id | start_date | end_date | virtual_size |
cpu_speed | cpu_cores | memory |
+--------+---------+------------+-----------+---------------------------------------------------------+---------------+------------+---------------------+----------------+----------+-------------+-------------+----------+------+------+------------+---------------------+---------------------+--------------+-----------+-----------+--------+
| 152915 | 1 | 23 | 11 | wolkvm01 allocated
(ServiceOffering: 1) (Template: 201) | 0.166667 Hrs | 2 |
0.1666669398546219 | 31 | wolkvm01 | 1 | 201 |
31 | KVM | NULL | NULL | 2014-11-03 13:15:00 | 2014-11-03 13:25:00 |
NULL | NULL | NULL | NULL |
| 152943 | 1 | 23 | 11 | wolkvm01 allocated
(ServiceOffering: 1) (Template: 201) | 0.166663 Hrs | 2 |
0.16666333377361298 | 31 | wolkvm01 | 1 | 201 |
31 | KVM | NULL | NULL | 2014-11-03 13:25:00 | 2014-11-03 13:35:00 |
NULL | NULL | NULL | NULL |
| 152971 | 1 | 23 | 11 | wolkvm01 allocated
(ServiceOffering: 1) (Template: 201) | 0.166667 Hrs | 2 |
0.1666666716337204 | 31 | wolkvm01 | 1 | 201 |
31 | KVM | NULL | NULL | 2014-11-03 13:35:00 | 2014-11-03 13:45:00 |
NULL | NULL | NULL | NULL |
| 152999 | 1 | 23 | 11 | wolkvm01 allocated
(ServiceOffering: 1) (Template: 201) | 0.166667 Hrs | 2 |
0.1666666716337204 | 31 | wolkvm01 | 1 | 201 |
31 | KVM | NULL | NULL | 2014-11-03 13:45:00 | 2014-11-03 13:55:00 |
NULL | NULL | NULL | NULL |
| 153027 | 1 | 23 | 11 | wolkvm01 allocated
(ServiceOffering: 1) (Template: 201) | 0.166667 Hrs | 2 |
0.1666669398546219 | 31 | wolkvm01 | 1 | 201 |
31 | KVM | NULL | NULL | 2014-11-03 13:55:00 | 2014-11-03 14:05:00 |
NULL | NULL | NULL | NULL |
| 153055 | 1 | 23 | 11 | wolkvm01 allocated
(ServiceOffering: 1) (Template: 201) | 0.166666 Hrs | 2 |
0.16666610538959503 | 31 | wolkvm01 | 1 | 201 |
31 | KVM | NULL | NULL | 2014-11-03 14:05:00 | 2014-11-03 14:15:00 |
NULL | NULL | NULL | NULL |
| 153086 | 1 | 23 | 11 | wolkvm01 allocated
(ServiceOffering: 1) (Template: 201) | 0.166667 Hrs | 2 |
0.1666666716337204 | 31 | wolkvm01 | 1 | 201 |
31 | KVM | NULL | NULL | 2014-11-03 14:15:00 | 2014-11-03 14:25:00 |
NULL | NULL | NULL | NULL |
+--------+---------+------------+-----------+---------------------------------------------------------+---------------+------------+---------------------+----------------+----------+-------------+-------------+----------+------+------+------------+---------------------+---------------------+--------------+-----------+-----------+--------+
Kind regards,
Ilia Shakitko
Innovation Engineer
LeaseWeb Technologies B.V.
T: +31 20 316 0235
E: [email protected]
W: www.leaseweb.com<http://www.leaseweb.com>
Luttenbergweg 8, 1101 EC Amsterdam, Netherlands
