Deployment Plan for Mail Integration in VIT
Below is the detailed installation and configuration plan required to enable Microsoft 365 email integration within the VIT environment. All steps follow the client’s security constraints and assume restricted internet access.

Required Software

VIT (Vector Issue Tracker)
Modern Web Browser (Chrome recommended)
Required for Azure login flow; Internet Explorer cannot access the Microsoft OAuth endpoint.
Notepad++ (or default Notepad)
For viewing large log files.
HMailServer
Local connection only.


Project Objective
Enable Microsoft 365 email functionality within VIT using OAuth2 authentication, secure token storage, and automated scheduled tasks.

Database Preparation
A new configuration database is required to store Azure OAuth tokens.

A pre-created database folder will be copied to the correct path on the DB server.
This database will store:

Tenant ID
Client ID / secret (if applicable)
OAuth tokens
Mail integration configuration




External URLs Required
The server must be able to reach the following Microsoft OAuth endpoint:
https://login.microsoftonline.com/1d7a1a92-ab12-44a0-abc7-54710983b297/oauth2/v2.0/authorize


Scheduled Tasks to Create

Get Mail
Refresh Token
Copy from SMTP Server to POP Server


Step-by-Step Implementation Plan


Create and configure the Configuration database.
Insert all necessary values such as TenantId, MailClient, etc.


Create the project inside VIT Projects.
Apply SQL updates included in aditional sql.txt.


Assign the DataStore.
Confirm that all paths in the configuration match the server structure.


Copy the Configuration.cen file
Place it in:
C:\Program Files (x86)\Vector\IssueTrackerServer\
Maintain the same folder structure as in the source location.


Update the HelpDesk02 definition.
In helpDesk02.def/tblMailIntegration, add fields:

tLastProcessedEmail
nConfigurationItem
(SQL included in aditional sql.txt)



Install the required C++ Redistributable
Install VC_redist.x86.exe (needed for Chilkat on Windows Server 2012).


Ensure the server can access the Microsoft OAuth URL.
If Internet Explorer fails, install Chrome (ChromeSetup.exe) and set it as the default browser.


Install GetToken.exe.
This tool only needs to be placed in the directory where it will run.


Create a Scheduled Task to run GetToken.exe every 45 minutes.


Create a Scheduled Task for Mail Integration execution.


Run GetToken.exe manually once
Authenticate using the designated Microsoft 365 user account.


Test the Mail Integration
Confirm that token refresh, mail retrieval, and message synchronization are working correctly.