turbot/microsoft365
steampipe plugin install microsoft365

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
addressesjsonb
company_nametextThe name of the contact's company.
departmenttextThe contact's department.
direct_reportsjsonb
display_nametext=The contact's display name.
filtertext=Odata query to search for resources.
given_nametext=The contact's given name.
idtext=The contact's unique identifier.
job_titletextThe contact’s job title.
mailtext
mail_nicknametext
managerjsonb
member_ofjsonb
on_premises_last_sync_date_timetimestamp with time zone
on_premises_provisioning_errorsjsonb
on_premises_sync_enabledboolean
phonesjsonb
proxy_addressesjsonb
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
surnametext=The contact's surname.
tenant_idtext=, !=, ~~, ~~*, !~~, !~~*The Azure Tenant ID where the resource is located.
titletextTitle of the resource.
transitive_member_ofjsonb

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