Create groups and then add users to them?
I'm in Higher Ed environment and I'm looking to maybe use ADManager instead of something like Microsoft Identity Manager to automate Group membership.
Our DBA can retrieve courses and their students (including their sAMAccountName) from a SQL database (the Student Information System).
Should I have those dumped to a csv and then with ADManager, would it be able to create them and then add the users to them?
Then periodically, we'd need to remove students from them. So I'm wondering if it's best to have a separate automation that just empties the group membership (at the beginning of a semester for example), and then re-adds based on a new CSV.