Retain Address Book

Address Book

Here we will discuss the t_abook table in the database, which holds the "address book" info. This might also be a good place to discuss how Retain gets the data via LDAP from Exchange, SOAP via GroupWise, and csv files for O365 via powershell scripts.

O365 via Powershell

Retain uses the data in the exchangeusers.csv and exchangegroups.csv to allow users to log into Retain the first time. If exchangeusers.csv is blank (as sometimes happens). Once they have logged in Retain uses its internal database of user credentials.

One of the big things about using sync365.ps1 is that you have to set up a recurring task in Task Scheduler so that it is updated regularly (eg Nightly).

If you are good at powershell create a script that will copy the current version of exchangeusers.csv and exchangegroups.csv to a safe place if it is not 0 bytes.