Hello Everyone,
In Alfresco, whenever new users created locally or synced by LDAP Sync, it creates nodes in Alfresco of type cmerson and attach some properties.
With Content Model defined properties, Alfresco adds few residual properties - cm:authorizationStatus, cm:userAccountStatusProperty
I would like to know where does Alfresco store this property and related values? In which table, I can query based on authorizationStatus? I have gone through alf_node_properties table and couldn't find these residual properties.
How I can query users which have Authorized or logged-in once in Alfresco and which users haven't logged in and status set as Never Authorized?
Any help would be appreciated.
Check this queries. It may help. https://www.dbi-services.com/blog/alfresco-some-useful-database-queries/
Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.
Related links:
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.