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

[Benadik, Jan]

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<mailto: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<http://www.OpenNebula.org> | cmartin at opennebula.org<mailto: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<mailto: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
--
[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.benadik at atos.net<mailto://jan.benadik@atos.net>
Vinohradnicka 6, 971 01 Prievidza
www.sk.atos.net<http://www.sk.atos.net>
__________________________________

[X]

_______________________________________________
Users mailing list
Users at lists.opennebula.org<mailto:Users at lists.opennebula.org>
http://lists.opennebula.org/listinfo.cgi/users-opennebula.org



--
[cid:part14.04020708.04040304 at atos.net]
Ján Beňadik
Managed Services - Solution Design Architect
mobile: +421 903 691 634
fax: +421 2 6852 8380
jan.benadik at atos.net<mailto://jan.benadik@atos.net>
Vinohradnicka 6, 971 01 Prievidza
www.sk.atos.net<http://www.sk.atos.net>
__________________________________

[cid:part17.07090906.07070901 at atos.net]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20130117/3ba1cdea/attachment-0002.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ciara.gif
Type: image/gif
Size: 281 bytes
Desc: ciara.gif
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20130117/3ba1cdea/attachment-0004.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: atos.gif
Type: image/gif
Size: 1723 bytes
Desc: atos.gif
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20130117/3ba1cdea/attachment-0005.gif>