Dňa 16.01.2013 14:29, � wrote / napísal(a): Hi, On Tue, Jan 15, 2013 at 5:18 PM, Benadik, Jan <jan.bena...@atos.net<mailto:jan.bena...@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<http://www.OpenNebula.org> | cmar...@opennebula.org<mailto:cmar...@opennebula.org> | @OpenNebula<http://twitter.com/opennebula> On Tue, Jan 15, 2013 at 5:18 PM, Benadik, Jan <jan.bena...@atos.net<mailto:jan.bena...@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@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 -- [X] Ján Beňadik Managed Services - Solution Design Architect mobile: +421 903 691 634<tel:%2B421%20903%20691%20634> fax: +421 2 6852 8380<tel:%2B421%202%206852%208380> jan.bena...@atos.net<mailto://jan.bena...@atos.net> Vinohradnicka 6, 971 01 Prievidza www.sk.atos.net<http://www.sk.atos.net> __________________________________ [X] _______________________________________________ Users mailing list Users@lists.opennebula.org<mailto:Users@lists.opennebula.org> http://lists.opennebula.org/listinfo.cgi/users-opennebula.org -- [cid:part14.04020708.04040304@atos.net] Ján Beňadik Managed Services - Solution Design Architect mobile: +421 903 691 634 fax: +421 2 6852 8380 jan.bena...@atos.net<mailto://jan.bena...@atos.net> Vinohradnicka 6, 971 01 Prievidza www.sk.atos.net<http://www.sk.atos.net> __________________________________ [cid:part17.07090906.07070901@atos.net]
<<inline: ciara.gif>>
<<inline: atos.gif>>
_______________________________________________ Users mailing list Users@lists.opennebula.org http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
