+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 23
How do you do....it? Thread, Inventory record keeping - In what ? in Technical; Well we're being audited under financial management standards in December and one of the points raised is inventory. Obviously everything ...
  1. #1
    jamin100's Avatar
    Join Date
    Feb 2008
    Location
    Birmingham
    Posts
    1,021
    Thank Post
    138
    Thanked 97 Times in 77 Posts
    Rep Power
    32

    Inventory record keeping - In what ?

    Well we're being audited under financial management standards in December and one of the points raised is inventory.

    Obviously everything has to be on the inventory, but what format / program do you use to keep it all? or is it all hand written?

    If anyone has any inventory templates it would be appreciated

  2. #2
    mjs_mjs's Avatar
    Join Date
    Jan 2009
    Location
    bexleyheath, london
    Posts
    1,004
    Thank Post
    37
    Thanked 108 Times in 93 Posts
    Rep Power
    36
    access is a good start...

    we used asset guard until it broke - was crap, dont use it as it's just a front end to an access database anyway.

    FMSIS should have a document explaing how they want it - thats probably useful to look at if they have one.

  3. Thanks to mjs_mjs from:

    jamin100 (19th October 2009)

  4. #3
    Mako's Avatar
    Join Date
    Apr 2009
    Location
    North Yorkshire
    Posts
    431
    Thank Post
    50
    Thanked 107 Times in 81 Posts
    Rep Power
    71
    We use Access, as we don't have any fancy software, and this handy template from Office Online does the trick quite nicely;

    MS Access Asset Database Template.

    Useful for a quick solution. Hope it helps.

  5. Thanks to Mako from:

    jamin100 (19th October 2009)

  6. #4

    Join Date
    Feb 2006
    Location
    Derbyshire
    Posts
    1,381
    Thank Post
    181
    Thanked 211 Times in 171 Posts
    Rep Power
    64
    If it's just you doing it, the Hardware Management System by MST is a brilliant little app -little bit quirky in places but nothing you don't get used to. Basically a very well designed Access DB with a nice front end. Only problem is since MST closed shop I'm not quite sure where you could track a copy down... I had it somewhere then misplaced it and have to admit am a bit behind on inventory since - keep meaning to dig it up and get it on my netbook!

  7. Thanks to OutToLunch from:

    jamin100 (19th October 2009)

  8. #5

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,151
    Thank Post
    369
    Thanked 365 Times in 323 Posts
    Rep Power
    145
    We use an access database with a php front end.

    Does the job for us as to the others posting above.

  9. Thanks to Sylv3r from:

    jamin100 (19th October 2009)

  10. #6

    witch's Avatar
    Join Date
    Nov 2005
    Location
    Dorset
    Posts
    10,390
    Thank Post
    1,105
    Thanked 2,090 Times in 1,471 Posts
    Rep Power
    651
    Mine's just an Excel spreadsheet - we don't have Access, more's the pity.
    Does the job though

  11. Thanks to witch from:

    jamin100 (19th October 2009)

  12. #7

    GrumbleDook's Avatar
    Join Date
    Jul 2005
    Location
    Gosport, Hampshire
    Posts
    9,881
    Thank Post
    1,316
    Thanked 1,738 Times in 1,087 Posts
    Blog Entries
    19
    Rep Power
    563
    I've just pointed out to Northants folk that ultimately they will have to stick it in SIMS Equipment Register as audit want to see everything *in one location* ... and so have asked them to look at what the format needs to be when exported from whatever they are presently using. It might be worth asking audit what info they want.

  13. Thanks to GrumbleDook from:

    jamin100 (19th October 2009)

  14. #8

    Join Date
    Oct 2008
    Posts
    67
    Thank Post
    1
    Thanked 9 Times in 6 Posts
    Rep Power
    13
    We use GLPI - does an automated inventory when used with OCS. A bit fiddly to get started, but well worth it. You can add all your networking gear, and set up all the links/ports to keep track of what goes where. It will keep track of your Printer catridge use, and all your consumables too. Does lots more besides - did I mention Helpdesk with automatic Ticket creation from email?

    Crumbs, it does everything bar make the tea!

    Excellent application - oh, and it's free!!

  15. #9

    TechMonkey's Avatar
    Join Date
    Dec 2005
    Location
    South East
    Posts
    3,237
    Thank Post
    218
    Thanked 387 Times in 288 Posts
    Rep Power
    158
    We have a HUGE Excel spreadsheet but are moving over to GLPI. All the computers are in thanks to OCS, next will be to slowly transfer everything else. Gonna be an epic task but well worth it I think.

  16. #10
    reggiep's Avatar
    Join Date
    Apr 2008
    Location
    In the vast area of space and time
    Posts
    1,526
    Thank Post
    506
    Thanked 54 Times in 48 Posts
    Rep Power
    28
    What is this OCS you guys speak of?

  17. #11

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,212
    Thank Post
    2,766
    Thanked 935 Times in 875 Posts
    Rep Power
    343
    There was another thread on here somewhere that pointed to

    http://sydiproject.com/

    Is that of any use ?

  18. #12


    Join Date
    Sep 2007
    Location
    UK
    Posts
    5,134
    Thank Post
    1,307
    Thanked 808 Times in 513 Posts
    Rep Power
    632
    I use Excel. It has the advantage that if I'm adding a batch of computers, I can fill down the common details and then just add the serial number. At some stage, we will be dragged into a management database of some description and hopefully it will have a csv import facitilty.

  19. #13

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    6,875
    Thank Post
    393
    Thanked 581 Times in 532 Posts
    Rep Power
    172
    Spiceworks inventory exported to Excel.

  20. #14

    Join Date
    Oct 2009
    Location
    Wolverhampton
    Posts
    95
    Thank Post
    7
    Thanked 3 Times in 3 Posts
    Rep Power
    10
    I've been given the job of doing it in our school and we're using the equipment register module thats built into sims, I've almost made a start of it and have done the course but it integrates with sims so it makes it easy to allocate equipment to rooms/staff.

  21. #15
    alan-d's Avatar
    Join Date
    Aug 2005
    Location
    Sutton Coldfield
    Posts
    2,400
    Thank Post
    353
    Thanked 254 Times in 185 Posts
    Rep Power
    74
    We use GLPI, as stated above it gives us all the info we need although pulling out bespoke reports is a pain. We can however pull up every detail of the equipment from the serial number, type of chipset to software installed as well as all tickets raised since it was installed.

    SIMs won't give us that detail.

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Keeping Website Up to date
    By u8dmtm in forum How do you do....it?
    Replies: 1
    Last Post: 1st October 2009, 08:11 AM
  2. Keeping a database of all your license's
    By EduTech in forum How do you do....it?
    Replies: 10
    Last Post: 18th April 2008, 12:37 PM
  3. Outlook - not keeping settings
    By firefox_2006 in forum Windows
    Replies: 3
    Last Post: 24th January 2008, 01:23 PM

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
  •