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

"Active Users" count via a new "Logins" table #498

Open
sei-jbooz opened this issue Sep 25, 2024 · 1 comment
Open

"Active Users" count via a new "Logins" table #498

sei-jbooz opened this issue Sep 25, 2024 · 1 comment
Assignees
Labels
block: needs triage Needs assessment from the Gameboard team to clarify/prioritize enhancement New feature or request

Comments

@sei-jbooz
Copy link
Contributor

As a site admin, it would be good to know how many "Active Users" we have over a period of time. Providing this metric would require tracking when users login. This could be done via a new DB table that tracks a new row for "UserId logged in at this time" (potentially add "from this IP address" ?) -- open to other column suggestions

This new table should generally be "append only" -- adding a row every time a user logs in. The metrics from this table should surface in the "Site Usage Report"

@sei-bstein
Copy link
Contributor

Probable columns:

  • UserId
  • DateTime
  • agent string
  • IP
  • Access token end times?

Migration considerations - we have old counts of logins, so we'd either have to allow a lot of nullable columns (which I don't think is disastrous in this case) or just preserve the old count as a legacy thing ("... and 43 historical logins" or something). We'll discuss.

We should also use this occasion to ensure that we're capturing login events as intended. Right now, it appears that page refreshes trigger additional logins. Use of a unique identification of the token might help.

@sei-bstein sei-bstein added enhancement New feature or request block: needs triage Needs assessment from the Gameboard team to clarify/prioritize labels Sep 25, 2024
@sei-bstein sei-bstein self-assigned this Sep 25, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
block: needs triage Needs assessment from the Gameboard team to clarify/prioritize enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants