Figure 1 • Maintenance log for an Imaging unit
runs on Windows servers and generates
web pages under program control. ASP
is able to interact with SQL Server to pull
desired information from the database
and generate HTML code which is sent to
the browser of a client computer. The end
user is only able to see the generated web
page and has no access to either the ASP
code or the underlying database. Thus the
programmer has full control over what
information is available and its format.
As the department grew in the 1980s, it
became apparent that paper-based files
were no longer sufficient to allow proper
management of equipment maintenance.
A relational database was created to log
service calls and originally included call
details such as the stated problem, call
initiator, and the repair service to which
the call was assigned. The database was
expanded several years ago to allow dis-
play of service tickets submitted by repair
personnel. Initially, service tickets were
scanned but now most service provid-
ers submit tickets via email as PDF files.
Each service ticket file is saved on the web
server and linked to the original service
call. This allows users to view the com-
plete chain of events for a maintenance
event from the initial call through the
actual service ticket describing resolution
of the problem.