<< Click to Display Table of Contents >> RayVentory Data Hub > 12.6 u5 > 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 •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 |