The Operations team use a Microsoft Outlook Calendar to review Planned, and Emergency Maintenance windows. This enables them to review the annual leave of the Operations Centre staff to ensure that they are available to support the maintenance period.
The Microsoft Outlook Calendar is called otrs_nm
Every hour, a CRON job runs a Bash Shell script called /home/local/GEANT/dante.sanigar/scripts/otrs_2_outlook.sh located on the test-esb01.geant.net (62.40.109.42) server. I (Omar Q.) moved the scripts folder to "/home/scripts/" directory, just in case the home directory is removed during a housekeeping exercise as Richard Sanigar left the organisation. OTRS TT# 2018100434000618
This script in turn calls three Java Batch Programs:
net.dante.otrs.OTRSProducer - Obtains the OTRS Maintenance Ticket Data from the OTRS system using it's SOAP Web Service, and produces ESB messages in the OTRS queue
net.dante.otrs.OTRSConsumer - Consumes the messages in the OTRS queue and stores the information in a MySQL database called sde located on the test-msr.geant.net server
net.dante.otrs.OTRSOutlookCalendar - Creates new Calendar events inside the otrs_nm calendar
The application uses a properties file called "home/scripts/otrs.properties" that contain the global variables required.
The application generates four log files within the /tmp/otrs directory:
OTRS_Producer_YYYYMMDD.log
OTRS_Consumer_YYYYMMDD.log
OTRS_Dashboard_YYYYMMDD.log
Outlook_YYYYMMDD.log
The Source Code is available from the following GitLab URL: https://gitlab.geant.net/live-projects/otrs/