Skip to main content

AlteryxGallery MongoDB: Schema

Die AlteryxGallery MongoDB ist die Datenbank für den Server-Benutzeroberflächenbereich Ihrer Server-Instanz. Dieser Artikel behandelt die AlteryxGallery MongoDB-Schemaversion 46, die den Server-Versionen 2023.2 entspricht. Server, die MongoDB entweder integriert oder benutzerverwaltet nutzen, verwenden dieses Schema.

Als Server-Administrator benötigen Sie möglicherweise Zugriff auf das MongoDB-Schema Ihrer Server-Instanz für Berichte und Analysen. Sie können über jeden kompatiblen Client auf das MongoDB-Schema zugreifen. mongo Shell ist ein gutes Tool für den Zugriff auf die Befehlszeile. MongoDB Compass ist ein gutes Tool für den Zugriff auf die Benutzeroberfläche. Wenn Sie MongoDB Atlas verwenden, können Sie über die Atlas-Webkonsole auf die Datenbankdokumente zugreifen.

Warnung

Direkte Änderungen an Ihrer MongoDB-Datenbank sind nicht unterstützt. Dies kann zu unerwarteten Ergebnissen führen.

Die Alteryx Gallery MongoDB besteht aus den folgenden Sammlungen. Sammlungen sind Gruppierungen von MongoDB-Dokumenten, die sich aus einer Reihe von Feld-Wert-Paaren zusammensetzen. Wählen Sie eine Sammlung aus, um die Definition der Felder, auch als Schema bezeichnet, anzuzeigen.

apiNonces

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • ApiKey : (Zeichenfolge) API-Schlüssel des Benutzers.

  • Timestamp : (Int32) Epochenzeitstempel.

  • Nonce : (Zeichenfolge) eindeutiger Nonce-Wert.

  • CompoundKey : (Zeichenfolge) zusammengesetzter Schlüssel, der aus API-Schlüssel, Zeitstempel und Nonce besteht.

  • CreateDate : (Datum) Datum/Uhrzeit (UTC) der Nonce-Erstellung.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

appInfos

  • _id : (Objekt-ID): Primärschlüssel des Dokuments.

  • CreatedBy : (Zeichenfolge) ID des ursprünglichen Autors.

  • IsPublic : (Boolean) Markierung: Workflow wurde öffentlich freigegeben.

  • DateMadePublic : (Datum) Datum/Uhrzeit (UTC) der letzten Workflow-Veröffentlichung.

  • IsDeleted : (Boolean) Markierung: Workflow wurde gelöscht. Hinweis: Wenn Sie diesen Wert auf „false“ zurücksetzen, wird der gelöschte Workflow nicht wiederhergestellt.

  • TotalRunCount : (Int32) Anzahl aller Ausführungen sämtlicher Workflow-Versionen.

  • SubscriptionId : (Zeichenfolge) Workflow-Abonnement-ID (Studio).

AppInfoSearchData

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • _t : (Zeichenfolge) Typ-Diskriminator. Wird vom Mongo C#-Treiber zur Unterstützung der Deserialisierung verwendet.

  • OwnerId : (Zeichenfolge) Benutzer-ID des Benutzers, der den Workflow erstellt hat.

  • SubscriptionId : (Zeichenfolge) Workflow-Abonnement-ID (Studio).

  • IsPublic : (Boolean) Markierung: Workflow wurde öffentlich freigegeben.

  • TagNames : (Zeichenfolge) Tag-Namen.

  • Name : (Zeichenfolge) der Anzeigename des Suchobjekts.

auditEvents

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • Entity : (Zeichenfolge) Typ des erstellten, geänderten oder entfernten Objekts.

  • EntityId : (Zeichenfolge) Objekt-ID.

  • UserId : (Zeichenfolge) Benutzer-ID des Benutzers, der die Aktion ausgelöst hat.

  • Timestamp : (Datum) Datum/Uhrzeit (UTC) zu welcher die Durchführung der Aktion stattfand.

  • Event : (Zeichenfolge) die Aktion.

  • OldValues : (Zeichenfolge) ursprüngliche Entitätswerte.

authenticationNonces

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • NonceValue : (Zeichenfolge) eindeutiger Nonce-Wert.

  • TimeStamp : (Datum) Datum/Uhrzeit (UTC) der Nonce-Erstellung.

  • Category: (nvarchar) The category of the notification.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

bannerImages

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • MimeType : (Zeichenfolge) hochgeladener Mime-Bildtyp.

  • FileName : (Zeichenfolge) hochgeladener Bilddateiname.

  • Banner : (Zeichenfolge) Base64-codierte Binärdaten für die hochgeladene Datei.

  • Active : (Boolean) Markierung zur Angabe, ob das Banner aktiv ist.

  • StartDate : (Datum) Datum/Uhrzeit (UTC), an dem das Banner auf „aktiv“ gesetzt wurde.

  • EndDate : (Datum) Datum/Uhrzeit (UTC), zu dem das Banner auf „inaktiv“ gesetzt wurde.

collections

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • CollectionId : (Zeichenfolge) Sammlungs-ID. Wird in der URL der Server-Sammlung verwendet.

  • Name : (Zeichenfolge) Name der Sammlung.

  • OwnerId : (Zeichenfolge) Benutzer-ID des Besitzers der Sammlung.

  • DateAdded : (Datum) Datum/Uhrzeit (UTC) der Erstellung der Sammlung.

  • Apps : (Array) Array von Informationen zu allen Workflows in der Sammlung.

  • Schedules : (Array) Array von Informationen zu allen Zeitplänen in der Sammlung.

  • Insights : (Array) Array von Informationen zu allen Insights in der Sammlung.

  • Users : (Array) Array von Benutzern, für die die Sammlung freigegeben ist.

  • Subscriptions : (Array) Array mit Informationen zu den Abonnements (Studios), für die die Sammlung freigegeben ist. Die Datenstruktur ist die gleiche wie bei „Users“.

  • UserGroups : (Array) Array mit Informationen zu den Benutzergruppen, für die die Sammlung freigegeben ist. Die Datenstruktur ist die gleiche wie bei „Users“.

  • MetaInfo_OutputMessage: (nvarchar) The output message portion of the AppMetaInfo.

  • MetaInfo_NoOutputFilesMessage: (nvarchar) The no-output-files message portion of the AppMetaInfo.

  • NextApp: (nvarchar) The name of the next app in a series of Analytic Apps.

  • DocumentXml: (nvarchar) The XML representation of the document (app).

  • Validation_Id: (nvarchar) Relationship foreign key part to an AppValidation.

  • Validation_ValidationId: (nvarchar) Relationship foreign key part to an AppValidation.

CollectionSearchData

  • _id (Objekt-ID): Primärschlüssel des Dokuments.

  • _t : (Zeichenfolge) Typ-Diskriminator.

  • Name : (Zeichenfolge) Name der Sammlung.

  • Owner : (Zeichenfolge) Name des Eigentümers der Sammlung.

  • OwnerId : (Zeichenfolge) Benutzer-ID des Besitzers der Sammlung.

  • DateCreated : (Datum/Uhrzeit) Datum/Uhrzeit, zu der die Sammlung erstellt wurde.

  • WorkflowCount : (Int32) Anzahl der Workflows innerhalb einer Sammlung.

commandQueueItems

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • Command : (Int32) Typ des Befehls.

  • SearchData : (Objekt) für den Suchindex spezifische Metadaten. Dieses Schema kann je nach Art der Suche, die erstellt oder aktualisiert wird, variieren. Es gibt zusätzliche Felder, die die Suchdaten enthalten.

  • State : (Objekt) Status der Aktualisierungsanfrage und Messaging.

  • IsDeleted: (bit) Workflow deleted flag. Note, changing this back to false does not recover the deleted workflow.

  • TotalRunCount: (int) Count of all runs across all workflow versions.

  • SubscriptionId: (nvarchar) Workflow's Subscription (Studio) ID.

  • SubscriptionName: (nvarchar) Subscription display name.

  • ServiceId: (nvarchar) ID of the document in AlteryxServiceAS_Applications.

  • SourceAppId: (nvarchar) ID used for workflow migration (promotion) via the API.

  • IconId: (nvarchar) Workflow icon image ID.

  • Version: (int) The version of the AppInfo record.

  • WorkerTag: (nvarchar) Workflow worker tag.

  • IsReadyForMigration: (bit) Workflow migration (promotion) flag.

  • Comments: (nvarchar) User-entered comments of the app.

  • RunDisabled: (bit) Flag to disable workflow runs.

  • PackageType: (bit) The type of the workflow - App (0), Module (1), or Macro (2).

configurations

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • EffectiveDate : (Datum) Installationsdatum/-uhrzeit (UTC) der Umgebung.

  • SystemMessage : (Zeichenfolge) Banner-Systemmeldung, die Benutzern in Server angezeigt wird. Navigieren Sie zu Benachrichtigungen .

  • [Veraltet] Terms : (Array) Informationen zu den Nutzungsbedingungen (gilt nur für die Alteryx Public Gallery unter gallery.alteryx.com).

  • Notifications : (Objekt) Konfigurationsinformationen für E-Mail-Benachrichtigungen.

  • Name: (nvarchar) The name of the App.

  • Owner: (nvarchar) The owner’s name of the App.

  • FileName: (nvarchar) The file name of the App.

  • ChainedAppNames: (nvarchar) The names of chained apps.

  • TagIds: (nvarchar) The identifiers of the tags assigned to the App.

  • PackageType: (int) The type of App - App (0), Module (1), or Macro (2).

  • DateCreated: (datetime) Date and time the App was created.

  • DateMadePublic: (datetime) Date and time the App was made public.

  • TotalRunCount: (int) The total number of times the app has been run.

  • IsAmp: (bit) Whether the App is Amp-enabled or not.

