Organization
Contains metadata and details about the organization accessible to the authenticated user.
Table Specific Information
Select
SELECT * FROM Organization
Update
To update an Organization record you need to specify the Id in WHERE clause.
Update Organization set marketingNotificationEmails = '[email protected]' where Id = 'bf6e4267-a9fb-419b-ae7b-7586fab0ff66'
Columns
| Name | Type | Description |
| id [KEY] | String | The unique identifier for the organization. |
| deletedDateTime | Datetime | The timestamp when the organization was marked as deleted, useful for auditing purposes. |
| assignedPlans | String | A list of plans assigned to the organization, detailing available services or subscriptions. |
| businessPhones | String | Contact phone numbers associated with the organization for business purposes. |
| city | String | The city where the organization's primary office is located. |
| country | String | The country where the organization is registered or primarily operates. |
| countryLetterCode | String | The ISO 3166-1 alpha-2 country code representing the organization's country. |
| createdDateTime | Datetime | The timestamp when the organization was first created in the system. |
| defaultUsageLocation | String | Default location code indicating where the organization primarily consumes services. |
| displayName | String | The human-readable name of the organization, often used for display purposes. |
| marketingNotificationEmails | String | Email addresses for receiving marketing-related communications from the system. |
| mobileDeviceManagementAuthority | String | Specifies the authority responsible for managing the organization's mobile devices, such as Intune. |
| onPremisesLastPasswordSyncDateTime | Datetime | The timestamp of the last successful password synchronization with on-premises systems. |
| onPremisesLastSyncDateTime | Datetime | The timestamp of the last directory synchronization with on-premises systems. |
| onPremisesSyncEnabled | Bool | Indicates whether synchronization with on-premises directories is enabled for the organization. |
| partnerTenantType | String | The type of tenant partnership, such as reseller or customer. |
| postalCode | String | The postal code of the organization's primary address. |
| preferredLanguage | String | The preferred language for communications and system interactions with the organization. |
| privacyProfile_contactEmail | String | The contact email address listed in the organization's privacy profile for data protection inquiries. |
| privacyProfile_statementUrl | String | The URL of the organization's privacy statement, outlining data protection policies. |
| provisionedPlans | String | A list of plans that have been provisioned for the organization, detailing available services. |
| securityComplianceNotificationMails | String | Email addresses for receiving security and compliance-related notifications. |
| securityComplianceNotificationPhones | String | Phone numbers for receiving security and compliance-related notifications. |
| state | String | The state or province where the organization's primary office is located. |
| street | String | The street address of the organization's primary office. |
| technicalNotificationMails | String | Email addresses for receiving technical alerts and system notifications. |
| tenantType | String | The type of tenant, such as educational or business. |
| verifiedDomains | String | A list of domains verified for use by the organization in the system. |