schema

Gsuite Schema

graph LR
    GSuiteGroup -- MEMBER_GSUITE_GROUP --> GSuiteGroup
    GSuiteGroup -- MEMBER_OF --> GSuiteGroup
    GSuiteGroup -- OWNER_GSUITE_GROUP --> GSuiteGroup
    GSuiteTenant -- RESOURCE --> GSuiteGroup
    GSuiteTenant -- RESOURCE --> GSuiteUser
    GSuiteUser -- MEMBER_GSUITE_GROUP --> GSuiteGroup
    GSuiteUser -- MEMBER_OF --> GSuiteGroup
    GSuiteUser -- OWNER_GSUITE_GROUP --> GSuiteGroup

GSuiteGroup

A GSuite group with the canonical UserGroup label.

Ontology Mapping: This node uses the ontology label UserGroup.

Additional Labels: This node also uses GCPPrincipal.

Additional Label Definitions:

  • GCPPrincipal: A node participating in the shared GCPPrincipal graph interface.

Properties

Ontology-generated fields are shown in italics.

Field Index Description
id Yes Unique GSuite group ID.
firstseen Timestamp when a sync job first created this node.
lastupdated Yes Timestamp of the last sync that observed this node.
admin_created Whether an administrator created the group.
customer_id ID of the GSuite tenant that contains the group.
description Description of the group.
direct_members_count Number of direct group members.
email Yes Email address of the group.
etag API resource ETag.
group_id Alias of the unique GSuite group ID.
kind API resource type.
name Display name of the group.
_ont_description Normalized field sourced from description.
_ont_email Yes Normalized field sourced from email.
_ont_name Yes Normalized field sourced from name.
_ont_source Module that populated this node's ontology fields.

Relationships

  • (:GSuiteGroup)-[:MEMBER_GSUITE_GROUP]->(:GSuiteGroup): Deprecated compatibility edge linking a member group to its parent group.

    • Properties:

      Field Description
      role Value sourced from role.
  • (:GSuiteGroup)-[:MEMBER_OF]->(:GSuiteGroup): A GSuite group is a member of another GSuite group.

    • Properties:

      Field Description
      role Value sourced from role.
  • (:GSuiteGroup)-[:OWNER_GSUITE_GROUP]->(:GSuiteGroup): A GSuite group owns another GSuite group.

    • Properties:

      Field Description
      role Value sourced from role.
  • (:GSuiteTenant)-[:RESOURCE]->(:GSuiteGroup): A GSuite tenant contains a group.

  • (:GSuiteUser)-[:MEMBER_GSUITE_GROUP]->(:GSuiteGroup): Deprecated compatibility edge linking a user to a GSuite group.

  • (:GSuiteUser)-[:MEMBER_OF]->(:GSuiteGroup): A GSuite user account is a member of a GSuite group.

  • (:GSuiteUser)-[:OWNER_GSUITE_GROUP]->(:GSuiteGroup): A GSuite user account owns a GSuite group.

GSuiteTenant

A GSuite customer account with the canonical Tenant label.

Ontology Mapping: This node uses the ontology label Tenant.

Properties

Field Index Description
id Yes Unique GSuite customer ID.
firstseen Timestamp when a sync job first created this node.
lastupdated Yes Timestamp of the last sync that observed this node.
customer_id Alias of the unique GSuite customer ID.

Relationships

  • (:GSuiteTenant)-[:RESOURCE]->(:GSuiteGroup): A GSuite tenant contains a group.

  • (:GSuiteTenant)-[:RESOURCE]->(:GSuiteUser): A GSuite tenant contains a user account.

GSuiteUser

A GSuite user account with the canonical UserAccount label.

Ontology Mapping: This node uses the ontology label UserAccount.

Additional Labels: This node also uses GCPPrincipal.

Additional Label Definitions:

  • GCPPrincipal: A node participating in the shared GCPPrincipal graph interface.

Properties

Ontology-generated fields are shown in italics.

Field Index Description
id Yes Unique GSuite user ID.
firstseen Timestamp when a sync job first created this node.
lastupdated Yes Timestamp of the last sync that observed this node.
agreed_to_terms Whether the user accepted the terms of service.
archived Whether the user account is archived.
change_password_at_next_login Whether the user must change their password at next login.
creation_time Time when the user account was created.
customer_id ID of the GSuite tenant that contains the user.
email Yes Primary email address of the user.
etag API resource ETag.
family_name Family name of the user.
given_name Given name of the user.
include_in_global_address_list Whether the user appears in the global address list.
ip_whitelisted Whether the user's IP address is allowlisted.
is_admin Whether the user is a super administrator.
is_delegated_admin Whether the user is a delegated administrator.
is_enforced_in_2_sv Whether two-step verification is enforced.
is_enrolled_in_2_sv Whether the user is enrolled in two-step verification.
is_mailbox_setup Whether the user's mailbox is configured.
kind API resource type.
last_login_time Time of the user's last login.
name Full name of the user.
org_unit_path Path of the user's organizational unit.
primary_email Primary email address of the user.
suspended Whether the user account is suspended.
thumbnail_photo_etag ETag of the user's thumbnail photo.
thumbnail_photo_url URL of the user's thumbnail photo.
user_id Alias of the unique GSuite user ID.
_ont_active Yes Normalized field sourced from suspended.
_ont_email Yes Normalized field sourced from email.
_ont_firstname Yes Normalized field sourced from given_name.
_ont_fullname Yes Normalized field sourced from name.
_ont_has_mfa Yes Normalized field sourced from is_enrolled_in_2_sv.
_ont_lastactivity Yes Normalized field sourced from last_login_time.
_ont_lastname Yes Normalized field sourced from family_name.
_ont_source Module that populated this node's ontology fields.

Relationships

  • (:GSuiteTenant)-[:RESOURCE]->(:GSuiteUser): A GSuite tenant contains a user account.

  • (:GSuiteUser)-[:MEMBER_GSUITE_GROUP]->(:GSuiteGroup): Deprecated compatibility edge linking a user to a GSuite group.

  • (:GSuiteUser)-[:MEMBER_OF]->(:GSuiteGroup): A GSuite user account is a member of a GSuite group.

  • (:GSuiteUser)-[:OWNER_GSUITE_GROUP]->(:GSuiteGroup): A GSuite user account owns a GSuite group.

  • (:Human)-[:IDENTITY_GSUITE]->(:GSuiteUser): generated by analysis job GSuite user map to Human.

  • (:User)-[:HAS_ACCOUNT]->(:UserAccount)