credentials

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • Username : (Zeichenfolge) Benutzername der Workflow-Anmeldedaten.

  • PasswordId : (Zeichenfolge) gespeicherte Kennwort-ID.

CredentialSearchData

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • _t : (Zeichenfolge) Typ-Diskriminator. Wird vom Mongo C#-Treiber zur Unterstützung der Deserialisierung verwendet.

  • UserName : (Zeichenfolge) Benutzername der Workflow-Anmeldedaten.

  • DateAdded: (datetime) The date and time the share was created.

  • AddedById: (nvarchar) The non-foreign-key identifier of the User record that created the share.

dCMEConnections

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • ConnectionId : (Zeichenfolge) eindeutige GUID der Verbindung.

  • CreatedOn : (Zeichenfolge) Datum/Uhrzeit (ISO-Format), an dem die Verbindung hergestellt wurde.

  • LastChangedOn : (Zeichenfolge) Datum/Uhrzeit (ISO-Format) der letzten Aktualisierung.

  • Name : (Zeichenfolge) Anzeigename der Verbindung.

  • SchemaName : (Zeichenfolge) Typ der Anmeldedaten.

  • Version : (Ganzzahl) Versionsnummer.

  • Comments: (nvarchar) The user-set comments on the revision.

  • AllowInSDKs : (Boolean) Markierung zur Aktivierung der Verbindung, die von den SDK-Tools verwendet werden soll.

  • Parameters : (Zeichenfolge) zugeordnete Metadaten für das Parent-Objekt.

  • DataSourceId : (Zeichenfolge)

  • Credentials : (Objekt)

  • Owner : (Zeichenfolge) ID des Benutzers, der Besitzer der Verbindung ist.

  • CreatedBy : (Zeichenfolge) ID des Benutzers, der die Verbindung hergestellt hat.

  • LastChangedBy : (Zeichenfolge) ID des Benutzers, der die Verbindung kürzlich aktualisiert oder geändert hat.

  • Deleted : (Boolean) Markierung, die angibt, ob die Verbindung gelöscht wurde.

  • DeletedBy : (Zeichenfolge) ID des Benutzers, der die Verbindung gelöscht hat.

  • DeletedOn : (Zeichenfolge) Datum/Uhrzeit, an dem die Verbindung gelöscht wurde.

  • Users : (Array) Array mit Benutzer-IDs, für die die Verbindung freigegeben ist. Ermöglicht die Workflow-Ausführung in Server über diese Verbindung. Ermöglicht Benutzern nicht, neue Inhalte mit der Verbindung zu erstellen.

  • UserGroups : (Array) Array mit Benutzergruppen-IDs, für die die Verbindung freigegeben ist. Ermöglicht die Workflow-Ausführung in Server über diese Verbindung. Ermöglicht Benutzern nicht, neue Inhalte mit der Verbindung zu erstellen.

  • IsE2: (bit) Whether the revision is AMP enabled or not.

  • Permissions_Id: (nvarchar) The foreign-key identifier for a PersistentAppPermissions record.

  • Validation_Id: (nvarchar) The partial foreign-key identifier for an AppValidation record.

  • Validation_ValidationId: (nvarchar) The partial foreign-key identifier for an AppValidation record.

dCMECredentials

  • _id : (Objekt-ID): Primärschlüssel des Dokuments.

  • CredentialId : (Zeichenfolge) eindeutige GUID der Anmeldedaten.

  • CreatedOn : (Zeichenfolge) Datum/Uhrzeit (ISO-Format), an dem die Anmeldedaten erstellt wurden.

  • LastChangedOn : (Zeichenfolge) Datum/Uhrzeit (ISO-Format) der letzten Aktualisierung.

dCMEDataSources

  • _id : (Objekt-ID): Primärschlüssel des Dokuments.

  • DataSourceId : (Zeichenfolge) eindeutige GUID der Verbindung.

  • CreatedOn : (Zeichenfolge) Datum/Uhrzeit (ISO-Format), an dem die Verbindung hergestellt wurde.

  • Category: (nvarchar) The category of the notification.

  • LastChangedOn : (Zeichenfolge) Datum/Uhrzeit (ISO-Format) der letzten Aktualisierung.

  • Name : (Zeichenfolge) Anzeigename der Verbindung.

  • SchemaName : (Zeichenfolge) Typ der Anmeldedaten.

dataConnections

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • ConnectionString : (Zeichenfolge) Hash-Zeichenfolge der Datenbankverbindung.

  • PasswordSecured : (Zeichenfolge) verschlüsseltes Kennwort für die Datenbankverbindung.

  • ConnectionName : (Zeichenfolge) Anzeigename der Datenverbindung.

DataConnectionSearchData

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • _t : (Zeichenfolge) Typ-Diskriminator. Wird vom Mongo C#-Treiber zur Unterstützung der Deserialisierung verwendet.

  • ConnectionName : (Zeichenfolge) Anzeigename der Datenverbindung.

  • ConnectionString : (Zeichenfolge) Zeichenfolge der Datenverbindung.

districtIcons

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • FileName : (Zeichenfolge) Dateiname des Symbols.

  • MimeType : (Zeichenfolge) Mime-Typ des Symbols.

  • LargeIcon : (Zeichenfolge) Base64-codierte Binärdaten für die hochgeladene Datei.

  • UploadDate : (Datum) Datum/Uhrzeit (UTC), an dem das Symbol hochgeladen wurde.

districts

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • Title : (Zeichenfolge) Anzeigename des Bereichs.

  • Description : (Zeichenfolge) Beschreibung des Bereichs.

  • TagId : (Zeichenfolge) Tag-ID für das Tag, das mit dem Bereich verknüpft ist.

  • NavTitle : (Zeichenfolge) Linktext für die Bereichsnavigation.

  • IconId : (Zeichenfolge) Symbol-ID.

  • Active : (Boolean) Markierung, die angibt, ob der Bereich aktiv ist.

  • SortOrder : (Int32) Sortierreihenfolge der Bereiche.

DistrictSearchData

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • _t : (Zeichenfolge) Typ-Diskriminator. Wird vom Mongo C#-Treiber zur Unterstützung der Deserialisierung verwendet.

  • Name : (Zeichenfolge) Anzeigename des Bereichs.

GlobalSearchData

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • Name : (Zeichenfolge) Anzeigename des Objekts.

  • OwnerId : (Zeichenfolge) Benutzer-ID des Benutzers, der Besitzer des Objekts ist.

  • CreatedDate : (Date) Datum/Uhrzeit (UTC) der Erstellung des Objekts.

  • Type : (String) Objekt-Typ.

  • IsViewable : (Boolean) Markierung, mit der angegeben wird, ob das Objekt von allen Benutzern angezeigt werden kann – oder nur von Benutzern, für die es freigegeben wurde.

  • EndDate: (datetime) Date-time (UTC) when the banner was set to inactive.

  • SortOrder: (int) Banner rotation order.

  • Link: (nvarchar) URL banner image links to.

  • AltText: (nvarchar) URL descriptive hover text.

groupRoles

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • WindowsIdentity : (Objekt) Informationen zur Active Directory-Gruppe.

  • Role : (Zeichenfolge) der Gruppe zugewiesene Rolle. Mögliche Werte sind No Access , Viewer , Member , Artisan oder Curator .

  • DateAdded : (Datum) Datum/Uhrzeit (UTC), an dem die Gruppe der Umgebung hinzugefügt wurde. Hinweis: Bei vorhandenen Gruppen ist dieses Datum auf das Datum und die Uhrzeit des Upgrades auf Version 2020.1 eingestellt. Wenn Sie Version 2020.1 übersprungen haben, werden das Datum und die Uhrzeit der Gruppen, die bereits vor der Aktualisierung vorhanden waren, auf das Datum und die Uhrzeit von der Aktualisierung auf 2020.3 gesetzt.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

insightIcons

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • FileName : (Zeichenfolge) Dateiname des Symbols.

  • MimeType : (Zeichenfolge) Mime-Typ des Symbols.

  • LargeIcon : (Zeichenfolge) Base64-codierte Binärdaten für die hochgeladene Datei.

  • UploadDate : (Datum) Datum/Uhrzeit (UTC), an dem das Symbol hochgeladen wurde.

  • SmallIcon : (Zeichenfolge) Base64-codierte Binärdaten für das Miniaturbild des Symbols.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

Insights

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • InsightId : (Zeichenfolge) Insight-ID. Wird in der Insight-URL von Server verwendet.

  • Name : (Zeichenfolge) Anzeigename des Insight.

  • LastUpdated : (Datum) Datum/Uhrzeit (UTC), an dem das Insight zuletzt aktualisiert wurde.

  • OwnerId : (Zeichenfolge) Benutzer-ID des Benutzers, der Besitzer des Insight ist.

  • IconId : (Zeichenfolge) ID des Insight-Symbols.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

