How to export customer’s data from Radius manager including the name of services and non-encrypted passwords:
select rm_users.*, radcheck.value, rm_services.srvname from rm_users left join radcheck on rm_users.username = radcheck.username left join rm_services on rm_services.srvid = rm_users.srvid where radcheck.attribute = ‘Cleartext-Password’
or
select rm_users.*, radcheck.value, rm_services.srvname from rm_users left join radcheck on rm_users.username = radcheck.username left join rm_services on rm_services.srvid = rm_users.srvid where radcheck.attribute = ‘Cleartext-Password’ and rm_services.srvname !=’Prepaid’