+ 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,484
    Thank Post
    133
    Thanked 488 Times in 436 Posts
    Rep Power
    138
    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
    83
    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,582
    Thank Post
    107
    Thanked 761 Times in 592 Posts
    Rep Power
    179
    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,350
    Thank Post
    104
    Thanked 219 Times in 129 Posts
    Rep Power
    85
    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
    10
    spice works again here 2

  8. #7

    m25man's Avatar
    Join Date
    Oct 2005
    Location
    Romford, Essex
    Posts
    1,608
    Thank Post
    49
    Thanked 444 Times in 330 Posts
    Rep Power
    136
    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,466
    Thank Post
    524
    Thanked 1,993 Times in 932 Posts
    Blog Entries
    23
    Rep Power
    575
    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,259
    Thank Post
    1,138
    Thanked 1,463 Times in 980 Posts
    Blog Entries
    22
    Rep Power
    457
    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
    252
    Thank Post
    57
    Thanked 19 Times in 18 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,534
    Thank Post
    271
    Thanked 752 Times in 590 Posts
    Rep Power
    218
    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
  •