InsightSearchData

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • _t : (Zeichenfolge) Typ-Diskriminator. Wird vom Mongo C#-Treiber zur Unterstützung der Deserialisierung verwendet.

  • InsightId : (Zeichenfolge) Insight-ID. Wird in der Insight-URL von Server verwendet.

  • Name : (Zeichenfolge) Anzeigename des Insight.

  • Besitzer  (Zeichenfolge) Anzeigename des Insight-Besitzers.

  • OwnerId : (Zeichenfolge) Benutzer-ID des Benutzers, der Besitzer des Insights ist.

  • LastPublishedDate : (Datum) Datum/Uhrzeit (UTC), an dem das Insight zuletzt veröffentlicht wurde.

locks

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • Type: (Int32) Typ der Sperre. 0 = Index. 1 = Schemamigration, 2 = Zeitplanvorschau.

  • LastObtained : (Datum) Datum/Uhrzeit (UTC) der letzten Aktivierung der Sperre.

  • MachineName : (Zeichenfolge) Hostname des Server-Knotens, der die Sperre enthält.

  • OwnerId : (Zeichenfolge) Prozess-ID des Prozesses, der die Sperre zuletzt angewendet hat.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

logoImages

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • ImageData : (Zeichenfolge) Base64-codierte Binärdaten für die hochgeladene Datei.

  • IsDefault : (Boolean)

  • MimeType : (Zeichenfolge) Mime-Typ des Logos.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

medias

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • FileName : (Zeichenfolge) Dateiname des Symbols.

  • Title : (Zeichenfolge) Titel der Medien. Dieser entspricht in der Regel dem Dateinamen.

  • Type : (Zeichenfolge) Typ der hochgeladenen Mediendatei.

  • Data : (Zeichenfolge) Base64-codierte Binärdaten für die hochgeladene Datei.

MediaSearchData

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • _t : (Zeichenfolge) Typ-Diskriminator. Wird vom Mongo C#-Treiber zur Unterstützung der Deserialisierung verwendet.

  • FileName : (Zeichenfolge) Dateiname des Symbols.

  • Title : (Zeichenfolge) Titel der Medien. Dieser entspricht in der Regel dem Dateinamen.

  • Type : (Zeichenfolge) Typ der hochgeladenen Mediendatei.

  • Extension : (Zeichenfolge) Dateierweiterung.

  • ScheduleCount: (int) How many schedules are shared via the collection.

  • UserCount: (int) How many users are members of the collection.

  • UserGroupCount: (int) How many user groups are members of the collection.

  • CollectionId: (nvarchar) The identifier of the Collection record.

navigations

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • Header : (Array) Array von Kopfzeilen-Links. Fußzeilenlinks wurden in die Kopfzeile verschoben.

  • Footer : nicht mehr in Verwendung.

  • Main : nicht mehr in Verwendung.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

pages

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • AuthorUserId : (Zeichenfolge) Benutzer-ID des Benutzers, der die Seite erstellt hat.

  • Title : (Zeichenfolge) Seitentitel.

  • Permalink : (Zeichenfolge) Permalink der Seite.

  • Body : (Zeichenfolge) Seiteninhalt.

PageSearchData

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • _t : (Zeichenfolge) Typ-Diskriminator. Wird vom Mongo C#-Treiber zur Unterstützung der Deserialisierung verwendet.

  • Status : (Int32) Seitenstatus. 0 = Entwurf. 1 = veröffentlicht.

  • DesignerDownloadURL: (nvarchar) Designer download link URL.

  • Autor : (Zeichenfolge) Anzeigename des Autors.

  • SignupDisabled: (bit) Flag to disable Server account signups. Allows users to sign up for an account via the login screen in Servers using built-in authentication. This flag also allows accounts to be created automatically with SAML after the user successfully authenticates with the IDP.

  • GalleryName: (nvarchar) Custom name for the Server. Defined in theme settings. See Theme.

  • AnonymousUsage: (bit) Flat to enable anonymous (unregistered) users to run workflows.

  • ApiEnabled: (bit) Flag to enable Server API access.

  • UserCredentialState: (int)

  • SchedulerEnabled: (bit) Server-level flag to enable scheduling.

  • SchedulerValidationInterval: (nvarchar)

  • KeyPairXmlEncrypted: (nvarchar) Encrypted key value.

  • NumAllowedLoginAttempts: (int) Number of login failures allowed before the account is locked.

  • MigrationEnabled: (bit) Flag to allow workflows to be migrated (promoted).

  • DirectDownloadDisabled: (bit) Whether users can download workflows directly.

  • AllowUnsharedCredentialAccess: (bit) Whether to allow unshared credentials access.

  • AllowedHosts: (nvarchar) List of newline separated hostnames that the service is allowed to serve data for. Default value is NULL. NULL and empty values allow all hostnames. The hostname 'localhost' and the hostname from the Server base URL are always allowed regardless of the setting.

  • LastForecastRefresh: (datetime) The date and time of the last refresh of the Schedule Forecast data.

  • ForecastInterval: (int) How often to refresh the Schedule Forecast data.

  • AccountLockTimeout: (int) Account lockout period.

  • EnforceLoginAttemptTimeout: (bit) Flag to enable account lockout for failed attempts.

  • LanguageEnabled: (bit) Flag to enable language support.

  • DefaultLanguage: (nvarchar) System defined default language/locale.

  • RestrictPublicWorkflows: (Boolean) Enable or disable the ability for users to make workflows public. If set to ‘true,' users can’t make workflows public.

  • LimitStudioToSingleUser: (Boolean) To limit the users in a studio to one user, set the value to ‘true’.

scheduleForecasts

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • ScheduleId (Zeichenfolge): eindeutige ID des Zeitplans.

  • AppEstimatedCompletionTime (Int32): vorhergesagte Ausführungsdauer des Zeitplans.

searchLocks

  • _id (Objekt-ID): Primärschlüssel des Dokuments.

  • Name : (Zeichenfolge) Name der Sperre.

secureCommss

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • SessionID : (Zeichenfolge) eindeutige Sitzungs-ID.

  • UserId : (Zeichenfolge) eindeutige Benutzer-ID.

sessions

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • SessionId : (Zeichenfolge) Sitzungs-ID.

  • Active : (Boolean) Markierung, die angibt, ob die Sitzung aktiv ist.

subscriptions

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • [Veraltet] LicenseKey : (Zeichenfolge) Abonnementschlüssel (Studio).

  • Name : (Zeichenfolge) Anzeigename des Studios.

SubscriptionSearchData

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • _t : (Zeichenfolge) Typ-Diskriminator. Wird vom Mongo C#-Treiber zur Unterstützung der Deserialisierung verwendet.

  • Name : (Zeichenfolge) Anzeigename des Abonnements (Studios).

  • CssSelectorCssSectionCustomCssId: (nvarchar) Partial foreign-key to CssSelector record.

  • FriendlyName: (nvarchar) The human readable name for the property.

  • Value: (nvarchar) The value of the property.

Tags

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • Name : (Zeichenfolge) Anzeigename des Tags.

  • Description : (Zeichenfolge) Tag-Beschreibung.

  • AdminOnly : (Boolean) Tag ist nur für Administratoren aktiviert.

  • CssPropertyCssSelectorCssSectionCustomCssId: (nvarchar) Partial foreign-key to CssProperties record.

  • Name: (nvarchar) The name of the css property.

TagSearchData

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • _t : (Zeichenfolge) Typ-Diskriminator. Wird vom Mongo C#-Treiber zur Unterstützung der Deserialisierung verwendet.

  • Name : (Zeichenfolge) Anzeigename des Tags.

temporaryTokens

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • Token : (Zeichenfolge) Token-Zeichenfolge.

  • UserId : (Zeichenfolge) Benutzer-ID.

  • Expiration : (Datum) Datum/Uhrzeit (UTC), an dem das Token abläuft.

usageReports

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • Type : (Int32) Ganzzahlwert, der den Typ der erfassten Nutzungsdaten darstellt. Mögliche Werte sind: 10 = AppExecution, 11 = SignupDisplayed, 12 = GlobalSearch, 13 = LicenseTransfer, 14 = Shepherding, GlobalSettings = 15, 400 = Profiling, 401 = DataProfiling, 1000-1999 = Exceptions.

  • SerialNumber : (Zeichenfolge) Seriennummer (normalerweise eine E-Mail-Adresse), die mit der aktiven Lizenz verknüpft ist.

  • DeviceId : (Zeichenfolge) ID des Geräts, das die Daten meldet. Die ID ist eine Kombination aus der Geräte-GUID, dem Rechnernamen und der Seriennummer.

  • SeatGuid : (Zeichenfolge) Platz-ID.

  • FlexnetVendorSnippets : (Objekt) Lizenzdaten.

  • Guid : (Zeichenfolge) eindeutige GUID.

