Client Management Suite

Hi All,

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?

A slightly easier approach might be to list all Filters that haven't been updated for a certain length of time because I think filters that have nothing applied to them don't get updated.

The issue with that is that when you try to delete them you then get the message that they are associated with a MSD.

It would be nice to see the relationship.

If they are associated with an MSD it would be best to go through all your MSDs first and delete those that are no longer required. I move them to an "Archive" folder for a week or so, then export them, then delete them, then delete the filters.

You might be able to find dependencies by opening resource explorer, pasting in the GUID of the filtere into the URL bar and selecting the Resource Association grid. Or

Select FROM ItemReference WHERE ChildItemGUID LIKE ‘guid’

might work.