Have you looked into GLPI? It integrates into OCS . http://www.ocsinventory-ng.org/en/about/features/ocsng-glpi.html
I have a buddy who runs IT for a county sheriff office and uses it to track everything.
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.
OCS Inventory is free OS software and does a pretty good job.
It's really easy to setup, especially if you're ok pushing a small client to all your machines.
You can try with OCS Inventory. It has an agent, works on Ubuntu (thus almost certainly on Debian) and windowzes. We have 500+ workstations and its a good timesaver when tracking/doing inventory.
Depending on what you need to do and how long you need to keep track of the data take a look at OCS Inventory. This is a free, open source product that uses a client-server architecture to inventory PCs. The client is very small footprint and will install on just about everything you can imagine. The server is very lightweight as well. We ran in on an NT 4.0 box. You have to touch every PC to install the client and that is the only downside to this program. AFter the installation the client will contact the server on a regular basis and report what is on the PC. It will tell you anything and everything about the PC.
You could also look at Spiceworks IT Asset Management Software. Being Spiceworks it is a free product and it will probably do what you need it to do but I have never used it.
I've setup OCS Inventory + GLPI at work recently. Its not too bad, works pretty decent
http://www.ocsinventory-ng.org/en/ http://www.glpi-project.org
OCS inventory has agents which can be deployed on clients which report home to the server and keeps track of changes to hardware and software etc.
There are some plugins in glpi where you can import stuff directly into it from OCS. Pretty useful.
I suggest you read up the documentation well as well as some of the tutorials out there. Good luck!
osTickets is pretty easy to setup, all web based too. For inventory, I would suggest OCS Inventory NG, as it does has a OS X Agent, but you would need to setup another box to run a Linux flavored server (preferably Debian). Then run GLPI as the front end to OCSNG (GLPI has a specific mode just for OCSNG). There are some guides to getting it all setup, but once you do, lots of fields are self populating.
If you are managing more than 5-10 dell's you might consider inventory software. I've been experimenting with OCS Inventory. Agent software runs on windows, linux, and mac. It can be distributed via group policy and runs as a service, and it's open source. Then you don't even have to be at the client computer to view the asset tag.
If you are talking about IT asset tracking:
http://www.ocsinventory-ng.org/ http://www.glpi-project.org/
I think there is a plugin to help with tracking ordering/valuation. I don't think it does depreciation tho, that you'd have to add. I will just say, your depreciation should be handled by your accounting package, and that staff should manage it, and not be stuck in an IT asset system.
If you are talking about a more generic asset tracker (i.e. to track furniture, buildings, vehicles, etc) then go look into a module for whatever accounting system you use, chances are you'll find one in there.
I just started playing around with this, but OCS Inventory NG. It will pull currently installed software, but I dont think it will tell you CD-Keys and stuff (although it did pull the key for XP). It is an agent that resides on the clients and reports back info. If you feel like going to each computer, you can use Belarc and it will give you a nice report of everything about the computer, including software and for most popular softwares the CD-Key too.
if you want a nice and simple open-source inventory solution for windows mac and linux with basics of deployment, try http://www.ocsinventory-ng.org/en/
We're using this for years without any problem. It's a piece of software that just works. And there aren't many of them left these days.
Give OCS a try. It is a free tool that monitors hardware and software. Link here. The link is French, just FYI. We used to use it but the server went down and it wasn't replaced for some reason.
They do have a paid pro support available, and they claim a regular Dual Xeon server with 4gb of ram will scan up to a million computers per day.. so it may do it. This is their site: http://www.ocsinventory-ng.org/en/
I recommend OCS Inventory. It does use a lightweight client, however the installer package can be custom built to your environment. It's open source with light server requirements and support available.
I'm surprised nobody suggested OCS Inventory yet.
Running in my place, keeping about 5k workstations in a single shitty server with mysql. Take a look, it's very customizable, you can make your own plugins for information retrieval.
OCS Inventory NG with GLPI
http://www.ocsinventory-ng.org/en/about/features/ocsng-glpi.html
Its a little more work to set up than spiceworks but if you have a large site or multiple sites its architecture is quite neat. The orginal developers of OCS went on to develop some of the components of Numara Footprints (not the horrendous Frankenstein BMC footprints that exists now)
Very true. You can also download a preconfigured VM - just spin it up, add a DNS entry for even easier install on the clients, install the agent, and let the data roll in. Tying it up to GLPI is a piece of cake too. The VMs look a little bit out of date at the moment but a bit of tinkering should bring them up-to-speed. http://www.ocsinventory-ng.org/en/download/download-server.html
I used to run GLPI + OTRS about 4 years ago, was quite good, a little tricky to get up and running (mainly cause alot of the interface was still in french then). GLPI is a little ugly but easy to use. Also has a fairly large number of plugins. Works along side OCS NG (http://www.ocsinventory-ng.org/) might be the same product now?
Hey! For me I use OCS-NG ( http://www.ocsinventory-ng.org ) & GLPI ( http://www.glpi-project.org/ ). But OCS don't "scan" the LAN to get informations, you need to install an agent on every machine. If you have ssh access on all the machines you can do it simply using a script or ClusterSSH.
I used to use OCS Inventory NG hooked onto GLPI. That was 7 years ago though and I haven't really been keeping abreast of that part of the industry since I do mostly database development and administration now and moved away from desktop and network support.
since all windows machines you could do a WMI query. - http://www.tek-tips.com/viewthread.cfm?qid=798632
personally I would invest in a little more time and setup something like OCS inventory for it to report back to a server all the time.
If you find a good solution I'm sure they will look past it now. I mean they havent had a good inventory of their stuff for 3 years, why should another year matter if there is a solution in sight that could solve this once and for all.
And no need to reinvent the wheel :)
How big is your medium sized company?
You can use a wiki if its in the scope of doing it manually
Spiceworks if its small enough
Then OCS inventory is one of the big open source solutions http://www.ocsinventory-ng.org/en/
Pen and paper.
No I kid, but almost any half way decent asset management software should collect most of the needed info. http://www.ocsinventory-ng.org/en/ comes to mind and some other free ones that I'm forgetting about.