userGroups

  • _id : (Objekt-ID): Primärschlüssel des Dokuments.

  • Name : (Zeichenfolge) Name der Gruppe.

  • Members : (Array) Array von Benutzern, die Teil der Gruppe sind.

  • Role : (Zeichenfolge) Zeichenfolgenwert für die Rolle, die der Gruppe zugewiesen ist.

  • Credentials : (Array) Array von Workflow-Anmeldedaten, die der Gruppe zugewiesen sind.

  • DataConnections : (Array) Array von Datenverbindungen, die für die Gruppe freigegeben sind.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

userIcons

  • _id (Objekt-ID): Primärschlüssel des Dokuments.

  • FileName (Zeichenfolge): Name der Datei.

  • MimeType (Zeichenfolge): Dateityp.

  • LargeIcon (Zeichenfolge): Bild base64-codiert.

  • UploadDate (Datum/Uhrzeit): Datum/Uhrzeit, zu der das Symbol hochgeladen wurde.

  • SmallIcon (Zeichenfolge): Bild base64-codiert.

  • UserId (Zeichenfolge): Benutzer, auf den sich das Symbol bezieht.

CustomCsses

  • Id: (nvarchar) The identifier of the record.

DataConnections

  • Id: (nvarchar) The identifier of the record.

  • ConnectionString: (nvarchar) Hashed database connection string.

  • PasswordSecured: (nvarchar) Encrypted password for the database connection.

  • ConnectionName: (nvarchar) Data connection display name.

  • DCMConnectionId: (string) DCM Connection linked to the migrated data connection.

DataConnectionSearchDatas

  • Id: (nvarchar) The identifier of the record.

  • ConnectionName: (nvarchar) Data connection display name.

  • ConnectionType: (nvarchar) Human-readable Data Connection type.

DataConnectionSubscriptions

  • Id: (nvarchar) The identifier of the record.

  • DataConnectionId: (nvarchar) Relationship foreign key to a DataConnection record.

  • UserGroupId: (nvarchar) Non-foreign-key identifier of a UserGroup record.

DataConnectionUsers

  • Id: (nvarchar) The identifier of the record.

  • DataConnectionId: (nvarchar) Relationship foreign key to a DataConnection.

  • UserId: (nvarchar) Non-foreign-key identifier of a UserGroup record.

DCMEConnectionHandlingRules

  • Id: (nvarchar) The identifier of the record.

  • SourceConnectionName: (nvarchar) Display name of the source connection.

  • SourceConnectionId: (nvarchar) ConnectionId of the source connection, as found in workflows.

  • TargetConnectionId: (nvarchar) ID of the connection to be used instead of the Source.

  • CreatedOn: (nvarchar) ISO date-time when the connection was created.

  • CreatedBy: (nvarchar) ID of the user that created the connection.

  • LastChangedOn: (nvarchar) ISO date-time of the last update.

  • LastChangedBy: (nvarchar) ID of the user that recently updated or changed the connection.

UserSearchData

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • _t : (Zeichenfolge) Typ-Diskriminator. Wird vom Mongo C#-Treiber zur Unterstützung der Deserialisierung verwendet.

  • Email : (Zeichenfolge) E-Mail-Adresse des Benutzers.

  • Name : (Zeichenfolge) Anzeigename des Benutzers.

  • DateAdded : (Datum) Datum/Uhrzeit (UTC), an dem der Benutzer erstellt wurde.

  • Role : (Zeichenfolge) Die dem Benutzer zugewiesene Rolle.

  • Active : (Boolean) Die E-Mail-Adresse des Benutzers ist aktiv.

  • AllowInSDKs: (bit) Flag to enable the connection to be used by SDK tools.

  • ShareablePortionId: (nvarchar) ID of the shareable connection portion.

  • ParametersAsJson: (nvarchar) Various connection parameters as defined by its schema, stored as JSON.

  • DataSourceId: (nvarchar) ID of the DCM data source.

  • CredentialsAsJson: (nvarchar) Various credential slots as defined by the connection schema, stored as JSON, including Credential ID reference(s).

  • Owner: (nvarchar) ID of the user that owns the connection.

  • CreatedBy: (nvarchar) ID of the user that created the connection.

  • LastChangedBy: (nvarchar) ID of the user that recently updated or changed the connection.

  • Deleted: (bit) Flag to indicate if the connection has been deleted.

  • DeletedBy: (nvarchar) ID of the user that deleted the connection.

  • DeletedOn: (nvarchar) Date-time the connection was deleted.

validationKeys

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • UserId : Benutzer-ID.

  • UserGroupId: (nvarchar) Relational foreign key to a UserGroup record.

versions

  • _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • Number : (Int32) Versionsnummer des MongoDB-Datenbankschemas.

  • MigrationDate : (Datum) Datum/Uhrzeit (UTC) der Migration des Schemas auf diese Version. Dies sind in der Regel das Datum und die Uhrzeit der Aktualisierung auf eine neue Server-Version.

windowsIdentitys

  • [Veraltet] _id : (Objekt-ID) Primärschlüssel des Dokuments.

  • CredentialId: (nvarchar) Unique GUID of the credential.

  • CreatedOn: (nvarchar) ISO date-time when the credential was created.

  • LastChangedOn: (nvarchar) ISO date-time of the last update.

  • Name: (nvarchar) Display name of the credential.

  • SchemaName: (nvarchar) Credential type.

  • Version: (int) Version number.

  • ParametersBsonDocAsJson: (nvarchar)

  • UserName: (nvarchar) Username associated with the credential.

  • SecretsAsJson: (nvarchar) Various secrets slots as defined by the credential schema, stored as JSON, including Secret ID reference(s).

  • VaultConnectionId: (nvarchar) ID of the Connection to the external vault.

  • VaultPath: (nvarchar) The common path to the secret inside an external vault.

  • VaultFieldsMappingAsJson: (nvarchar) Mapping of secrets fetched from an external vault to the credential schema, stored as JSON.

  • Owner: (nvarchar) User ID of the user that owns the credential.

  • CreatedBy: (nvarchar) User ID of the user that created the credential.

  • LastChangedBy: (nvarchar) User ID of the last user to update the credential.

  • Deleted: (bit) Flag indicating if the credential has been deleted.

  • DeletedBy: (nvarchar) User ID of the user that deleted the credential.

  • DeletedOn: (nvarchar) ISO date-time the credential was deleted.

DCMEDataSources

  • Id: (nvarchar) The identifier of the record.

  • DataSourceId: (nvarchar) Unique GUID of the connection.

  • CreatedOn: (nvarchar) ISO date-time when the connection was created.

  • LastChangedOn: (nvarchar) ISO date-time of last update.

  • Name: (nvarchar) Display name of the connection.

  • SchemaName: (nvarchar) Credential type.

  • Version: (int) Version number.

  • DriverName: (nvarchar) Name of the ODBC driver used.

  • Host: (nvarchar) hostname or FQDN of a server providing the data source.

  • ParametersAsJson: (nvarchar) Various data source parameters as defined by its schema.

  • Owner: (nvarchar) ID of the user that owns the data source.

  • CreatedBy: (nvarchar) ID of the user that created the data source.

  • LastChangedBy: (nvarchar) ID of the user that recently updated or changed the connection.

  • Deleted: (bit) Flag indicating if the data source has been deleted.

  • DeletedBy: (nvarchar) ID of the user that deleted the data source.

  • DeletedOn: (nvarchar) Date-time the data source was deleted.

DCMELocks

  • Id: (nvarchar) The identifier of the record.

  • LockId: (nvarchar) Unique GUID of the lock.

  • ConnectionId: (nvarchar) ConnectionId of the connection this lock was created for.

  • CredentialId: (nvarchar) CredentialId of the credential this lock was created for.

  • ExpiresIn: (float) Time when the lock will expire (from CreatedOn, in microseconds).

  • CreatedOn: (datetime) ISO date-time the lock was created.

  • CredentialType: (nvarchar) The name of the slot the locked credential resides in the connection.

  • SecretType: (nvarchar) The name of the slot the locked secret resides in the credential.

DCMEShareableConnectionPortions

  • Id: (nvarchar) The identifier of the record.

  • ObjectId: (nvarchar) Unique GUID of the object.

  • ConnectionId: (nvarchar) GUID of the entire connection, used to reference connections in workflows.

  • CreatedOn: (nvarchar) ISO date-time when the connection was created.

  • LastChangedOn: (nvarchar) ISO date-time of the last update.

  • Name: (nvarchar) Display name of the connection.

  • SchemaName: (nvarchar) Credential type.

  • Version: (int) Version number.

  • AllowInSDKs: (bit) Flag to enable the connection to be used by SDK tools.

  • ParametersAsJson: (nvarchar) Various connection parameters as defined by its schema.

  • DataSourceId: (nvarchar) The DataSourceId of the connection data source

  • CredentialsAsJson: (nvarchar) Various credential slots and references as defined by the connection schema.

  • PresentFieldsAsJson: (nvarchar) Subset of fields shared with the connection.

  • PresentCredentialsAsJson: (nvarchar) Subset of credentials which are shared with the connection.

  • Owner: (nvarchar) ID of the user that owns the connection.

  • CreatedBy: (nvarchar) ID of the user that created the connection.

  • LastChangedBy: (nvarchar) ID of the user that recently updated or changed the connection.

  • Deleted: (bit) Flag to indicate if the connection has been deleted.

  • DeletedBy: (nvarchar) ID of the user that deleted the connection.

  • DeletedOn: (nvarchar) Date-time the connection was deleted.

