Question Horde to Roundcube migration

[efisher@]

Server operating system version

AlmaLinux 9.5

Plesk version and microupdate number

18.0.67.2

I understand and support the decision to deprecate Horde. One of the challenges with Horde has always been with the address book. Server migrations and backups do not grab these. That all being said, I'm looking for some guidance one of these options...

1) How to tell which mail users are actively using Horde and a query to figure out if they have have contacts stored so I can work with that user to move their contacts manually.
or
2) A script to export all contacts and then import them into Roundcube.

I hadn't thought much about it until I found out the cPanel is actually making this pretty easy. How to Manually Migrate Horde Data to Roundcube | cPanel & WHM Documentation

I don't have access to a cPanel server to grab the scripts and Roundcube plugins and try and make them work, but I'm wondering if anyone has these for Plesk or if anyone has tried to use the cPanel scripts and adopt them for Plesk?

Sadly, this is one area where cPanel is better and sad that this is the same company and one group seems to get this right and the other is missing it.

Any help or thoughts would be appreciated.

 

[AYamshanov]

1) How to tell which mail users are actively using Horde and a query to figure out if they have have contacts stored so I can work with that user to move their contacts manually.

With CLI, you can quickly find out what domains use Horde as a webmail, here is an example,

# plesk db "\
SELECT d.name AS domain_name, param.val AS webmail_service \
FROM domains d \
JOIN dom_param param ON d.id = param.dom_id \
WHERE param.param = 'webmail' AND param.val = 'horde';"
+---------------------------+-----------------+
| domain_name               | webmail_service |
+---------------------------+-----------------+
| example.org               | horde           |
+---------------------------+-----------------+

It does not help to understand how actively it is used, to be honest, but at least it provides some data for analysis. I know it is possible to export data from Horde GUI, but I am not familiar with Horde API or any details that could help to do export from CLI in an automated way.