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*
