You could try filtering CB > User Management to all users who have an expired free subscription. You could also try using CBSubs > Import and importing those with an expired free subscription to your new free lifetime subscription (run it as simulation first to make sure the users it finds is correct). CB Auto Actions can act on plan status change using the below if you still want to go that route.

Plan Active
Global
Triggers: onCPayUserStateChange
User: Automatic
Access: Everybody
Conditions
1: [var3] Equal To PLAN_ID_HERE
2: [var2] Equal To A

Plan Expired
Global
Triggers: onCPayUserStateChange
User: Automatic
Access: Everybody
Conditions
1: [var3] Equal To PLAN_ID_HERE
2: [var2] Not Equal To A

I'm not against creating the list using myPHPadmin but unsure what SELECT statement might yield the results I'm looking for. Is that possible?

Of course, you'd need to join the users and subscriptions table then filter accordingly. Simple example as follows.


That should give you a list of users that have a subscription to PLAN_ID_HERE of any kind (active, expired, etc..) and do not have an active subscription to any other plan. Note it's setup for phpmyadmin so replace jos_ with whatever your table prefix actually is.

The easiest solution though is to just edit your free plan, change it to free lifetime, then find all the users who have an active subscription to it and force renew them.