Thanks a lot Daan, now this is working fine ;) On Tue, Nov 7, 2023 at 3:28 PM Francisco Arencibia Quesada < [email protected]> wrote:
> 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* > -- *Francisco Arencibia Quesada.* *DevOps Engineer*
