Monthly Archives: August 2013

Using OpenFileDialog in PowerShell

How many scripts have you had to had a line in that declares a file path? How many times has that path changed? Some scripters like to use a host prompt to ask for the variable, or they declare it … Continue reading

Posted in Programming | Tagged , , | 1 Comment

Inventory Outlook

UPDATE: This script has been updated here… As I mentioned before, we’re running a hosted version of Exchange 2007 here (please see the date of publishing for how ridiculous this is) and have nothing to manage Exchange except a web … Continue reading

Posted in Programming | Tagged , , , , , | 3 Comments

Enter PowerRegEx

Sweet!  Sapien just released they’re latest free app, PowerRegEx. Regular Expression has by far been the single most useful skill I picked up this year.  Being dyslexic, I’ve always struggled in working with long sets of string data in my … Continue reading

Posted in Enterprise Management | 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

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

The debug database switch snippet

Not long into this whole project it became clear that while I was making changes to my PowerShell inventory scripts and updating the database, there were also people who were needing to look at the data while I was making … Continue reading

Posted in Programming | Tagged , , | Leave a comment