MSSQL – Ektron

This script will rename manual aliases Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx

This script will rename menu link paths Source: http://www.skonet.com/Articles_Archive/Helpful_Sql_Scripts_for_Ektron_CMS_400_Net.aspx

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

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

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

This is a compilation of some of the scripts on this site to get numbers to report to management

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 In Checked in for other…

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 Will return you the users…