The Multifunctioning DBA:

Powershell


October 5, 2010  9:47 PM

Exchange Email Changes (filtering)



Posted by: Colin Smith
Exchange Scripting, Powershell, Scripting

Sorry for the long delay in posts but I have been moving and it is a mess. We purchased a prevously owned home and I will never do that again. New is the only way to go. But now that we are settling in and things are starting to wind down I love the house. Still a ton to do though. Anyway back...

August 30, 2010  10:00 AM

Exchange Email Changes (Users meet Mialboxes)



Posted by: Colin Smith
Exchange Scripting, Powershell, Scripting

Now that I have both the users stored in an array and the mailboxes stored in another array it is time to start making sure that I am working with a mailbox and a user account that match up. I do not want to look at my user account and Johns Mailbox and start making changes based on what I find in...


August 29, 2010  8:00 PM

Exchange Email Changes (Users)



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

Last time we went through and got a list of all the mailboxes and out put all smtp addreses to $comparefile. This time we need to get all of the ad records that are associated with the same OU. Now to do this you need the quest ad tools. At least that is how I did it. So here we go, this is pretty...


August 29, 2010  10:00 AM

Exchange Email Changes (Mailboxes)



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

So lets dive into some of the code in order to get this thing done. This post will be in multiple parts since I actually am still not done writing the code. I have done the majority of it at this time and can start sharing thought. So one thing that you need to know is that I am working on this for...


August 28, 2010  10:00 AM

Exchange Email Changes (Obstacle)



Posted by: Colin Smith
Exchange, Powershell, Scripting

I have run into a pretty big obstacle with my email change script. So right now I did some testing and I am able to assign the same smtp address to multiple people. I think it is a replication issue that I am running into and so I am not getting an error stating that a smtp address is in use when I...


August 27, 2010  10:00 AM

Exchange Email Changes (Policy)



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

Another thing that I have found is that you are not able to change the primary smtp address for a mailbox if the mailbox has the emailaddresspolicyenabled flag set to true. Since in my case we want all uses to conform to the new standard, if the script determines that the Primary address needs to...


August 26, 2010  7:00 PM

Exchange Email Changes



Posted by: Colin Smith
Exchange, Powershell

Part 2 in this series I am going to go over why a email policy would not work and why we are scripting this out. So here is the deal, according to my Exchange admin for a policy to work all the users or mailboxes in an ou have to have that policy applied. We did not want to affect all the users...


August 25, 2010  7:13 PM

Powershell Script to modify thousands of email records



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

Like I said I have been tasked with a project to make thousands of modifications to our email addresses at my company. The rules are pretty complex and the Exchange Admin said that because it is not really a blanket thing that a policy will not help us. Good news for me though, now I get to do a...


May 28, 2010  6:16 PM

Database Restores



Posted by: Colin Smith
DBA, Powershell, Recovery

In my environment we have a few instances where the customer would like to have a refresh done from Production to a test server. This is good for me since it gives me a chance to test my backups and make sure that they are good. It is good for the developers because then they are working witht the...


May 27, 2010  10:00 AM

Powershell Gui



Posted by: Colin Smith
DBA, Monitoring, Powershell

A while back, about a year ago, I wrote some custom scripts to monitor all of our SQL Server instances for errors. I have a driver file that has all the information that the script needs in order to find errors on the SQL Servers and it just walks thru them and checks for any errors that I might...


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: