All, this is the first version that has been released for some time. Previous
versions can be found on the sourceforge site under the old name ats-system.

You can find and download this release in the Download section of this site.


Here is the version history since the last official release...
-----------------------------------------------------------------------------
GLEAM Version 1.3 Copyright 2004-2008
-----------------------------------------------------------------------------

GLEAM HISTORY
=============

2006-04-26
----------
Changed the name and version from ATS version 0.90B to GLEAM version 1.0

Started taking notes on changes - all changes prior to this date were unrecorded.

2006-06-24
----------
Added cell phone tracking for vendor contacts.

Added floor/locations to contacts search page.

Changed quick search for assets to include name, trackname and make/model.

2006-06-26
----------
Fixed short list of history objects that lost page breaks and had inserted \'s

2006-06-27
----------
Moved ticket buttons into seperate routine ticket_process_options() in
gleam-module-ticket.php
- To allow icons in middle and bottom of ticket screen

Disabled the ability for users to update without e-mail notification unless
e-mail notification is turned off in the GLEAM Configuration
- Also fixed icon spacing for all users.

Added monitor calibration tracking and reports.

2006-06-28
----------
Added "Assign To" button to asset display page so you can assign the asset
you are actually looking at.

Fixed "Assigned To/From" auto-generated history notes.

2006-06-30
----------
Fixed display of Default Software/Services for Contacts that do not
have any machines assigned as well as showing only active assets.

Fixed display of Software/Software-Service licenses when 0 licenses
have been specified.
2006-07-03
----------
Created new people.php for allowing all employees to search the
contact database without having to create user accounts.

Changed gleam-search-contacts.php to reflect contact view in
people.php - Now shows 4 people per line w/name, dept, phone, email.

Added definition of global variable $PREFIX in wantMAIL() routine
so e-mail graphic displays properly in some setups.

2006-07-04
----------
Added field personalshow to assets database to allow the showing
of personal cell phone or home phone number in contact search.

Added missing </td> in team leader field view.

2006-07-05
----------
Added lease period to configurable drop-downs so values can be
changed by administrators.

Created inventory.export and change.emaildomain scripts.

2006-07-10
----------
Added setup configuration variable $GLEAMOS to add differences
between Linux and Windows operating systems.

Fixed gleam-process-assets.php to include reporting of changes
for all fields.

Fixed gleam-process-assets.php to change entries with ' character
to save with a \' for Windows operating system.

2006-08-21
----------
Added setup configuration variables to allow modifying MySQL variables

$cfg_dbname - Name of MySQL Database Host machine (default: localhost)
$cfg_dbdb - Name of MySql Database (default: gleam)

2006-08-23
----------
Released GLEAM Version 1.0 on http://sourceforge.net

Old version had 2248 downloads since April 1st, 2006.

2006-08-24
----------
Added desk extension to field to search for on contacts/people pages.
2006-08-29
----------
Re-Used phone, phonedesk and personal fields to record digital, ext,
and analog phone numbers for areas.

Added display of Area phone numbers (if entered) in area search.

2006-09-01
----------
Added LDAP authentication support.

Added the following setup configuration variables to gleam.conf.inc

$cfg_ldap - use LDAP server for authentication (on or off)
$ldap_server - hostname of ldap server
$ldap_proto - ldap protocol version (ie. "3")
$ldap_rootdn = ldap rootdn (ie. ou=people,dc=gargoylelogic,dc=com)
$ldap_login = ldap login filter (ie. uid);

Created new places.php for allowing all employees to search the
common area database without having to create user accounts.

Changed gleam-search-areas.php to reflect common area view in
places.php - Similar to people.php for Areas.

2006-09-05
----------
Changed all "dropdown" menus to save with URL encoded strings.

Fixed issue with using spaces (or other bad characters) in
the office/site modules.

2006-09-06
----------
Added office to display and sort by name/department/project in
search for gleam-search-contact.php and people.php pages.

2006-09-08
----------
Fixed lost contact entries when adding a new vendor.

2006-09-13
----------
Updated ticket e-mail headers to include UPDATE and short
message of what actually changed for quicker reference by users.

2006-09-14
----------
Re-used $personalshow variable for Areas to identify if analog
number is used for a fax machine or conference phone.

2006-09-15
----------
Fixed URL encoding/decoding issues for ticket modules.

2006-09-19
----------
Fixed growing GLEAMBACK sting reference in URL's to calculate
last page visited by truncing multiple GLEAMBACK entries.

This fixes browswer issues when editing mutiple entries in
one session.

