Where does Alfresco Stores Residual properties and associated values? How to query them?

cancel
Showing results for 
Search instead for 
Did you mean: 
jigirshah
Active Member

Where does Alfresco Stores Residual properties and associated values? How to query them?

Hello Everyone,

In Alfresco, whenever new users created locally or synced by LDAP Sync, it creates nodes in Alfresco of type cmSmiley Tongueerson 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.

1 Reply
sanjaybandhniya
Intermediate

Re: Where does Alfresco Stores Residual properties and associated values? How to query them?