Tag Archives: Microsoft SQL Server

Updating Active Directory using PowerShell and SQL

There are a ton of examples out there on how to use CSV files to import user accounts into AD, but personally I prefer SQL to power the data that I’m pulling into my scripts when I can. Case in … Continue reading

Posted in Enterprise Management, Programming | Tagged , , , | Leave a comment

UPDATED: Inventory Outlook GAL

Recently my company was acquired and the first thing to be migrated was our email infrastructure. Firstly, this makes all the work I did inventorying the Rackspace system both very useful up front and very useless once we’ve transitioned. The … Continue reading

Posted in Programming | Tagged , , , , , | 2 Comments

Reading and Writing from Excel with PowerShell

My company is in the middle of being bought out, so my manager was asked to supply a report of everyone’s email addresses so they could be created on the exchange server in our new company. No problem, only my … Continue reading

Posted in Enterprise Management, Programming | Tagged , , , , | 1 Comment

Inventory AD Groups

This PowerShell script grabs every group listed in Active Directory, then parses through the members and uploads it into SQL. The purpose was to get each user entry as a separate row to be used later in COUNT() functions and … Continue reading

Posted in Programming | Tagged , , , , | 1 Comment