Network Inventory Database/Spreadsheet

Posted on 2004-11-30
Last Modified: 2013-12-07

I manage several small networks and I would like compile all our inventory information in one spreadsheet or access database.  I am looking to put in information such as system info, software, purchase dates and prices, software license keys, serial numbers, assigned to, notes on machine, monitors etc.

does anyone have a good template for this that they would be willing to share.  I am not really looking to purchase an audit software program- mainly just a good system for manually tracking all this stuff in one place.

thanks in advance!
Question by:cgit
    LVL 8

    Expert Comment

    i have a license tracker that i found you can use it for a template or just as is.
    Send me you email and i wll send you the zip file.

    Author Comment

    Hi Mark,

    Thanks so much for your reply!  Does this program just handle licneses or can it handled detailed information for a machine-

    I am thinking of something where I can pull up a machine by name and have all the information pertaining it- including machine make model, type and serial number, hardware config, purchase price, user assigned to it, software installed on it along with licnese key used etc.

    Would this program handle something like this?

    Thanks again!
    LVL 8

    Expert Comment

    No it willl not handle all that but does  have some of the features you want. It would be a good template to write your own database as it is written in Access.
    LVL 4

    Accepted Solution

    We use Emco Inventory 3.0 (

    It is VERY cheap, pulls all the hardware and software specs in the network, dumps into Excel or Access, is fast, and has the best support of any commercial package we have ever bought.

    If you are looking for a free solution, try ARI  (

    It does a lot of the same features, only dumps into a delimited text file, and is "quirky" (hangs/freezes occasionally)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Some time ago I was asked to set up a web portal PC to put at our entrance. When customers arrive, they could see a webpage 'promoting' our company. So I tried to set up a windows 7 PC as a kiosk PC.......... I will spare you all the annoyances I…
    Don’t let your business fall victim to the coming apocalypse – use our Survival Guide for the Fax Apocalypse to identify the risks and signs of zombie fax activities at your business.
    After creating this article (, I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now