How could I find out edition of the current Creatio product by interface?

11:19 Jan 28, 2020

Hi community,

We got Sales Creatio licence,

however when I'm asked what edition we use, I'm not sure what to choose.

I may be asked by interface either of documentation or forum:

Is there a way of finding it out by interface, not contacting manager or teammates?

For a user with admin rights.

Thanks in advance.

________

If there a need to tell that searched for the answer on the community forum an in docs, I could tell I spent a considerable time on it; googling also. Searched by keywords "get edition", "find out edition", etc.

4 comments

Best reply

Angela Reyes

16:16 Jan 28, 2020

Hi! Please use following sql query to determine version of your application:

DECLARE @ConfigurationVersion nvarchar(250)

DECLARE @PrimaryCulture nvarchar(250)

DECLARE @Product nvarchar(250)

DECLARE @SysAdminUnit_AllUsers uniqueidentifier = 'A29A3BA5-4B0D-DE11-9A51-005056C00008'

BEGIN

SELECT @ConfigurationVersion = TextValue

FROM SysSettingsValue ssv

INNER JOIN SysSettings ss on ss.Id = ssv.SysSettingsId

WHERE ss.Code = 'ConfigurationVersion'

AND SysAdminUnitId = @SysAdminUnit_AllUsers

SELECT @PrimaryCulture = c.Name

FROM SysSettingsValue ssv

INNER JOIN SysSettings ss on ss.Id = ssv.SysSettingsId

INNER JOIN SysCulture c on c.Id = ssv.GuidValue

WHERE ss.Code = 'PrimaryCulture'

AND SysAdminUnitId = @SysAdminUnit_AllUsers

SELECT @Product =

CASE

WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankOnboardingSoftkey%')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankSalesSoftkey%')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'Lending%')

   THEN 'bpmonline bank sales & bank customer journey & lending & marketing'

WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankOnboardingSoftkey%')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankSalesSoftkey%')

   THEN 'bpmonline bank sales & bank customer journey'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesEnterprise')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'ServiceEnterpriseSoftkey')

   THEN 'bpmonline sales enterprise & marketing & service enterprise'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesEnterprise')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'CustomerCenterSoftkey')

   THEN 'bpmonline sales enterprise & marketing & customer center'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesCommerce')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'CustomerCenterSoftkey')

   THEN 'bpmonline sales commerce & marketing & customer center'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesTeam')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'CustomerCenterSoftkey')

   THEN 'bpmonline sales team & marketing & customer center'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'MarketingSoftkey%')

       AND EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesTeam')

   THEN 'bpmonline sales team & marketing'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesTeam')

   THEN 'bpmonline sales team'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesCommerce')

   THEN 'bpmonline sales commerce'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name = 'SalesEnterprise')

   THEN 'bpmonline sales enterprise'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name Like 'MarketingSoftkey%')

   THEN 'bpmonline marketing'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name = 'CustomerCenterSoftkey')

   THEN 'bpmonline customer center'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name = 'ServiceEnterpriseSoftkey')

   THEN 'bpmonline service enterprise'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'Studio%')

   THEN 'bpmonline studio'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'Lending%')

   THEN 'bpmonline lending'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankSalesSoftkey%')

   THEN 'bpmonline bank sales'

   WHEN

       EXISTS(SELECT Id FROM SysPackage WHERE Name LIKE 'BankOnboardingSoftkey%')

   THEN 'bpmonline bank customer journey'

   ELSE '?' END

SELECT @Product, @ConfigurationVersion, @PrimaryCulture

END

Angela Reyes

16:16 Jan 28, 2020

Hi! Please use following sql query to determine version of your application:

DECLARE @ConfigurationVersion nvarchar(250)

DECLARE @PrimaryCulture nvarchar(250)

DECLARE @Product nvarchar(250)

DECLARE @SysAdminUnit_AllUsers uniqueidentifier = 'A29A3BA5-4B0D-DE11-9A51-005056C00008'

SELECT @Product, @ConfigurationVersion, @PrimaryCulture

END

Mary P D'Arrigo

16:13 Nov 30, 2021

I know this post is almost 2 years old, but it seems like this information should be readily available from the UI on the Help menu

Oliver Crowe

11:32 Mar 20, 2023

Angela Reyes,

This seems like an overly complicated solution, this SQL query also doesnt run for me?

Frances Carrera

22:21 Apr 04, 2023

It should be available on the settings somewhere, but for now, simplest way I've found is to log out. Version is visible on the login screen, underneath where you enter credentials

Show all comments