Scripting

So not sure if I went about this the right way, but we are responsible for all toner replenishment in our district and decided to try to use Kace to help keep track of our toner usage. When users put in tickets saying their toner is low, we go grab the toner from our stock, replace it and close the ticket. That's fine and all, but does not really allow us to have much info other than how many tickets were put in due to "printer" issues. That being said, I am working on adding some of my printers as agent-less devices into my K1000. I got this working ( SNMP) and got that part setup. Next created a few dummy tickets and assigned said printers as the "asset" to that ticket and closed it. Now is where I'm not sure what to do. I did create subcategories that the technicians will use when closing a printer ticket, but users can't see when creating it so not to confuse them. Attached is the structure I created (Note..... not shown is the Black and Color option. If Toner is Black then other subcategories aren't shown) . My problem is how to create a report that can show me only tickets for each location ( yes I did assign each printer to a location) that were toner replenishment, and which asset it was and which toner cartridge was used.This way I can run this report and provide it to each of my sites and they can see how many toner cartridges they used by printer on their campus. That being said, I am lost on where to start in building the report. If this works, I may even go so far as add sub catagories for each model of said color cartridge that I have and can really get granular with my reporting, but not even sure if this first part can be done or not Any thoughts? Sorry if this does not make sense. Can try to explain better if need be. Thanks