Title: Inventory System for SASS
Abstract:
Student Academic Success Service (SASS) is a group of services
provided for students at the University of Ottawa, the SASS-IT team
is a group within SASS that is responsible for the purchasing and
deployment of hardware and software for every other group within
SASS. This has created a need for a new tool that will be used by
the staff of SASS-IT to manage inventory. This application was built
using the following technologies:MySQL: database layer, PHP: server
side scripting and an interface to MySQL, CSS 3 and HTML 5:
presentation layer with an open mind to making websites accessible,
JavaScript: improve client side interaction through jQuery. The
primary goal of the project is to analyze the requirements, design,
develop and deploy an application that will allow SASS-IT to
efficiently manage its inventory of hardware and software.
The high level features required include (but are not limited to):
Be able to add hardware and software items with relevant information
about these items: such as MAC address, IP address, software license
keys, etc.
Be able to add/edit/discard (without entirely removing from
database) the equipment
Be able to use a tagging system to tag items (for example use a
“Accessibility” tag to label equipment for accessibility needs)
Allow IT staff to track the age of an item, to assist in managing
resources and replacement plans – it is important to track and
remind the IT team about expired warranties, employees that no
longer work for the department assigned to the equipment and so
forth
Associate users to equipment so that an administrator can track the
equipment that has been assigned to a user