Thanks Daan, that is a great idea, I'm testing it, I will let you know. Thank buddy
On Tue, Nov 7, 2023 at 2:19 PM Daan Hoogland <[email protected]> wrote: > I mean try startdate="2023-11-06'T'00:00:00" > enddate="2023-11-06'T'23:59:59". Does that give the expected output? > > On Tue, Nov 7, 2023 at 1:37 PM Francisco Arencibia Quesada < > [email protected]> wrote: > > > 24h of ratio :) > > > > it should always be less or equal than 24h right? > > The result above 24 h is breaking my head. > > > > On Tue, Nov 7, 2023 at 1:32 PM Daan Hoogland <[email protected]> > > wrote: > > > > > Fransisco, > > > > > > Do these happen to be 48 hour ratios? > > > > > > startdate="2023-11-06'T'00:00:00" enddate="2023-11-07'T'00:00:00", > could > > > just be one second more than you intend to find. > > > > > > On Tue, Nov 7, 2023 at 12:45 PM Francisco Arencibia Quesada < > > > [email protected]> wrote: > > > > > > > Good morning guys, > > > > > > > > I have created a script to get the ratios, and for some reason is > > giving > > > me > > > > more than 24h, I have checked the calculation and it is correct, do > you > > > > know why this could be? > > > > > > > > > > > > the time frame I'm using has the following format: > > > > startdate="2023-11-06'T'00:00:00" enddate="2023-11-07'T'00:00:00" > > > > > > > > > > > > This is my script output: > > > > Processing page 1: 500 VMs running > > > > Processing page 2: 500 VMs running > > > > Processing page 3: 500 VMs running > > > > Processing page 4: 500 VMs running > > > > Processing page 5: 500 VMs running > > > > Processing page 6: 500 VMs running > > > > Processing page 7: 500 VMs running > > > > Processing page 8: 500 VMs running > > > > Processing page 9: 171 VMs running > > > > 4171 VMs running found > > > > Processing page 1: 500 public IP addresses > > > > Processing page 2: 500 public IP addresses > > > > Processing page 3: 500 public IP addresses > > > > Processing page 4: 500 public IP addresses > > > > Processing page 5: 500 public IP addresses > > > > Processing page 6: 500 public IP addresses > > > > Processing page 7: 500 public IP addresses > > > > Processing page 8: 500 public IP addresses > > > > Processing page 9: 500 public IP addresses > > > > Processing page 10: 197 public IP addresses > > > > 4697 public IP addresses found > > > > Processing page 1: 497 disks in ready status > > > > Processing page 2: 500 disks in ready status > > > > Processing page 3: 500 disks in ready status > > > > Processing page 4: 498 disks in ready status > > > > Processing page 5: 500 disks in ready status > > > > Processing page 6: 500 disks in ready status > > > > Processing page 7: 500 disks in ready status > > > > Processing page 8: 500 disks in ready status > > > > Processing page 9: 500 disks in ready status > > > > Processing page 10: 500 disks in ready status > > > > Processing page 11: 183 disks in ready status > > > > 5178 disks in ready status found > > > > Processing page 1: 11963.4 usagetype 1 > > > > Processing page 2: 11973.3 usagetype 1 > > > > Processing page 3: 11962.9 usagetype 1 > > > > Processing page 4: 11979.1 usagetype 1 > > > > Processing page 5: 11924.1 usagetype 1 > > > > Processing page 6: 11922.2 usagetype 1 > > > > Processing page 7: 11993.6 usagetype 1 > > > > Processing page 8: 11923.5 usagetype 1 > > > > Processing page 9: 4077.14 usagetype 1 > > > > 99719.24 usagetype 1 found > > > > Processing page 1: 11958.3 usagetype 3 > > > > Processing page 2: 12000 usagetype 3 > > > > Processing page 3: 11976 usagetype 3 > > > > Processing page 4: 11989.2 usagetype 3 > > > > Processing page 5: 11976.1 usagetype 3 > > > > Processing page 6: 12000 usagetype 3 > > > > Processing page 7: 11985.9 usagetype 3 > > > > Processing page 8: 12000 usagetype 3 > > > > Processing page 9: 12000 usagetype 3 > > > > Processing page 10: 4214.53 usagetype 3 > > > > 112100.03 usagetype 3 found > > > > Processing page 1: 11939.5 usagetype 6 > > > > Processing page 2: 11976 usagetype 6 > > > > Processing page 3: 12000 usagetype 6 > > > > Processing page 4: 11891.6 usagetype 6 > > > > Processing page 5: 11958.7 usagetype 6 > > > > Processing page 6: 11909.5 usagetype 6 > > > > Processing page 7: 11976 usagetype 6 > > > > Processing page 8: 11983.4 usagetype 6 > > > > Processing page 9: 11918.6 usagetype 6 > > > > Processing page 10: 12000 usagetype 6 > > > > Processing page 11: 10080.1 usagetype 6 > > > > 129633.4 usagetype 6 found > > > > Total VMs running: 4171 > > > > Total public IP addresses: 4697 > > > > Total disks in ready status: 5178 > > > > Total hours for usage type 1 [VM]: 99719.24 > > > > Total hours for usage type 3 [IP]: 112100.03 > > > > Total hours for usage type 6 [disk]: 129633.40 > > > > Getting ratios > > > > Ratio of billed hours per VM: 23.90 > > > > Ratio of billed hours per public ip: 23.86 > > > > Ratio of billed hours per volumen: 25.03 > > > > > > > > > > > > Regards > > > > -- > > > > *Francisco Arencibia Quesada.* > > > > *DevOps Engineer* > > > > > > > > > > > > > -- > > > Daan > > > > > > > > > -- > > *Francisco Arencibia Quesada.* > > *DevOps Engineer* > > > > > -- > Daan > -- *Francisco Arencibia Quesada.* *DevOps Engineer*
