Hi Nux! I am referring to cloud_usage.cloud_usage table.
But I am talking to the author of this feature, and looks like it is related to another new feature in 4.4 - dynamic offering. So now when you create a ComputeOffering, you can check/uncheck 'custom': (unchecked) http://clip2net.com/s/jdjAkz (checked) http://clip2net.com/s/jdjBzi Kind regards, Ilia Shakitko Innovation Engineer LeaseWeb Technologies B.V. T: +31 20 316 0235 M: E: i.shaki...@tech.leaseweb.com W: http://www.leaseweb.com Luttenbergweg 8, 1101 EC Amsterdam, Netherlands -----Original Message----- From: Nux! [mailto:n...@li.nux.ro] Sent: dinsdag, 04 november, 2014 10:09 To: dev@cloudstack.apache.org Subject: Re: [CLOUDSTACK-6850][4.4.2][BUG] - listUsageRecords with type=2 doesn't return "Cpu cores, cpu speed and memory" Hello Ilia, Most of the stuff I see re cores, memory and so on is NULL for me (4.4.1 ADVSG zone). Are you referring at some particular DB table? Lucian -- Sent from the Delta quadrant using Borg technology! Nux! www.nux.ro ----- Original Message ----- > From: "Ilia Shakitko" <i.shaki...@tech.leaseweb.com> > To: dev@cloudstack.apache.org > Sent: Tuesday, 4 November, 2014 08:18:02 > Subject: RE: [CLOUDSTACK-6850][4.4.2][BUG] - listUsageRecords with > type=2 doesn't return "Cpu cores, cpu speed and memory" > 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.shaki...@tech.leaseweb.com > W: http://www.leaseweb.com > > Luttenbergweg 8, 1101 EC Amsterdam, Netherlands > > > -----Original Message----- > From: Ilia Shakitko [mailto:i.shaki...@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=20 > 14-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.shaki...@tech.leaseweb.com > W: www.leaseweb.com<http://www.leaseweb.com> > > Luttenbergweg 8, 1101 EC Amsterdam, Netherlands
