Hardware Thread, How do you inventory your equipment? in Technical; We have a database that we enter in manually into Access. Occasionly during the summer we can borrow the librarians ...
20th May 2009, 08:14 AM #1
How do you inventory your equipment?
We have a database that we enter in manually into Access. Occasionly during the summer we can borrow the librarians barcode scanner to enter in the serial numbers.
Does anyone do anything special to build up their inventories with ease?
20th May 2009, 08:30 AM #2
we use spiceworks ( Spiceworks - Free Network Monitoring Software for Network Management ) any computer/printer attatched to the network is automatically picked up and added to the database, you only then need to manually add monitors, usb printers and anything else you wish to add to the database.
Also it's free
Hope this helps,
20th May 2009, 08:35 AM #3
We have a custom in-house solution. My colleague wrote an application in C# which talks to our MS SQL server. We print our own barcodes on security labels from Avery and and one of our guys goes around scanning the barcodes and entering the location/product/serial number of the item, etc. We can then use the application to search by product type (e.g. monitor, laptop, speakers), brand, department, location as required. I'm sure there are more advanced solutions out there but this one was quick and easy and cost nothing besides the barcode reader.
20th May 2009, 08:38 AM #4
Don't bother here, but in my other life at the theatre I wrote an Access application to do location-based inventory and insurance valuation. We print our own barcoded labels for both labels and items, and all new items get coded and a test. Once a year we work our way around the building, clocking into an area and scanning all the items in it to do a headcount, then go onto the next. It tracks other bits, like disposals, depreciation in value, location changes, loss, PAT, etc etc.
20th May 2009, 08:41 AM #5
+1 Spiceworks - its very good in my opinion.
20th May 2009, 08:42 AM #6
Seconded, also comes with a helpdesk as well. Some people say its too slow but tbh i haven't noticed that since the patchs to fix the issue.
Originally Posted by bladedanny
Last edited by mossj; 20th May 2009 at 08:45 AM.
20th May 2009, 08:54 AM #7
His name is Ben and he has some paper and a pen! best 16k we ever spent!
Thanks to martynbez from:
powdarrmonkey (20th May 2009)
20th May 2009, 08:59 AM #8
I used Impero Inventory for a few years, not sure what they use here as I haven't done one yet
20th May 2009, 09:03 AM #9
Written own in-house PHP/MYSQL solution. Bought a netbook especially for the job. Wander around the school with the netbook logging the details on the database.
20th May 2009, 09:43 AM #10
OCS Inventory, plugged into GLPI.
20th May 2009, 09:48 AM #11
If you have office 2007 you can download a free asset template for Access from MS website. It's got a good rating as well although i haven't got 2007 so can't say how good it actually is.
20th May 2009, 12:36 PM #12
- Rep Power
We use an Inventory piece built into our helpdesk application, ITDirect (SchoolDude - Home) which works well for tracking inventory. However, it won't allow you to use a barcode scanner to truly "run" an inventory, so we're looking at switching.
Right now we're planning to go to an inventory piece from Follett, the same company that does our library automation. It will provide a barcode-scanable inventory, allow us to track where items are, etc.
I've got spiceworks running too, but it's only of so much value to me. True, it will track anything on the network, but won't do cables, monitors, etc. I *love* it for the software tracking side of it however.
20th May 2009, 03:22 PM #13
Spiceworks for us very good stuff
20th May 2009, 07:08 PM #14
20th May 2009, 07:25 PM #15
Pretty much the same as Duke
I use the librarians spare barcode scanner, print a barcode onto a mini address label and put it on the back / bottom of the machine where fingers cant get to peel them off
Then just enter it into an access database that i made myself, kind of a work in progress but so far it can search by barcode, serial, location and asset tag and records where it is, how old it is (warranty). Eventually i will sort it so that it will record any items that were lost / broken or disposed and maybe even the software on each machine.
By Geoff in forum Downloads
Last Post: 3rd June 2011, 08:40 AM
By cookie_monster in forum Network and Classroom Management
Last Post: 5th March 2008, 12:02 PM
Last Post: 1st November 2007, 01:28 PM
By mmoseley in forum Network and Classroom Management
Last Post: 20th June 2007, 12:31 PM
By bjg5858 in forum General Chat
Last Post: 11th July 2006, 09:10 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)