Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Apply license for database users
#1
Hello,

We are deploying ASG RD to our users with SCCM/ConfigMgr (we have a country license with an active maintenance). For new installations, the license is applied by adding license information to the registry (HKLM). This works flawless, but not for updates and “database users”.

The license registry import (REG ADD) works for users that stores connections into a file, but not for users that uses a database.

I have used Active Setup before for this issue, applying the license in the user-profile (AppData). However, that did not worked all the time.

Also tried the new “/importlicense” parameter, but that needs a common database if I am correct? We do not have one database for all. Each user has its own personal database.

The help-documentation says that the license can be imported in the database. How does that work exactly?

Thanks for the support.
Reply
#2
Hi,

you can read it from database where you already have imported your license in "serialized data" and UPDATE / INSERT it to another database - the database scheme of the version should be the same (so any version that requires an update of the database you should also update your SQL Commands)


Code:
SELECT Data FROM ItemProperties WHERE RolePropertyId = '1E6F572A-EAB2-446D-826A-A55B4CE92963' and ItemId = '1BF121C1-EFC4-4851-9407-D652D3B7C5BF'

UPDATE ItemProperties
SET Data = '***' WHERE RolePropertyId = '1E6F572A-EAB2-446D-826A-A55B4CE92963' and ItemId = '1BF121C1-EFC4-4851-9407-D652D3B7C5BF'

INSERT INTO ItemProperties
( ItemId, UserId, RolePropertyId, Data)
VALUES
( '1BF121C1-EFC4-4851-9407-D652D3B7C5BF', '00000000-0000-0000-0000-000000000000', '1E6F572A-EAB2-446D-826A-A55B4CE92963', '***')


Hope that helps :-)
Regards/Gruss
Oliver
Reply
#3
OK, that was what we needed!

A user imports the license manually using the GUI, and the DB Admin copies that license to other users' datebases with some SQL-magic.

Thanks for the prompt response.
Reply




Users browsing this thread: 1 Guest(s)