Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

XRM-Server [Session Stats] Create Session Statistics Table #139

Open
M-griffin opened this issue Apr 16, 2017 · 3 comments
Open

XRM-Server [Session Stats] Create Session Statistics Table #139

M-griffin opened this issue Apr 16, 2017 · 3 comments
Assignees

Comments

@M-griffin
Copy link
Owner

Track user sessions, term type, emulation, and basic info.
This can also be used for last callers and general usage.

@M-griffin
Copy link
Owner Author

M-griffin commented Apr 17, 2017

Initial Table Layout for Session Stats. DAO Methods and Creation on Start up added.
Need to complete integration on sing-up and login then make sure to update status and save when counts are incremented in different interfaces.

cmdCreateSessionStatTable =
        "CREATE TABLE IF NOT EXISTS " + strTableName + " ( "
        "iId               INTEGER PRIMARY KEY, "        
        "iUserId           INTEGER NOT NULL, "
        "sSessionType      TEXT NOT NULL COLLATE NOCASE, "
        "sCodePage         TEXT NOT NULL COLLATE NOCASE, "
        "sTerminal         TEXT NOT NULL COLLATE NOCASE, "
        "sIPAddress        TEXT NOT NULL COLLATE NOCASE, "
        "iTermWidth        INTEGER NOT NULL, "
        "iTermHeight       INTEGER NOT NULL, "
        "dtStartDate       DATETIME NOT NULL, "
        "dtEndDate         DATETIME NOT NULL, "
        "iInvalidAttempts  INTEGER NOT NULL, "
        "bNewUser          BOOLEAN NOT NULL, "
        "bLogonSuccess     BOOLEAN NOT NULL, "
        "bHungup           BOOLEAN NOT NULL, "
        "iMsgRead          INTEGER NOT NULL, "
        "iMsgPost          INTEGER NOT NULL, "
        "iFilesUl          INTEGER NOT NULL, "
        "iFilesDl          INTEGER NOT NULL, "
        "iFilesUlMb        INTEGER NOT NULL, "
        "iFilesDlMb        INTEGER NOT NULL, "
        "iDoorsExec        INTEGER NOT NULL  "
        "); ";

@M-griffin M-griffin self-assigned this Apr 17, 2017
@M-griffin
Copy link
Owner Author

Initial Setup per Pull Request #142
Still WIP, have to implemented updates in mods and add tracking updates through hangup and logoff.

@M-griffin
Copy link
Owner Author

Update are also needed after successful logon, flags should be updated and record re-saved.
On new user signup, the newuser flag should be set to true.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant