You are viewing limited content. For full access, please sign in.

Question

Question

When using the 'Find User' Activity inside Workflow Designer, where is the Default Folder information stored?

asked on November 12, 2013

When I find a user I am able to set a default folder. It is the only thing I am allowed to change about any specific user from within Workflow Designer. I was wondering where this information gets stored. Since I was searching the Active Directory for these users, is it stored to the Active Directory accounts in the domain controller or is it inside of the Account information for the repository (accessed through the administration console)

 

0 0

Answer

SELECTED ANSWER
replied on November 12, 2013

When you're using a Laserfiche trustee directory, the default folder (and email address) are stored in the user attributes. Besides the display name, email and default folder, there are 2 default properties available: first and last name. More custom properties can be created through the WF Admin Console.

 

For Active Directory trustee directories, the default folder is stored in the SQL database used by Workflow. When using AD trustee directories, the email address, name, manager information is pulled directly from Active Directory.

1 0
replied on November 12, 2013

Is there a way to set the default folders from within workflow? I would like to have this information readily available for some clients and manually inputting this information is not a great way to scale that type of work when dealing with multiple clients and potentially new users being added to the system.

0 0

Replies

replied on November 12, 2013

The default folders can't be set from within workflow. However, if you have a naming convention for them, you can use the "route to folder" option in Route to User/Group (rather than the default "route to user's default folder") and specify the path using that naming convention.

0 0
replied on December 9, 2013

We have a client who are migrating to a new domain and they use AD trustee accounts. Each user is configured with a default user folder which has been assigned manually.

 

When they switch domains this information will be lost I assume? Is there an easy way, via a SQL table maybe, to update this information. Only the domain name will change, the usernames will remain the same.

0 0
replied on December 10, 2013

The Laserfiche user attributes are stored in the trustee_attr table by trustee SID. When you migrate domains, the account SIDs are going to change, so yes, you would lose the information. You could update the table with the new SIDs. However, that's not quite trivial as the attributes are stored in a varbinary column. So you'd need to create a table that maps the old SID to the new SID and then iterate through that and update trustee_attr. 

 

If you use Windows accounts through a Laserfiche trustee provider in Workflow, then updating the table above should preserve their folders. If you use Windows accounts through an Active Directory trustee provider in Workflow, then their folder mappings are stored in the SQL DB associated with WF, not the LF one. You would have to update the user_param table. The users are stored by their AD unique identifier.

 

Obviously, you'd want to make sure you have good backups for your SQL and stop the LF and WF services before altering the tables.

 

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.