Scott’s Blog

Monthly Activity Report
August 2008 

1. AIMWorX – Supported all AIMWorX users varying requests.  Copied all SMDR and CDR backup files to CDR 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.  Setup charge information for new App Hosting monthly & onetime charges.  During student return weekend it was discovered that Apphost2 did not have access to AIMWorX.  Apphost2 runs a query against the AIMWorX database to give validated students their Vnet codes.  When the AIMWorX servers were moved into thier new subnet, this firewall rule was not moved.  Terry Cavender updated the firewall to allow the Apphost2 query.
2. AIMWorX Issues — The beginning of August brought problems with the OAI connections to both the Student & Admin PBX networks and AIMWorX.  These problems originally showed themselves by a constant stream of screen pops for VPD stating there was a ‘line link error’ on the FPC17 route to VPD (170).  After resetting AIMWorX and the OAI connection multiple times, the PBX techs and NECdecided that a restart of the Student PBX network NCN was needed.  This corrected the problem.  The next weekend the OAI problems presented themselves in the Admin PBX network.  AIMWorX was rebooted several times and each time the problem bounced between VPD screen pops and Authorizer.  Either Authorizer was not working or the ‘line link errors’ on the VPD route was received every minute.  This problem was worsened because the CHECKSUM process in the PBX was not working to validate Vnets.  The result was that no one could make long distance calls using a Vnet.  It was decided that the Admin PBX NCN had to be rebooted.  Again this resolved the problem.
3. MA4000 project – After installing the MA4000 software using the SQL test cluster the software was producing errors.  The DTC registry hacks were checked on both the MA4000 & SQL test cluster servers.  It was determined that a service restart did not always work, this was determined based on comments found while searching for a resolution to the DTC issues.  The recommendation was always to reboot.  So, the SQL test cluster servers were rebooted and MA4000 was able to make a connection to the database using DTC.  During this process NEC was consulted and assisted in correcting a problem with the CAS software.  The CAS software is used to validate logins with MA4000.
4. Virtual Desktop project — The three VISTA virtual desktops within VMware VDI lost trust with the domain.  These three desktops were deleted and recreated to resolve the problem.  Users are again testing.  Went and talked with LPS about the Citrix Xendesktop solution.  A pilot of this would require one physical server.
5. Virtual Servers — Created a virtual server template for Windows 2008 64 bit.  Converted the DOA web server from physical to virtual.
6. OSIS servers — It was determined that the six windows servers did not have the security setup completed on them: IVR01 & 02, TAPI01 & 02, CR01 & 02.  I have contacted Amcom and Higher Ground to determine what firewall rules are needed on the local host for their software to funtion.  Once this is received the firewalls will be setup and turned on.
7. Higher Ground Server –  On August 11, one of the Higher Ground call recording servers began sending error messages to the PBX operators every minute or so.  They contacted me, on-call, and I called Amcom per our support agreement.  Talking with Amcom support they stated that they did not support this server and that I should contact Higher Ground.  I asked them to talk with Ian Campbell, Amcom support manager.  They did and according to the tech support person he would get the server checked out.  After a while the Amcom support tech called back and said that the Amcom software was working properly and that I should contact HG.  Again I asked them to talk with Ian because my understanding was that Amcom would contact HG.  I went ahead and contacted HG and opened a support ticket because the server had not been recording for several hours.  HG resolved the problem in short order.  I continued to email back and forth with Ian about the support arrangement.  Ian stated that VU was suppose to contact Amcom when there are issues with the HG servers and that he needed to communicate this to his staff.  In the next OSIS meeting, Ian stated that we should contact him with support for the HG servers until his staff is properly trained.
8. QueWorX Life Cycle replacement –  The two IBM servers purchased for QueWorX were recieved and determined that they did not have the correct expansion ports.  The Dialogic board being used for QueWorX was a PCIx board.  The servers had two PCIx slots and two PCIe slots.  The problem being the Dialogic board was a full length/full height board.  Only one of the PCIx slots was usable.  NEC was contacted and they determined that this board was only available in full length/full height.  The install document states that PCIe slots are needed, but the board only comes in PCIx.  This prompted a discussion on whether the servers received would work since there was no expansion capibility.  During this discussion the current IVR server for node one, QueWorX is replacing this server, began having power supply problems.  So, one of the two IBM servers was loaded with Windows 2003 sp2 and the QueWorX software and installed in the Bryan Building to begin the load process to replace the server going bad.  No decision has been made regarding the second server.
9. Mediasite — Worked with Mike Vidal, of Sonic Foundry, to resolve an issue with MAC’s not being able to view presentation.  This issue was corrected with the setup of http streaming on the Mediasite server.
10. SCALA players — Before student return, several of the SCALA players were not talking with the server over https.  Tom Hunt, NEC, set the players to a http connection to allow the players to download their new content.  Now it needs to be determined why https will not work.  A new SSL certificate was installed on this server the week prior to the problems.  An emergency sign process was tested and was successful.  The process is very manual.  NEC was then asked if there was an easier way to make this work.  NEC came back with SCALA scripting that can be added at a cost to make the emergency process easy.
11. Server Decommission — The hard drives were erased or removed from four servers that need to be sent to supluss.  The server information was sent to Joy Saunders to remove them from inventory.  These servers came from the Bryan building:  Two were used for MCS, one for Codemaster, and the other I do not know. 

 

