On the Dell end, have you looked at DELL openmanage? it basically needs a
server with a toned down version of micro$oft SQL. Dell Openmanage gives you
all the dell specs, memory, procesor, service tag #, BIOS revision, etc. I'm
sure it wouldn't be to bad to connect that into MySQL. (I haven't looked at
Dell Openmanage that much yet though, so I may be way off key here). Well if
anyone else has had luck with that, I'd be interested.
Personally I'm looking into dell openmanage, connected to micro$oft SMS, and
exchange server (for a helpdesk). I'm planning on dumping that into our
inventory database.. and I already have the sms (wich is micro$oft SQL). If
I could use MySQL for the inventory database I would. So SMS will keep track
of the physical computer, and software installed, and the inventory database
will keep track of purchase dates, and waarenty, etc. The web interface I'm
planning on going with is ColdFusion, with reports being gerenated by
crystal reports.
-Bill
-----Original Message-----
From: Sanborn, Ed [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 10, 2001 3:44 PM
To: '[EMAIL PROTECTED]'
Subject: IT Inventory database needed.
Does anyone out there have a good inventory solution?
I'm in search of a web-based inventory database that will be used by
our internal IS department. Utilizing MySQL, Perl and/or PHP I'm
trying to build a database that will allow us to track our IT equipment.
I'd like the following features:
Web-based - Solaris/Apache webserver / SQL backend database
Multiple user w/authentication
Ability to have multiple fields tracked (location, assett #, OS type, lease
info, etc.)
I want to have some fields filled in via pull-down menus. For example,
If we have two popular manufacturers (Dell, Sun) I want to have the ability
from
the web browser to click on "Edit Manufacturers" and "edit my manufacturers
list". After adding, say, Compaq to the list of manufacturers then Compaq
now
appears in the list of Manufacturers when I add a record. It is selectable
now
as well as the already defined Dell and Sun from the pull-down menu. Also,
other fields (like popular cpu speeds, amounts of ram, location, OS
versions, etc)
will be similarly utilized.
Add to this, I want to be able to run canned queries like:
Give me all of the assetts in Andover.
Giveme all the assetts in Andover that have WinNT 4.0 Workstation loaded.
Give me all of the assetts in Andover whose maintenance agreement will
expire in the
next 3 months...etc.
Does anyone have work in progress they would like to share? I have found
a vendor that will sell me such a system but the price is hefty ($25,000+).
-Ed
Ed Sanborn (978) 691-6496
Manager of IT, Andover
Alcatel fax (509) 277-3056
5 Corporate Drive
Andover, MA. 01923 http://www.alcatel.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
