Save SQL return as a field in AD?

Question

• Short question:

I have a Powershell script that is generating some information and saving it to a SQL table. Is there some way to save that information into a field in AD using Adaxes?

• Long question:

In our job, we have an internal program that needs a unique username in a specific format. So, the AD username cannot be this value. I am currently generating the username and placing it in the needed SQL table using a Powershell query in Adaxes, but that means we need to view/query the table manually to get the result. We've been placing the special username manually in the "Office" field.

Ideally, I would be able to store this username in some field in AD as an action, either during or directly after the initial Powershell query. I don't mind making a few actions if needed to do this.

Basically, our current workflow is:

1. Make the user in Adaxes
2. Powershell runs and generates their special, unique username
3. Someone manually checks the table for what uername it is and places the name into AD in the "Office" field manually
4. Someone then emails the name to the user and their manager manually

What we would like is:

1. Make the user in Adaxes
2. Powershell runs and generates their special, unique username
3. Some other automated action takes that username (from the prevous query or from the SQL table) and places it in the "Office" field of AD
4. Automated email sends this value to the user

Let me know if you need more information. I know how to take an AD item and place it in Powershell using Adaxes, but I don't know how to go the opposite way basically. Thanks!

Answer 1

Hello,

It should work fine using a PowerShell script in a business rule triggering After creating a user. The script will query your SQL database, generate the required unique value and save it to the Office property. Unfortunately, we do not have the exact script, but the following one from our repository should be helpful: https://www.adaxes.com/script-repository/check-whether-employee-id-is-present-in-sql-database-s10.htm.

Comments

I'm having trouble seeing where in that query it is storing the generated value in AD? I'm new to Powershell so I may be misunderstanding.

I can see where it is comparing the SQL result to an existing value in AD, but I'm not trying to compare to an existing AD value, rather, I am trying to assign a new value to an AD feild.

Let me know please, thank you!

---

Hello,

The script we referenced does no update AD properties. It was just an example you can use as base. To update a property of the target object, you can use the below code in Adaxes scripts. The $propertyName variable represents the schema name (not display name) of the property to update. For example, if you want to update the Office property, the variable must be set to physicalDeliveryOfficeName exactly like in the example.

$propertyName = "physicalDeliveryOfficeName" # TODO: modify me

$Context.TargetObject.Put($propertyName, "<value to set for the property>")
$Context.TargetObject.SetInfo()

---

That worked immediately and perfectly, thank you so much!