Scott’s Blog

TagLine Here

2009 July MAR

Filed under: apphosting — Scott.Evans at 5:46 am on Monday, July 27, 2009

Monthly Activity Report
July 2009

  1. AIMWorX – Supported all AIMWorX users varying requests.  Processed the weekly update of cost centers and student information.  Imported yearly Housestaff pagers for PBX operators.  SMDR for April, May, & June were backed up to CD and sent to an off site location.  Call record prior to 12/31/08 were purged.
  2. AIMWorX Templates – Completed new work order template for the OCS project to setup billing in AIMWorX and to request an OCS account.  These templates were imported into the production database.
  3. AIMWorX Data Purge — Purged data prior to 2006 from CHARGES, TRANS, Trouble Ticket tables in AIMWorX.  Work Order purge failed due to ‘database error’.  Research into this issue has found no errors in the AIMWorX database.
  4. AIMWorX Work Order Scheduling — An issue was resolved that was causing work orders to not show up on the technician calendar.  In work order there are two types of tasks: Group & Task.  The group type tasks does not get populated with hours the order will be scheduled for on a particular date, that information is suppose to be on the task type.  For some reason, on one order this information was populated on a group task, this was the cause of the issue.  With help from Paul Lockaby, the incorrect work order was found and the hours information was removed. 
  5. SQL Reporting Services — Began the learning process of this report writing software and created five AIMWorX reports in the process.
  6. OCS Reports — Requested reports for OCS license information were unable to be created that gave an accurate number.  This was due to the way AIMWorX stores work order information.  SQL Reporting Services was tried but ran into the same problems.
  7. IBM Amber Light — There was an amber light found on its-hcwnap64 that was reported to IBM.  The problem turned out to be a bad power supply which was replaced.
  8. Virtual Servers — Created two new virtual servers (DC-10, ITS-HCWNAP66) and rebuilt a virtual server (DC-SB1) for iDev test environment.
  9. Exchange Servers — Build 3 of 9 new physical server for Exchange 2007 environment.