Hi all,

I've been able to find most other object info on my own, but so far, haven't been able to determine what table(s) in the ARSystem database contain the list of filters in a filter guide.

Does anyone know where the items contained in a filter guide are stored (i.e. where I could query the table(s) in order to show the guide name and the objects contained in the guide)? It would help speed my documentation and my troubleshooting.

Thanks in advance!

Bill

Not silly at all here is the answer
Remedy treats filter guides as containers so to get the filter guide and get the filters inside you would query the arcontainer with containertype=4. for example
;to get all the filter guides on server
select *
from arcontainer
where containertype=4
;to get the filters inside the container
select referenceobjid
from arreference
where containerid=ID OF THE FILTER GUIDE YOU Get from first sql

;
ofcourse to get the filter definition for one of the filters
you would;
select *
from filter
where filterid=REFERENCEOBJID from previous select

maybe you can do a join for the two to get a Guide with its filters as childs.

hope it helps

Another option would be to sync up your DB and then do a search for the naming convention that you used for the filters. Provided the filters are named uniquely, would make it easier to find as well.

ARCONTAINER table is the other option to locate the guides but you can quantify your SQL search by looking for the particular guide name or label.