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.