DCMEShareableConnectionUserGroups

  • Id: (nvarchar) The identifier of the record.

  • DcmeShareableConnectionPortionId: (nvarchar) Relational foreign key to a ShareableConnectionPortion record.

  • UserGroupId: (nvarchar) Relational foreign key to a UserGroup record.

DCMEShareableConnectionUsers

  • Id: (nvarchar) The identifier of the record.

  • DcmeShareableConnectionPortionId: (nvarchar) Relational foreign key to a ShareableConnectionPortion record.

  • UserId: (nvarchar) Relational foreign key to a User record.

DefaultUserCredentials

  • Id: (nvarchar) The identifier of the record.

  • Username: (nvarchar) Username for the user's default credential.

  • PasswordId: (nvarchar) Encrypted password if the user-provided credentials that aren't shared. Value is null if the user selects a shared workflow credential as their default credential.

  • CredentialId: (nvarchar) Id of the workflow credential if the user-selected default is a shared

DistrictIcons

  • Id: (nvarchar) The identifier of the record.

  • FileName: (nvarchar) Icon file name.

  • MimeType: (nvarchar) Icon mime type.

  • LargeIcon: (nvarchar) Base64-encoded binary data for the uploaded file.

  • UploadDate: (datetime) Date-time (UTC) icon was uploaded.

  • SmallIcon: (nvarchar) Base64-encoded binary data for the icon thumbnail.

Districts

  • Id: (nvarchar) The identifier of the record.

  • Title: (nvarchar) District display name.

  • Description: (nvarchar) District description.

  • TagId: (nvarchar) Tag ID for the tag associated with the district.

  • NavTitle: (nvarchar) District navigation link text.

  • IconId: (nvarchar) Icon ID.

  • Active: (bit) Flag for whether district is active.

  • SortOrder: (int) District sort order.

  • Excerpt: (nvarchar) District excerpt text.

DistrictSearchDatas

  • Id: (nvarchar) The identifier of the record.

  • Name: (nvarchar) District display name.

  • Tag: (nvarchar) Tag Name for the tag associated with the district.

  • Active: (bit) Flag for whether district is active.

  • OwnerId: (nvarchar) Unpopulated as Districts do not have owners.

  • DateCreated: (datetime) Unpopulated as District creation date is not tracked.

EmailMessageNotificationPreferenceGroups

  • Id: (nvarchar) The identifier of the record.

  • Group: (nvarchar) Email preference group ID.

  • Description: (nvarchar) Email preference group description.

  • Active: (bit) Flag for whether the group is active.

EmailMessages

  • Id: (nvarchar) The identifier of the record.

  • NotificationMessagesId: (nvarchar) Relational foreign-key to a NotificationMessages record.

  • Name: (nvarchar) Email notification name.

  • Subject: (nvarchar) Subject of the email.

  • Body: (nvarchar) Body of the email.

  • IsBodyHtml: (bit) Flag for HTML email notification body.

  • FriendlyName: (nvarchar) Email notification display name.

  • Description: (nvarchar) Description summarizing the notification.

  • IsDisableable: (bit) Flag to allow notification to be disabled.

  • Enabled: (bit) Flag to enable notification.

  • EmailGroup_Id: (nvarchar) Relational foreign-key to an EmailMessageNotificationPreferenceGroup record.

  • PlaceholdersAsJson: (nvarchar) JSON string representation of email message placeholders.

GlobalSearchDatas

  • Id: (nvarchar) The identifier of the record.

  • Name: (nvarchar) The name of the record.

  • OwnerId: (nvarchar) The User record identifier that owns the searchable record subject.

  • DateCreated: (datetime) The date and time the searchable record subject was created.

  • Type: (nvarchar) The underlying type of the searchable record subject.

  • IsViewable: (bit) Whether the record should be viewable or not.

GroupRoles

  • Id: (nvarchar) The identifier of the record.

  • Role: (nvarchar) Role assigned to the group. Possible values are No Access, Viewer, Member, Artisan, or Curator.

  • DateAdded: (datetime) Date-time (UTC) the group was added to the environment. Note that for existing groups this date is set to the date-time of the upgrade to version 2020.1. If you skipped version 2020.1, the date-time of groups that existed prior to upgrade is set to the date-time of the upgrade to 2020.3.

  • ServerRole: (int) The role with which the group and members will be regarded as.

GroupRoleWindowsIdentities

  • Id: (nvarchar) The identifier of the record.

  • Sid: (nvarchar) Group SID (security identifier).

  • DisplayName: (nvarchar) Group display name.

  • Name: (nvarchar) Group name in domain/group format.

  • SamAccountName: (nvarchar) Sam account name.

  • GroupRole_Id: (nvarchar) Document primary key.

InsightCollectionShares

Anmerkung

With the 2024.1 release, the Insight tool has reached end of life and is no longer available in Alteryx Server. To understand how this might impact you, please visit our FAQ page.

  • Id: (nvarchar) The identifier of the record.

  • CollectionId: (nvarchar) The identifier of the Collection record.

  • InsightId: (nvarchar) Insight ID.

  • DateAdded: (datetime) The date and time when the collection was added.

  • AddedById: (nvarchar) User record identifier of who added the insight to the collection.

InsightIcons

Anmerkung

With the 2024.1 release, the Insight tool has reached end of life and is no longer available in Alteryx Server. To understand how this might impact you, please visit our FAQ page.

  • Id: (nvarchar) The identifier of the record.

  • FileName: (nvarchar) Icon file name.

  • MimeType: (nvarchar) Icon mime type.

  • LargeIcon: (nvarchar) Base64-encoded binary data for the uploaded file.

  • UploadDate: (datetime) The date and time (UTC) the icon was uploaded.

  • SmallIcon: (nvarchar) Base64-encoded binary data for the icon thumbnail.

Insights

Anmerkung

Note: With the 2024.1 release, the Insight tool has reached end of life and is no longer available in Alteryx Server. To understand how this might impact you, please visit our FAQ page.

  • Id: (nvarchar) The identifier of the record.

  • InsightId: (nvarchar) Insight ID. Used in the Server insight URL.

  • Name: (nvarchar) Insight display name.

  • LastUpdated: (datetime) Date-time (UTC) insight was last updated.

  • OwnerId: (nvarchar) User ID for the user the owns the insight.

  • IconId: (nvarchar) Insight icon ID.

InsightSearchDatas

Anmerkung

Note: With the 2024.1 release, the Insight tool has reached end of life and is no longer available in Alteryx Server. To understand how this might impact you, please visit our FAQ page.

  • Id: (nvarchar) The identifier of the record.

  • InsightId: (nvarchar) Insight ID.

  • Name: (nvarchar) Insight display name.

  • Owner: (nvarchar) The name of the owner of the insight.

  • OwnerId: (nvarchar) User ID for the user the owns the insight.

  • LastPublishedDate: (datetime) Date-time (UTC) insight was last published.

  • DateCreated: (datetime) Date and time the insight was created.

LocalizationNotifications

  • Id: (nvarchar) The identifier of the record.

  • Message: (nvarchar) The message displayed for the notification.

  • CreatedDate: (datetime) Date and time the notification was created.

  • Category: (nvarchar) The category of the notification.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

Locks

  • Id: (nvarchar) The identifier of the record.

  • Type: (int) Type of lock. 0=index. 1=schema migration, 2=schedule forecast.

  • MachineName: (nvarchar) Hostname of the Server node holding the lock.

  • OwnerId: (nvarchar) Process ID of the process that last used the lock.

  • LastObtained: (datetime) Date-time (UTC) the lock was last obtained.

LogoImages

  • Id: (nvarchar) The identifier of the record.

  • ImageData: (nvarchar) Base64-encoded binary data for the uploaded file.

  • IsDefault: (bit)

  • MimeType: (nvarchar) Logo mime type.

Media (Originally “Medias”)

  • Id: (nvarchar) The identifier of the record.

  • FileName: (nvarchar) Icon file name.

  • Title: (nvarchar) Title of the media. This is usually the same as the file name.

  • Type: (nvarchar) The type of media file uploaded.

  • Data: (nvarchar) Base64-encoded binary data for the uploaded file.

  • Thumbnail: (nvarchar) Base64-encoded binary data for the thumbnail.

  • Extension: (nvarchar) File extension.

MediaSearchDatas

  • Id: (nvarchar) The identifier of the record.

  • FileName: (nvarchar) Icon file name.

  • Title: (nvarchar) Title of the media. This is usually the same as the file name.

  • Type: (nvarchar) The type of media file uploaded.

  • Extension: (nvarchar) File extension.

MembershipExpiredArtistsNotifications

  • Id: (nvarchar) The identifier of the record.

  • Message: (nvarchar) The message displayed for the notification.

  • CreatedDate: (datetime) Date and time the notification was created.

  • Category: (nvarchar) The category of the notification.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

  • SubscriptionId: (nvarchar) The non-foreign-key identifier of a Subscription record.

MembershipExpiredMemberNotifications

  • Id: (nvarchar) The identifier of the record.

  • Message: (nvarchar) The message displayed for the notification.

  • CreatedDate: (datetime) Date and time the notification was created.

  • Category: (nvarchar) The category of the notification.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