Monthly Activity Report
July 2008 

1. AIMWorX – Supported all AIMWorX users varying requests.  Copied all SMDR and CDR backup files to CDR 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.  Upgraded McAfee to v8.5 and installed approved OS patches on AIMWorXFE01 and BE02.
2. MA4000 project – Talked with NEC about reasons MA4000 worked on week by then did not the next.  Eventually, the project team decided to move the SQL database from the mom-sql server, which was having problems, to the new SQL test cluster.  The MA4000 server was moved to the test network to remove the ITS firewall from the equation.  So, the MA4000 & NECCAS software were unintalled and re-installed using the test SQL cluster.
3. Virtual Desktop project — Spent many hours trying to install the Sun Secure Global Desktop.  It took two phone calls to a Sun technical person but have finally gotten a grasp on how it works.  The problem being that to offer up a desktop requires a desktop, a 1 to 1 relationship.  It basically gives access to your desktop on your desk via the internet.  Also, SGD can offer up software running on a server to other desktops; keeping all data on the server.  There was some good news.  The VMware VDI was setup and has 5 virtual desktops ready for testing, 3 Vista and 2 XP clients.  Servers in use: Virtual Desktop Manager, Windows Terminal Server, Vista golden image, XP golden image, Secure Global Desktop.
4. Virtual Servers — Created 3 virtual servers in support of the following projects: Virtual Desktop & Dreamspark.
5. Operator Services — Script written to update pager data in AIMWorX for the PBX Operators was run on July 1, 2008.
6. New AIMWorX Server VLAN — Moved AIMWorX production server to the new VLAN.  Several firewall issues had to be worked through:  secure remote connection to web2; access to backup environment; NTP using the DCs; and ftp connection to the MIS ftp server.
7. Business & Planning: A script was written to download monthend data files from the MIS server.  This will assit B&P with research of past billing cycles.
8. SSL Certificates: New 2 year SSL certificates were installed for Mediasite and new ITS change management web site.
9. Change Management:  Started the process of migrating the change management web site from the Medical Center to an ITS server.  This web site was put on the Apphost1a web server.  There are still a couple issues to work out with connecting to the web page. 
10. Lifecycle Replacement:  Worked with Rick Carlton on lifecycle replacement of two servers, IVR1 & 2.  The new servers will use QueWorX for ACD menuing.  Two IBM servers were ordered.

Monthly Activity Report
June 2008 

