The Multifunctioning DBA:

Scripting


September 27, 2009  9:00 AM

AD Audit in Powershell Script Part 5



Posted by: Colin Smith
AD, AD Administration, AD Managment, Powershell, Scripting

Now that we have disabled and moved all the disabled accounts to the Disabled OU I am going to get all the user object information from just the disabled OU this time. I need this since objects have been moved around. This scan of AD does go much faster as I am only scanning the one OU. I have this...

September 25, 2009  4:57 PM

AD Audit in Powershell Script Part 4



Posted by: Colin Smith
AD, AD Administration, AD Managment, Powershell, Scripting

Now that we have all of the users information into a csv file it is time to start sorting through all of that data and determining what objects need to be disabled and moved to the disabled OU that I have set up for all disabled accounts to go and await deletion. Lets do that with the...


September 24, 2009  8:30 PM

AD Audit in Powershell Script Part 3



Posted by: Colin Smith
AD, AD Administration, Powershell, Scripting

Now that we have the main part of the script setup it is time to look at the first function that we call. This is the Get_users function. Now this function gets a listing of all the DC's and does a get-qaduser on all of them looking at the lastlogon property to determine what DC has the latest...


August 18, 2009  6:00 PM

Powershell Profile



Posted by: Colin Smith
Administration, Automation, Powershell, Powershell Tips, Scripting

The Powershell Profile is a script that druns anytime you launch Powershell. This is handy so you can ste up variables, add snapins, or just do what ever you like or think is cool when launching Powershell. I was just editing mine, which you can do by: notepad $profile This will pull up your...


August 18, 2009  5:47 PM

Find how many files of any extension are in a folder



Posted by: Colin Smith
One Liners, Powershell, Powershell Tips, Scripting, System Administration

Recently I needed to find out if I had any files of a certain extension in a particular folder and if so how many. With Powershell this is no problem at all. Say I was looking for a count of .ps1 files in the directory.


July 24, 2009  3:47 PM

Another New Language



Posted by: Colin Smith
Database Administration, DBA, Education, Monitoring, Perl, Scripting

My team is going to be developing a new application that will handle all of our monitoring. Currently that includes the monitoring of Sybase Servers, Oracle Instances, and MSSQL Servers. We will also be adding another Database Type that will house all of the Monitoring data. We will be using a...


June 30, 2009  8:13 PM

Select Folder Dialog Box



Posted by: Colin Smith
Administration, Powershell, Scripting

If you would like your scripts to interact with the user and have a nice popup box for a user to select a folder here is a link to an article that will help you out. I think this is pretty great. http://powershell.com/cs/blogs/tips/archive/2009/04/01/select-folder-dialog.aspx


June 26, 2009  3:54 PM

Another Example of why you should learn Powershell



Posted by: Colin Smith
Administration, Powershell, Scripting, Server Administration

I was roaming around the web and reading some articles and I ran across the following blog post: http://bassplayerdoc.blogspot.com/2008/10/another-one-liner-in-windows-powershell.html I think this is a great reason why all administrators that deal with Microsoft products should learn...


May 29, 2009  9:58 PM

Exchange and Powershell



Posted by: Colin Smith
Exchange, Exchange Management, Exchange Scripting, Powershell, Scripting

I was just asked to take a look at writing a script for our new Exchange environment. Now I do not have a lot of experiance scripting for Exchange but I love a Powershell challenge. The problem was that all of our distribution groups had been set up with one option incorrect. I was asked if I could...


May 29, 2009  2:56 PM

Notepad style editor



Posted by: Colin Smith
Editors, Managment, Scripting, Systems Managment, Tools

We all like notepad since it is quick easy and very lightweight. But what if it just does not do all that you want? Well I have used programs like Ultra Edit and I love it. The downside is that it is not as lightweight, you have to buy it, and the intallation is a pain. Great App and it does just...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: