Official

Premium

Microsoft Entra ID (Azure AD)

The CloudQuery Microsoft Entra ID (Azure AD) source plugin extracts your Microsoft Entra ID information and loads it into any supported CloudQuery destination

Publisher

cloudquery

Latest version

v3.3.1

Type

Source

Platforms

Date Published

Documentation Tables Changelog Destinations

entraid_applications
- entraid_application_managementpolicies
- entraid_application_owners
entraid_auditlogs_directoryaudits
entraid_auditlogs_signins
entraid_devicemanagement_configurations
entraid_devicemanagement_manageddevices
entraid_directoryroles
- entraid_directoryrole_members
- entraid_directoryrole_scopedmembers
entraid_directory_subscriptions
entraid_domains
entraid_groups
- entraid_group_approleassignments
- entraid_group_lifecyclepolicies
- entraid_group_memberof
- entraid_group_members
- entraid_group_owners
- entraid_group_settings
entraid_groupsettings
entraid_identity_conditional_access_policies
entraid_identityprotection_riskdetections
entraid_identityprotection_riskyserviceprincipals
entraid_identityprotection_riskyusers
entraid_identityprotection_serviceprincipalriskdetections
entraid_policies_identity_security_defaults_enforcements
entraid_reports_user_registration_details
entraid_rolemanagement_directory_roledefinitions
entraid_rolemanagement_entitlementmanagement_roledefinitions
entraid_rolemanagement_roleassignmentscheduleinstances
entraid_rolemanagement_roleassignmentschedulerequests
entraid_rolemanagement_roleassignmentschedules
entraid_serviceprincipals
- entraid_serviceprincipal_approleassignments
- entraid_serviceprincipal_memberof
- entraid_serviceprincipal_owners
entraid_subscriptions
entraid_users
- entraid_user_approleassignments
- entraid_user_memberof

Entra ID Device Management Managed Devices

The entraid_devicemanagement_manageddevices table shows data for Entra ID Device Management Managed Devices.

https://learn.microsoft.com/en-us/graph/api/intune-devices-manageddevice-list

Primary Keys #

Name	Type
id	`utf8`

Columns #

Name	Type
activation_lock_bypass_code	`utf8`
android_security_patch_level	`utf8`
azure_ad_device_id	`utf8`
azure_ad_registered	`bool`
compliance_grace_period_expiration_date_time	`timestamp[us, tz=UTC]`
compliance_state	`utf8`
configuration_manager_client_enabled_features	`json`
_cq_id	`uuid`
_cq_parent_id	`uuid`
device_action_results	`json`
device_category_display_name	`utf8`
device_compliance_policy_states	`json`
device_configuration_states	`json`
device_enrollment_type	`utf8`
device_health_attestation_state	`json`
device_name	`utf8`
device_registration_state	`utf8`
eas_activated	`bool`
eas_activation_date_time	`timestamp[us, tz=UTC]`
eas_device_id	`utf8`
email_address	`utf8`
enrolled_date_time	`timestamp[us, tz=UTC]`
enrollment_profile_name	`utf8`
ethernet_mac_address	`utf8`
exchange_access_state	`utf8`
exchange_access_state_reason	`utf8`
exchange_last_successful_sync_date_time	`timestamp[us, tz=UTC]`
free_storage_space_in_bytes	`int64`
iccid	`utf8`
id	`utf8`
imei	`utf8`
is_encrypted	`bool`
is_supervised	`bool`
jail_broken	`utf8`
last_sync_date_time	`timestamp[us, tz=UTC]`
managed_device_name	`utf8`
managed_device_owner_type	`utf8`
management_agent	`utf8`
management_certificate_expiration_date	`timestamp[us, tz=UTC]`
manufacturer	`utf8`
meid	`utf8`
model	`utf8`
notes	`utf8`
operating_system	`utf8`
os_version	`utf8`
partner_reported_threat_state	`utf8`
phone_number	`utf8`
physical_memory_in_bytes	`int64`
remote_assistance_session_error_details	`utf8`
remote_assistance_session_url	`utf8`
require_user_enrollment_approval	`bool`
serial_number	`utf8`
subscriber_carrier	`utf8`
total_storage_space_in_bytes	`int64`
udid	`utf8`
user_display_name	`utf8`
user_id	`utf8`
user_principal_name	`utf8`
wi_fi_mac_address	`utf8`