If you don't have a lot of subscriptions, then manually doing these might get you by for now. You can get a list of active subscriptions along with the userid and groups by running the following query:

SQL Query
select USER_ID,GROUP_ID 
from ubbt_SUBSCRIPTION_DATA
where SUBSCRIPTION_IS_ACTIVE='1'