Dynamically update inventory in tickets

[iankriss]

Hey my first question!

Here is what I want to accomplish and hopefully it makes sense. 

We work as a MSP for a chain of Pediatrician Dental Offices throughout the country. They have these intra-oral sensors they use constantly. 

Well, they get chewed up and damaged and we as a IT team have to go through on troubleshooting/replacing and RMA'ing these sensors on a near daily basis. 

Multiple status we using including the ones mentioned above. Like calling the contacting vendor to the office receiving labels and verification of drop off to UPS. And also when they receive the new one we record the serial and sizes. And manually adjust use an excel sheet as a main data source. Usually replacing the one that was RMA'd with the new serial they received with size and manufacture. I then use that as a main data set for PowerBi for reporting.

I started to create our ticketing project out of Jira Software to allow staff to fill out a form to contact us when they have trouble.

Here is what I would like to accomplish and need guidance. 

Is there a way to have Jira do a hardware inventory that would dynamically change it when we have to replace them? Or perhaps a App or something that I can use to put in to the form? Also to keep a status on what is happening with that particular sensor via serial number? Like I mentioned above if there is a serial number that I received a label; I change that status to: Received Label

I then would like to see if there is a way I can use PowerBi to get information as a data set perhaps. 

[Mikael Sandberg]

Have you looked at JSM and Insight? You could store your inventory in Insight and have it automatically updating based on tickets coming in via JSM.