Video Screencast Help

Report of Filters and what they are referenced by

Created: 19 Jun 2013 | 3 comments

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?

 

 

Operating Systems:

Comments 3 CommentsJump to latest comment

andykn101's picture

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.

Authorised Symantec Consultant (ASC) with Endpoint Management Limited, an Authorised Symantec Delivery Provider based in the UK.

Connect Etiquette: Please "Mark as Solution" posts that fix your problem.

ktm_2000's picture

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.

andykn101's picture

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.

Authorised Symantec Consultant (ASC) with Endpoint Management Limited, an Authorised Symantec Delivery Provider based in the UK.

Connect Etiquette: Please "Mark as Solution" posts that fix your problem.