MembershipRevokedNotifications

  • Id: (nvarchar) The identifier of the record.

  • Message: (nvarchar) The message displayed for the notification.

  • CreatedDate: (datetime) Date and time the notification was created.

  • Category: (nvarchar) The category of the notification.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

MigrationHistory

  • MigrationHistory: (nvarchar) The identifier of the migration record.

  • ContextKey: (nvarchar) Fully Qualified class of the Database Context which the migration is applied from.

  • Model: (varbinary) Entity Framework hash representation of the Model state post-migration.

  • ProductVersion: (nvarchar) Entity Framework library version used.

NavigationFooterLinkChilds

  • Id: (nvarchar) The identifier of the record.

  • Title: (nvarchar) Link text.

  • Url: (nvarchar) Link URL.

  • PageId: (nvarchar) ID of the linked page (if the link is to a Server page).

  • NavigationFooterLink_Id: (nvarchar) Relational partial foreign-key to a NavigationFooterLink record.

  • NavigationFooterLink_NavigationId: (nvarchar) Relational partial foreign-key to a NavigationFooterLink record.

NavigationFooterLinks

  • Id: (nvarchar) The partial identifier of the record.

  • NavigationId: (nvarchar) The partial identifier of the record.

  • Title: (nvarchar) Link text.

  • Url: (nvarchar) Link URL.

  • PageId: (nvarchar) ID of the linked page (if the link is to a Server page).

NavigationHeaderLinkChilds

  • Id: (nvarchar) The identifier of the record.

  • Title: (nvarchar) Link text.

  • Url: (nvarchar) Link URL.

  • PageId: (nvarchar) ID of the linked page (if the link is to a Server page).

  • NavigationHeaderLink_Id: (nvarchar) Relational partial foreign-key to a NavigationHeaderLink record.

  • NavigationHeaderLink_NavigationId: (nvarchar) Relational partial foreign-key to a NavigationHeaderLink record.

NavigationHeaderLinks

  • Id: (nvarchar) The identifier of the record.

  • NavigationId: (nvarchar) Link ID.

  • Title: (nvarchar) Link text.

  • Url: (nvarchar) Link URL.

  • PageId: (nvarchar) ID of the linked page (if the link is to a Server page).

NavigationMainLinkChilds

  • Id: (nvarchar) The identifier of the record.

  • Title: (nvarchar) Link text.

  • Url: (nvarchar) Link URL.

  • PageId: (nvarchar) ID of the linked page (if the link is to a Server page).

  • NavigationMainLink_Id: (nvarchar) Relational partial foreign-key to a NavigationMainLink record.

  • NavigationMainLink_NavigationId: (nvarchar) Relational partial foreign-key to a NavigationMainLink record.

NavigationMainLinks

  • Id: (nvarchar) The identifier of the record.

  • NavigationId: (nvarchar) Link ID.

  • Title: (nvarchar) Link text.

  • Url: (nvarchar) Link URL.

  • PageId: (nvarchar) ID of the linked page (if the link is to a Server page).

Navigations

  • Id: (nvarchar) The identifier of the record.

NewUserValidationNotifications

  • Id: (nvarchar) The identifier of the record.

  • Message: (nvarchar) The message displayed for the notification.

  • CreatedDate: (datetime) Date and time the notification was created.

  • Category: (nvarchar) The category of the notification.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

NotificationLists

  • Id: (nvarchar) The identifier of the record.

  • LastPolled: (datetime) Date and time (UTC) the notifications were last checked.

  • LocalizationNotificationSent: (bit) Tracks if the user has been presented the localization notice.

NotificationMessages

  • Id: (nvarchar): The identifier of the record.

OptedOutUsers

  • Id: (nvarchar): The identifier of the record.

  • UserId: (nvarchar) Non-foreign-key identifier to a User record.

  • SubscriptionCollectionShare_Id: (nvarchar) Relational partial foreign-key to a SubscriptionCollectionShare record.

  • SubscriptionCollectionShare_CollectionId: (nvarchar) Relational partial foreign-key to a SubscriptionCollectionShare record.

Pages

  • Id: (nvarchar) The identifier of the record.

  • AuthorUserId: (nvarchar) User ID for the user that created the page.

  • Title: (nvarchar) Page title.

  • Permalink: (nvarchar) Page permalink.

  • Body: (nvarchar) Page body content.

  • Excerpt: (nvarchar) Page excerpt.

  • Categories: (nvarchar) Null.

  • Status: (int) Page status. Values: 0=Draft, 1=Published.

  • CreatedDate: (datetime) Date and time (UTC) page was created.

  • UpdatedDate: (datetime) Date andtime (UTC) page was last updated.

PageSearchDatas

  • Id: (nvarchar) The identifier of the record.

  • Status: (int) Page status. Values: 0=Draft, 1=Published.

  • Author: (nvarchar) The User record identifier of who made the Page.

  • Name: (nvarchar) The name of the page.

  • OwnerId: (nvarchar) The User record identifier of who owns the Page.

  • DateCreated: (datetime) The date and time the Page subject record was created.

PasswordChangedNotifications

  • Id: (nvarchar) The identifier of the record.

  • Message: (nvarchar) The message displayed for the notification.

  • CreatedDate: (datetime) Date and time the notification was created.

  • Category: (nvarchar) The category of the notification.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

PasswordResetNotifications

  • Id: (nvarchar) The identifier of the record.

  • Message: (nvarchar) The message displayed for the notification.

  • CreatedDate: (datetime) Date and time the notification was created.

  • Category: (nvarchar) The category of the notification.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

PendingUserArtisanshipNotifications

  • Id: (nvarchar) The identifier of the record.

  • Message: (nvarchar) The message displayed for the notification.

  • CreatedDate: (datetime) Date and time the notification was created.

  • Category: (nvarchar) The category of the notification.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

PendingUserCollectionAppAddedNotifications

  • Id: (nvarchar) The identifier of the record.

  • Message: (nvarchar) The message displayed for the notification.

  • CreatedDate: (datetime) Date and time the notification was created.

  • Category: (nvarchar) The category of the notification.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

PendingUserCollectionAppUpdatedNotifications

  • Id: (nvarchar) The identifier of the record.

  • Message: (nvarchar) The message displayed for the notification.

  • CreatedDate (datetime) Date and time the notification was created.

  • Category: (nvarchar) The category of the notification.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

PendingUserCollectionScheduleAddedNotifications

  • Id: (nvarchar) The identifier of the record.

  • Message: (nvarchar) The message displayed for the notification.

  • CreatedDate: (datetime) Date and time the notification was created.

  • Category: (nvarchar) The category of the notification.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

PendingUserCollectionSharedNotifications

  • Id: (nvarchar) The identifier of the record.

  • Message: (nvarchar) The message displayed for the notification.

  • CreatedDate: (datetime) Date and time the notification was created.

  • Category: (nvarchar) The category of the notification.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

PendingUserMembershipNotifications

  • Id: (nvarchar) The identifier of the record.

  • Message: (nvarchar) The message displayed for the notification.

  • CreatedDate (datetime) Date and time the notification was created.

  • Category: (nvarchar) The category of the notification.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

PersistentAppPermissions

  • Id: (nvarchar) The identifier of the record.

  • CanDownload: (bit) Flag that enables workflow downloads.

  • AllowVersionHistory: (bit) Flag that allows others to view workflow history.

  • CanExecute: (bit) Whether execution is allowed.

  • CanDelete: (bit) Whether deletion is allowed.

  • Discriminator: (nvarchar) The underlying software object type that should be populated when read from the database.

ReferralNotifications

  • Id: (nvarchar) The identifier of the record.

  • Message: (nvarchar) The message displayed for the notification.

  • CreatedDate (datetime) Date and time the notification was created.

  • Category: (nvarchar) The category of the notification.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

ScheduleCollectionShares

  • Id: (nvarchar) The identifier of the record.

  • CollectionId: (nvarchar) Collection ID. Used in the Server collection URL.

  • ScheduleId: (nvarchar) Unique ID of the schedule.

  • DateAdded: (datetime) Date and time the schedule was added to the collection.

  • AddedById: (nvarchar) User record identifier of who added the schedule to the collection.

ScheduleForecasts

  • Id: (nvarchar) The identifier of the record.

  • ScheduleId: (nvarchar) Unique ID of the schedule.

  • AppEstimatedCompletionTime: (int) The predicted amount of time the schedule will run for.

  • ScheduleName: (nvarchar) Name of the schedule.

  • StartTime: (datetime) Date and time the schedule should start.

  • Frequency: (nvarchar) Frequency at which the schedule will occur.

  • WorkflowName: (nvarchar) Name of the workflow associated with the schedule.

  • OwnerId: (nvarchar) Unique ID of the user that owns the schedule.

  • Priority: (int) Integer value representing the priority of the schedule.

ScimConfigurations

  • Id: (nvarchar) The identifier of the record.

  • IsEnabled: (bit) Whether SCIM config is enabled.

  • CanonicalUri: (bit) The Canonical URI.

  • WebApiUri: (nvarchar) The Server Web API hosted Uri.

ScimTokens

  • Id: (nvarchar) The identifier of the record.

  • Jwt: (nvarchar) JWT token.

  • LifetimeDays: (int) Lifetime validity.

  • SymmetricKey (nvarchar) Symmetric Encryption key.

