Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

After the OTRSConsumer has written the ticket information away to the sde.otrs_incident and maintenance.otrs_incident tables   tables , it checks to see if a record exists in the sde.outlook_incidents for the particular Ticket Number. If a record does not exist, then this ticket record is new and no further processing takes place. If however a record is found, then it is assumed that this ticket is an update for a previously defined maintenance window, and as such the OTRSConsumer uses the value in the outlook_event_id field of the sde.outlook_incidents table to identify which Microsoft Outlook Calendar Event to delete from the otrs_nm calendar. At the end of the processing, it deletes the calendar event for the fore-mentioned Yellow coloured appointment. (The unique identifier for this event is stored within the  sde.outlook_incidents table with a ticket_number set to 9999999999999999)

...