June 2009 MAR
June 29th, 2009 by 
kendra.thorpe
- Rewrote virtual machine inventory script in Powershell – The old script utilized perl, and I rewrote the script using Powershell and the vSphere Power CLI. The data is written to a MySQL database and I utilized the ODBC drivers to connect to the MySQL database.
- Normalized Runbook data with the NOC inventory data – Due to naming mismatches and servers located in datacenters not managed by the NOC, we had servers that were in the Runbook and not in the NOC inventory. In order to give accurate counts on our inventory, it was necessary to normalize this data.
- Recreated Weekly Helpdesk ticket in SQL Reporting Services – Previously a sysadmin had to manually calculate the number of helpdesk tickets in the various states. Now the report automatically calculates this information.
Posted in AppHosting | 
No Comments »