Create business unit based on external SQL query

Question

Dear colleagues, can you please advise if it is possible to create (and update reqularly) business unit of computer objects based on a query to external SQL DB (hostnames stored in SQL)? Thanks!

Answer 1

Hello Dmytro,

Unfortunately, there is no such possibility using business unit membership rules. However, it should work just fine using a scheduled task and a script. The script will query your SQL database and then add a dedicated membership rule for each computer to the business unit.

Comments

Thanks! Do you have by any chance an example on how to manipulate the membership rules via script?

---

Hello Dmytro,

Sure, have a look at the following SDK article: https://adaxes.com/sdk/SampleScripts.ModifyingMembershipRules.