Custom Report to list part configuration serial numbers

I'm trying to figure out how to use the query builder to make a custom report that will return a part structure with serial numbers of a part config instance.  My goal is to have a report that can instruct or document what serials numbers went into a build and pull a report.

For example: If I have a WT part number 00123 that has 3 different configurations (S/N 001, 002, 003) with a structure of parts underneath that all have serial numbers. How do I make a custom report to list that?