Epic: Admin dashboard enhancements to avoid SQL queries for support

[jldec]

Summary
The goal of this epic is to enable the use of the admin dashboard, to resolve support scenarios which currently require SQL queries for inspection or direct SQL manipulation of data.

Context
Features such as teams, or projects and prebuilds cannot currently be inspected via the admin dashboard. This makes it difficult to support users in their use of these features.

Issues with infrastructure scheduling may result in database inconsistencies which can currently only be resolved through direct SQL manipulation of the affected records. One examples of this is #7255.

Description

general

• [Self-hosted]: cannot search users/workspaces without enterprise license and error is console only #6932
• Fix search input to trim whitespace in all searches #8454
• Admin date/time values should show exact date/time on hover

workspaces

• Searches for workspaces never return #8005
• force backup
• force stop when stuck in stopping state
• list recent workspace instances with times, duration, status
• link-to and show prebuild workspaces
• Change "Search workspaces" to "Enter workspace ID" and disable contextURL search. #8453
• Show list of instances under workspace detail
• Distinguish between prebuild and other kinds of workspaces in workspaces list

user accounts

• fix account statement to download JSON
• Show git providers in Admin user detail #8451
• recover account e.g. after deleting the last authorized git provider account
• list projects under a user account

projects

• [Admin] Search for projects and show project details #7636
  • show project team or owner
  • show recent project prebuilds below
• delete project
• restore project
• Show prebuild logs for Admin prebuild detail #8452
• show project configuration

teams

• [Admin] Search for team by name or slug and show team details #8060
  • list team members and owners below
  • change roles between member and admin
• Allow deleting a team / a project from the admin panel #8523
• list projects in a team

nice to have (not in scope for this epic)

• show team activity log (changes in memberships, projects)
• report team usage (workspace hours by project, team member)

Value
Visibility into Gitpod feature usage is important for customers and operators to understand how users are getting value from the platform.

[kylos101]

👋 @jldec I really like how you have this epic broken down, and the tasks in the epic link to issues. 👍

It would be helpful if users could force stop a workspace themselves, perhaps after a certain amount of time has passed (an hour?) since it started stopping. I say this because, right now, when a workspace is stuck in stopping, the user is dependent on an admin (Team Workspace usually), and this requires us to update the database manually (which doesn't scale well).

WDYT? This would get the user access to their workspace sooner, reduce messages in Front, and cut down on manual tasks within Gitpod itself.

[geropl]

@jldec Once you're back: can you look into splitting this up in follow ups? 🙏

[jldec]

Closing this because the Epic process requires epics to end.

• scheduled Show git providers in Admin user detail #8451 as urgent support followup.
• added Show prebuild logs for Admin prebuild detail #8452 to Epic Epic: Prebuild logs reliability #9291.
• treating other tasks including Allow deleting a team / a project from the admin panel #8523 as lower priority for now.

[laushinka]

• treating other tasks including werft/deploy/post-process: Remove openvsx statefulsetstatus #8532 as lower priority for now.

Thanks for following up, @jldec! How is #8532 related to the epic btw, is it a typo?

[jldec]

Yeah, that was a typo - thanks for noticing @laushinka