Scott’s Blog

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.