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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

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

    SELECT
	*
FROM
	AllUserData
WHERE
	tp_IsCurrentVersion = CONVERT(bit,1)
  AND
	tp_CalculatedVersion = 0
  AND
	tp_DeleteTransactionId = 0x

    Please see the OOB database view UserData in content database.

    Best Regards,

    Dennis

    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