1. AIMWorX – Supported all AIMWorX users varying requests.  Copied all SMDR and CDR backup files to CDR 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. MA4000 project – MA4000 service stopped working sometime during the week of 6/16/08.  Working with NEC to resolve problem.
3. Virtual snapshots — Setup automatic snapshot service for VULS and VUSM.  VULS has 5 snapshots created on Sunday evenings and VUSM has one snapshot created Sunday mornings.  Created a one time snapshot of colo server ‘Flanders’ for Owen prior to them upgrading software on the server.  After the upgrade and Owen was satisfied the upgrade worked properly, the snapshot was removed.
4. Virtual Desktop project — Spent many hours researching & meeting with different vendors solutions for a virtual desktop.  The project team met with representatives in person or over the phone of Dell, Microsoft, Sun, VMware and HP.  Also met with OGSM and reviewed their VMware VDI installation.  We are in the process of setting up a pilot of the Sun virtual desktop solution.
5. Virtual ESX server — Completed setup of ‘Mammoth’ ESX server (its-hcvm12.an).  Setup ESX cluster between its-hcvm11 & its-hcvm12.  Removed all virtual servers from its-hcvm01 and reloaded ESX software using its-hcvm03-ts host name.  This server was placed in the development ESX environment.
6. Virtual Servers — Created 9 virtual servers in support of the following projects: UC2K7, Sharepoint, & Virtual Desktop.
7. AIMWorX & VPD — The AIMWorX alarm client stopped working for VPD on 6/2/08.  Worked with Terry Cavendar to make firewall changes to correct this problem.  Terry found encryption errors between the ITS and VPD firewalls that needed correcting.
8. DOAWeb — Attempted to convert the DOAWeb physical server to a virtual server.  Multiple attempts failed from the 194 network and the App Hosting Admin network.  Currently researching the error that caused the failure.
9. Operator Services — Every July the Medical Center has hundreds of new residents & clinical fellows that have to updated/added to AIMWorX.  This year they requested an auto load into AIMWorX.  I created a Perl script to read the file and populate AIMWorX accordingly.  This script will be run in the production database the morning of July 1.
10. AWAPI update — MIS moved the files used to update AIMWorX to their new secure ftp server.  The ITS firewall was changed to all the AIMWorX server access to this server without the use of Secure Remote.  Also, the automatic Perl script was changed to login to the new server and download the new files.
11. New AIMWorX Server VLAN — Move AIMWorX3 server to the new VLAN for testing prior to the production server move.  Had problems with WINS not being updated with the new IP address but was resolved once the firewall rules were changed to allow the WINS ports outbound traffic.  However, outside the VU IP range access does not work.
12. Windows Server 2003 sp2 upgrade to Magic-DB2 server.

Monthly Activity Report
May 2008 

1. AIMWorX – Supported all AIMWorX users varying requests.  Copied all SMDR and CDR backup files to CDR 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. AWAPI — Changed run times of AWAPI update to 3:25am.  This allowed the process to run without being blocked by another AIMWorX process.  This is running automatically again.
3. MA4000 project – Upgraded the MA4000 software to the beta release of version 7.0.1.  This caused a problem with the software connecting to the database.  Discovered this changed the ports used by Microsoft DTC.  After talking with NEC, they suggested setting the default ports used by MS DTC to 5000-5020.  This was done by a registry change on both the MA4000 server and the Mom-SQL server where the database is stored.  These ports were also opened on the ITS firewall.
4. Virtual snapshots — Restored a snapshot of itsproject01.  Once the snapshot was done the server would not boot.  After much research, it was found that the restore of the snapshot renamed vmdk files.  These were renamed back to thier appropriate names and the server booted.
5. Virtual Desktop project — It was determined that since NEC only used RDP to connect to the virtual machines the security did not meet VU’s standard and the pilot ws stopped before it started.  Now working with Dell and VMware on virtual desktop pilot.
6. Virtual ESX server — Completed setup of ‘Behemeth’ ESX server (its-hcvm11.an).  Setup in Nagios.  Discovered this server had a different chipset that other IBM ESX servers, vmotion will not work between IBM servers of different chipsets.  This server was setup in it own cluster and an additional server with same chipset was ordered.  Created a new virtual server for the sharepoint project.
7. Software Store project — Uninstalled and re-installed the RPEG software using the latest version supplied by e-Academy. 
8. Runbook — Updated install dates and locations of servers on Rick Williams list of incomplete server data for life cycle replacement.  Used websites of Dell & IBM to find warrenty expiration and used this date to determine install date.
9. OS updates — installed Windows 2003 server service pack 2 on Mom-SQL & MagicTest servers.

