+ Post New Thread
Results 1 to 13 of 13
Network and Classroom Management Thread, Computer And Software Inventory!! HELP! in Technical; Hello, im wonder if someone has got some advice for me one of my jobs here at the school is ...
  1. #1
    joshjacklin's Avatar
    Join Date
    Mar 2010
    Location
    Stevenage
    Posts
    33
    Thank Post
    25
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Computer And Software Inventory!! HELP!

    Hello, im wonder if someone has got some advice for me one of my jobs here at the school is to do a hardware and software inventory, now ive got all this information in excel and stuff which i have written down as well and i want to put it in an easy to access format where I can pull up any information that management wants when ever they want it, microsoft excel with visual basic is amazing except i dont know visual basic and the time it would take me to play around with it is a waste of time, I also have thought of access but of course im not too familiar with it, when i have looked on google as you do, its all companies wanting you to install software which will scan your network and do an audit, which is all well and good if it actually tells me what I want to know and is either open source or freeware.

    to give you an idea of the information i have got, we use a logging system here where we provide allocation numbers to equipment, so we have seton labels and have our company name and then a number like 100512 and then in excel that will have 100512 Video Seven Monitor, Model Number, Serial Number, Location and Previous location. which is all well and good, however I want to put in a technical specification for the machines and things i need it to be really indepth as they have got a thing on at the moment and i want to provide them with more information than they can shake a stick at but at the same time in an easy way.

    For example if I wanted to say x amount of machines are failing this is the technical specification, doing a simple ram upgrade may increase the speed of the machine but of course this is not the way forward when your doing an upgrade hirachy, new at the top rolling the older machines down the chain to get rid of the obselete equipment on a shoe string budget. before you laugh we have shuttle x machines here, and the power supply has a fault if it is off for a long period of time it fails, shuttle know about this only suggest to buy a new part 50 a psu, times 3-4 maybe even 5 machines a week failing its not cost effect just replacing psus i could provide a chart or graph.

    yes thats off on a tangent a little bit but im trying to give as much information as i can to get the best possible help

    i just need to know how to go forward before i waste a stupid amount of time.
    Thank You! -Josh Jacklin-

  2. #2

    3s-gtech's Avatar
    Join Date
    Mar 2009
    Location
    Wales
    Posts
    2,711
    Thank Post
    144
    Thanked 548 Times in 492 Posts
    Rep Power
    149
    From a scan read of what you want - Spiceworks. Yes it installs and scans, but it's free (for the version you'll need) and it's superb. I have it running on an old DC so it just ticks along in the background.

  3. #3
    ReverentCreature's Avatar
    Join Date
    Apr 2007
    Location
    Kent, UK
    Posts
    88
    Thank Post
    4
    Thanked 6 Times in 5 Posts
    Rep Power
    16
    Unless you are familiar with Access you wil be better sticking with Excel. I would take time to learn access thoguh as its exactly what you need. You can add tick boxes, list boxes and create reports that filter your information differently. It sounds like you only need once tabel though. Just one big long list of information. So I would stick with Excel if you jusdt want to sort and filter your columns. Youc an do this from the Data menu.

  4. #4

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180
    Another free option is GLPI - open source and you can enter all your information to produce reports. It is quite feature rich mind and if you don't integrate with OCS-NG (to do a scan and audit of your hardware) it will take you ages to populate the database.

  5. Thanks to Ric_ from:

    andrew_91090 (13th May 2010)

  6. #5
    Pete10141748's Avatar
    Join Date
    Nov 2007
    Posts
    1,365
    Thank Post
    106
    Thanked 220 Times in 130 Posts
    Rep Power
    86
    Another vote for Spiceworks here, it scans everything connected to your network, gives you all information you'll need for an audit and lots more besides.

  7. #6

    Join Date
    Jan 2010
    Posts
    101
    Thank Post
    0
    Thanked 7 Times in 7 Posts
    Rep Power
    11
    spice works again here 2

  8. #7

    m25man's Avatar
    Join Date
    Oct 2005
    Location
    Romford, Essex
    Posts
    1,621
    Thank Post
    49
    Thanked 451 Times in 334 Posts
    Rep Power
    137
    Lansweeper is my favourite.

  9. Thanks to m25man from:

    andrew_91090 (13th May 2010)

  10. #8

    Join Date
    Dec 2007
    Posts
    8
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    We've been using SysAid from Help Desk Software by SysAid since 2006, which is a helpdesk with extra's.

  11. #9

    Dos_Box's Avatar
    Join Date
    Jun 2005
    Location
    Preston, Lancashire
    Posts
    9,831
    Thank Post
    581
    Thanked 2,162 Times in 987 Posts
    Blog Entries
    23
    Rep Power
    627
    If you have the money, NetSupport DNA is the way to go. It's network and IT support on steroids: NetSupport DNA: The latest evolution in Asset Management and PC Remote Support

  12. #10

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    6,730
    Thank Post
    1,272
    Thanked 1,644 Times in 1,100 Posts
    Blog Entries
    22
    Rep Power
    505
    Spiceworks will do everything you need and more, free and stunning.

  13. #11
    Osprey's Avatar
    Join Date
    Mar 2007
    Location
    West Yorkshire
    Posts
    65
    Thank Post
    0
    Thanked 6 Times in 4 Posts
    Rep Power
    16
    Spiceworks gets my vote. I use it for inventory purposes, as a help desk, as a central database for all equipment. It is excellent for generating reports of what is installed or what is not installed on workstations. My only gripe is that there seems to be an update every five minutes! Mind you, there is nearly always a nice new feature or an increase in speed.

  14. #12
    Elison's Avatar
    Join Date
    Feb 2010
    Location
    Russia
    Posts
    256
    Thank Post
    60
    Thanked 20 Times in 19 Posts
    Rep Power
    12
    I've been using 10-Strike Network Monitor. It does everything you need: scan and audit the system, create differant kinds of reports and warn you if changes have been made.

  15. #13


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,628
    Thank Post
    275
    Thanked 777 Times in 604 Posts
    Rep Power
    223
    I use GLPI and OCS-NG. The agent is installed on the base images, so any hardware that's imaged adds itself to the database as soon as it realises it's on new hardware.

SHARE:
+ Post New Thread

Similar Threads

  1. Inventory Software
    By school in forum Network and Classroom Management
    Replies: 9
    Last Post: 4th December 2010, 08:24 PM
  2. After open source inventory software
    By PEO in forum General Chat
    Replies: 6
    Last Post: 11th August 2008, 01:02 PM
  3. Software for an inventory
    By LukeC in forum Budgets and Expenditure
    Replies: 12
    Last Post: 26th March 2008, 09:09 AM
  4. Help desk and Inventory software (again sorry)
    By edie209 in forum Downloads
    Replies: 32
    Last Post: 11th August 2006, 11:10 AM
  5. School Inventory Software
    By GavRob in forum How do you do....it?
    Replies: 26
    Last Post: 10th May 2006, 09:51 AM

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
  •