NeophyteNeophyte@Cole McDonald I agree it would make sense that once you have the unique instance ID you should be able to pull the information with that ID alone.
I'm creating the same type of reference utilization table based on the time series information and need to better understand the usage over the prime time day and the overnight window. One item I need to exclude is the obvious backup window time frame. That should be full usage of the circuit or interface and should not be factored in with 'normal' utilization. But still accounted for in terms of high usage during that interval.
Did you end up doing this work in Powershell? Or did you finish it off in Python? Curious as to how you finished up the project.
We have 90+ remote facilities each with dual WAN links and also an Internet connection now for the OS365 and other direct attached SAAS applications. Those application no longer use the Hub Spoke design for application use and have complicated the overall summation of utilization.