Query to find security roles of a user / team

Query to find security roles of all users

Select SU.fullname as [User Name] ,SU.businessunitidname as [BU Name] , SU.systemuserid as [User Guid],R.name as [User RollName]
From SystemUserRoles SUR Inner Join FilteredSystemUser SU
On SU.systemuserid  = SUR.SystemUserId Inner Join FilteredRole R
On R.roleid = SUR.RoleId

Order By SU.FullName

Query to find security roles of a particular user

Select SU.fullname as [User Name],SU.businessunitidname as [BU Name] ,SU.systemuserid as [User Guid],R.name as [User Role Name] From SystemUserRoles SUR Inner Join FilteredSystemUser SU
On SU.systemuserid  = SUR.SystemUserId Inner Join FilteredRole R
On R.roleid = SUR.RoleId

where SU.systemuserid =  '' (UserGuid)

Query to find teams of a particular user

Select SU.fullname as [User Name] ,SU.businessunitidname as [BU Name] ,T.name as [Team Name] From filteredteammembership TM Inner Join FilteredSystemUser SU On TM.systemuserid  = SU.SystemUserId Inner Join FilteredTeam T On T.teamid = TM.teamid where SU.systemuserid ='' (UserGuid)

Query to find teams of all users

Select SU.fullname as [User Name],SU.businessunitidname as [BU Name],T.name as [Team Name] From filteredteammembership TM Inner Join FilteredSystemUser SU On TM.systemuserid  = SU.SystemUserId Inner Join FilteredTeam T On T.teamid = TM.teamid Order By SU.FullName

Query to get Roles of the Team

Select * from FilteredTeamRoles