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

Question

Question

Find AD Attributes

asked on January 21

We are working on a review process and running into issues with getting data to Laserfiche.  In short we are pulling employee information from their HR system.  We want to invoke a forms process that sends to each users manager during review time.  Here is the data issue we are running into:

1.  In order to assign to the manager, we need their username (domain\user).  Their HR system does not hold that attribute

2.  We need to find that users supervisor (and the supervisors username).

Their AD seems to hold this as they set it up that way.  However, we dont seem to be able to retrieve many of the useful fields using the find user activity.

For example, here is a user profile that has the employeeNumber:

Is there an ability using custom SDK scripting or some option to get at this data?  Essentially we want to be able to do a find user activity but pass forward the employeeNumber (from the other system) and find the user in AD and then pull other various attributes (not just the 5 or 6 in the built in activity)

0 0

Answer

SELECTED ANSWER
replied on January 21

Hi Chris,

If you want to get user's employeeNumber attribute in Find User activity, please go to Workflow Admin Console -> External Objects -> Trustee Directories; double click the Active Directory you have configured. Add custom property employeeNumber there.

Go back to Workflow Designer, select the AD source in Find user activity. Test and run to see if user's employeeNumber could be got. If want to run a search based on employeeNumber, please select the employeeNumber there. 

1 0
replied on January 22 Show version history

So this is very helpful but have a few questions on this. 

1.  I did set it up and found the employeeNumber in my available choices but am not getting a hit.  I am using the same number from the original screenshot above so I know that number should be there.

I changed the search back to the specific user and found them via typing in their username just so I can get a return.  I found the user and the token tracker seems to show the employeenumber at the bottom but its empty.  From the screenshot in AD the user has an employee number but Laserfiche doesnt seem to be able to search on it or find it as a token.

Edit - would there be rights to consider here?  Does it use the workflow service account to query AD in the Find User activity?  If you can get a hit is it all or nothing?

0 0
replied on January 23

Trustee providers prefixed with "LF\" are the repositories. Can you confirm you added an active directory trustee provider and selected it in your activity?

0 0
replied on January 24

It looks like I got it.  Not sure why but had to recreate the LDAP AD connection in the workflow admin console.  Looks like we can pull data now so thank you for the suggestion!

0 0

Replies

replied on January 21 Show version history

Sounds like you need to add Active Directory as a Linked Server in SQL. Here is a site that can walk you through the steps to accomplish this: Querying Active Directory Data from SQL Server - MSSQLTips.com.

I would be sure to research the cons of setting up linked servers in general as well as configuring AD as a linked server in SQL before implementing this solution though.

1 0
replied on January 21

Can you pull the Employee ID from the HR system into a hidden field on your form, then use that value in a lookup from your AD system?
When EmployeeID = value, then return the fields from AD? 

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

Sign in to reply to this post.