SQL Script to pull Role Name and Role ID

Login to the SQL Server and expand the databases and click the database.

Click New Query & Paste the below query

SELECT  Name, NameAndDescriptionInstanceId as 'RoleId' 
      FROM BASLocaleNamesAndDescriptions 
      WHERE NameAndDescriptionTypeId = 8 
      AND PlugInId = 0
      AND Locale = 'en_US'

Click Execute

From the results you can copy the information of Role Name and Role Id.