Description
User story
As an admin, I want to see the number of task users without running a direct SQL query so that I can see at all times if we are in the contractual contingent.
Background
Contracts can include a limit on task users. Today, our customers are provided with a SQL query they need to run in order to see the number of active task users.
This is not only cumbersome but also infrequent, resulting in less than desired insight for us and our customers.
In a multi-tenant setup, accounting for the right amount of task users can be a challenge that needs further investigation.
Acceptance criteria
- In Admin, there is a dialogue to fetch the number of unique task users for a configurable time period
- When executed, it makes a query against the currently available historic task data
- Reasonable indexes are in place to reduce query execution time