[one-users] oneacct - "incorrect" figures in output

Thu Jan 17 09:06:13 PST 2013

It has been solved in the repo. You can apply the patch [1], or download
these files (check the paths before, as they may vary depending on how you
installed opennebula):

wget
http://dev.opennebula.org/projects/opennebula/repository/revisions/one-3.8/raw/src/cli/oneacct-O
`which oneacct`
wget
http://dev.opennebula.org/projects/opennebula/repository/revisions/one-3.8/raw/src/cli/one_helper/oneacct_helper.rb-O
/usr/lib/one/ruby/cli/one_helper/oneacct_helper.rb

I hope that solves the issue

[1]
http://dev.opennebula.org/projects/opennebula/repository/revisions/af470487098c4228600b36a36bfd2dc8f73435c3
--
Carlos Martín, MSc
Project Engineer
OpenNebula - The Open-source Solution for Data Center Virtualization
www.OpenNebula.org | cmartin at opennebula.org |
@OpenNebula<http://twitter.com/opennebula><cmartin at opennebula.org>

On Thu, Jan 17, 2013 at 3:19 PM, Carlos Martín Sánchez <
cmartin at opennebula.org> wrote:

> I forgot to add that meanwhile, you can try to filter records using xpath
> expressions for HISTORY/STIME and HISTORY/ETIME
>
> Regards
> --
> Carlos Martín, MSc
> Project Engineer
> OpenNebula - The Open-source Solution for Data Center Virtualization
> www.OpenNebula.org | cmartin at opennebula.org | @OpenNebula<http://twitter.com/opennebula><cmartin at opennebula.org>
>
>
> On Thu, Jan 17, 2013 at 3:04 PM, Carlos Martín Sánchez <
> cmartin at opennebula.org> wrote:
>
>> You are right, that first entry should be filtered out. We'll look into
>> it [1], thanks for reporting.
>>
>> Regards
>>
>> [1] http://dev.opennebula.org/issues/1732
>>
>> --
>> Carlos Martín, MSc
>> Project Engineer
>> OpenNebula - The Open-source Solution for Data Center Virtualization
>> www.OpenNebula.org | cmartin at opennebula.org | @OpenNebula<http://twitter.com/opennebula><cmartin at opennebula.org>
>>
>>
>> On Thu, Jan 17, 2013 at 1:32 PM, Benadik, Jan <jan.benadik at atos.net>wrote:
>>
>>>
>>> Dňa 16.01.2013 14:29, � wrote / napísal(a):
>>>
>>> Hi,
>>>
>>>  On Tue, Jan 15, 2013 at 5:18 PM, Benadik, Jan <jan.benadik at atos.net> wrote:
>>>
>>>>
>>>> *My questions:*
>>>> - how can I limit time frame for oneacct command (i.e. - from 1. 1.
>>>> 2013 to 31.1.2013 - only running VM's in that only period)?
>>>> If I use -s and -e option, it displays all machines without any
>>>> limitations ...
>>>>
>>>
>>>  The -s and -e options will show all the history records that were
>>> active during that time interval, but they may start or end outside that
>>> interval. Maybe you were expecting records that started and ended within
>>> the interval. Can you check if this is the case, or if you found a bug and
>>> there is no filtering at all?
>>>
>>> But there are records in all state (stopped included) - I want to have
>>> running state only in that report. That means - If I set exact time frame,
>>> I expect records which were in state "Running" inside of that time frame
>>> and only number of minutes in "running" state inside of that time frame.
>>>
>>> I.e. - I have three VM's, all with 4vCPU, 8096MB RAM:
>>> - VM1 started on 12. 24. 2012, stopped on 12. 31. 2012
>>> - VM2 started on 01. 01. 2013, stopped on 01. 15. 2013
>>> - VM3 started on 12. 24. 2012, still running
>>>
>>> If I use (on 02. 01. 2013) command *bill "01/01/2013" "01/31/2013", *I
>>> expect output like:
>>> oid, vcpus, memory, minutes_running
>>> VM2, 4, 8096, 21600
>>> VM3, 4, 8096, 44640
>>>
>>>
>>>
>>>
>>>  - how can I display correct figures in minutes for running machines in
>>>> oneacct output?
>>>>
>>>
>>>  That depends on how you plan to bill, by the month or waiting after
>>> the registry ends.
>>> If you want to get the minutes spent in this month, you need to take
>>> into account that STIME and ETIME can be outside the range, you can compute
>>> them as:
>>>
>>> bill_start = [$1, h['STIME'].to_i].max
>>>
>>>  etime = h['ETIME'].to_i == 0 ? Time.now : h['ETIME'].to_i
>>>  bill_end = [$2, etime].min
>>>
>>>
>>>  This is pseudo-ruby, but I hope you get the idea.
>>>
>>>
>>> Thanks - I will try it.
>>>
>>> Jan
>>>
>>>
>>>  Regards
>>> --
>>> Carlos Martín, MSc
>>> Project Engineer
>>> OpenNebula - The Open-source Solution for Data Center Virtualization
>>> www.OpenNebula.org | cmartin at opennebula.org | @OpenNebula<http://twitter.com/opennebula>
>>>
>>>
>>> On Tue, Jan 15, 2013 at 5:18 PM, Benadik, Jan <jan.benadik at atos.net>wrote:
>>>
>>>> Hi all,
>>>>
>>>> *I have a script /usr/bin/bill*
>>>> #!/usr/bin/env ruby
>>>>
>>>> require 'json'
>>>>
>>>> j = JSON.parse(`oneacct -j -s $1 -e $2`)
>>>>
>>>> puts "oid,vcpus,memory,minutes_running"
>>>>
>>>> j['HISTORY_RECORDS']['HISTORY'].each do |h|
>>>>     puts "#{h['OID']},"<<
>>>>         "#{h['VM']['TEMPLATE']['VCPU']},"<<
>>>>         "#{h['VM']['TEMPLATE']['MEMORY']},"<<
>>>>         "#{(h['ETIME'].to_i - h['STIME'].to_i)/60}"
>>>> end
>>>>
>>>> Output from that command:
>>>> *oneadmin at myto-node:~$ bill "01/01/2013" "01/31/2013"*
>>>> oid,vcpus,memory,minutes_running
>>>> 0,2,1024,0
>>>> 0,2,1024,0
>>>> 1,2,1024,0
>>>> 1,2,1024,32
>>>> .
>>>> .
>>>> .
>>>> 110,4,8096,29925
>>>> 111,4,8096,84
>>>> 112,4,8096,5939
>>>> 113,4,8096,22
>>>> 114,4,8096,-22637691
>>>>
>>>> First 4 lines were VM's running in october 2012 (for a while), last
>>>> line is still running VM.
>>>>
>>>> *My questions:*
>>>> - how can I limit time frame for oneacct command (i.e. - from 1. 1.
>>>> 2013 to 31.1.2013 - only running VM's in that only period)?
>>>> If I use -s and -e option, it displays all machines without any
>>>> limitations ...
>>>> - how can I display correct figures in minutes for running machines in
>>>> oneacct output?
>>>>
>>>> Jan
>>>> --
>>>>
>>>> *Ján Beňadik*
>>>> Managed Services - Solution Design Architect
>>>> mobile: +421 903 691 634
>>>> fax: +421 2 6852 8380
>>>> jan.benadik at atos.net <//jan.benadik at atos.net>
>>>> Vinohradnicka 6, 971 01 Prievidza
>>>> www.sk.atos.net
>>>> __________________________________
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Users mailing list
>>>> Users at lists.opennebula.org
>>>> http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
>>>>
>>>>
>>>
>>> --
>>>
>>> *Ján Beňadik*
>>> Managed Services - Solution Design Architect
>>> mobile: +421 903 691 634
>>> fax: +421 2 6852 8380
>>> jan.benadik at atos.net <//jan.benadik at atos.net>
>>> Vinohradnicka 6, 971 01 Prievidza
>>> www.sk.atos.net
>>> __________________________________
>>>
>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20130117/f5660d62/attachment-0002.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 1723 bytes
Desc: not available
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20130117/f5660d62/attachment-0004.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 281 bytes
Desc: not available
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20130117/f5660d62/attachment-0005.gif>