The Multifunctioning DBA:

September, 2009


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


September 24, 2009  4:13 PM

Powershell Remove files



Posted by: Colin Smith
Microsoft Windows, Powershell, Windows, Windows Administration

I have a server that attempts to backup up the SQL Server databases and it always fails because not enough space is available. This usually is not a big deal as I would run a SQL Clean up task before the backups run to remove the old files. In this case though I am using a third party utility to...


September 24, 2009  7:30 AM

AD Audit in Powershell Script Part 2



Posted by: Colin Smith
Active Directory, AD, AD Administration, Powershell

Now that we have some idea about what this script is about and what we would like to accomplish with the script lets get into it. I have the code in the box below and I will just go over what I am doing . This is where the script will start so I am setting up my variables and then I will start...


September 23, 2009  4:52 PM

Oracle Dataguard Replication Scare



Posted by: Colin Smith
Dataguard, DBA, DR, Oracle, Oracle Administration, Standby Database

I had to bring down the standby server for the power outage in our DR location a few nights agon. No big deal, shut off replication from the primary, go to the standby and do a shutdown imediate, since you can not do a shutdown on the standby server. When things cam up I go to the secondary and do...


September 23, 2009  4:35 PM

AD Audit in Powershell Script Part 1



Posted by: Colin Smith
Active Directory, AD, AD Administration, Powershell

As I said before I have completed my re-write of my Active Directory Audit into Powershell. Man is it better. more functional and less code. I love it. This script goes out and searches my domain for user accounts that are old and stale. By old and stale I mean that they were both created, and have...


September 22, 2009  4:55 PM

Sybase Instance Scare



Posted by: Colin Smith
DR, Sybase, Sybase Administration

Monday morning my company was putting in a new UPS at our DR facility. This is great but it means that all database instances that are running at that location are coming down as power to the entire site was down for 2 hours. No big deal right, I got a list of the instances and shut them all down...


September 18, 2009  4:37 PM

AD Audit in Powershell



Posted by: Colin Smith
AD, Administration, Audit, Automation, Powershell

I have mentioned this before but I have finally done what I set out to do and re-wrote my old vbscript that audits AD Accounts based on Create Date and Last LogonDate in Powershell. This is another great example of how much better powershell is and why everyone should now it. My VB Script was just...


September 16, 2009  4:37 PM

SQL Class



Posted by: Colin Smith
Education, SQL, T-SQL, Training

Found a nice article on some basic SQL. Check it out, it is never bad to have the knowledge even if you are not a DBA or SQL Developer. http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1368296,00.html?track=sy41


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: