+ Post New Thread
Page 1 of 3 123 LastLast
Results 1 to 15 of 32
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 ...
  1. #1
    HMCTech's Avatar
    Join Date
    Apr 2008
    Posts
    618
    Thank Post
    37
    Thanked 48 Times in 35 Posts
    Rep Power
    22

    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?

  2. #2

    bladedanny's Avatar
    Join Date
    May 2009
    Location
    Sheffield
    Posts
    1,268
    Thank Post
    188
    Thanked 298 Times in 224 Posts
    Rep Power
    130
    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,

    Dan

  3. #3
    Duke's Avatar
    Join Date
    May 2009
    Posts
    1,017
    Thank Post
    300
    Thanked 174 Times in 160 Posts
    Rep Power
    57
    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.

    Cheers,
    Chris

  4. #4

    powdarrmonkey's Avatar
    Join Date
    Feb 2008
    Location
    Alcester, Warwickshire
    Posts
    4,859
    Thank Post
    412
    Thanked 777 Times in 650 Posts
    Rep Power
    182
    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.

  5. #5

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    6,729
    Thank Post
    1,271
    Thanked 1,644 Times in 1,100 Posts
    Blog Entries
    22
    Rep Power
    505
    +1 Spiceworks - its very good in my opinion.

  6. #6
    mossj's Avatar
    Join Date
    Dec 2008
    Location
    Leicester
    Posts
    1,466
    Thank Post
    157
    Thanked 189 Times in 174 Posts
    Rep Power
    52
    Quote Originally Posted by bladedanny View Post
    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,

    Dan
    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.
    Last edited by mossj; 20th May 2009 at 08:45 AM.

  7. #7
    martynbez's Avatar
    Join Date
    Jun 2008
    Location
    South East London/North west Kent
    Posts
    54
    Thank Post
    2
    Thanked 4 Times in 4 Posts
    Rep Power
    13
    His name is Ben and he has some paper and a pen! best 16k we ever spent!

  8. Thanks to martynbez from:

    powdarrmonkey (20th May 2009)

  9. #8
    apoth0r's Avatar
    Join Date
    Apr 2007
    Location
    Northants
    Posts
    1,221
    Thank Post
    151
    Thanked 180 Times in 132 Posts
    Rep Power
    51
    I used Impero Inventory for a few years, not sure what they use here as I haven't done one yet

  10. #9

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    5,616
    Thank Post
    845
    Thanked 880 Times in 730 Posts
    Blog Entries
    9
    Rep Power
    326
    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.

  11. #10

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,803
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224
    OCS Inventory, plugged into GLPI.

  12. #11

    Join Date
    May 2006
    Location
    West Bromwich
    Posts
    2,190
    Thank Post
    299
    Thanked 215 Times in 185 Posts
    Rep Power
    56
    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.

    http://office.microsoft.com/en-us/te...253421033.aspx

  13. #12

    Join Date
    Jun 2008
    Posts
    105
    Thank Post
    33
    Thanked 3 Times in 3 Posts
    Rep Power
    13
    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.

  14. #13

    john's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    10,507
    Thank Post
    1,492
    Thanked 1,050 Times in 919 Posts
    Rep Power
    302
    Spiceworks for us very good stuff

  15. #14
    Batman's Avatar
    Join Date
    Mar 2009
    Location
    Northampton
    Posts
    940
    Thank Post
    115
    Thanked 118 Times in 74 Posts
    Rep Power
    39
    Quote Originally Posted by AlexPilot View Post
    Does anyone do anything special to build up their inventories with ease?
    Yep. I let Mike do it... Ho ho ho!!

  16. #15
    Griffo's Avatar
    Join Date
    Sep 2008
    Location
    Wrexham
    Posts
    124
    Thank Post
    26
    Thanked 7 Times in 7 Posts
    Rep Power
    13
    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.

SHARE:
+ Post New Thread
Page 1 of 3 123 LastLast

Similar Threads

  1. OCS Inventory
    By Geoff in forum Downloads
    Replies: 5
    Last Post: 3rd June 2011, 08:40 AM
  2. Anyone use Specops Inventory?
    By cookie_monster in forum Network and Classroom Management
    Replies: 0
    Last Post: 5th March 2008, 12:02 PM
  3. OCS Inventory
    By apeo in forum Windows
    Replies: 0
    Last Post: 1st November 2007, 01:28 PM
  4. Inventory
    By mmoseley in forum Network and Classroom Management
    Replies: 15
    Last Post: 20th June 2007, 12:31 PM
  5. inventory system
    By bjg5858 in forum General Chat
    Replies: 2
    Last Post: 11th July 2006, 09:10 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •