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

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 currently has 5 different Insight types shown in the user interface:

  • PlanWithoutService

  • SingleLicenseSuggestion

  • UnlinkedUsers

  • UnmanagedUsers

  • UnusedLicenses

NumericValue

The insight's numeric value.

Example 20.

UnusedLicenses insight: NumericValue column shows total number of unused licenses.



CostValue

The insight's cost value.

Example 21.

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 22.

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.

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 for the price.

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.

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 for the price.

Note

Adobe CC does not support multiple currencies.