The Multifunctioning DBA:

Scripting


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 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...


April 13, 2010  5:50 PM

Get a quick Idea of Space used for SQL



Posted by: Colin Smith
Database Size, Powershell, Scripting

A couple weeks ago I had my SAN admin ask me about how much disk I would need to backup all of my sql instances to the SAN. Well I do not know that off the top of my head but I do have a list of all my instances and I know a little bit about powershell. So I decided to throw together a quick and...


January 8, 2010  7:19 PM

Find SQL Server Instances using Powershell



Posted by: Colin Smith
MS SQL Server, MSSQL Administration, MSSQL Instance, Powershell, Scripting

As I had mentioned before, I recieved a network scan that lists the host names of servers that have some sort of SQL Server running on them. Now I need to get a list of all instances that are on those servers. I thought I could do it in Powershell and I was correct. I know that all instnances of...


October 21, 2009  10:00 AM

AD Audit all together



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

Here is the full script so you can copy and paste it. Remember that you will need to make some modifications to the script to fit your environment. Let me know if you have any questions at...


October 20, 2009  6:48 PM

AD Audit Script Q and A



Posted by: Colin Smith
AD, AD Administration, AD Managment, Powershell, Q and A, Scripting

I got the following comment on Part 3 of the script. RobDolfijn Hi Colin, This is just what I need so I’m looking forward to the whole script! I’m getting stuc on Get_Users because it...


October 20, 2009  4:45 PM

AD Audit in Powershell Script Part 6



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

As i recall, in Part 5 we had gathered all the account information, parsed that, disabled accounts that needed to be disabled, gathered information on all the disabled accounts, and removed the accounts from the domain that needed to be...


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: