SharePoint 2013 - Identify deleted app list item in content database RRS feed

  • Question

  • Hi,

    I developed a SSRS report accessing the SharePoint 2013 Content Database. It works nicely but for the deleted list items they continue to appear. In SharePoint 2010 there was a field <tp_DeleteTransactionId > that if its value is different from "ox", then the item is deleted. In SharePoint 2013 this field is binary.

    Does anybody have any suggestion to identify which list items are deleted and purge them from my report? It do not matter if it is on the trash basket or not.

    Thank you.

    Best regards, Ricardo Segawa - Segawas Projetos / Microsoft Partner

    • Edited by R.Segawa Monday, November 14, 2016 9:28 PM
    Monday, November 14, 2016 9:28 PM


  • Hi,

    We can also use the SQL script below to filter the data from AllUserData table. Please note use "0x", not "ox".

    	tp_IsCurrentVersion = CONVERT(bit,1)
    	tp_CalculatedVersion = 0
    	tp_DeleteTransactionId = 0x

    Please see the OOB database view UserData in content database.

    Best Regards,


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    • Proposed as answer by Patrick_Liang Wednesday, December 7, 2016 9:52 AM
    • Marked as answer by Sjoukje ZaalMVP Thursday, January 12, 2017 2:00 PM
    Tuesday, November 15, 2016 9:11 AM