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
