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
Last Updated on October 26, 2015