Table: microsoft365_organization_contact

Retrieve the list of organizational contacts for this organization.

Examples

List all

select
  *
from
  microsoft365_organization_contact;

Schema for microsoft365_organization_contact

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
addresses	jsonb
company_name	text		The name of the contact's company.
department	text		The contact's department.
direct_reports	jsonb
display_name	text	=	The contact's display name.
filter	text	=	Odata query to search for resources.
given_name	text	=	The contact's given name.
id	text	=	The contact's unique identifier.
job_title	text		The contact’s job title.
mail	text
mail_nickname	text
manager	jsonb
member_of	jsonb
on_premises_last_sync_date_time	timestamp with time zone
on_premises_provisioning_errors	jsonb
on_premises_sync_enabled	boolean
phones	jsonb
proxy_addresses	jsonb
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
surname	text	=	The contact's surname.
tenant_id	text	=, !=, ~~, ~~, !~~, !~~	The Azure Tenant ID where the resource is located.
title	text		Title of the resource.
transitive_member_of	jsonb

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- microsoft365

You can pass the configuration to the command with the --config argument:

steampipe_export_microsoft365 --config '<your_config>' microsoft365_organization_contact