troubleshooting Question

How to use Powershell data from SQL

Avatar of Ackles
AcklesFlag for Switzerland asked on
Microsoft 365Active DirectoryPowershellSQL
151 Comments1 Solution984 ViewsLast Modified:
Hello,
This is in regards to question asked here:
https://www.experts-exchange.com/questions/29013772/Problems-creating-account-in-AD-with-Powershell-data-from-SQL.html?anchor=a42078157¬ificationFollowed=186907313#a42078157

If you see in the script posted, I have $otherAttributes being used for New-Aduser, however the same variable cannot be used for Set-Aduser as it doesn't support -OtherAttributes.
I want to have the possibility of making the changes to an existing user by using the new values from SQL where the Action Column has value Update.

Further I want to use the same scenario for New-MsolUser & Set-MsolUser.

Regards,
A
ASKER CERTIFIED SOLUTION
Chris Dent
PowerShell Developer
Join our community to see this answer!
Unlock 1 Answer and 151 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 151 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros