Chandler · usage
Reset

5 sessions

Last active UserFirst match Questions Cost Feedback
2026-09-10 08:30 chris.scott@dext.com Query MELTANO.SALESLOFT.TASKS directly. The USER column may be a JSON/variant object containing an "id" — extract the numeric user id from it. Filter to rows where _SDC_DELETED_AT is null and CURRENT_STATE is not 'completed', and where the extracted user id is one of 19389, 18717, 18716, 13847, 13842, 13833, 11892, 4510, 4471, 4346. Group by that user id and return: count of rows with DUE_DATE < current_date as OVERDUE, count with DUE_DATE = current_date as DUE_TODAY, count with DUE_DATE > current_date as FUTURE, and MIN(DUE_DATE) as OLDEST_OVERDUE. Order by OVERDUE descending.
3 failed
3 $0.2311 —
2026-08-31 11:15 chris.scott@dext.com Using field parent_account_crn (not account_crn) to filter and no other filter on account_crn, list child account CRNs where parent_account_crn = 7333782788, snapshot date 2026-04-23, sorted by account_crn descending
2 failed
2 unpriced —
2026-08-27 13:54 chris.scott@dext.com Using field parent_account_crn (not account_crn) to filter and no other filter on account_crn, list child account CRNs where parent_account_crn = 7333782788, snapshot date 2026-04-23, sorted by account_crn descending
1 failed
1 $0.2842 —
2026-08-27 10:56 chris.scott@dext.com Using field parent_account_crn (not account_crn) to filter and no other filter on account_crn, list child account CRNs where parent_account_crn = 7211761474, snapshot date 2026-06-01, sorted by account_crn descending
14 failed
14 unpriced —
2026-08-26 13:01 chris.scott@dext.com Using field parent_account_crn (not account_crn) to filter, list child account CRNs where parent_account_crn = 7211533107, snapshot date 2026-04-01, sorted by account_crn ascending, limit 1000
1 failed
1 $0.3564 —
Page 1 of 1

Cost is the LLM completion spend LiteLLM priced for each call, summed per request. Chandler is running on the Codex CLI, which draws ChatGPT plan quota rather than per-token API billing, so this figure is not money paid — it is what the same traffic would have cost on the API, priced from the token counts Codex reports. Read it as the size of the bill avoided. Two known limits: embedding spend is not recorded, so retrieval and matching cost is missing, and because the figure is one sum per request it cannot be split by model within a request — a request's classifier and agent calls can use different models while llm_model holds only one name. Only authenticated calls are logged, USAGE_LOG_ENABLED can switch logging off, and log writes are fail-soft — this is not a complete record of traffic. Questions are grouped into sessions: a session is exact when the caller echoed its id back to us and otherwise inferred from a 30-minute gap in that user’s activity, so a grouping is only as good as the source shown on the session itself. A call with no attributable user gets no session at all; those questions are listed separately rather than dropped.