Helpdesk Script OR Report for troubleshooting which rules are being applied to Store for specific Vendor item

As a user, I want to be able to take a store number, as well as a vendor item (i.e. 101562), and run a report to see all the relevant rules for that item that have been applied to the entered store, so that I can troubleshoot why items may not be available and who changed rules most recently.

Specifics:
1. User enters a store number, and a Vendor Item number. Hits run/generate.
2. A report (either Helpdesk script output, pdf, csv, on-screen data, etc--anything is fine) gets generated showing me the following columns based on the inputted data:
a. Type:
b. Zone V Restaurant
c. Zone Name
d. Start Date
e. End Date
f. Deleted Date
g. Last Modified By
h. CFA Item #
i. CFA Item description.
j. CFA Item status (i.e. active/disabled)

With the above info, our support team will be able to quickly identify the cause for certain vendor items now being available at a given store.

See an excel mock-up screenshot of the specific type of data we are expecting: