i am using official discourse ai plugin with openai api key [imagem] Discourse AI Plugin [ai] discourse2 Summary Integration between AI features and Discourse globe_with_meridians Website Discourse AI Features | Discourse - Civilized Discus…

-- [params] -- date :start_date -- date :end_date WITH token_usage AS ( SELECT user_id, SUM(request_tokens) AS total_request_tokens, SUM(response_tokens) AS total_response_tokens, SUM(request_tokens + response_tokens) AS total_tokens FROM ai_api_audit…

It shows users who aren’t using anykind AI at all. Any ideas why, included in summaries or something?

Maybe, look at the logs, filter on user it will tell you which feature it is SqlHelper persona can help you with the query

thanks for your reply, could you please explain more about how to run these code? should i execute them after ./launcher enter app? how to change start_date and end_date? what’s the type of these code? i just know some python Sorry for my ignorance :pensive:

Hi @whitewaterdeu , that SQL query Sam posted can be run from the admin UI using the data explorer plugin.

Como faço para calcular o uso de tokens de cada usuário no Discourse AI?

Comunidade Dados e relatórios

Jagster (Jakke Flemming) Junho 12, 2024, 8:23am 3

Ele mostra usuários que não estão usando nenhuma IA. Alguma ideia do porquê, incluído em resumos ou algo assim?

Tópico		Respostas	Visualizações
Discourse AI - AI usage Site Management how-to , ai	0	670	23 de Janeiro de 2025
Dashboard Report - Consolidated API Requests Data & reporting sql-query , dashboard-reports , dashboard-sql	0	192	23 de Setembro de 2025
AI Usage page is awesome :heart_eyes: Praise ai	7	434	4 de Dezembro de 2024
Provide topic count via Discourse AI tool API `discourse.getUser` function Feature ai	1	188	9 de Fevereiro de 2026
Daily graph of user time online Feature	2	2277	1 de Outubro de 2015

Como faço para calcular o uso de tokens de cada usuário no Discourse AI?

Tópicos relacionados