Monthly Activity Report
April 2008 

1. AIMWorX – Supported all AIMWorX users varying requests.  Ran AWAPI manually several times a week since this process was broken with the SQL sp4 update.  Copied all SMDR and CDR backup files to CDR 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 templates — The ‘Hotline’ template was modified to correct an error.  On the backup/test server, the install template was modified so the template would not program the PBX.  This was requested by Taj Wolff and Dave Mathews.  Currently, this is only on the backup server until the modifications have been tested.  Taj, Dave, and the group were notified of the completed request.  The header template for data ports was modified to include the short description from the work order to give the customer more information as to what the order will be doing.  This was requested by Taj & Lisa after a department received multiple emails for port orders and they did not know which order went with which building request.
3. AIMWorX billing – It was discovered that the AT&T switched calls were imported multiple times.  Unfortunately, this was discovered after the billing cycle was run.  Created a SQL script to pull only the unique call records for this type of call and sent the resulting file to MIS for processing.
4. MA4000 project – Worked through the issues with the MA4000 server.  The first problem was the networks were setup on the incorrect NIC.  This was corrected by putting the correct static IP address on the correct NIC card.  It was also determined there was a problem with the ITS firewall letting DTC requests out but not back from the SQL server.  After the specific ports were opened, Marcus was able to login and run a PBX sync on the student PBX network.  Another problem has been found that the port being used for DTC request is not static.  Attempting to determine the range of ports used by DTC so the firewall can be setup accordingly.
5. Virtual snapshots — Created virtual server snapshots for multiple servers, including 2 for VULS.  Also fullfilled a request to restore snapshots for sharept & project virtual servers.
6. Virtual Desktop project — Research various virtual desktop software packages.  Specifically, VMware VDI.  NEC will be sending hardware & software to ITS for a pilot of thier virtual desktop solution.  Working on scheduling a meeting with Dell to discuss their virtual desktop solution.
7. Virtual ESX server — Worked with Kendra on installing ESX software on the new IBM server.  After several attempts at installing version 3.0.2.  Kendra discovered that the model IBM server we have must use version 3.0.2 update 1.  After downloading this version of the ESX software the install proceeded.  Now waiting on the storage group to complete the zoning on the SAN.  Server name: its-hcvm11.an.
8. Bluetooth on XP — The bluetooth technology does not natively work on a Windows XP laptop.  Did some research on the Microsoft and other websites.  Determined that the installed bluetooth drivers had to be unloaded and a different driver installed.  This was accomplished and a bluetooth headset was setup and worked with OCS.
9. Perl Script — Created a Perl script for Rick Carlton to download UCD station peg couts from AIMWorX.
10. Old Server — Clean the drives of the old AIMWorX2 server.  This server will be placed in the test lab for use by the AD group.  This server is out of warrenty.
11. Sotware Store project — Worked with ELMS software vendor to gain acces to their ftp site for cost center uploads.  The suggested using FileZilla ftp software after WinSCP did not work.  After setting FileZilla to the vendor specifications, connection was not optained.  Sent this information to ELMS vendor and requested assistance.  Waiting on their reply.
12. Certifications — Passed Microsoft SQL Server 2005 - Implementation & Maintenance exam

Monthly Activity Report
March 2008 

