Ask the Community
Groups
Office 365 Field Mapping - Connect IT Community | Kaseya
<main> <article class="userContent"> <p>This article defines how Office 365 fields are mapped to IT Glue fields. Learn more about integrating with Office 365 in our <a rel="nofollow" href="https://kaseya.vanillacommunities.com/kb/articles/aliases/itglue/hc/en-us/articles/360004937698">Office 365 Integration</a> article.</p> <p>A summary of the sync behaviour:</p> <ul><li>Tenants —> IT Glue Organizations</li> <li>Users —> IT Glue Contacts</li> </ul><h3 data-id="organizations">Organizations</h3> <table><tbody><tr style="background-color: DCDCDC;"><td><strong>IT Glue: Organizations</strong></td> <td><strong>Office 365: Tenants</strong></td> </tr><tr><td>Name</td> <td>Tenant Name</td> </tr><tr><td>Location Name (use organization name)</td> <td>Tenant Name</td> </tr><tr><td>Address</td> <td>Address</td> </tr><tr><td>State/Province</td> <td>State/Province</td> </tr><tr><td>City</td> <td>City</td> </tr><tr><td>Postal / Zip Code</td> <td>Postal / Zip Code</td> </tr><tr><td>Location Phone</td> <td>Phone</td> </tr></tbody></table><h3 data-id="contacts">Contacts</h3> <table><tbody><tr style="background-color: DCDCDC;"><td><strong>IT Glue: Contacts</strong></td> <td><strong>Office 365: Users</strong></td> </tr><tr><td>Name</td> <td>First Name + Last Name</td> </tr><tr><td>Title</td> <td>Job Title</td> </tr><tr><td>Office Phone</td> <td>Phone</td> </tr><tr><td>Mobile Phone</td> <td>Mobile</td> </tr><tr><td>Primary Email</td> <td>User Name</td> </tr><tr><td>Mailbox Aliases</td> <td>Alias</td> </tr></tbody></table><h3 data-id="matching-logic">Matching logic</h3> <p>Standard matching rules are used to match records within IT Glue when pulling data from Office 365. The sync will discover Tenants and Contacts in Office 365 and match them to data in IT Glue using the Office 365 fields shown in the table below:</p> <table><tbody><tr style="background-color: DCDCDC;"><td><strong>IT Glue: Asset</strong></td> <td><strong>IT Glue Field</strong></td> <td><strong>Office 365 Field</strong></td> </tr><tr><td>Organizations</td> <td>Name</td> <td>Tenant Name</td> </tr><tr><td>Contacts</td> <td>Email</td> <td> <ol><li>Attempt match on any alias of the Microsoft user.</li> <li>Attempt match on the username value (e.g. the <em><a href="https://kaseya.vanillacommunities.com/profile/onmicrosoft" rel="nofollow">@onmicrosoft</a>.com</em> domain).</li> <li>Attempt match on combination of First Name + Last Name.</li> </ol></td> </tr></tbody></table><h3 data-id="location">Location</h3> <p>Location information is a one-time push into IT Glue and does not sync. If the location is updated in Office 365, then IT Glue creates another location for the Organization.</p> <p>The matching logic for the initial sync of locations is that Address 1, City, State/Province, and Country all must match between the Office 365 tenant and a location within IT Glue. If there is a match, there will be no location created in IT Glue, but the existing location will be updated.</p> <p>After the initial sync, any updates to the location of the Office 365 tenant will result in another location created in IT Glue. <strong>If Address 1, City, State/Province, and Country do not match, then a new location is created.</strong></p> </article> </main>