Scott’s Blog

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