1. Support AIMWorX users, database, and servers
2. Backup SMDR and archive to CD (raw call files)
3. Backup CDR and archive to CD  (SQL DB backup)
4. Weekly update of Cost Center & Student information in AIMWorX
5. Call detail lookup for Police & Security and Help Desk fax problems
6. Attended ‘Implementing a Microsoft SQL 2005 Database’ class
7. Attended ‘Maintaining a Microsoft SQL 2005 Database’ class
8. Worked with support personell at NEC to install and configure MA4000 software.
9. Modified AIMWorX templates to correct errors.
10. Modified monthend Access database used by Business & Finance to run properly in MS Office 2007.
11. Created a Perl script to create a file of e911 data to be emailed to VPD.  Discovered an issue with emailing the file because the file size is greater that the maximum attachment size allowed by VU email system.  Asked Judy Whitley to contact VPD to discuss other means of delivery.
12. Worked with ITS Security on plans to secure the AIMWorX servers in seperate VLAN.  Submitted a Magic ticket with details of what processes and ports need to be allowed access to the new VLAN.
13. Contacted IBM support over ITS-SCVM03 & ITS-SCVM04 problems.  SCVM03 had the processor board replaced and SCVM04 was rebooted.
14. Worked with Sonic foundry to correct an issue discovered by an end user, problem was resolved.
15. Manually ran AWAPI process, at least once a week.  AWAPI automatic processing was broken when AIMWorX SQL database was upgraded to service pack 4.
16. Requested and received a new 512GB LUN to expand the Software Stores drive capacity to 1TB on new VM server.  This was requested by the Software Store.
17. Created virtual server snapshots for multiple servers.  Restored two snapshots, at the request of the primary admin, after the servers could not be repaired. 
18. Created a new template for imaging Windows Server 2008 virtual servers.
19. Installed new SSL certificate on helpdesk web server.

Monthly Activity Report
February 2008 

1. Support AIMWorX users, database, and servers
2. Backup SMDR and archive to CD (raw call files)
3. Backup CDR and archive to CD  (SQL DB backup)
4. Weekly update of Cost Center & Student information in AIMWorX
5. Call detail lookup for Police & Security and Help Desk fax problems
6. Worked with Business Objects to correct a problem with the AIMWorX reports web page.  Business Objects had to replace four dll files.
7. Worked with AT&T support because BMS data would not load.  The only way to correct the problem was to uninstall the application and then install the latest version.
8. Setup all the AIMWorX test desktops to point to the new AIMWorX backup server (AIMWorX3).
9. Ran AIMWorX testing for MS SQL 2000 sp4.
10. Loaded MS SQL 2000 sp4 on the production AIMWorX server.
11. Installed reports for Operator Services to run against their new Amcom database on the AIMWorX report web page.
12. Installed Windows 2003 sp2 on OSIS-IVR01 & 02 using WSUS.
13. Installed MA4000 software on new virtual server.  (PBX programming software)  Talked with NEC support for several hours trying to get the software to work. 
14. Downloaded and installed Mediasite v4.3 upgrade.
15. Installed the latest version of NEC software on the AIMWorX FT servers, then installed Windows 2003 Server sp2.
16. Upgraded the Runbook with purchase date for all Dell and IBM servers that was missing this data.
17. Worked with MIS on transferring the daily student file from the new ftp server instead of the HP3000. 
18. Created a Perl script to download all e911 information to be sent to VPD on a weekly basis.
19. Gathered information on virtual servers for master worksheet of all ITS servers in Hill Center.

Monthly Activity Report
January 2008 

1. Support AIMWorX users, database, and servers
2. Backup SMDR and archive to CD (raw call files)
3. Backup CDR and archive to CD  (SQL DB backup)
4. Weekly update of Cost Center & Student information in AIMWorX
5. Call detail lookup for Police & Security and Help Desk fax problems
6. Supported Printing Services server Print-CMYK when drive filled up.  Database log file grew so large it filled the drive.  Worked with Julie to get database backups working again to prevent log file from growing so big.  Cleaned the log file with permission from Printing Services and shrank the file to normal size.
7. Upgraded AIMWorX production servers with v5 sp5a.
8. Reviewed and updated Telemanagement RFP.
9. Created 5 virtaul servers for various projects.
10. Installed Windows 2003 service pack 2 on Strawberry bastion host.
11. Received an extension list from Steve Bryant, Phone Reduction project, and wrote a Perl script to pull name and cost center from AIMWorX.
12. Installed Microsoft SQL 2000 sp4 on backup AIMWorX3 server.
13. Worked with Business Objects to correct issue with AIMWorX web page were no one could log in.

