Software 101 – Database Part 2

Find a software User’s Teams/Groups in the software

In the database we are able to see a user’s active and deleted Teams, once called Groups. Follow the steps below to find their Teams:

1. Run the following stored procedure to the the user’s UserID:

  • exec [Support].[User_Info_ByEmail] ‘insert email’ 

** remember you can also search using the first and last name query

2. Run the next query using the UserID from step 1:  

  • select *
    from [UserCompanyMyGroup]
    where userid = ‘insert UserId’ 

Under the column ‘MyGroupName’ you can view all teams/groups that have been created.  In the column ‘IsDeleted’, if there is a 1 present then that team/group has been deleted.

If a team/group needs to be restored, escalate the case to Tier 2 and they will be able to restore it for you.

Copy link