tag:blogger.com,1999:blog-27767261042356300052024-11-01T04:50:01.801-07:00      Ramblings from University IT... VMWare, NetApp, Powershell,Active Directory, Exchange and Scripting.MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.comBlogger69125tag:blogger.com,1999:blog-2776726104235630005.post-59322336759715089822014-11-12T14:44:00.000-08:002014-11-12T14:44:00.096-08:00

When replacing Domain Controller certificates for Active Directory with a valid 3rd party certificate I use this script to quickly test my domain and all my domain controllers directly to make sure they are serving out the certificate. ### ----------------------------------------------------------------- ### Written by Matt Brown ### ### Description: This Grabs a list of all the Domain

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com0tag:blogger.com,1999:blog-2776726104235630005.post-1335595463688483672014-11-10T07:00:00.000-08:002014-11-10T07:00:00.079-08:00

Here's a PowerShell script to add computers to the Domain to a specific OU (Organizational Unit) and allows you to select the OU Location. I did not use the AD modules as they are not pre-installed on most desktops, even though it would of been much easier to write with them. ### ----------------------------------------------------------------- ### Written by Matt Brown ### - http://

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com0tag:blogger.com,1999:blog-2776726104235630005.post-52364998480179941722014-11-07T07:30:00.000-08:002014-11-07T07:30:01.174-08:00

Here's a handy script I use to verify networks on my VMWare Clusters. This script takes a test VM and changes the Network and IP Address from a list, then does a simple ping from the VM on each host to let you know your networks are working correctly before moving Production Machines to it. The need for this spawned from a missing "allowed vLan id" not being configured across the ether channel

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com0tag:blogger.com,1999:blog-2776726104235630005.post-6591283541649108352014-11-05T07:30:00.000-08:002014-11-05T07:30:00.822-08:00

Here's a handy script I use to Generate a list of all "Users" with email addresses within a group. It's a recursive function so it will dig through nested groups to make sure all users are picked up. It does not do checking for duplicates as I normally just open the output in Excel and run the Remove Duplicates command. ### ----------------------------------------------------------------- ###

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com0tag:blogger.com,1999:blog-2776726104235630005.post-49704882018078921562014-11-03T13:40:00.002-08:002014-11-03T13:40:55.605-08:00

Here's a handy script I use to send me a report on all VM's in my VMWare Environment with active snapshots. This script finds all VM's with Snapshots, creates an HTML report and emails the info to the provided list. I schedule this to run via the Task Manager automatically every week. ### ----------------------------------------------------------------- ### Written by Matt Brown ### ###

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com0tag:blogger.com,1999:blog-2776726104235630005.post-83935929423866385132010-11-16T22:43:00.000-08:002010-11-16T22:43:52.965-08:00

Here's a quick script to update the Timezone and Language of all your Outlook Live Accounts using remote powershell. ### ----------------------------------------------------------------- ### Written by Matt Brown - 11/16/2010 ### ### Powershell script requires a csv text file in the following Format: ### > email ### > address1@domain.com ### > user2@domain.com ### -------------------------

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com3tag:blogger.com,1999:blog-2776726104235630005.post-11859459064124510542010-05-31T11:27:00.000-07:002014-11-03T13:52:42.136-08:00

I recently needed a script to automatically log the user out after 1 hour of computer usage. I came up with a pretty low tech solution. Set a scheduled task to activate on user login that runs a DOS bat script. The bat script sleeps for 57 minutes and then kicks off a reboot with notice. Note: It requires sleep.exe from the Windows Resource Kit tools. @ECHO OFF REM ##############################

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com1tag:blogger.com,1999:blog-2776726104235630005.post-7140406275217945572010-02-28T06:08:00.000-08:002014-11-03T13:52:55.397-08:00

Quick Powershell script to remove disabled users from the Exchange 2007 Global Address List (GAL) without deleting the account / mailbox. This uses the Quest Active Roles powershell extensions for Active Directory. ### ----------------------------------------------------------------- ### Written by Matt Brown ### ### Name: Remove Terminated Employees from GAL ### ### Version: v1.0, 02/2010 ### ##

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com0tag:blogger.com,1999:blog-2776726104235630005.post-69435308863657170222010-02-26T22:48:00.000-08:002010-02-26T22:59:11.562-08:00