Monthly Activity Report
December 2007 

1. Support AIMWorX users, database, and servers
2. Backup SMDR and archive to CD (raw call files)
3. Backup CDR and archive to CD  (SQL DB backup)
4. Weekly update of Cost Center & Student information in AIMWorX
5. Call detail lookup for Police & Security and Help Desk fax problems
6. Installed software and database on replacement AIMWorX backup server
7. Upgraded Mediasite software from v4.1 to v4.2
8. Corrected AIMWorX data that caused AWAPI to fail
9. Created 6 virtual servers for UC2K7 project
10. Documented process for converting physical servers to virtual servers using the VMWare Converter software
11. Converted Jump01 physical server to a virtual
12. Converted Apps2 physical server to a virtual, had to revert back to physical because of a problem with Filemaker Pro v6.  Continuing to investigate the problem.
13. Rebuilt Windows 2003 Server virtual template to use 20GB hard drive instead of 30GB hard drive.
14. Built Windows 2003 Server 64bit virtual template.
15. Worked with SCLogic to correct RPEG software problems, still working.
16. Setup virtual servers for new Access Control system and Groove Backup replacement.
17. Installed new 2 year certificate on AIMWorX-web2
18. Upgraded SCALA software from v2.0.6 to 2.0.11

Monthly Activity Report
November 2007 

1. Support AIMWorX users, database, and servers
2. Backup SMDR and archive to CD (raw call files)
3. Backup CDR and archive to CD  (SQL DB backup)
4. Weekly update of Cost Center & Student information in AIMWorX
5. Call detail lookup for Police & Security and Help Desk fax problems
6. Worked with AIMWorX testing team to determine if problems were software or database related, so far all problems have been caused by the database being greater than six months out of date.
7. Moved 4 virtual servers from Stevenson to Hill ESX clusters.
8. Created virtual server for MOSS training class.
9. Went to onsite Sharepoint training.
10. Installed eAcademy software (RPEG) for new software store server product evaluation.
11. Assisted SCLogic in setting up email on Mailing Services server.
12. Installed operating system on new AIMWorX backup server.
13. Worked with VMware to get new P2V client and ran conversion from physical to virtual on jump01 as test.
14. Setup WSUS to run all Windows patches for month of November on all servers and workstations.

Monthly Activity Report
October 2007 

1. Support AIMWorX users, database, and servers
2. Backup SMDR and archive to CD (raw call files)
3. Backup CDR and archive to CD  (SQL DB backup)
4. Weekly update of Cost Center & Student information in AIMWorX
5. Call detail lookup for Police & Security and Help Desk fax problems
6. Worked with project team on preliminary RFP for Telemanagement Software
7. Researched templated changes to remove PBX programming
8. Worked with AIMWorX testing team to determine if problems were software or database related, so far all problems have been caused by the database being greater than six months out of date.
9. Researched School of Nursing request for security on the Mediasite server
10. Worked with Judy Whitley and Alan Baker, Dining Services, on setting up their digital sign in the Commons Dining center.
11. Working with ITS Security and Higher Ground, vendor, to get them access to the OSIS server with their software
12. Worked with C.L McKinney, Medical Center, on turnning off HL7 link to old MCS servers
13. Decommissioned MCS & MCS backup servers, scrubbed drives and shutdown
14. Modified multiple Crystal Reports reports at the request of users
15. Modified multiple AIMWorX work order templates at the request of users to correct problems
16. Replaced system board on Mailbe07 to correct bad serial port
17. Created 3 virtual servers for various projects and removed, recreated virtual server for the SCOM project
18. Worked with NEC to create e911 NENA file, unfortunately this process can not be automated, created Perl script to pull data and send to VUPD.
19. Worked on process to backup SCALA server and content. 

