Information on what users have what roles

Ran script and emailed to Arnah SELECT sg.[UserLogin] ,u.LastSite ,[GroupName] FROM [WinscribeText].[dbo].[SecurityUserGroup] sg with (NOLOCK) join [User] u with (NOLOCK) on u.userlogin = sg.UserLogin