0 votes


We are a K-12 private school currently using a small program call ADSync to manage new/existing user accounts based on information populated into our HR system (MS SQL DB).

I'd like to transfer the role of this small program over to Adaxes for account management (creation, changes etc).

It runs an SQL query to return results from the DB (like first/last name, school year, preferred name, etc etc). It then takes this various information and does such things as place the user account in the correct OU, adds them to a security group based on year level, sets manager based on their 'school house' membership).

I would like to explore the options of still using this SQL DB as the information master and getting Adaxes to read from this and populate the user properties accordingly.

Ive seen some scripts you have generated for other users:

http://www.adaxes.com/tutorials_Simplif ... Script.htm
Load Possible Property Pattern values from SQL

Im not sure that these are the things I am looking for...

Look forward to discussing further my options.


by (170 points)

1 Answer

0 votes
by (215k points)


Actually, there's a much better example in our SDK. Take a look at Example 1 under Script Examples in Server-Side Scripting. The script from the samples can be executed before creating a user. It looks up an MS SQL database for a user with the specified Employee ID and sets the Department and Job Title specified in the database for that user. You can base your scripts on that example. If you need further assistance, we will help you.


Thank you for your response. We have some pretty specific requirements so I think I will open a support case to discuss this further.



Related questions

0 votes
0 answers

Is it possible to query the external SQL database for audits of a specific action, even if that action is a 'sub-command' of a business rule, scheduled task etc? Simple ... interested if data is structured in the log in a manner that would allow this? Thanks

asked Aug 30, 2014 by firegoblin (1.6k points)
0 votes
1 answer

We have a business need for automating and controlling the creation of service accounts in our AD. For example, we want all new service accounts to start with "svc_" for ... customize the "New User" form to create a "New Service Account" workflow in Adaxes?

asked Sep 10, 2021 by joshua.lapchuk (50 points)
0 votes
0 answers

I noticed that other identity management solutions have a way for new user to claim their account. This would be helpful so we can help all of our new students (who do not ... ) claim their account and reduce the burden on our help desk. Thanks for your help.

asked Aug 29, 2020 by rmedeiros (360 points)
0 votes
1 answer

Hi, I adapted the code found in this thread to my needs Import Constraints The method works and it does create and populate the property pattern, however ... .Add($constraint) $item.SetConstraints($constraints) $item.SetInfo() $userPattern.Items.Add($item)

asked Dec 6, 2017 by digimortal (240 points)
0 votes
1 answer

We were wondering if Adaxes has a script available to create AS400 accounts during the AD creation. This will allow us to totally automate the new hire process going forward.

asked Jan 26, 2017 by willy-wally (3.2k points)
2,733 questions
2,469 answers
1,336,416 users