HowTo get the number of items per table name from the RecycleBin in Spider LCM

[#1]

Summary

This article explains how to determine where data is coming from in your Spider RecycleBin.

Synopsis

Your Spider RecycleBin has been growing too much and you want to know where most of the data comes from.

Discussion

Run the following statement against the database you want to get the information from:

Select    TableName 
        , SCObjectName = dbo.GetSCObjectName(SCObjectID) 
        , ANZ = count(*) 
from sosys.RecycleBin with (nolock) 
group by SCObjectID, TableName 
order by 3 desc,1,2

Additional Information

You need at least read access to the Spider databases

Products

LCM6