This script will look through all open and assigned tickets and create one appointment per ticket in an iCalendar format (ICS) based upon the due dates. The invitation is sent by email, so the user can add it on Outlook calendar.

The organizator of the event is the IT person whom the tickets is assigned to, the creator is set as needed attendee and others are set as optional attendees.

If a ticket does NOT have a due date or an assigned technichian, the invitation is not created.

Spiceworks locks the entire database at times, making it difficult for the script to run and synchronize events. The best work around for this is to have an automated routine that copies the production database to another location, then make the synchronization script pull events from that instead. This works really well.