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 | [email protected] | @OpenNebula<http://twitter.com/opennebula><[email protected]> On Thu, Jan 17, 2013 at 1:32 PM, Benadik, Jan <[email protected]> wrote: > > Dňa 16.01.2013 14:29, � wrote / napísal(a): > > Hi, > > On Tue, Jan 15, 2013 at 5:18 PM, Benadik, Jan <[email protected]> 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 | [email protected] | > @OpenNebula<http://twitter.com/opennebula> > > > On Tue, Jan 15, 2013 at 5:18 PM, Benadik, Jan <[email protected]>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@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 >> [email protected] <//[email protected]> >> Vinohradnicka 6, 971 01 Prievidza >> www.sk.atos.net >> __________________________________ >> >> >> >> _______________________________________________ >> Users mailing list >> [email protected] >> 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 > [email protected] <//[email protected]> > Vinohradnicka 6, 971 01 Prievidza > www.sk.atos.net > __________________________________ > > >
<<atos.gif>>
<<ciara.gif>>
_______________________________________________ Users mailing list [email protected] http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
