This script will rename manual aliases Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx
Category: MSSQL – Ektron
This area of the site is dedicated to Ektron CMS specific MS SQL queries and procedures.
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.
Ektron Metrics Script
This is a compilation of some of the scripts on this site to get numbers to report to management
Ektron Content Status Codes
This is a list of code definitions for the content_status column in the content table Letter Meaning Content state More Information A Approved Through the workflow and published on the Web site. Approved Content O Checked Out Currently being edited. Has not been checked in. Checked Out Content I Checked…
Subscribed Web Alert
Will return you all the web alerts. The ID column represent the ID for the web alert Will return you the folder(s) where the web alert is assigned The column Value_number represents the ID column from subscriptions_tbl The column Object_ID represents the folder ID where the web alert is assigned…