Monthly Activity Report
September 2007 

1. Support AIMWorX users, database, and servers
2. Backup SMDR and archive to CD (raw call files)
3. Backup CDR and archive to CD  (SQL DB backup)
4. Weekly update of Cost Center & Student information in AIMWorX
5. Call detail lookup for Police & Security and Help Desk fax problems
6. Completed setup of SCALA server and documented processes
7. Added GeoTrust Certificate to SCALA server with assistance from Kevin McDonald
8. Worked with Security to get backup to work on the co-lo network for SCALA server 
9. Corrected a data error in AIMWorX that cuased AWAPI to crash
10. Loaded OS on server for WRVU media server
11. Reviewed/updated RFP for Telemanagement Replacement project
12. Updated AIMWorX work order templates based on request from Lisa Dorton
13. Worked through provisioning process to order replacement server for AIMWorX2
14. Research permission request for VUSN on Mediasite server

Monthly Activity Report
August 2007 

1. Support AIMWorX users, database, and servers
2. Backup SMDR and archive to CD (raw call files)
3. Backup CDR and archive to CD  (SQL DB backup)
4. Weekly update of Cost Center & Student information in AIMWorX
5. Call detail lookup for Police & Security and Help Desk fax problems
6. Worked with Julie on the Magic upgrade to version 9
7. Setup AnyWhere USB device to support the SCALA digital signage project
8. Attended Sharepoint training (1 week)
9. Attended SCALA training (2 days)
10. Setup Windows virtual server for use with SCALA digital signage
11. Upgraded/supported VC400 computers in the field for SCALA digital signage
12. Created new virtual Windows servers for Project ‘07, SCOM, & Sharepoint projects
13. Rebuilt Windows 2003 Standard server template, old version was corrupted
14. Applied GeoTrust certificate to Mediasite application
15. Created or modified multiple Crystal Reports reports for various AIMWorX users
16. Research for new TEM RFP

Monthly Activity Report
July 2007 

1. Support AIMWorX users, database, and servers
2. Backup SMDR and archive to CD (raw call files)
3. Backup CDR and archive to CD  (SQL DB backup)
4. Weekly update of Cost Center & Student information in AIMWorX
5. Call detail lookup for Police & Security and Help Desk fax problems
6. Virtual machine management
7. Assisted in SAN change for ESX servers
8. Created a server for Mail Services for their new package tracking software
9. Installed 2 new ESX servers for the virtual machine enivironment
10. Moved all iLo/RSA network ports to the AppHosting Admin network
11. Setup 5 different groups for AD authentication into Mediasite software

Monthly Activity Report
June 2007 

1. Support AIMWorX users, database, and servers
2. Point of contact with NEC for AIMWorX issues
3. Backup SMDR and archive to CD (raw call files)
4. Backup CDR and archive to CD  (SQL DB backup)
5. Weekly update of Cost Center & Student information in AIMWorX
6. Call detail lookup for Police & Security and Help Desk fax problems
7. Virtual machine management
8. Continued testing of AIMWorX v5 sp5a on AIMWorX2 backup server
9. Put 10 templates to search e911 database instead of cable database for location information into production
10. Put 6 reports to search e911 database instead of cable database for location information into production
11. Ran NEC SQL script to cancel all work order cable tasks and closed orders on AIMWorX production database
12. Completed removal of all circuits from AIMWorX production database
13. Assisted in installation of SCOM on all Windows servers
14. Completed Mediasite application installation with Sonic Foundry and put into production
15. Worked with AT&T to securely transfer monthly billing files using sftp
16. Tested transfered files from AT&T with the current BMS processes
17. Assisted Jeff in completing surplus inventory list
18. Tested purging of Trouble Tickets in AIMWorX2 backup database
19. Purged 2 years worth of Trouble Tickets in AIMWorX production database
20. Created a Perl script for Sandra to create a file of charges from AT&T Teleconference CD
21. Corrected issues with TAPI servers for the Amcom project, with help from Kendra