Active Lists to check against events on demand...best method?

What I'm trying to accomplish and what would most easily satisfy my need is if my filter which contains an active list could be used against an active channel.  From everything I've read this is not a possibility.  Here's the scenario:

- I have an active list which is populated regularly via a CSV file.  This active list contains a single field that is being populated...nothing more.  This active list has over 1300 entries in it.  To clarify a bit, it contains id=xxxxxx and a six digit number represented by the x's.  Events with the particular xxxxxx numbers in this active list are something we want to report, alert and pull a history of on demand.  The reporting and alerting functions work just fine.

The problem I have is when someone comes up to me and says I need a list of all events for the last week matches based on this filter which contains this active list.  I unfortunately cannot do this with an active channel....that I can see.  So I've built a query which uses the filter that contains the active list in question.  I then use a query viewer to pull the information on demand.  This will pull the data I require but I'm wondering if this is a better way?  So I thought I'd share my scenario with all of you in hopes that you may be able to enlighten me.  Thank you in advance and Happy Holidays!

Tags:

Parents Reply Children
No Data