2006-09-21
----------
Added E-Mail aliases in user drop down menu for CC E-Mail Responses
fields in tickets so users can send e-mail to multiple groups.

Added the following setup configuration variables to gleam.conf.inc

$ticket_aname[0-29] - used for ticket e-mail aliases display names
$ticket_amail[0-29] - used for ticket e-mail addresses

2006-10-02
----------
Fixed various urldecode text displays throughout all modules for
both screen display and e-mails.

2006-10-12
----------
Changed field display order for tickets and added reverse sorting
for various fields in the ticket search module.

Changed Severity field to display only the number instead with
associated colour instead of full name to reserve space.

Removed ability to change dropdown options that should not be
changed for proper program functionality.

Status/Locations/Departments
- Asset Status
- Asset Type

Networking Peripherals
- Network Port Status

Projects/Tickets/History
- Project Status
- Project Roles
- Ticket Status
- Ticket Severity

2006-10-24
----------
Removed Operating System and IP Address from default Associated
Assets View for cleaner display purposes.

2006-10-25
----------
Updated gleam-report-ticket.php to reflect the same information
as reported in gleam-search-tickets.php
2006-10-26
----------
Updated login code to update users passwords when using LDAP
authentication. This will also create a default users with a
locked status in the administrator accounts table (users).

2006-11-06
----------
Re-Used calibration asset variable for "Area" assets to be
associated with "Allow users to see associated assets". This
will allow the viewing of assets in common areas in the Area
search as well as the places.php pages.

Re-Used lockkey asset variable for "Area" assets to be
associated with "Capacity" to display number of people able
to fit in meeting rooms, etc.

Changes gleam-search-area.php and places.php view back to one
area per line to allow showing of assets from above change.

2006-11-24
----------
More url decode/encode changes throughout the application.

Changed gleam-module-resource.php to only show contacts
that have active accounts.

2006-11-30
----------
Fixed gleam-assign-license.php to record lost history info
on users fullname and location.

Added new run once script fix.historyclean to fix lost
information from above change as well as remove all history
items for assets that no longer exist in the database.

Added new asset type "HW-Rack" so assets can be assigned to
the rack, then the rack can be assigned to an area.

2007-01-10
----------
Created PHP script gleam-update-database.php to check and
make changes to the gleam database and make required changes
for new versions

Currently this script updates employee names with URL encoded
name and then updates all associated tickets to match the
users URL encoded name.

2007-01-19
----------
Fixed URL to long error when editing large software licenses.

Fixed assignment of tickets when changing an administators
login account.

2007-02-01
----------
Added "Jump to name starting with:" in user administrator
accounts to save time scrolling through large list of names
with updates.

Added "DELETE" button for locked administrator user accounts.

2007-02-08
----------
Fixed ureport-projects script to not send e-mail if there are
no open projects in the queue.

2007-02-09
----------
Added Image_Graph libraries into gleam.include directories to
start building reporting graphs.

Create reporting pie chart to show open tickets for each year,
breaking down open tickets by month. (gleam-info-ticket.php)

2007-02-15
----------
Added NEW HIRE Form for managers to fill out that creates a new
ticket. This allows mangers to select where the person will sit
what hardware, estimated start date, E-Mail aliases and access
requirements. A single ticket containing all the information
is created in the UNASSIGNE queue when completed.

Updated E-Mail aliases for user drop down menu CC E-Mail Responses
fields to hold 120 values instead of 30.

$ticket_aname[0-119] - used for ticket e-mail aliases display names
$ticket_amail[0-119] - used for ticket e-mail addresses

Added Access aliases for use with NEW HIRE form these are stored
in the gleam.conf.inc file and can be edited from the configuration
menu.

$access_aname[0-29] - used for network/resource access display names

New modules create:

gleam-module-newhires.php
: To fill out the form.

gleam-process-newhires.php
: To process the data, creat and send ticket e-mail.
2007-02-16
----------
Started working on Skills Matrix module to determine cross reference
on skills required for cross-training on various jobs types and job
functions.

Extended users ACL's to include fields for new SKILLS MATRIX module.

Added Tools - Skills Matrix to Information menu.

Updated Slider and Range java script to pass maximum range size.

2007-02-19
----------
Added new tables skills and skills_values to record data for the
skills matrix module. By using gleam-update-database.php it will
create these tables for you if they don't already exist.

2007-02-21
----------
Added link in gleam-module-active for ticket users to access the
self ranking portion of the skills matrix.

Created new modules for Skills Matrix.

gleam-module-skillsmatrix-jobs.php
: to add/modify/delete positions

