Audit Collector in Operations Manager 2007 is one of the most frequently used. When I was supporting the SCOM and ACS, the challenge many of customers informed me was that applying filter query using adtadmin tool. This is more important to make sure that unnecessary data is not inserted to the ACS database and that the ACS database is within the manageable size limits.
You can get more details from this link on the Adtadmin tool.
This tool designed by me is a GUI tool which uses adtadmin tool behind but will make the user level experience better. This will work with the following condition.
· This tool is supposed to run only on ACS collector system
· This is not for complex quires.
· This tool can be run with a user having administrator rights
· With System with UAC enabled you need to use Run as Administrator to the tool.
I have tested this with Windows Server 2003 and Windows Server 2008 but keep in mind that this is not an official Microsoft tool and just something that I created for my own personal use. As such, Microsoft makes no warranties or guarantee’s regarding the applicability of this utility, nor does Microsoft support the use of this tool in any way. This is just one of those ‘use at your own risk’ type of things that hopefully you’ll find helpful
If you have any question please let me know.
Hope this will be Helpful