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 Discussio…

-- [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에서 모든 사용자의 토큰 사용량을 어떻게 계산하나요?

커뮤니티 구축 데이터 및 보고

Lilly (Lillian ) 6월 13, 2024, 2:32오전 6

안녕하세요 @whitewaterdeu, Sam이 게시한 SQL 쿼리는 데이터 탐색기 플러그인을 통해 관리자 UI에서 실행할 수 있습니다.

글		댓글	조회수
Discourse AI - AI usage Site Management how-to , ai	0	643	1월 23, 2025
Dashboard Report - Consolidated API Requests Data & reporting sql-query , dashboard-reports , dashboard-sql	0	176	9월 23, 2025
AI Usage page is awesome :heart_eyes: Praise ai	7	388	12월 4, 2024
Provide topic count via Discourse AI tool API `discourse.getUser` function Feature ai	1	153	2월 9, 2026
Daily graph of user time online Feature	2	2250	10월 1, 2015

Discourse AI에서 모든 사용자의 토큰 사용량을 어떻게 계산하나요?

Related topics