Monthly Archives: December 2013

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

Get a SQL Inventory of Active Directory with PowerShell

Here is the newly improved version of my Powershell script to inventory Active Directory script. Rather than use SQLPS, I instead create .NET objects within the Data.SqlClient namespace. I also prettied it up a bit with progress bar using Write-Progress. … Continue reading

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

Getting fancy with Write-Progress

Recently I watched a great CBT Nugget by Don Jones (seriously the best trainer/writer out there for PoSH) called Powershell Toolmaking and Scripting.  A lot of it was review, but I did pick up a few nuggets along the way that … Continue reading

Posted in Musing, Programming | Tagged , , , | Leave a comment

When a PowerShell module becomes a crutch

As I’ve mentioned, I’ve a big fan of SQLPS.  However, as this inventory system I’ve built has slowly started to become used by more people than myself, it has become more important that I ensure the data is always available.  … Continue reading

Posted in Musing | Tagged , , , , , | Leave a comment