Adobe Creative Cloud data tables
This section lists all relational and event-sourced data tables in the Adobe Creative Cloud data model and the schema changes introduced in different versions.
Schema changes
The table shows the schema changes in Snow License Manager version 9.8.1 as compared to version 9.8.0.
| Schema | Changes |
|---|---|
| adobecc.Portal | Added in version 9.8.1 |
| adobecc.SubscriptionPlan | Added in version 9.8.1 |
| adobecc.User | Added in version 9.8.1 |
| adobecc. MigrationProgress | Added in version 9.8.1 |
| adobecc.Projections | Removed in version 9.8.1 |
| adobecc.ProjectionsTracking | Removed in version 9.8.1 |
Temporary tables
These tables are used temporarily during the migration between Snow License Manager 9.20 and 9.21:
- adocecc.MigrationHistoricalProgress
- adocecc.MigrationHistoricalSubscriptionPlan
- adocecc.MigrationHistoricalSubscriptionPlanPrice
adobecc.MigrationProgress
The table adobecc.MigrationProgress contains the information related to the event migration from EventStore database to MSSQL database.
The migration takes place on Snow License Manager 9.8.1 from EventStore db to SnowLicenseManager's ew schema: TenantSource and Event tables.
| Column name | Description |
|---|---|
| Data | Not completed migration data. If the Adobe CC service shuts down during migration, the process will start from where it stopped, in the next run. |
| SequenceNumber | The sequence number of the latest migrated event. The sequence number is -1 if there is no event to migrate. |
| IsCompleted | The status of the migration. |
| Saved | The date when the migration was completed, and all events were successfully saved to ew.Event table. |
adobecc.Import
The table adobecc.Import contains queued aggregations from Adobe Creative Cloud Integration Connector.
| Column name | Description |
|---|---|
| TenantID | The identity of the tenant. |
| ImportID | The identity of the import. |
| AddedDate | The saved date of the aggregation. |
| JsonPayload | Json payload. Portal, Subscription plans, and portal users data. |
adobecc.Portal
The table adobecc.Portal contains all Adobe Creative Cloud portals of the tenant.
| Column name | Description |
|---|---|
| TenantId | The identity of the tenant. |
| PortalId | The identity of the portal. |
| InstanceName | The account instance name of the portal. |
| LastImportDate | Last aggregation date. |
adobecc.SubscriptionPlan
The table adobecc.SubscriptionPlan contains the portal subscription plans of the tenant.
| Column name | Description |
|---|---|
| TenantId | The identity of the tenant. |
| PortalId | The identity of the portal. |
| SubscriptionPlanId | The subscription plan's unique id. |
| SubscriptionPlanSKU | The name of the subscription plan (AccountSKU, unique). |
| FriendlyName | The friendly name of the subscription plan. |
| UserCount | The subscription plan's user count (sum of all PRODUCT_PROFILE groups' user count data of the subscription plan). |
| LicenseQuota | The subscription plan’s license quota (sum of all PRODUCT_PROFILE groups' license quota data of the subscription plan). Note: LicenseQuota sets to UserCount if the subscription plan has UNLIMITED license quota. |
| PriceChanges | The price change of the subscription plan. The column contains historical data. |
| Services | The services list of the subscription plan. |
| Profiles | The list of PRODUCT_PROFILE groups of the subscription plan. |
| IsPaid | Identifies if the subscription plan is free of charge or not. |
adobecc.User
The table adobecc.User contains the portal users of the tenant.
| Column name | Description |
|---|---|
| TenantId | The identity of the tenant. |
| PortalId | The identity of the portal. |
| Email* | The user's Adobe Email address. |
| Username* | The user's Adobe username. |
| AdobeId* | The user's Adobe Id. |
| AdobeUserGroups* | The user's all Adobe groups. (Comma separated) |
| FirstName* | The user's first name. |
| LastName* | The user’s last name. |
| SlmIds | The user’s Snow License Manager Ids. (Comma separated) |
| SubscriptionPlans | The user's subscription plan licenses. (Comma separated) |
| Activities | The user’s activities. (Json array) |
| Country* | The user’s country. |
| Domain* | The user’s domain. |
| Status* | The user’s status. |
| Type* | The user's type. |
adobecc.Insights
The table adobecc.Insights contains the generated insights by the Adobe CC service for the tenant portal.
| Column name | Description |
|---|---|
| TenantId | The identity of the tenant. |
| PortalId | The identity of the portal. |
| Type | The insight's type. Adobe CC service has the following Insight types shown in the user interface:
|
| NumericValue | The insight's numeric value. Example: UnusedLicenses insight: NumericValue column shows total number of unused licenses. |
| CostValue | The insight's cost value. Example: UnusedLicenses insight: CostValue column shows total cost of unused licenses. This column will be NULL if the type of insight does not represent a cost value. For instance, UnlinkedUsers insight has no connection with cost. |
| Currency | The insight's cost currency (EUR, USD, SEK etc.). |
| OptionalData | The insight’s optional data information might be used in Adobe CC user interface. Example: PlanWithoutService insight's optional data: {"Plans": ["Illustrator CC", "Creative Cloud All Apps"],"TotalLicenses":5} |
adobecc.ReadModelOverview
The table adobecc.ReadModelOverview contains the overview of each subscription plan. This table keeps only the recent information aggregated by Adobe CC Integration connector.
| Column name | Description |
|---|---|
| TenantId | The identity of the tenant. |
| PortalId | The identity of the portal. |
| SubscriptionPlanName | The name of the subscription plan (AccountSKU, unique). |
| TotalLicenses | The subscription plan's number of total licenses. |
| UsedLicenses | The subscription plan's total number of used licenses. |
| UnassignedLicenses | The subscription plan's total number of unassigned licenses. |
| AssignedLicenses | The subscription plan's total number of assigned licenses. |
| UnusedLicenses | The subscription plan's total number of unused licenses. |
| UnlinkedUsers | The subscription plan's total number of unlinked users. |
| TotalLicensesCost | The subscription plan's cost of total licenses. |
| UsedLicensesCost | The subscription plan's cost of used licenses. |
| UnassignedLicensesCost | The subscription plan's cost of unassigned licenses. |
| UnusedLicensesCost | The subscription plan's cost of unused licenses. |
| UnlinkedUsersCost | The subscription plan's cost of unlinked users. |
| AssignedLicensesCost | The subscription plan's cost of assigned licenses. |
| HasServices | Identifies if the subscription plan has any services or not. Note: Run SRS sync if there are any plans without services. |
| TotalUsers | The number of total users per subscription plan. Added in Snow License Manager 9.21.0. |
adobecc.ReadModelOverviewSummary
The table adobecc.ReadModelOverviewSummary contains the overview summary of each tenant portal. This table keeps only the recent information aggregated by the Adobe CC Integration connector.
| Column name | Description |
|---|---|
| TenantId | The identity of the tenant. |
| PortalId | The identity of the portal. |
| TotalLicenses | The subscription plan's number of total licenses. |
| UsedLicenses | The subscription plan's total number of used licenses. |
| UnlinkedUsers | The subscription plan's total number of unlinked users. |
| UnusedLicenses | The subscription plan's total number of unused licenses. |
| UnassignedLicenses | The subscription plan's total number of unassigned licenses. |
| TotalUsers | The subscription plan’s number of total users. |
| TotalLicensesCost | The subscription plan's cost of total licenses. |
| UsedLicensesCost | The subscription plan's cost of used licenses. |
| UnassignedLicensesCost | The subscription plan's cost of unassigned licenses. |
| UnusedLicensesCost | The subscription plan's cost of unused licenses. |
| UnlinkedUsersCost | The subscription plan's cost of unlinked users. |
| Updated | The updated date of the read model (is updated a couple of seconds or minutes after the import date). |
adobecc.ReadModelCost
The table adobecc.ReadModelCost contains the current price information of each subscription plan.
| Column name | Description |
|---|---|
| TenantId | The identity of the tenant. |
| PortalId | The identity of the portal. |
| SubscriptionPlanName | The name of the subscription plan (AccountSKU, unique). |
| ValidFrom | The date from when the price change is valid from. |
| Currency | Currency of the price information. Note: Adobe CC does not support multiple currencies. |
| Price | The subscription plan's total number of unused licenses. |
adobecc.ReadModelManagedUsers
The table adobecc.ReadModelManagedUsers contains the managed portal users per subscription plan and service.
| Column name | Description |
|---|---|
| TenantId | The identity of the tenant. |
| PortalId | The identity of the portal. |
| AdobeUserEmail | The user's Adobe Email address. |
| SubscriptionPlanName | The name of the subscription plan (AccountSKU, unique). |
| ServiceId | The unique Id of the subscription plan's service. |
adobecc.ReportAllAdobeCcUsers
The table adobecc.ReportAllAdobeCcUsers contains all of the Adobe CC portal users and their assigned licenses for tenant.
| Column name | Description |
|---|---|
| TenantId | The identity of the tenant. |
| PortalId | The identity of the portal. |
| AdobeUserEmail | The user's Adobe Email address. |
| FirstName | The user's first name. |
| LastName | The user's last name. |
| AssignedLicenses | The user's subscription plan licenses. (Comma separated) |
| UsedProducts | The products which has been used by the user. (Comma separated) |
| AdobeUserGroups | The user's Adobe user groups. (Comma separated) |
| Country | The user's country. |
| LastActivityStatus | The user's last activity. Added in Snow License Manager 9.22.0. |
adobecc.ReportAllAppsUsersWithLowUsage
The table adobecc.ReportAllAppsUsersWithLowUsage contains all the users assigned to the All Apps plan, but that have low usage.
| Column name | Description |
|---|---|
| TenantId | The identity of the tenant. |
| PortalId | The identity of the portal. |
| AdobeUserEmail | The user's Adobe Email address. |
| FirstName | The user's first name. |
| LastName | The user's last name. |
| UsedProducts | The products which has been using by the user. (Comma separated) |
| AdobeUserGroups | The user's Adobe user groups. (Comma separated) |
| Country | The user's country. |
| SingleLicensesCost | The cost of single application licenses (if available). |
| PotentialSave | The total amount of potential saving, if the user's plan would be changed from an All Apps plan to a Single App plan. |
adobecc.ReportUnlinkedUsers
The table adobecc.ReportUnlinkedUsers contains all the portal users who are not linked to a Snow License Manager User.
| Column name | Description |
|---|---|
| TenantId | The identity of the tenant. |
| PortalId | The identity of the portal. |
| AdobeUserEmail | The user's Adobe Email address. |
| FirstName | The user's first name. |
| LastName | The user's last name. |
| AssignedLicenses | The user's subscription plan licenses. (Comma separated) |
adobecc.ReportUnusedLicenses
The table adobecc.ReportUnusedLicenses contains all licenses assigned to a user that have not been used for at least last 90 days.
| Column name | Description |
|---|---|
| TenantId | The identity of the tenant. |
| PortalId | The identity of the portal. |
| SubscriptionPlanName | The subscription plan’s name (AccountSKU). |
| AdobeUserEmail | The user’s Adobe Email address. |
| FirstName | The user's first name. |
| LastName | The user's last name. |
| AdobeUserGroups | The user's Adobe user groups. (Comma separated) |
| Country | The user's country. |
| LastUsed | The user’s last used date for the Adobe CC subscription plan. |
| LicenseCost | The price for the subscription plan. |
| Currency | Currency of the price information. Note: Adobe CC does not support multiple currencies. |
adobecc.MigrationHistoricalProgress
The table adobecc.MigrationHistoricalProgress contains the information related to the activity migration from EventWarehouse.
This table was added in Snow License Manager 9.21.0.
| Column name | Description |
|---|---|
| TenantId | The identity of the tenant. |
| Year | The year of the data period. |
| Month | The month of the data period. |
| SequenceNumber | The number of the last processed sequence number. |
| IsCompleted | The status of the import process. |
| Saved | The status time stamp. |
adobecc.ReadModelMonthlyOverviewBreakdown
The table adobecc.ReadModelMonthlyOverviewBreakdown contains the overview of each subscription plan per month. The table contains historical data.
This table was added in Snow License Manager 9.21.0.
| Column name | Description |
|---|---|
| TenantId | The identity of the tenant. |
| PortalId | The identity of the portal. |
| SubscriptionPlanName | The name of the subscription plan (AccountSKU, unique). |
| Year | The year of the breakdown. |
| Month | The month of the breakdown. |
| TotalLicenses | The subscription plan's number of total licenses. |
| UsedLicenses | The subscription plan's total number of used licenses. |
| UnassignedLicenses | The subscription plan's total number of unassigned licenses. |
| AssignedLicenses | The subscription plan's total number of assigned licenses. |
| UnusedLicenses | The subscription plan's total number of unused licenses. |
| UnlinkedUsers | The subscription plan's total number of unlinked users. |
| TotalLicensesCost | The subscription plan's cost of total licenses. |
| UsedLicensesCost | The subscription plan's cost of used licenses. |
| UnassignedLicensesCost | The subscription plan's cost of unassigned licenses. |
| UnusedLicensesCost | The subscription plan's cost of unused licenses. |
| UnlinkedUsersCost | The subscription plan's cost of unlinked users. |
| AssignedLicensesCost | The subscription plan's cost of assigned licenses. |
| TotalUsers | The number of total users per subscription plan. |
| HasServices | Identifies if the subscription plan has any services or not. |