Ah, rats. Well, then this would need to be rebuilt from scratch… which is a good idea in itself.
So, here it is anyway. It’s ugly. It works. I would do it differently today.
Really, all I need is for it to record the max users per hour per license type, overwriting when there is a new winner.
But when I made this, I had no idea what the data would look like. And as it turns out, when it grabs the license data, it sometimes jumbles the order of them. So I made the BAQ to decode it all.
The one oddity here is that I apparently pass in a GUID at the start. I built this off of a trace of the button in Company Config Tracker, so I guess it need that.
LicenseUsage.efxb (84.0 KB)
LicenseUsageLogCondensed.baq (23.2 KB)
And then graph it:
Also, that UD table gets mighty full after a few months. If I only needed 24 rows a day, it wouldn’t be so bad. Another reason for a redesign.