Skip to content

feat(site): display user status history as an indication of license usage #16020

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.

Sign up for GitHub

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

Closed
wants to merge 23 commits into from
Closed

feat(site): display user status history as an indication of license usage #16020

Changes from 1 commit
Commits
Show all changes
23 commits
Select commit Hold shift + click to select a range
4cd66af
add user_status_changes table
SasSwart Dec 14, 2024
61b27bf
add GetUserStatusCountsByDay
SasSwart Dec 14, 2024
7cba28c
rename unused variable
SasSwart Dec 14, 2024
2d748c9
Test GetUserStatusCountsByDay
SasSwart Dec 17, 2024
52620ce
make gen
SasSwart Dec 17, 2024
6d15a32
fix dbauthz tests
SasSwart Dec 17, 2024
b99468f
do the plumbing to get sql, api and frontend talking to one another
SasSwart Dec 23, 2024
b204783
rename migration
SasSwart Dec 23, 2024
ce1bda5
move aggregation logic for GetUserStatusChanges into the SQL
SasSwart Dec 24, 2024
734ff2b
use window functions for efficiency
SasSwart Dec 24, 2024
737e63e
ensure we use the same time zone as the start_time param
SasSwart Dec 24, 2024
045e438
ensure we use the same time zone as the start_time param
SasSwart Dec 24, 2024
32aeb4d
make gen
SasSwart Dec 24, 2024
1a2fde8
update field names and fix tests
SasSwart Dec 24, 2024
5b8fcac
exclude deleted users from the user status graph
SasSwart Dec 27, 2024
4ac83aa
GetUserStatusChanges now passes all querier tests
SasSwart Jan 2, 2025
b23018a
renumber migrations
SasSwart Jan 2, 2025
adbc8aa
add partial fixture for CI
SasSwart Jan 3, 2025
8bff303
fix migration numbers
SasSwart Jan 3, 2025
1ceff06
rename and document sql function
SasSwart Jan 3, 2025
94bb06a
fix api call
SasSwart Jan 3, 2025
d443a72
display the license user limit in the user status graph
SasSwart Jan 3, 2025
040086e
make fmt
SasSwart Jan 3, 2025
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
ensure we use the same time zone as the start_time param
  • Loading branch information
@SasSwart
SasSwart committed Jan 3, 2025
commit 737e63ef96e1f8fe8a841648161b410563fa55fd
4 changes: 2 additions & 2 deletions coderd/database/queries/insights.sql
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -774,11 +774,11 @@ GROUP BY utp.num, utp.template_ids, utp.name, utp.type, utp.display_name, utp.de

-- name: GetUserStatusChanges :many
WITH dates AS (
SELECT generate_series(
SELECT (generate_series(
date_trunc('day', @start_time::timestamptz),
date_trunc('day', @end_time::timestamptz),
'1 day'::interval
)::timestamptz AS date
) AT TIME ZONE (extract(timezone FROM @start_time::timestamptz)::text || ' minutes'))::timestamptz AS date
),
latest_status_before_range AS (
-- Get the last status change for each user before our date range
Expand Down