This post is going to be pretty short and simple. We had a customer who had lost track of the corresponding Auth Key to their existing SRP ID in Blackberry Enterprise Server 12. A simple SQL query was all that is required to pull the SRP and Auth Key from the existing production SQL database. This **should** work on any version of BES12, but I only tested it on BES 12.5.2 and BES 12.6.
- Open Microsoft SQL Server Management Studio.
- Connect to the SQL server instance that hosts the BES database.
- Click the “New Query” button on the toolbar (or press CTRL + N).
- Paste the following query into the query editor, then click the Execute Button (adjust the BES_DATABASE_NAME as required)
SELECT TOP 1000 [id_sws_tenant] ,[created] ,[modified] ,[external_tenant_id] ,[external_authenticator_id] FROM [BES_DATABASE_NAME].[dbo].[obj_sws_tenant]
The output will contain the SRP (external_tenant_id) and Auth Key (external_authenicator_id).
As always – Use any tips, tricks, or scripts I post at your own risk.