New Yest, 9:18 AM Stefano Bagnatica

1

Votes

AI - Log chat requests and token usage to database

Ability to log every GPT chatbot usage to a database table, in order to inspect token usages by user / ticket / date.

It could be something like this:

CREATE TABLE [dbo].[GPTRequestLogs] (
    [LogID] [int] IDENTITY(1,1) NOT NULL,
    [InstanceID] [int] NOT NULL,
    [TicketID] [int] NOT NULL,
    [UserID] [int] NULL,
    [InputTokensUsed] [int] NOT NULL,
    [OutputTokensUsed] [int] NOT NULL,
    [CreatedDate] [datetime] NOT NULL,
    PRIMARY KEY CLUSTERED ([LogID] ASC)
);

Separating Input / Output tokens would be useful because they have two different pricing .

chatgpt