Report of Filters and what they are referenced by
I am looking for orphaned filters which are no longer being used. I can find these manually by opening the filter and going to the bottom section of filter membership and choosing Referenced By. From there I can see if the filter is being used by anything and then chose to get rid of it.
So far I have found filters with this SQL
select * from vNonResourceItem where ClassGuid = 'AECA2D91-C615-4D99-BAD5-612CA159DA4F' and Attributes = 0
I can work my way around in SQL but I am struggling to find the right table which has this relationship.
Any suggestions? better yet has anyone else needed this same report and has already created it?