Need advice: Inventory management/database app

[DocGreen]

I'm in the middle of a company-wide audit of our backup batteries, and Google Sheets just isn't doing it for me. I'm wondering if anyone knows of a better solution. I've got a ton of SLA batteries in everything from desktop UPS units, to bare batteries in access control panels, and even battery banks for our ISP network, and I need to find a more elegant solution for keeping track of it all and finding batteries that need replaced ahead of time instead of finding them the hard way when there's an outage and now things don't work.

What I NEED	What I WANT
To track... Item, what device it's in, where it's located, when it was installed, brand, rated specs, and periodic test results (voltage, amperage, temp, tech initials), indicate when test results are out of compliance.	Print barcode to my Brother PT-E550W, affix to each item. Scan barcode, enter test results (voltage, amperage, temp, initials). Plot test results onto graph for fun trend visuals.

Thanks in advance!!

 

[dannyict]

I'm using https://snipeitapp.com to track all inventory