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

-- [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.

我如何计算 Discourse AI 中每个用户的令牌使用情况？

社区数据与报告

Jagster (Jakke Flemming) 2024 年6 月 12 日 08:23 3

它显示了根本不使用任何kind AI的用户。有什么想法为什么会这样，是否包含在摘要或其他内容中？

话题		回复	浏览量
Discourse AI - AI usage Site Management how-to , ai	0	670	2025 年1 月 23 日
Dashboard Report - Consolidated API Requests Data & reporting sql-query , dashboard-reports , dashboard-sql	0	192	2025 年9 月 23 日
AI Usage page is awesome :heart_eyes: Praise ai	7	434	2024 年12 月 4 日
Provide topic count via Discourse AI tool API `discourse.getUser` function Feature ai	1	188	2026 年2 月 9 日
Daily graph of user time online Feature	2	2277	2015 年10 月 1 日

我如何计算 Discourse AI 中每个用户的令牌使用情况？

相关话题