How to search all children within a Part structure?

Version: Windchill 12.1

Use Case: In the top level Part structure of a car or truck, search for children at all levels with an matching attribute value, ie show all parts within the car made from Aluminium

Description:

I need to search attributes of all children at all levels within a Part structure. I want to report on attributes like state and materials for all Parts within a car structure, this may be 6 levels deep.

Currently the method being used is to export to excel and use pivot tables.

I have previously used a JSP with some java code I wrote to recursively search for children at all levels with a certain state, this works but is limited to a single attribute input, I want to select any usage or item attribute as input and see a filtered list of child parts matching the criteria.

Any ideas on what approach to take?