+1-888-365-2779
Try Now
More in this section

Forums / General Discussions / Report that lists changes since a given date

Report that lists changes since a given date

3 posts, 1 answered
  1. Leon Williams
    Leon Williams avatar
    20 posts
    Registered:
    18 Mar 2010
    08 Jun 2010
    Link to this post
    Is there a way in Sitefinity to get a list of files (records) that changed since a given date?  I need to push changes to production from our dev/test environment and wanted to be sure that what we are moving to production is indeed what we know we changed.  I want to prevent moving things to production that shouldnt go, and make sure I move everything that should go.  Is there such a report or is there a way I can get the information from the Sitefinity database?
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    08 Jun 2010
    Link to this post
    Hi Leon Williams,

    There is no such report that you can use. You can check the following tables in the database which keeps records about the content items and pages and when they have been modified

    • [sf_VersionItem]
    • [sf_CmsContentVersion]
    Another option would be creating a tool that will return the last DateModified for each content item. For instance the objects of type CmsContentBase have a property  DateModified that you can use. You can use the same property for objects of type ICmsPage.
    All the best,
    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.
    Answered
  3. Leon Williams
    Leon Williams avatar
    20 posts
    Registered:
    18 Mar 2010
    08 Jun 2010
    Link to this post
    Thank you.  We created a query using the tables you listed and got the information we needed.

    Thanks,

    Leon
Register for webinar
3 posts, 1 answered