gleam-module-skillsmatrix-skill.php
: to add/modify/delete skills

gleam-module-skillsmatrix.php
: to modify Contacts acquired skills
: also to report matching positions and alert required
skills for other positions in the matrix

gleam-process-skillsmatrix.php
: to update all skill matrix changes

2007-02-22
----------
Created new module for searching for people with specific skills
or users that match skill requirement for specific positions.

gleam-search-skillsmatrix.php
: to search for specific skills/positions.

2007-03-05
----------
Created new module to show summary of skills matrix positions
compared to list of required skills. Also, added an "interested"
field for self ranking matrix so that managers can do reports on
total people interested in taking particular skills training.

gleam-report-skillsmatrix.php
: to show summary of skills/positions.
2007-03-09
----------
Fixed gleam-module-menu.php to get proper window width and height
as well as fixing scroll frames for Internet Explorer.

GLEAM should now work with Mozilla, Firefox, an IE7.

2007-03-14
----------
Added capability to turn disable certain modules to reduce the menu
drop downs for modules that may not be used in certain offices.

Added the following setup configuration variables to gleam.conf.inc

$cfg_ticks - ticket modules (on or off)
$cfg_calbs - calibration modules (on or off)
$cfg_projs - project modules (on or off)
$cfg_skills - skill matrix modules (on or off)

2007-05-30
----------
Added capability to monitor Foundry Switches for network usage. On
Foundry switches you can enable/disable ports using SNMP. The port
alias will also be set when a port is assigned.

Changed look of network ports look. Monitored ports show MB used,
octets, packets, bcats, mcasts, collisions. Unmonitored ports show
the same way they did before.

Switches are monitored by using command line call to snmpset and
snmpget. This must be in your path to work correctly.

Added the following setup configuration variables to gleam.conf.inc

$NUMAX - maximum network bandwidth used before being
disabled. 0 to turn of automatic disabling.

$NWARN - % of $NUMAX before sending a warning e-mail

$dis_ports - enable automatic disabling of ports that go
past the maximum bandwidth usage.

2007-05-31
----------
New Scripts added for network monitoring modules:

ureport-abuse - to report all disabled ports as well as
ports reaching withing the warning
threshold

- this will also disable ports if they
reach the $NUMAX amount and $dis_ports is
set to "on"

treport-abuse - text report of all current monitored ports
sorted by usage since last counter reset

ureport-clearports - to clears all counters on monitored ports

ureport-network - to report all monitored ports

2007-07-13
----------
Re-wrote gleam-search-contacts and people to sort by name,
department and project better as well as choice to view
list with or without pictures.

2007-09-19
----------
Added code to include serial #'s in the asset quick search to
speed up inventory references.

Update LDAP code to allow binding to ldap servers that do not
allow Anonymous binding. Tested this against Active Directory
server with Windows 2003 Server.

Need to set $ldap_login to "sAMAccountName" for Windows AD.

Added the following setup configuration variables to gleam.conf.inc

$ldap_blogin = ldap bind login (ie. apacheldap@gargoylelogic.com)
$ldap_bpasswd = ldap bind login password

2007-10-26
----------
Updated Skills Matrix searches to not include non-Active contacts.

Changed default user account privileges to not include projects,
all disabled user accounts were showing up as project resources.

Fixed some urldecode issues2008-01-07
----------
Added "Assigned Location" for Contact assets to use the assignee
field. This is so that Area assets can be used as locations of
where Contacts are located.

Increased Contact picture size from 90x120 to 120x160 in asset
view and people contact search pages.

2008-03-03
----------
Fixed ldap login with blank password.

2008-03-26
----------
Added redirect for login timeouts to go directory back to
the login screen from the gleam-module-active.php module.

2008-04-10
----------
Fixed ticket module to only show active assets.

2008-04-21
----------
Added Phone Jack and Phone TN to asset Areas to link sites
with PBX phone system. Added these values to the contacts
page to be shown when pictures are turned off.

2008-04-23
----------
Added ulocator and locator.py scripts to generate location
maps (in pdf format) that link with assigned locations

Added security groups info to be shown in new hire form so
systems admins know which groups users should belong to.

Added the following variables to the gleam.conf.inc file:

$security_aname[0-29] - used for available security group lists

2008-05-13
----------
Added field etstime to assets_tickets table to allow the selection
of estimated ticket resolution time for tickets.

Added dropdown_ticket_esttime table for selectable values.

Ticket lists now show calculation of estimated time for resolution
of tickets.

Updated gleam-update-database for new database changes.
with some of the project/task fields.