Delegate365 faced significant challenges in managing license data reports due to its daily storage practices. The root cause was the accumulation of an excessive amount of license data over the years, which exceeded the available resources. So we changed that and the License Aggregation Report in Delegate365 got an update.
What Happened
Recently, several users encountered a "Query Timeout - operations failed" error when generating a report in menu Licenses / License Aggregation. The system recorded license data for all Organizational Units (OUs) every day, resulting in the accumulation of hundreds to thousands of rows daily. Over time, this practice led to the creation of millions of rows in the database. Consequently, the Delegate365 client struggled to process this vast amount of data efficiently.
The Solution
We have addressed this issue and made adjustments in the new Delegate365 version. Here are the key changes:
- Data Cleanup: Historical license data has been exported to a CSV file and stored in the "archive" container within the Delegate365 Storage. Customers can download this archive file if needed.
- Monthly Data Storage: The new Delegate365 version now stores license data only once per month, capturing the current state. This means queries will show the current month's data and the final state at the end of each month (see screenshot below) . Also, data older than one year will be archived in future.
- Enhanced Reporting: In Delegate365 v10, you can now access year-month data for each OU and all licenses.
Note: The current Delegate365 version 9.x still supports daily filtering until you upgrade to the new Delegate365 v10. Upon upgrading your Delegate365 tenant, the old license report data will be archived, and a cleanup will be performed as previously outlined.
For more information about Delegate365 v10, check out our blog post Introducing the new and improved Delegate365: A modern SaaS solution for efficient, delegated management of an M365 tenant.
This update resolves the issue. If you have not yet upgraded to the new Delegate365 version, please contact us to schedule a convenient update date.
Categories: Delegate365, English, Microsoft365, Office365, atwork
Source: https://blog.atwork.at/post/Delegate365-License-Aggregation-Report-Update