http://blogs.vanderbilt.edu/s/squirej Just another WordPress weblog Fri, 30 Oct 2009 14:05:35 +0000 http://backend.userland.com/rss092 en Gathered Help Desk data for Law School and assisted with data associations so the Law School could set up their own help desk application. The ITS DOA helpdesk web site was not compatible with IE8.  I got the Vandy templates and upgraded the site to work with IE8. RE-wrote ... http://blogs.vanderbilt.edu/s/squirej/?p=57 Researched and wrote scripts to purge logs and history from incontrol database.  These scripts are written and scheduled within the oracle database to purge these tables nightly up to a given number of days. Updated the code on the IP Request web site by NDE's request. Modified Service Desk ... http://blogs.vanderbilt.edu/s/squirej/?p=54 Corrected Service Desk Business Rule code to eliminate monitoring errors.  Also fixed code to allow IPAM clients to get notification on ticket creation. Worked with DNS admins on database issues to include creating export dmps, adding tablespace, adding flash recovery space and changing backup scripts. Researched and downloaded BMC ... http://blogs.vanderbilt.edu/s/squirej/?p=50 Database Maintenance:  Increased processes for RHN's database.  Created auto_maintance list query for faculty. Corrected BMC Service Desk notifications that went to a list.  Lists have a limit to the number of emails that may be sent.  This limit stopped notifications from BMC Service Desk.  I worked with the List Admin ... http://blogs.vanderbilt.edu/s/squirej/?p=46 Wrote Database queries for ITS Management to include vuspace, vumail, vsa data. DNS/DHCP IP Request Web Page modification.  Added and modified business rules in BMC Service Desk to fill in client ID if vanity addresses are used for IPAM requests.  Assisted Mark with verifying viewable data for Web Page.  ... http://blogs.vanderbilt.edu/s/squirej/?p=32 Applied Oracle's security patch CPUJAN2009 to RHN database. Moved system and datafiles to larger drive for VCMS database. Wrote draft App Hosting Oracle Database User Account Policy. Checked, Confirmed and sometimes locked db accounts and passwords on all of our oracle databases. Created User account speadsheet that lists who or ... http://blogs.vanderbilt.edu/s/squirej/?p=31 Completed and tested web page development for NDE to view and change subnets that are viewable by DiamondIP IP Request web page. Modified IP Request web page to fix a bug with the network request type field. The tape backup has not been backing up the Netid oracle backups ... http://blogs.vanderbilt.edu/s/squirej/?p=30 1. Created query for DiamondIP to find inconsistant IP addresses between IPAM and DNS. This query will be run before and after Mark imports IPAM data to make sure the data is consistant. 2. Created query for Kenon to disable constraints, truncate tables and reenable everything on ... http://blogs.vanderbilt.edu/s/squirej/?p=29 1.       Database support activities for Diamondip IPAM implementation a.       Run NETID scripts for Mark b.      Refresh DIP test database on a weekly basis c.       Provided documentation for our DIP database environment d.      Ran reports 2.       Moved VCMS database files, increased tablespace and flash recovery area 3.       Worked with IDEV DBA ... http://blogs.vanderbilt.edu/s/squirej/?p=28 Set up new DNS IP request web page to send notifications to BMC Service Desk and Create Tickets for DNS and IP. Set up Business Rules in BMC Service Desk to manage DNS, IP tickets. Worked on DNS Project.  Refreshed test database, executed SQL scripts on NETID database for Mark. ... http://blogs.vanderbilt.edu/s/squirej/?p=27