Scott’s Blog

Monthly Activity Report
October 2008 

1. AIMWorX – Supported all AIMWorX users varying requests.  Copied SMDR and CDR backup files to CD for archive.  Processed the weekly update of cost centers and student information.  Ran a monthly process to remove any duplicate calls from the database prior to a billing cycle.   
2. AIMWorX Issues — The AIMWorX nightly SQL backup has been failing periodically.  The backup has been run manually on the days it fails.  Research into why this is happening has not determined a cause.
3. AIMWorX Web page — ITS Security found that the MSDE database had some vulnerabilities that needed addressing.  Since MSDE is no longer a product that Microsoft sells it was determined that SQL Server 2005 Express would need to be used.  A test AIMWorX web site was created to test this database upgrade as sell as BO Enterprise updates.
4. Perl Script — Created a script that read a list of extensions and put all work orders they appeared on in a text file.  This script was in support of the voice mail reduction project.  Created a new billing journal for Application Hosting monthly charges. 
5. Virtual Desktop project — Worked with Kenon on virtual desktop scripting for automatic desktop setup.
6. Virtual Servers — Moved 17 Windows virtual servers from production LUNs to the new test/dev LUN.  Virtual server templates were updated with the latest Windows OS patches.  Setup a new virtual server for Psychology & Human Development per their request.  Moved a bastion host from local storage to network storage so host would not go down if ESX server failed.
7. ESX servers — ESX servers SCVM03 & SCVM04 had a variety of amber lights on them.  After contacting IBM and running their DSA tools on the server, IBM determined that firmware and drivers needed to be updated.  Working with IBM the proper update tools and software were downloaded.  All updates was successfully installed on SCVM04.  Only one of the multiple updates was applied to SCVM03.  IBM stated that the updates would need to be applied individually.  This change will be scheduled in the near future.  All amber lights on both servers were corrected with the patches that were applied.
8. SCALA Digital Signage– Content Manager was upgraded to the latest version (v5 release 3.1.2).
9. Training — Attending on-site training for Diamond IP.