Inventory record keeping - In what ?

[jamin100]

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

[mjs_mjs]

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.

[Mako]

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.

[OutToLunch]

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!

[Sylv3r]

We use an access database with a php front end.

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

[witch]

Mine's just an Excel spreadsheet - we don't have Access, more's the pity.
Does the job though

[GrumbleDook]

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.

[7andY]

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!!

[TechMonkey]

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.

[reggiep]

What is this OCS you guys speak of?

[mac_shinobi]

There was another thread on here somewhere that pointed to

http://sydiproject.com/

Is that of any use ?

[laserblazer]

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.

[Edu-IT]

Spiceworks inventory exported to Excel.

[Crowmanuk]

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.

[alan-d]

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.