Update Ektron License

Posted on By David Kittell

After applying this update you will need to restart the services and in some case restart the server completely.

SELECT lic_key
FROM Settings

SELECT module_license
FROM module_licenses

UPDATE Settings
SET lic_key = '<License>'

UPDATE module_licenses
SET module_license = '<License>'
Originally Posted on July 19, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code Ektron MSSQL MSSQL - Ektron MSSQL - Ektron 8.0.2 SQL

Related Posts

Remove Last N Characters From Column

Posted on

Recently in a project to list all the plugins in a WordPress site with their versions I had accidently added .0 on to various rows in error. This script was very helpful to correct this error SELECT [id], [siteid], [pluginid], [versioninstalled], LEFT([versioninstalled], LEN([versioninstalled]) – 2), [Activated] FROM [Documentation].[dbo].[tblWP_SiteToPlugin] WHERE RIGHT([versioninstalled],…

Read More

Swift – iOS – Get Device Identity

Posted on

This code will help you determine what phone or device is using your app. In your ViewController put this under your imports public extension UIDevice { var modelName: String { var systemInfo = utsname() uname(&systemInfo) let machineMirror = Mirror(reflecting: systemInfo.machine) let identifier = machineMirror.children.reduce("") { identifier, element in guard let…

Read More

Azure CLI – List All VMs with Details

Posted on

az vm list –show-details –query ‘[].{VMName:name, OSType:storageProfile.osDisk.osType,VMSize:hardwareProfile.vmSize, Location: location,ResourceGroup:resourceGroup,PowerState:powerState, privateIPs: privateIps}’ -o table All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is…

Read More