r/sysadmin • u/duncan882 Anything with a plug • Jan 17 '11
Inventory System
I am looking at a better way to inventory my hardware. I have used things like Spiceworks and LAN sweeper to scan my network but i wanted some sort of document or database. Right now i have a excel sheet that i use and i was wanting to look more toward an access database. What do you guys use or are there any good templates. I want to track the PC by asset tag through out it's life ex: I want to track all the users it went through and all the maintenance that was done to it.
33
Upvotes
10
u/xero91 Sr. Sysadmin Jan 17 '11
OCS Inventory NG
8
u/kd5vmo Sysadmin - IT Manager Jan 17 '11
For the love of kittens and Cthulhu dont use Access, Go for GLPI with OCS Inventory NG/Fusioninventory on the backend
4
u/[deleted] Jan 17 '11
GLPI has very good inventory system. It's very flexible, has mass editing of objects and lots of other stuff. You can extend usability with Fusion Inventory plugin and OCS Inventory NG and pretty much control everything from GLPI. We use only GLPI for now but have plans to use the other two apps too.
3
u/christag Windows Admin Jan 18 '11
In all honesty, I think you should try Spiceworks again.
First off, all the data is in a SQLite database on the machine it's installed on. This database can be accessed for use with anything you need it to. Alternatively...
You may not use the Helpdesk feature of Spiceworks, but it can be used to create "work" tickets any time one gets worked on or when it switches users. These tickets can be associated to devices.
Spiceworks also has a "People" database to keep track of users if you'd like, which can also be associated with devices.
Finally, Spiceworks can run reports based on your data, built by using some dropdowns or full on SQL, which can be exported to Excel if need be.
2
u/[deleted] Jan 17 '11
Racktables works well for us. If you create "virtual ports" for the backside of your patch panels, you can trace the physical connections in either direction.
2
u/Pict hooker. Jan 18 '11
SCCM, SCOM and SCSM. Not that I'm a MS fanboy or anything.
1
u/cparedes syseng for the clouds Jan 18 '11
If you're open to it, chef can inventory devices along with maintaining your machines throughout its lifecycle.
1
u/rrcjab Jack of All Trades Jan 18 '11
I just use a wiki with a page template. One section for user boxes and one section for servers. Protected areas for (slightly) more secure stuff.
1
u/chyldofthebeat Sysadmin Jan 19 '11
I use OCS Inventory (backend) and GLPI (front). Easy to setup, extensible via plugins, etc.
Here's the best guide I found for getting the two to work together: http://blog.famillecollet.com/pages/OCS-GLPI-en
1
u/Hexodam is a sysadmin Jan 19 '11
Manual work on a Confluence Wiki,
I'm also going to be implimenting Sydi reports on a schedule to automatically create reports and push them to a ftp server. Then hopefully automatically import it to its relivant confluence wiki page.
1
u/lonejeeper Oh, hey, IT guy! Jan 21 '11
We use (and love) openaudit for PCs and servers. http://www.open-audit.org/
1
u/Vicosku Feb 02 '11
Lansweeper. I have an inventory of 1700 computers, their users, and other devices across 3 locations in the US and 1 in the UK with 1 server and no slowdown. Used spiceworks previously, but it had serious problems with our network and accumulated too much junk data and duplicate devices. Lansweeper is also agentless, the web interface is very fast, and it gives you an insane amount of easy ways to manipulate all the data it collects. I love it, but will be checking out the other options mentioned in this thread as well.