cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ilia Shakitko <i.shaki...@tech.leaseweb.com>
Subject RE: [CLOUDSTACK-6850][4.4.2][BUG] - listUsageRecords with type=2 doesn't return "Cpu cores, cpu speed and memory"
Date Tue, 04 Nov 2014 08:18:02 GMT
Does anybody have Cores, Memory stored & displayed with UsageServer in 4.4?


Kind regards,

Ilia Shakitko
Innovation Engineer
LeaseWeb Technologies B.V.

T: +31 20 316 0235
M:
E: i.shakitko@tech.leaseweb.com
W: http://www.leaseweb.com

Luttenbergweg 8, 1101 EC Amsterdam, Netherlands


-----Original Message-----
From: Ilia Shakitko [mailto:i.shakitko@tech.leaseweb.com]
Sent: maandag, 03 november, 2014 15:28
To: dev@cloudstack.apache.org
Subject: [CLOUDSTACK-6850][4.4.2][BUG] - listUsageRecords with type=2 doesn't return "Cpu
cores, cpu speed and memory"

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: i.shakitko@tech.leaseweb.com
W: www.leaseweb.com<http://www.leaseweb.com>

Luttenbergweg 8,        1101 EC Amsterdam,      Netherlands



Mime
View raw message