SecureComms

  • Id: (nvarchar) The identifier of the record.

  • SessionID: (nvarchar) Unique session ID.

  • UserId: (nvarchar) Unique user ID.

  • ServerRSAPublicKey: (nvarchar)

  • ServerRSAPrivateKey: (nvarchar)

  • ServerECDHPublicKey: (nvarchar)

  • ServerECDHPrivateKey: (nvarchar)

  • ClientRSAPublicKey: (nvarchar)

  • ClientECDHPublicKey: (nvarchar)

  • SharedSecret: (nvarchar)

  • IsDesignerSyncKeys: (bit)

SecurityInfoes

  • Id: (nvarchar) The identifier of the record.

  • Password: (nvarchar) Hashed, salted, and encrypted password.

  • HMACKey: (nvarchar) HMAC key for hashing password.

  • Salt: (nvarchar) Salt value used to salt password.

  • PasswordResetNonce: (nvarchar) Nonce value used when password reset is initiated.

  • User_Id: (nvarchar) Relational foreign-key to a User record.

SendApplicationLinkNotifications

  • Id: (nvarchar) The identifier of the record.

  • Message: (nvarchar) The message displayed for the notification.

  • CreatedDate: (datetime) Date and time the notification was created.

  • Category: (nvarchar) The category of the notification.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

SerializableNotifications

  • Id: (nvarchar) The identifier of the record.

  • Message: (nvarchar) The message displayed for the notification.

  • CreatedDate: (datetime) Date and time the notification was created.

  • Category: (nvarchar) The category of the notification.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

Sessions

  • Id: (nvarchar) The identifier of the record.

  • SessionId: (nvarchar) Session ID.

  • Active: (bit) Flag for whether the session is active.

  • UserId: (nvarchar) User ID.

  • CreationDate: (datetime) Date and time (UTC) session was created.

  • UpdateDate: (datetime) Date and time (UTC) session was last updated.

  • Anonymous: (bit) Flag for whether session is for an anonymous user.

  • KeepAlive: (bit) Flag for whether the session should be kept alive.

SubscriptionChangedNotifications

  • Id: (nvarchar) The identifier of the record.

  • Message: (nvarchar) The message displayed for the notification.

  • CreatedDate: (datetime) Date and time the notification was created.

  • Category: (nvarchar) The category of the notification.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

SubscriptionCollectionSharePermissions

  • SubscriptionCollectionShareId: (nvarchar) Relational partial foreign-key to a SubscriptionCollectionShare record.

  • SubscriptionCollectionShareCollectionId: (nvarchar) Relational partial foreign-key to a SubscriptionCollectionShare record.

  • Collection_IsAdmin: (bit) Flag for collection admin permissions. Users with this permission have all asset and user-management permissions.

  • Assets_CanUpdate: (bit) Permission for updating assets (for example, workflows and insights) in the collection.

  • Assets_CanAdd: (bit) Permission for adding assets (for example, workflows and insights) to the collection.

  • Assets_CanRemove: (bit) Permission for removing assets (for example, workflows and insights) from the collection.

  • Users_CanAdd: (bit) Permission to add users to the collection.

  • Users_CanRemove: (bit) Permission for removing users from the collection.

SubscriptionCollectionShares

  • Id: (nvarchar) The identifier of the record.

  • CollectionId: (nvarchar) Relational foreign-key to a Collection record.

  • SubscriptionId: (nvarchar) Non-foreign-key to a Subscription record.

  • DateAdded: (datetime) Date and time the share was created.

  • AddedById: (nvarchar) User record identifier of who added the subscription to the collection.

  • ExpirationDate: (datetime) Date and time the share should expire. Null if no expiry.

SubscriptionCredentials

  • Id: (nvarchar) The identifier of the record.

  • SubscriptionId: (nvarchar) User's subscription ID.

  • CredentialId: (nvarchar) Default workflow credential ID for the subscription.

SubscriptionDataConnections

  • Id: (nvarchar) The identifier of the record.

  • SubscriptionId: (nvarchar) User's subscription ID.

  • DataConnectionId: (nvarchar) Document primary key.

Subscriptions

  • Id: (nvarchar) The identifier of the record.

  • Name: (nvarchar) Studio display name.

  • ApiKey: (nvarchar) Subscription API key.

  • ApiSecret: (nvarchar) Encrypted/hashed API secret for the subscription/studio.

  • Active: (bit) Flag for whether subscription is active.

  • ExpDate: (datetime) Date and time (UTC) subscription expires.

  • DateUpdated: (datetime) Date and time (UTC) subscription was last updated.

  • ApiEnabled: (bit) Flag to enable Server API access for the subscription.

  • CanShareSchedules: (bit) Flag to enable scheduling for the subscription.

  • CredentialId: (nvarchar) Default workflow credential ID for the subscription.

SubscriptionSearchDatas

  • Id: (nvarchar) The identifier of the record.

  • Name: (nvarchar) Studio display name.

SystemMessageNotifications

  • Id: (nvarchar) The identifier of the record.

  • Message: (nvarchar) The message displayed for the notification.

  • CreatedDate: (datetime) Date and time the notification was created.

  • Category: (nvarchar) The category of the notification.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

Tags

  • Id: (nvarchar) The identifier of the record.

  • Name: (nvarchar) Tag display name.

  • Description: (nvarchar) Tag description.

  • AdminOnly: (bit) Tag is enabled for Curators only.

TagSearchDatas

  • Id: (nvarchar) The identifier of the record.

  • Name: (nvarchar) Tag display name.

  • AdminOnly: (bit) Tag is enabled for Curators only.

TemporaryTokens

  • Id: (nvarchar) The identifier of the record.

  • Token: (nvarchar) Token string.

  • UserId: (nvarchar) User ID.

  • Expiration: (datetime) Date and time (UTC) token expires.

  • SessionId: (nvarchar) Session ID.

UsageReports

  • Id: (nvarchar) The identifier of the record.

  • Type: (int) Integer value representing the type of usage data captured. Possible values are 10=AppExecution, 11=SignupDisplayed, 12=GlobalSearch, 13=LicenseTransfer, 14=Shepherding, GlobalSettings=15, 400=Profiling, 401=DataProfiling, 1000-1999=Exceptions.

  • SerialNumber: (nvarchar) Serial number (typically an email address) associated with the active license.

  • DeviceId: (nvarchar) ID of device reporting the data. The ID is a combination of the device GUID, machine name, and serial number.

  • SeatGuid: (nvarchar) Seat ID.

  • Guid: (nvarchar) Unique Guid.

  • IpAddress: (nvarchar) IP address for machine reporting usage data.

  • DateTime: (datetime) Date and time (UTC) the data was reported by the client.

  • ServerDateTime: (datetime) Date and time (UTC) on the Server when the data was received.

  • Version: (nvarchar) Version of Designer.

  • Preview: (bit) Flag for whether the build is Beta.

  • Cores: (int) Number of cores detected by Designer.

  • IsTrial: (bit) Flag for a trial license.

  • Data: (nvarchar) Usage data in JSON format.

  • UserId: (nvarchar) User ID.

Usages

  • Id: (nvarchar) The identifier of the record.

  • Type: (int) Integer value representing the type of usage data captured. Possible values are 10=AppExecution, 11=SignupDisplayed, 12=GlobalSearch, 13=LicenseTransfer, 14=Shepherding, GlobalSettings=15, 400=Profiling, 401=DataProfiling, 1000-1999=Exceptions.

  • Content: (nvarchar)

UserCollectionShareActiveDirectoryObjects

  • UserCollectionShareId: (nvarchar) User's or Group's Active Directory security ID.

  • UserCollectionShareCollectionId: (nvarchar) Relational partial foreign-key to a UserCollectionShare record.

  • Sid: (nvarchar) User's or Group's Active Directory security ID.

  • Category: (int) Identifies if an Active Directory object is a user or a group (0 = User, 1 = Group).

  • DisplayName: (nvarchar) User's Active Directory Display Name in 'firstName lastName' format.

  • DomainName: (nvarchar) User's network name in 'domain\username' format.

  • SamAccountName: (nvarchar) User's Active Directory Sam (username).

UserCollectionSharePermissions

  • UserCollectionShareId: (nvarchar) Relational partial foreign-key to a UserCollectionShare record.

  • UserCollectionShareCollectionId: (nvarchar) Relational partial foreign-key to a UserCollectionShare record.

  • Collection_IsAdmin: (bit) Flag for collection admin permissions. Users with this permission have all asset and user-management permissions.

  • Assets_CanUpdate: (bit) Permission for updating assets (for example, workflows and insights) in the collection.

  • Assets_CanAdd: (bit) Permission for adding assets (for example, workflows and insights) to the collection.

  • Assets_CanRemove (bit) Permission for removing assets (for example, workflows and insights) from the collection.

  • Users_CanAdd: (bit) Permission to add users to the collection.

  • Users_CanRemove: (bit) Permission for removing users from the collection.

UserCollectionShares

  • Id: (nvarchar) The identifier of the record.

  • CollectionId: (nvarchar) Relational foreign-key to a Collection record.

  • UserId: (nvarchar) Relational non-foreign-key to a User record.

  • DateAdded: (datetime) Date and time (UTC) user was added.

  • AddedById: (nvarchar) User Id of the user who added the user.

  • ExpirationDate: (datetime) User's expiration date-time (UTC).

