Ektron Current Version

Posted on By David Kittell

This script will display the current Ektron version.

Works In: 8.0.2, 8.5, and 8.7

SELECT convert(VARCHAR, version) AS "Current Ektron Version"
FROM settings

Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx

Originally Posted on October 23, 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

Android Contacts – Update Company Name

Posted on

UPDATE data SET data1 = "<Company Name>" WHERE mimetype_id IN ( SELECT _id FROM mimetypes WHERE mimetype LIKE "%organization%" ) AND data1 LIKE "%<Company Name>%"; UPDATE data SET data1 = "<Company Name>" WHERE mimetype_id IN ( SELECT _id FROM mimetypes WHERE mimetype LIKE "%organization%" ) AND raw_contact_id IN ( SELECT…

Read More

NPI Database

Posted on

If you work in medical databases you are likely familiar with the site CMS NPI Search I have had a few projects that need the ability to validate NPI numbers so based on data at CMS.gov I have worked out a solution to get the data into a database that…

Read More

UNIX – Create Sudoers Access

Posted on

# Variables – Start username="dkittell" # Variables – Stop su # type in sudo password chmod -v +w /etc/sudoers && echo -e "$username ALL=(ALL) ALL" >> /etc/sudoers && chmod -v -w /etc/sudoers # Variables – Start username="dkittell" # Variables – Stop su # type in sudo password # Remove Sudoers…

Read More