Untouched component inventory

Good morning all. I need some help understanding this request. This might be something that already exists.

The first part went: “Please run a report for us that shows component inventory report filtered with last used date or touch date so we can identify dead inventory.”

So for this I just used an existing aging inventory report and just sorted by touch date, and filtered on PartClass.Description = ‘Components’

After generating that report, the request was “Can you look at the component inventory data and advise what can be made from them based on available BOM/Methods?”

This is where I got stuck. At Jose’s suggestion, I looked at PartMtl instead. So for instance, the very first record in my original report looks like this:
image

If you look at this in Method Tracker, you get these unpainted parts:

So do I actually want a query off of PartMtl, sorted by touch date, with the Revisions where they are used? Does anything like this already exist in Epicor?