[front] - feature: implement user and agent usage reporting - Githubissues

dust-tt / dust

Amplify your team's potential with customizable and secure AI assistants.

https://dust.tt

MIT License

897 stars 99 forks source link

[front] - feature: implement user and agent usage reporting #5948

Closed JulesBelveze closed 2 days ago

JulesBelveze commented 4 days ago

Description

This PR introduces new queries that will be added to the reporting for workspace analytics.

The main changes include:

Adding new SQL queries to fetch detailed usage data for users, agents, and messages within specified time periods.
Implementing functions to generate CSV reports for message, user, builder, and agent usage data.

References:

https://github.com/orgs/dust-tt/projects/3/views/1?pane=issue&itemId=67809458

Risk

None for now as the new queries are not being used

Deploy Plan

None

JulesBelveze commented 4 days ago

did you test it and it worked? (front-edge to have real data) will this be called on demand by admins only?

@philipperolet I tested it on front-edge and it worked as expected, even though quite slow. But it will only be called on demand (basically replacing the "Download Activity Data" that we currently have

would suggest creating separate .sql files for those queries; ... and we load them as top level constant

@flvndvd fine with you?