Tag Archives: Active Directory

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

PoSH: Connecting to an Remote Domain

DISCLAIMER: The following is pretty much the worst way to do this when it comes to security. Putting plain-text passwords into anything is always a bad idea and I highly recommend using the method described by TechNet at this link … Continue reading

Posted in Programming | Tagged , , , , | Leave a 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

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

Making PUT calls to the RackSpace API

In my inventory database I use the Employee ID from HR as my unique identifier across systems. I’ve already populated Active Directory’s Employee ID fields and have a SQL inventory of that, so to populate RackSpace I just linked up … Continue reading

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

Inventory AD Computers

Again, to use Active Directory data as for cross reference with other systems, I grab all the computer accounts and put them into SQL. Granted, the INSERT is based on my own tables schema, but I think you can get … Continue reading

Posted in Programming | Tagged , , | Leave a comment

A word on modules and plugins

There are a few that I make heavy use of and are pretty common, but I’ll give a brief on the major ones just for a CYA. SQLPS I don’t know what I’d do without it!  The main thing that … Continue reading

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