Oct 17, 2025 · Sep 12, 2025 · Sep 17, 2025 · Sep 17, 2025 · Oct 16, 2025 · Oct 16, 2025
diff --git a/coderd/database/dbauthz/dbauthz.go b/coderd/database/dbauthz/dbauthz.go
 return q.db.GetWorkspaceAgentsCreatedAfter(ctx, createdAt)
 }

 func (q *querier) GetWorkspaceAgentsForMetrics(ctx context.Context) ([]database.GetWorkspaceAgentsForMetricsRow, error) {
 if err := q.authorizeContext(ctx, policy.ActionRead, rbac.ResourceWorkspace); err != nil {
 return nil, err
 }
 return q.db.GetWorkspaceAgentsForMetrics(ctx)
 }

 func (q *querier) GetWorkspaceAgentsInLatestBuildByWorkspaceID(ctx context.Context, workspaceID uuid.UUID) ([]database.WorkspaceAgent, error) {
 workspace, err := q.GetWorkspaceByID(ctx, workspaceID)
 if err != nil {
 return q.db.GetWorkspacesEligibleForTransition(ctx, now)
 }

 func (q *querier) GetWorkspacesForWorkspaceMetrics(ctx context.Context) ([]database.GetWorkspacesForWorkspaceMetricsRow, error) {
 if err := q.authorizeContext(ctx, policy.ActionRead, rbac.ResourceWorkspace); err != nil {
 return nil, err
 }
 return q.db.GetWorkspacesForWorkspaceMetrics(ctx)
 }

 func (q *querier) InsertAIBridgeInterception(ctx context.Context, arg database.InsertAIBridgeInterceptionParams) (database.AIBridgeInterception, error) {
 return insert(q.log, q.auth, rbac.ResourceAibridgeInterception.WithOwner(arg.InitiatorID.String()), q.db.InsertAIBridgeInterception)(ctx, arg)
 }
diff --git a/coderd/database/dbauthz/dbauthz_test.go b/coderd/database/dbauthz/dbauthz_test.go
 // No asserts here because SQLFilter.
 check.Args(arg).Asserts()
 }))
 s.Run("GetWorkspaceAgentsForMetrics", s.Mocked(func(dbm *dbmock.MockStore, faker *gofakeit.Faker, check *expects) {
 row := testutil.Fake(s.T(), faker, database.GetWorkspaceAgentsForMetricsRow{})
 dbm.EXPECT().GetWorkspaceAgentsForMetrics(gomock.Any()).Return([]database.GetWorkspaceAgentsForMetricsRow{row}, nil).AnyTimes()
 check.Args().Asserts(rbac.ResourceWorkspace, policy.ActionRead).Returns([]database.GetWorkspaceAgentsForMetricsRow{row})
 }))
 s.Run("GetWorkspacesForWorkspaceMetrics", s.Mocked(func(dbm *dbmock.MockStore, _ *gofakeit.Faker, check *expects) {
 dbm.EXPECT().GetWorkspacesForWorkspaceMetrics(gomock.Any()).Return([]database.GetWorkspacesForWorkspaceMetricsRow{}, nil).AnyTimes()
 check.Args().Asserts(rbac.ResourceWorkspace, policy.ActionRead)
 }))
 s.Run("GetAuthorizedWorkspaces", s.Mocked(func(dbm *dbmock.MockStore, _ *gofakeit.Faker, check *expects) {
 arg := database.GetWorkspacesParams{}
 dbm.EXPECT().GetAuthorizedWorkspaces(gomock.Any(), arg, gomock.Any()).Return([]database.GetWorkspacesRow{}, nil).AnyTimes()
diff --git a/coderd/database/dbmetrics/querymetrics.go b/coderd/database/dbmetrics/querymetrics.go
diff --git a/coderd/database/dbmock/dbmock.go b/coderd/database/dbmock/dbmock.go
diff --git a/coderd/database/querier.go b/coderd/database/querier.go
diff --git a/coderd/database/queries.sql.go b/coderd/database/queries.sql.go
diff --git a/coderd/database/queries/workspaceagents.sql b/coderd/database/queries/workspaceagents.sql
 id = $1
 AND parent_id IS NOT NULL
 AND deleted = FALSE;

 -- name: GetWorkspaceAgentsForMetrics :many
 SELECT
    w.id as workspace_id,
    w.name as workspace_name,
    u.username as owner_username,
    t.name as template_name,
    tv.name as template_version_name,
    sqlc.embed(workspace_agents)
 FROM workspaces w
 JOIN users u ON w.owner_id = u.id
 JOIN templates t ON w.template_id = t.id
 JOIN workspace_builds wb ON w.id = wb.workspace_id
 LEFT JOIN template_versions tv ON wb.template_version_id = tv.id
 JOIN workspace_resources wr ON wb.job_id = wr.job_id
 JOIN workspace_agents ON wr.id = workspace_agents.resource_id
 WHERE w.deleted = false
 AND wb.build_number = (
    SELECT MAX(wb2.build_number)
    FROM workspace_builds wb2
    WHERE wb2.workspace_id = w.id
 )
 AND workspace_agents.deleted = FALSE;
diff --git a/coderd/database/queries/workspaces.sql b/coderd/database/queries/workspaces.sql
 AND fsb.initiator_id != 'c42fdf75-3097-471c-8c33-fb52454d81c0'::uuid
 GROUP BY t.name, COALESCE(tvp.name, ''), o.name
 ORDER BY t.name, preset_name, o.name;

 -- name: GetWorkspacesForWorkspaceMetrics :many
 SELECT
    u.username as owner_username,
    t.name as template_name,
    tv.name as template_version_name,
    pj.job_status as latest_build_status,
    wb.transition as latest_build_transition
 FROM workspaces w
 JOIN users u ON w.owner_id = u.id
 JOIN templates t ON w.template_id = t.id
 JOIN workspace_builds wb ON w.id = wb.workspace_id
 JOIN provisioner_jobs pj ON wb.job_id = pj.id
 LEFT JOIN template_versions tv ON wb.template_version_id = tv.id
 WHERE w.deleted = false
 AND wb.build_number = (
    SELECT MAX(wb2.build_number)
    FROM workspace_builds wb2
    WHERE wb2.workspace_id = w.id
 );
Original file line number	Diff line number	Diff line change
Expand Up		@@ -3552,6 +3552,13 @@ func (q *querier) GetWorkspaceAgentsCreatedAfter(ctx context.Context, createdAt
		return q.db.GetWorkspaceAgentsCreatedAfter(ctx, createdAt)
		}

		func (q *querier) GetWorkspaceAgentsForMetrics(ctx context.Context) ([]database.GetWorkspaceAgentsForMetricsRow, error) {
		if err := q.authorizeContext(ctx, policy.ActionRead, rbac.ResourceWorkspace); err != nil {
		return nil, err
		}
		return q.db.GetWorkspaceAgentsForMetrics(ctx)
		}

		func (q *querier) GetWorkspaceAgentsInLatestBuildByWorkspaceID(ctx context.Context, workspaceID uuid.UUID) ([]database.WorkspaceAgent, error) {
		workspace, err := q.GetWorkspaceByID(ctx, workspaceID)
		if err != nil {
Expand DownExpand Up		@@ -3857,6 +3864,13 @@ func (q *querier) GetWorkspacesEligibleForTransition(ctx context.Context, now ti
		return q.db.GetWorkspacesEligibleForTransition(ctx, now)
		}

		func (q *querier) GetWorkspacesForWorkspaceMetrics(ctx context.Context) ([]database.GetWorkspacesForWorkspaceMetricsRow, error) {
		if err := q.authorizeContext(ctx, policy.ActionRead, rbac.ResourceWorkspace); err != nil {
		return nil, err
		}
		return q.db.GetWorkspacesForWorkspaceMetrics(ctx)
		}

		func (q *querier) InsertAIBridgeInterception(ctx context.Context, arg database.InsertAIBridgeInterceptionParams) (database.AIBridgeInterception, error) {
		return insert(q.log, q.auth, rbac.ResourceAibridgeInterception.WithOwner(arg.InitiatorID.String()), q.db.InsertAIBridgeInterception)(ctx, arg)
		}
Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -1689,6 +1689,15 @@ func (s *MethodTestSuite) TestWorkspace() {
		// No asserts here because SQLFilter.
		check.Args(arg).Asserts()
		}))
		s.Run("GetWorkspaceAgentsForMetrics", s.Mocked(func(dbm dbmock.MockStore, faker gofakeit.Faker, check *expects) {
		row := testutil.Fake(s.T(), faker, database.GetWorkspaceAgentsForMetricsRow{})
		dbm.EXPECT().GetWorkspaceAgentsForMetrics(gomock.Any()).Return([]database.GetWorkspaceAgentsForMetricsRow{row}, nil).AnyTimes()
		check.Args().Asserts(rbac.ResourceWorkspace, policy.ActionRead).Returns([]database.GetWorkspaceAgentsForMetricsRow{row})
		}))
		s.Run("GetWorkspacesForWorkspaceMetrics", s.Mocked(func(dbm dbmock.MockStore, _ gofakeit.Faker, check *expects) {
		dbm.EXPECT().GetWorkspacesForWorkspaceMetrics(gomock.Any()).Return([]database.GetWorkspacesForWorkspaceMetricsRow{}, nil).AnyTimes()
		check.Args().Asserts(rbac.ResourceWorkspace, policy.ActionRead)
		}))
		s.Run("GetAuthorizedWorkspaces", s.Mocked(func(dbm dbmock.MockStore, _ gofakeit.Faker, check *expects) {
		arg := database.GetWorkspacesParams{}
		dbm.EXPECT().GetAuthorizedWorkspaces(gomock.Any(), arg, gomock.Any()).Return([]database.GetWorkspacesRow{}, nil).AnyTimes()
Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -365,3 +365,26 @@ WHERE
		id = $1
		AND parent_id IS NOT NULL
		AND deleted = FALSE;

		-- name: GetWorkspaceAgentsForMetrics :many
		SELECT
		w.id as workspace_id,
		w.name as workspace_name,
		u.username as owner_username,
		t.name as template_name,
		tv.name as template_version_name,
		sqlc.embed(workspace_agents)
		FROM workspaces w
		JOIN users u ON w.owner_id = u.id
		JOIN templates t ON w.template_id = t.id
		JOIN workspace_builds wb ON w.id = wb.workspace_id
		LEFT JOIN template_versions tv ON wb.template_version_id = tv.id
		JOIN workspace_resources wr ON wb.job_id = wr.job_id
		JOIN workspace_agents ON wr.id = workspace_agents.resource_id
		WHERE w.deleted = false
		AND wb.build_number = (
		SELECT MAX(wb2.build_number)
		FROM workspace_builds wb2
		WHERE wb2.workspace_id = w.id
		)
		AND workspace_agents.deleted = FALSE;
Original file line number	Diff line number	Diff line change
Expand Up		@@ -983,3 +983,23 @@ WHERE
		AND fsb.initiator_id != 'c42fdf75-3097-471c-8c33-fb52454d81c0'::uuid
		GROUP BY t.name, COALESCE(tvp.name, ''), o.name
		ORDER BY t.name, preset_name, o.name;

		-- name: GetWorkspacesForWorkspaceMetrics :many
		SELECT
		u.username as owner_username,
		t.name as template_name,
		tv.name as template_version_name,
		pj.job_status as latest_build_status,
		wb.transition as latest_build_transition
		FROM workspaces w
		JOIN users u ON w.owner_id = u.id
		JOIN templates t ON w.template_id = t.id
		JOIN workspace_builds wb ON w.id = wb.workspace_id
		JOIN provisioner_jobs pj ON wb.job_id = pj.id
		LEFT JOIN template_versions tv ON wb.template_version_id = tv.id
		WHERE w.deleted = false
		AND wb.build_number = (
		SELECT MAX(wb2.build_number)
		FROM workspace_builds wb2
		WHERE wb2.workspace_id = w.id
		);