UserCredentials

  • Id: (nvarchar) The identifier of the record.

  • UserId: (nvarchar) The User record identifier.

  • CredentialId: (nvarchar) The Credential record identifier.

UserDataConnections

  • Id: (nvarchar) The identifier of the record.

  • UserId: (nvarchar) Relational foreign-key to a User record.

  • DataConnectionId: (nvarchar) Non-foreign-key to a DataConnection record.

UserGroupActiveDirectoryObjects

  • UserGroupMemberId: (nvarchar) Relational partial foreign-key to a UserGroupMember record.

  • UserGroupMemberUserGroupId: (nvarchar) Relational partial foreign-key to a UserGroupMember record.

  • Sid: (nvarchar) User's or Group's Active Directory security ID.

  • Category: (int) Identifies if an Active Directory object is a user or a group (0 = User, 1 = Group).

  • DisplayName: (nvarchar) User's Active Directory Display Name in 'firstName lastName' format.

  • DomainName: (nvarchar) User's network name in 'domain\username' format.

  • SamAccountName: (nvarchar) User's Active Directory Sam (username).

UserGroupCollectionSharePermissions

  • UserGroupCollectionShareId: (nvarchar) Relational partial foreign-key to a UserGroupCollectionShare record.

  • UserGroupCollectionShareCollectionId: (nvarchar) Relational partial foreign-key to a UserGroupCollectionShare record.

  • Collection_IsAdmin: (bit) Flag for collection admin permissions. Users with this permission have all asset and user-management permissions.

  • Assets_CanUpdate: (bit) Permission for updating assets (for example, workflows and insights) in the collection.

  • Assets_CanAdd: (bit) Permission for adding assets (for example, workflows and insights) to the collection.

  • Assets_CanRemove: (bit) Permission for removing assets (for example, workflows and insights) from the collection.

  • Users_CanAdd: (bit) Permission to add users to the collection.

  • Users_CanRemove: (bit) Permission for removing users from the collection.

UserGroupCollectionShares

  • Id: (nvarchar) The identifier of the record.

  • CollectionId: (nvarchar) Relational foreign-key to a Collection record.

  • UserGroupId: (nvarchar) Non-foreign-key to a UserGroup record.

  • DateAdded: (datetime) Date and time created.

  • AddedById: (nvarchar) User identifier that added the user group to the collection.

  • ExpirationDate: (datetime) Date and time the share expires; null if no expiry.

UserGroupCredentials

  • Id: (nvarchar) The identifier of the record.

  • UserGroupId: (nvarchar) Relational foreign-key to a UserGroup record.

  • CredentialId: (nvarchar) Non-foreign-key to a Credential record.

UserGroupDataConnections

  • Id: (nvarchar) The identifier of the record.

  • UserGroupId: (nvarchar) Relational foreign-key to a UserGroup record.

  • DataConnectionId: (nvarchar) Non-foreign-key to a DataConnection record.

UserGroupMembers

  • Id: (nvarchar) The identifier of the record.

  • UserGroupId: (nvarchar) Relational foreign-key to a User Group record.

  • UserId: (nvarchar) Unique ID of the user added to the group (NULL if member is an Active Directory user or Active Directory Group).

  • DateAdded: (datetime) Date and time the user was added.

  • AddedById: (nvarchar) Unique ID of the admin that added the user to the group.

UserGroups

  • Id: (nvarchar) The identifier of the record.

  • Name: (nvarchar) Name of the group.

  • Role: (nvarchar) String value for the role assigned to the group.

  • DateAdded: (datetime) Date and time the group was created.

  • ServerRole: (int) The Alteryx Server Role assigned to the user group.

UserIcons

  • Id: (nvarchar) The identifier of the record.

  • UserId: (nvarchar) The non-foreign-key identifier of a User record.

  • FileName: (nvarchar) The file name of the icon.

  • MimeType: (nvarchar) The MIME type of the icon file.

  • LargeIcon: (nvarchar) Base64 encoded string of the large image.

  • UploadDate: (datetime) Date and time the icon was uploaded.

  • SmallIcon: (nvarchar) Base64 encoded string of the small image.

UserNotificationGroups

  • Id: (nvarchar) The identifier of the record.

  • UserId: (nvarchar) Relational foreign-key to a User record.

  • NotificationGroupId: (nvarchar) Non-foreign-key to a NotificationGroup record.

UserProfiles

  • Id: (nvarchar) The identifier of the record.

  • Picture: (varbinary) User's profile picture.

  • IconId: (nvarchar) ID of the user's profile picture.

Users

  • Id: (nvarchar) The identifier of the record.

  • Role: (nvarchar) The user's assigned role.

  • Email: (nvarchar) The user's email address.

  • FirstName: (nvarchar) The user's first name.

  • LastName: (nvarchar) The user's last name.

  • DateAdded: (datetime) Date and time (UTC) the user was created.

  • DateUpdated: (datetime) Date and time (UTC) the user was last updated.

  • Validated: (bit) The user's email address has been validated.

  • Pending: (bit) The user's email address is pending validation.

  • Active: (bit) The user's email address is active.

  • ApiEnabled: (bit) Enables access to the Server API.

  • ApiKey: (nvarchar) User's API key. Used to access both the admin and user API. Admin access requires the user to be a Curator.

  • ApiSecret: (nvarchar) Encrypted API secret. Used to access both the admin and user API. Admin access requires the user to be a Curator. (Change: Schema and values haven't changed just the usage and description.)

  • NumFailedLogins: (int) Count of failed login attempts.

  • AccountLocked: (bit) Flag for locked account.

  • AccountLockedAt: (datetime) Date and time (UTC) account was locked.

  • SubscriptionId: (nvarchar) User's subscription ID.

  • ExpDate: (datetime) Date and time (UTC) the user's account expires (only applies to the Alteryx Public Gallery at Community Gallery).

  • LastLoginDate: (datetime) Date and time (UTC) of the user's last login.

  • IsPasswordMigrated (bit) Whether the User’s password is migrated to latest encryption.

  • CanSchedule: (bit) User permission flag for scheduling workflows.

  • CanSetPriority: (bit) User permission flag for setting workflow priority.

  • CanSetWorkerTag: (bit) User permission flag for setting a worker tag.

  • Timezone: (nvarchar) User's selected time zone.

  • CanCreateCollections: (bit) User permission flag for creating collections.

  • IsDeleted: (bit) Flag to indicate if the user record has been deleted.

  • DeletedById: (nvarchar) ID of the user that deleted the user record.

  • DeletedDateTime: (datetime) Date-time the user was deleted.

  • DefaultWorkerTag: (nvarchar) User's default worker tag.

  • Language: (nvarchar) User's preferred language/locale.

  • CanCreateAndUpdateDcm (bit) User permission flag for creating and updating DCM objects.

  • CanShareForCollaborationDcm (bit) User permission flag for sharing DCM connections for collaboration.

  • CanShareForExecutionDcm (bit) User permission flag for sharing DCM connections for execution.

  • CanManageGenericVaultsDcm (bit) User permission flag for managing generic external vaults in DCM.

UserSearchDatas

  • Id: (nvarchar) The identifier of the record.

  • Email: (nvarchar) The email of the subject User record.

  • Name: (nvarchar) The name of the subject User record.

  • DateAdded: (datetime) The date and time the subject User record was created.

  • Role: (nvarchar) The Server Role of the subject User record.

  • Active: (bit) Whether the subject User record is marked as Active.

UserWindowsIdentities

  • Id: (nvarchar) The identifier of the record.

  • Sid: (nvarchar) Group SID (security identifier).

  • DisplayName: (nvarchar) Group display name.

  • Name: (nvarchar) Group name in domain/group format.

  • SamAccountName: (nvarchar) Sam account name.

UserWorkflowTransferredAwayNotifications

  • Id: (nvarchar) The identifier of the record.

  • Message: (nvarchar) The message displayed for the notification.

  • CreatedDate: (datetime) Date and time the notification was created.

  • Category: (nvarchar) The category of the notification.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

UserWorkflowTransferredNotifications

  • Id: (nvarchar) The identifier of the record.

  • Message: (nvarchar) The message displayed for the notification.

  • CreatedDate: (datetime) Date and time the notification was created.

  • Category: (nvarchar) The category of the notification.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

ValidationCompleteNotifications

  • Id: (nvarchar) The identifier of the record.

  • Message: (nvarchar) The message displayed for the notification.

  • CreatedDate: (datetime) Date and time the notification was created.

  • Category: (nvarchar) The category of the notification.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

ValidationKeys

  • Id: (nvarchar) The identifier of the record.

  • UserId: (nvarchar) User ID.

WelcomeUserNotifications

  • Id: (nvarchar) The identifier of the record.

  • Message: (nvarchar) The message displayed for the notification.

  • CreatedDate: (datetime) Date and time the notification was created.

  • Category: (nvarchar) The category of the notification.

  • Enabled: (bit) Whether the notification is enabled or disabled.

  • IsUnread: (bit) Whether the notification is unread or read.

  • NotificationListId: (nvarchar) Relationship foreign key to a NotificationList record.

In diesem Abschnitt: