I wanted to add\edit a filter collection in Netcool that was going to be at least 200 filters. Obviously, this would take forever to do through the WebGUI. There has to be a faster\easier way. I searched the database, nothing there. Pressing on to find the config file that contains the information, I added a filter and then searched for that string in the configs.
I found ..\IBM\Tivoli\tip\TIPProfile\etc\webtop\data\global\filter.xml
Excerpt from filter.xml:
sql="Service = 'DNS'">
I modified this file using examples of other filters I had already created as a template. A few quick copy and pastes and we have our filters built. Save the file and go back into Netcool, no filters.
When you change this file, you need to restart the WebGUI service on the server and log back in. Restarting will repopulate the list from xml file.
Guarding your IT Experience!