network inventory scan

“We do not use any off-the-shelf software for asset management,” says Robert Farrell, director of technology at Livingston Manor CSD. “I built a Microsoft Access database that controls our IT network inventory scan. The database took me roughly a couple of hours to build.” Currently, Farrell says, the district is “tracking computers, laptops, monitors, servers, printers. We do not track software, license renewals, etc. I do that in a spreadsheet, but I will consider eventually adding it to the database.” Farrell also plans to add a repairs tracking section, “so we can tell which devices have been giving us the most problems.” And he wants to add toner tracking. “This is all fairly easy to set up if you have intermediate experience with Access.”

Dike-New Hartford Community School District in Iowa keeps most of its asset information on Microsoft Excel spreadsheets, according to Jeremiah Lehr, technology coordinator. “We have about 800 students, so we’re small enough to get by with this sort of solution.”