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

Question

Question

Query AD from Forms or Workflow

Forms Workflow
Updated April 30, 2016
asked on April 26, 2016

Hi!

We have a BP Form that needs to query the AD in order to determine who that person's manager is based on a value on the form and continue with the correct routing. Unfortunately we haven't been able to accomplish this in any way. Has anyone run into this situation?

We have come up with an alternative, which involves creating a table in SQL with all the data we need from the AD. However, in order to automatically maintain it using Workflow, we would need to query the AD to search for new users on it, however this doesn't seem to be an option with the Find User activity within Workflow.

Any suggestions are welcome!

0 0

Answer

SELECTED ANSWER
replied on April 27, 2016

Hi Linda,

I posted a response to a related question that may help you out.   See here: http://answers.laserfiche.com/questions/72033/Can-Forms-91-query-Active-Directory-or-can-Forms-retrieve-tokens-from-Workflow

My response mentions how to create a SQL linked server to AD.

We also use a relatively inexpensive tool to import our AD users into a SQL table nightly (http://www.dovestones.com/active-directory-user-import/).

I hope this helps.

 

4 0

Replies

replied on April 26, 2016

There is no way for Workflow to know which AD users have been added. However, you can create an active directory trustee provider in Workflow and query the user's manager against that directly rather than maintaining a table. See the help file for creating trustee providers and adding custom properties.

0 0
View 1 previous reply
replied on April 26, 2016

Hi Miruna, 

Thank you, but I think you're missing my point. The reason behind creating the table and maintaining it with Workflow is to be able to get Forms to query it and get the manager and assign the next task to them.

0 0
replied on April 26, 2016

Hm, you're right, I read it as Forms calling into Workflow for the manager. There's nothing out of the box in Workflow that will find users created after a given date. You could script it against Active Directory though. See this example and Microsoft docs on filtering AD users. A Powershell script scheduled through Windows tasks might be a better tool for populating the table.

1 0
SELECTED ANSWER
replied on April 27, 2016

Hi Linda,

I posted a response to a related question that may help you out.   See here: http://answers.laserfiche.com/questions/72033/Can-Forms-91-query-Active-Directory-or-can-Forms-retrieve-tokens-from-Workflow

My response mentions how to create a SQL linked server to AD.

We also use a relatively inexpensive tool to import our AD users into a SQL table nightly (http://www.dovestones.com/active-directory-user-import/).

I hope this helps.

 

4 0
replied on April 30, 2016

Thank you Rob!

We used your recommendation with the linked server to SQL and created a stored procedure with the script. As far as updating the table, we're actually using a scheduled Workflow to call the stored procedure as that give us better control over the process.

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

Sign in to reply to this post.

Details
Related Posts
Loading ...