This script will display the current Ektron version. Works In: 8.0.2, 8.5, and 8.7 Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx
Category: MSSQL
Ektron Rename Templates
This script will rename template paths Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx
Ektron Find Replace Library Folder Names
This script will rename folder paths of renamed CMS folders. Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx
Ektron Find Replace In UrlAliasManual
This script will rename manual aliases Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx
Ektron Find Replace In Menu
This script will rename menu link paths Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx
Ektron Find Replace In Sitemap
This script will search and replace sitemap links/titles/etc Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx
Ektron Find Replace In Library
This script will search and replace specific library links Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx
Ektron Find Replace In Content Html
This script will search and replace specific content/phrases through the entire content table. This script can be modified to handle different scenarios as well. Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx
Ektron File Extension Asset Inventory
Following the logic in a previous post, File Extension, this query will list Ektron asset file extensions and count them.