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*
