Tables

<< Click to Display Table of Contents >>

Raynet One Data Hub > 14.0 u1 > Connectors > Alphabetic Connector List > Microsoft Azure AD > Extracted Data 

Tables

Table

Column

Type

users

accountEnabled

city

companyName

country

deletedDateTime

department

displayName

employeeID

employeeType

givenName

id

mail

officeLocation

onPremisesDistinguishedName

onPremisesImmutableId

onPremisesLastSyncDateTime

onPremisesSamAccountName

onPremisesUserPrincipalName

signInSessionsValidFromDateTime

surname

userPrincipalName

userType

String

String

String

String

String

String

String

String

String

String

String

String

String

String

String

String

String

String

String

String

String

String

groups

createdDateTime

deletedDateTime

displayName

id

mailNickname

onPremisesDomainName

onPremisesSamAccountName

renewedDateTime

securityIdentifier

String

String

String

String

String

String

String

String

String

group_members

groupId

userId

String

String

roles

deletedDateTime

description

displayName

id

roleTemplateId

String

String

String

String

String

role_member

roleId

userId

String

String

devices

accountEnabled

approxiateLastSignInDateTime

complianceExpirationDateTime

deviceId

deviceMetadata

deviceVersion

displayName

id

isCompliant

isManaged

kind

manufacturer

mdmAppId

model

name

onPremisesLastSyncDateTime

onPremisesSyncEnabled

operatingSystem

operatingSystemVersion

platform

profileType

status

trustType

Boolean

String

String

String

String

Integer

String

String

Boolean

Boolean

String

String

String

String

String

String

Boolean

String

String

String

String

String

String