https://connect.hyland.com/t5/alfresco-forum/where-does-alfresco-stores-residual-properties-and-associated/m-p/130368#M35250 <P>Hello Everyone,</P><P>In Alfresco, whenever new users created locally or synced by LDAP Sync, it creates nodes in Alfresco of type cm<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />erson and attach some properties.</P><P>With Content Model defined properties, Alfresco adds few residual properties - cm:<SPAN>authorizationStatus,&nbsp;cm:userAccountStatusProperty</SPAN></P><P><SPAN>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.</SPAN></P><P><SPAN>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?</SPAN></P><P><SPAN>Any help would be appreciated.</SPAN></P> Thu, 05 Jan 2023 15:04:37 GMT jigirshah 2023-01-05T15:04:37Z https://connect.hyland.com/t5/alfresco-forum/where-does-alfresco-stores-residual-properties-and-associated/m-p/130368#M35250 <P>Hello Everyone,</P><P>In Alfresco, whenever new users created locally or synced by LDAP Sync, it creates nodes in Alfresco of type cm<img id="smileytongue" class="emoticon emoticon-smileytongue" src="https://connect.hyland.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />erson and attach some properties.</P><P>With Content Model defined properties, Alfresco adds few residual properties - cm:<SPAN>authorizationStatus,&nbsp;cm:userAccountStatusProperty</SPAN></P><P><SPAN>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.</SPAN></P><P><SPAN>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?</SPAN></P><P><SPAN>Any help would be appreciated.</SPAN></P> Thu, 05 Jan 2023 15:04:37 GMT https://connect.hyland.com/t5/alfresco-forum/where-does-alfresco-stores-residual-properties-and-associated/m-p/130368#M35250 jigirshah 2023-01-05T15:04:37Z https://connect.hyland.com/t5/alfresco-forum/where-does-alfresco-stores-residual-properties-and-associated/m-p/130369#M35251 <P>Check this queries. It may help. <A href="https://www.dbi-services.com/blog/alfresco-some-useful-database-queries/" target="_blank" rel="nofollow noopener noreferrer">https://www.dbi-services.com/blog/alfresco-some-useful-database-queries/</A></P><P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot_1.jpg" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="image"><img src="https://connect.hyland.com/t5/image/serverpage/image-id/1624i0172DC68E7037EFB/image-size/large?v=v2&amp;px=999" role="button" title="image" alt="image" /></span></SPAN></P> Sat, 07 Jan 2023 07:55:09 GMT https://connect.hyland.com/t5/alfresco-forum/where-does-alfresco-stores-residual-properties-and-associated/m-p/130369#M35251 sp2 2023-01-07T07:55:09Z