hendem
diff --git a/‎packages/console/core/script/lookup-user.ts‎
Lines changed: 4 additions & 3 deletions b/‎packages/console/core/script/lookup-user.ts‎
Lines changed: 4 additions & 3 deletions
@@ -14,7 +14,7 @@ if (!identifier) {
 if(identifier.startsWith("wrk_")){
 awaitprintWorkspace(identifier)
 }else{
-constauthData=awaitprintTable("Email",(tx)=>
+constauthData=awaitDatabase.use(async(tx)=>
 tx.select().from(AuthTable).where(eq(AuthTable.subject,identifier)),
 )
 if(authData.length===0){
@@ -25,7 +25,7 @@ if (identifier.startsWith("wrk_")) {
 
 // Get all auth records for email
 constaccountID=authData[0].accountID
-awaitprintTable("Auth Records",(tx)=>tx.select().from(AuthTable).where(eq(AuthTable.accountID,accountID)))
+awaitprintTable("Auth",(tx)=>tx.select().from(AuthTable).where(eq(AuthTable.accountID,accountID)))
 
 // Get all workspaces for this account
 constusers=awaitprintTable("Workspaces",(tx)=>
@@ -60,6 +60,7 @@ async function printWorkspace(workspaceID: string) {
 tx
 .select({
 balance: BillingTable.balance,
+customerID: BillingTable.customerID,
 })
 .from(BillingTable)
 .where(eq(BillingTable.workspaceID,workspace.id))
@@ -113,7 +114,7 @@ async function printWorkspace(workspaceID: string) {
 .from(UsageTable)
 .where(eq(UsageTable.workspaceID,workspace.id))
 .orderBy(sql`${UsageTable.timeCreated} DESC`)
-.limit(1000)
+.limit(10)
 .then((rows)=>
 rows.map((row)=>({
  ...row,