The SPVTAC POC Rotation Control web page was created as a tool for operations center support engineers. It is used for scheduling, rotating and tracking activity associated with on call personnel. Click on the image to access the internal Cisco site. It is replica of the live site.
The site is simplistic, easy to use and developed with commonly used tool suites. It was designed using a backend Mysql database consisting of the engineers contact information, schedules and rotation history. The presentation layer consists of php generated html code pulling data from the Mysql database. Operations engineers use this tool to "rotate" to the next engineer when someone has been called. When this rotation occurs, a notification phone text is sent to all engineers in the rotation to inform them of this event having occurred. Additionally users of the website can view upcoming schedules and the history of the rotations as well as make changes to the database using phpMyAdmin.
Bash shell scripts are used for automating the process of creating new schedules, changing the group of engineers in the rotation and backing up file system and database.
|