SBS 2008 - Using Powershell to add/modify/delete users

I need toadd/modify/delete users  many  users in SBS 2008 on a regular basis. I am attempting to use PowerShell to import the data from a CSV file and to make the changes in AD. On MS Technet is states that in Server 2008 "start Active Directory Module for Windows PowerShell to use powershell to get access to the AD". Unfortunately this option does not seem to be available in SBS 2008 so I have been unable to get any further.

Any suggetions on how I can get access to the SBS 2008 AD using powershell would be a great help.

Thanks

John
jhswinsonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

davorinCommented:
That module is available only for Windows 2008 R2 server, which SBS 2008 is not.
http://technet.microsoft.com/en-us/library/dd378937(v=ws.10).aspx

This tool should be replacement for previous versions of OSes:
http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=2852

I have never used it. Hope it is what you are looking for.
0
SubsunCommented:
You may use Quest PowerShell Commands for Active Directory, it's a free and useful tool..

http://www.quest.com/powershell/activeroles-server.aspx
http://ss64.com/ps/quest.html
0
Cris HannaSr IT Support EngineerCommented:
The very first rule in managing an SBS environment is USE THE WIZARDS in the SBS Console.
Since SBS is limited to 75 cals, it's odd that you'd be making frequent changes to multiple users at once.  Not using the console will result in unexpected issues somewhere down the road

More specific information about your environment and needs will help us provide possible solutions
0
Redefine Your Security with AI & Machine Learning

The implications of AI and machine learning in cyber security are massive and constantly growing, creating both efficiencies and new challenges across the board. Check out our on-demand webinar to learn more about how AI can help your organization!

jhswinsonAuthor Commented:
The reason for this is that the customer has an Avaya phone system which needs to use a LDAP server to store contact numbers to match incoming calls with caller data (these will be extracted from the customer's CRM database). The Avaya supports Microsoft AD so I thought I could use the network AD. I am beginning to think that this may not be such a good idea. Would be interested in others comments.

John
0
Cris HannaSr IT Support EngineerCommented:
So if I understand correctly, your plan was to add all those customers to Active Directory, so that that they would show up properly when calling?

What they really need to do (or you can do it for them) is talk to the CRM vendor.  Most higher end CRM and VOIP systems have modules to connect the data.

But adding these customers to AD is not the way to go.
0
jhswinsonAuthor Commented:
I probably have not fully explained this. The problem is the Avaya phone system; there are two methods of getting it to access the caller data from a CRM system. The simple way is to import a csv file containing the caller data, the problem is that the only way to delete the records once they have been imported into the phone system is to delete them one by one manually ( I didn't believe this but we have checked with Avaya support  and it is apparently so I had to delete 900 records one by one after the phone technician accidentally uploaded an out of date file of names and numbers). This makes it impracticable to keep a large number of caller data records up to date automatically. Avaya Support's answer is that if you want to automatically sync the data with a CRM system is to use LDAP, support for which is built into their system. I would not have considered using AD had it not been for the fact that Avaya support it and I agree that it seems a peculiar solution to the problem. Possibly a better alternative would be to set up a separate LDAP server.

The customer's CRM is a custom built MS Access database designed especially for the needs of their business. I didn't write it but can modify it to export data in any specified format either to file or to another application.

John
0
Cris HannaSr IT Support EngineerCommented:
I think the better solution is to schedule a weekly export form the Access program in .csv format and import it.

does each new import overwrite the previous file?
0
jhswinsonAuthor Commented:
Unfortunately the new import does not overwrite the previous file so I end up with the same name in twice one old entry and one new one.  I am still baffled as to how a company such as Avaya could produce such an inflexible system. I keep thinking that I must be missing something but I have been in contact (indirectly through the company that installed the phone system) with Avaya support and I have spent a lot of time on the specific Avaya forums and I can find no good solution. The LDAP solution with AD does work in that it keeps the Avaya system up to date (I have tried it with a few users added manually on the server) but if I could avoid LDAP I would do so as it has quite a steep learning curve.

John
0
Cris HannaSr IT Support EngineerCommented:
I'm not an Avaya guy so I can't give you any definitive answer there
I don't know if Access will support LDAP queries, but I suspect not.
but throwing these all into AD seems like a really bad idea
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jhswinsonAuthor Commented:
I can understand the negative opinions about using AD for this so I will attempt to use another LDAP server, AppacheDS  (not installed on the server) and see if I can get that to work.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Legacy OS

From novice to tech pro — start learning today.