More in this section

Forums / General Discussions / Finding Orphaned Generic Content Items

Finding Orphaned Generic Content Items

2 posts, 0 answered
  1. Laura
    Laura avatar
    311 posts
    25 Feb 2008
    02 Jul 2010
    Link to this post
    I think I read something in the forums about this previously however, please forgive me, I can not find it now. Is there a script (SQL?) I can run to find any generic content items (from the Generic Content module) that are not used on any pages in the site?

    Thank you.
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    12 Sep 2017
    04 Jul 2010
    Link to this post
    Hi Laura,

    1. You can use similar approach as described in this post - getting all controls of a certain time and find controls location.

    2. Using SQL queries

    [sf_WebControlBase] - here you can find all controls of type equals to Telerik.Cms.Engine.WebControls.GenericContent

    [sf_CmsCtrlLinks] - you should make a JOIN on [sf_CmsCtrlLinks] and get the PageID

    Best wishes,
    Ivan Dimitrov
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
2 posts, 0 answered