The net.dante.otrs.OTRSOutlookCalendar JAVA class does not require any parameterstake one integer parameter which is the number of minutes to subtract from the current time, in order to determine the date and time range of the tickets required.

In a nutshell, the OTRConsumer retrieves the XML messages from the ESB OTRS queue, and parses the XML, and uses a standard class, OTRSTicket to store the parsed XML values into. The OTRSTicket class is then used to store the data within the two MySQL databases described below.OTRSOutlookCalendar  retrieves all of the tickets from the sde.otrs_incidents table that have changed in the last 60 minutes. 

The class uses the standard AuditLog class to write log message to /tmp/otrs/OTRSConsumerOutlook-YYYYMMDD.log. The location and name of the log file is configurable from within the otrs.properties file

Enterprise Service Bus (ESB)

The net.dante.otrs.OTRSConsumer JAVA class connects to the test-esb01.geant.net ActiveMQ Message Broker, using credentials stored in the otrs.properties file.

*** It is possible to review the contents of the ESB queue called OTRS using the following URL: http://test-esb01.geant.net:8161/admin/browse.jsp?JMSDestination=OTRS 

The XML returned from the OTRS Web Service TicketGet operation from the OTRSProducer class is sent as a plain text message to the ESB and stored in the OTRS queue.

MySQL Database Connections

The OTRSConsumer connects to two one MySQL databasesdatabass:

sde database on test-msr.geant.net using user reportsUser

maintenance database on uat-dboard01-corr.geant.net using user maintainor. This database is used by the UAT version of the new dashboard correlator. This is not in use by the Production instance.

*** IMPROVEMENT - Add a configuration flag to turn on / off the UAT Dashboard connection

Microsoft Outlook Calendar Connection

The OTRSConsumer connects OTRSOutlookCalendar connects to the Microsoft Outlook Calendar called otrs_nm using a third party JAVA library called JWebServices (http://www.independentsoft.com/jwebservices/index.html). The JWebServices relies on the Microsoft Restful API End-Point: https://outlook.office365.com/EWS/Exchange.asmx and requires a username of OTRS-NM@dante.net and a password that is stored in KeyPass

...