topic Re: Backup user information before deleting from Alfresco Share in Alfresco Forum

Backup user information before deleting from Alfresco Share

saikumar — Mon, 18 Oct 2021 15:10:19 GMT

We are currently running Alfresco content services(6.2) in our development projects and would like to seek community's help on few questions we have.

We currently disable or delete few users based on their activity to maintain user count below a subscription threshold. So, we want to backup/store user data(like site membership) before disabling/deleting a user. Our idea now is to save user site membership information in a custom table inside alfresco's mysql database and restore that data when required.
we wanted to seek communuity's help to see if it's possible to write user information to Alfresco's database. If so, how do we perform CRUD operations on alfresco's database.

Thank you for your time.

Re: Backup user information before deleting from Alfresco Share

fedorow — Mon, 18 Oct 2021 23:55:22 GMT

It is a bad idea to CRUD directly on alfresco's database. Never touch database. Think about SDK methods.

Re: Backup user information before deleting from Alfresco Share

cristinamr — Tue, 19 Oct 2021 10:15:41 GMT

Agreed with fedorow.

The easiest and recommended way is vía SDK. You can develop a javascript or even a webscript to extract that information.

Cheers,

Cristina.

Re: Backup user information before deleting from Alfresco Share

saikumar — Tue, 19 Oct 2021 13:51:50 GMT

thank you for your replies.

for existing users we can use something like "get-user-info", but for a deleted user do you think it is possible to retrieve the list of sites the user belonged to?

thanks.