0 votes

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!

by (920 points)

1 Answer

0 votes
by (271k points)
selected by
Best answer

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.

0

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

+1

Hello Dmytro,

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

Related questions

0 votes
1 answer

We would like to have a business unit that is based on an adaxes custom attribute. I don't see a way of doing this. Do you all have any ideas?

asked May 18, 2020 by mark.it.admin (2.3k points)
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

I'm trying to setup SelfService group management. We have multiple Forests. Because of the Forests we can't add users from a different forest to the ManagedBy. We can add a local ... end up getting all the groups a user is a memberof or nothing at all. :)

asked Jun 23, 2021 by ComputerHabit (790 points)
0 votes
1 answer

Hello, I have some AD Groups I would like to exclude from a business unit I'm using. I have standard group names across multiple OUs, some should be a part of the ... than simply having a working exclude query. Any thoughts on how I can get this working?

asked Mar 24, 2016 by drew.tittle (810 points)
0 votes
1 answer

Hello, we manage 20 Domains with Adaxes. How can we create a Business Unit that holds all objects within OU's /Builtin and Users of all managed Domains without adding each OU seperately? regards Helmut

asked Jan 21, 2021 by a423385 (510 points)
3,340 questions
3,041 answers
7,764 comments
544,924 users