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
Category: SQL
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.
File Extension
If you are working in a database that has asset/file storage and need to get just the extension of the column this query will help save time.