With a recent migration from an old email system I needed to bring over aliases from the old system that would be grandfathered for those users but not new users. This Powershell script checked the accounts to see if the alias was present and if not added it to the account as an accepted Email Address.### -----------------------------------------------------------------### Written by Matt Brown -

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com1tag:blogger.com,1999:blog-2776726104235630005.post-55380710033282292652009-11-02T21:32:00.000-08:002009-11-02T21:37:47.200-08:00

I run a live@edu hotmail system at our school and I needed a way to find out which mailboxes were not longer active (I.E. student hasn't logged in for 365 days). So I put together this little python script to make an SMTP connection on each address load the status into a mysql database.######################################### Written by Matt Brown## - check hotmail mailbox status active /

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com1tag:blogger.com,1999:blog-2776726104235630005.post-3939321102599591922009-11-02T17:32:00.000-08:002009-11-02T17:37:50.385-08:00

I needed a quick way to create a random password for a large number of users in mysql.SELECT SUBSTRING( MD5( RAND() ) FROM 1 FOR 8 ) AS PASSWORD;

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com0tag:blogger.com,1999:blog-2776726104235630005.post-2132081775839162712009-10-12T08:17:00.000-07:002009-10-24T19:36:02.938-07:00

Here's a quick little script to terminate an employee in Active Directory. I'm using the quest AD Powershell command-lets in this script. This uses powershell to disable the AD Account, Change the AD password to a random password, set the description of the account and remove all the group membership from the account.Input text file looks like this:empID0879108792Powershell Script:# -------------

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com0tag:blogger.com,1999:blog-2776726104235630005.post-62800003666528941042009-10-10T09:43:00.000-07:002009-10-12T19:08:57.057-07:00

Problem: I needed to add new applications / servers to the SMTP Relay Connector and document the additions.Solution: Powershell script that reads a csv file with needed server / application / admin info. It then adds the IP address to the connector and logs the info to another CSV file.CSV Files looks like this:IP,Server,Admin,Application,fromaddr10.0.0.1,SQL01,John Doe,SQL Mailer,jdoe@

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com0tag:blogger.com,1999:blog-2776726104235630005.post-33289879331877858742009-10-09T21:42:00.000-07:002009-10-12T19:10:27.838-07:00

Problem: We needed to allow specific servers / applications to send through our Exchange servers without first authenticating.Solution: In order to do this we setup a send connector on our Exchange HUB servers that allowed any of the specified IP's to send without authentication.Powershell to setup the Exchange Connector:$remoteserver = '10.0.0.1'$emaildomain = 'mydomain.com'$HubServers =

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com0tag:blogger.com,1999:blog-2776726104235630005.post-48160055391302901822009-09-29T22:12:00.000-07:002009-10-12T19:12:34.545-07:00

Here's a quick script to write (insert) data into a mysql database using powershell.function ConnectMySQL([string]$user,[string]$pass,[string]$MySQLHost,[string]$database) { # Load MySQL .NET Connector Objects [void][system.reflection.Assembly]::LoadWithPartialName("MySql.Data") # Open Connection $connStr = "server=" + $MySQLHost + ";port=3306;uid=" + $user + ";pwd=" + $pass + ";database="+$

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com3tag:blogger.com,1999:blog-2776726104235630005.post-7687269311640926882009-05-31T09:25:00.000-07:002009-10-12T19:13:59.525-07:00

In this example I'm setting up a Public Folder structure for departmental Absence or Leave Calendars, Giving departments an shared calendar that can be used to track vacation, sick leave, holiday's, etc. What I do first is create the top level Public Folder called Absence Calendars. I then grant my username owner rights on that new Public Folder. Now I can do the rest of the setup (create

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com2tag:blogger.com,1999:blog-2776726104235630005.post-6619093373373618732009-04-06T09:38:00.000-07:002009-04-06T09:47:13.238-07:00

Question:How do I remove another user's data folder or inbox that I have showing up in my outlook profile? When I right click and go to close folder it tells me to go to account settings and when I go to account settings it only show's my account.Answer:1. Select your Main Outlook Profile (Mailbox - )2. Right click and go to Properties for "Mailbox - "3. Under General Tab click on the Advanced

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com0tag:blogger.com,1999:blog-2776726104235630005.post-77998501570127472282009-03-14T10:59:00.000-07:002009-03-14T11:17:31.546-07:00

After clean installs of my 2 ESX VDI systems (now VMWare View) I was unable to get a successful vMotion from one host to the next. I was also having issues getting HA properly configure although after a bit of moving it around, creating a new cluster with a new name and moving the host into that it finally configured. All that said, vMotion still did not work.After a bit of googling, I found that

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com3tag:blogger.com,1999:blog-2776726104235630005.post-58488453715704057982009-02-12T16:06:00.000-08:002009-02-12T07:49:05.091-08:00

I've got (2) NetApp 3040a clustered systems both running LACP Aggregated vifs (nics) for my NFS VMWare Connections. One cluster is running on Cisco Catlyist 3750's and the other is running on a Cisco Catlyist 4507. Both switches are setup redundantly. The fail over / load balance is excellent. Here's how I set it up:My switches are set to IP Load Balance (global switch setting)Commands I used to

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com2tag:blogger.com,1999:blog-2776726104235630005.post-65659522064694437652009-01-19T07:00:00.000-08:002009-10-12T19:17:03.771-07:00

Here are a couple things I had to do to get the Blackberry Enterprise Server (BES) running with Exchange 2007. This stuff wasn't clear in the install guide. Especially number 1 below.1. Give the BESAdmin account permission on my exchange databases. I had to do it on all of our databases. Here's the command for Database07add-adpermission -user BESAdmin –identity “Database07” -accessrights

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com0tag:blogger.com,1999:blog-2776726104235630005.post-50111752759701795202009-01-18T11:48:00.000-08:002009-10-12T19:18:30.384-07:00

Here a quick little snippet from a script I run when setting up users for our BES (Blackberry Enterprise Server) environment with Exchange 2007. Essentially, the script is just giving the BESAdmin account Send-As permission on the AD Account. You could do this on your entire User OU in the domain, but for security purposes we've decided to only set the permission for the Blackberry users.# Open

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com0tag:blogger.com,1999:blog-2776726104235630005.post-50314973992699968732008-11-11T19:00:00.001-08:002009-10-12T19:19:09.024-07:00

I needed to add a 15 minute pause in a script that we were using to create exchange mailboxes and this little Powershell progress bar with a countdown timer worked really nice.###===========================### Pause Program for 15 min### - Matt Brown, 2008###===========================$x = 15*60$length = $x / 100while($x -gt 0) { $min = [int](([string]($x/60)).split('.')[0]) $text = " " + $min

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com2tag:blogger.com,1999:blog-2776726104235630005.post-1942300660716399452008-11-06T07:18:00.000-08:002009-10-12T19:19:52.801-07:00

We have an exchange IIS Application Pool stopping every so often because of some Entourage client problems. It would cause the Application Pool to stop and therefore break owa access, which was a problem.So while we are working with Microsoft on a permanent solution I quickly put together a powershell script to run every 30 seconds and check the state of the application pool. If the

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com0tag:blogger.com,1999:blog-2776726104235630005.post-61197024894478637452008-11-05T10:55:00.000-08:002009-10-12T19:20:41.731-07:00

Here's a quick Powershell script to send you a report of the most recent additions to Active Directory.### --------------------------------------------### Written by Matt Brown - 12:13 PM 10/22/2008###### AD Report on new objects created in the### last 24 hours### Requires Quest Powershell extenstions for AD### --------------------------------------------##########################################

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com1tag:blogger.com,1999:blog-2776726104235630005.post-59911280088016511602008-11-04T08:42:00.000-08:002009-10-12T19:24:55.134-07:00

We recently decided to change on how our Global Address list is displayed from using the format to the , format.Powershell made quick work of this task and took about 10 minutes with 2500 users. Here's the script.###=====================================### Update Exchange Global Address List Display### - Matt Brown, 2008###=====================================$Users = Get-User -ResultSize

MBhttp://www.blogger.com/profile/14651890523678387870noreply@blogger.com0