[463] in Tooltime
New items
daemon@ATHENA.MIT.EDU (Debi Fuchs)
Mon Nov 3 14:36:46 1997
Date: Mon, 3 Nov 1997 14:36:38 -0500
To: tooltime@MIT.EDU
From: Debi Fuchs <debi@MIT.EDU>
Hi there,
Here are some new items. We can talk about priority in tomorrow's
Babs/Steve,Debi meeting.
Cheers,
-Debi
SYSTEM:
=======
Database
1.) Add functionality to cron process to also close Frozen logs which are
marked "Close on Thaw" and for which it is time to "thaw out".
2.) Add a field to the database for hostname in the mit_ni table.
SCOPUS:
=======
1. Repeat the IP address info on the network screen, as it, like the log
number, is important to see it there among the other network-related
information even though it is stored in the main log table, not the network
table.
2. Add a field for hostname (see #2, above), to the scopus network screen.
Web/Oracle
===========
1. Put History and Network Description below all other fields, as the
others are all fixed length, whereas these two fields can flow on and on
for pages, causing any fields below them to be hard to find.
THAT IS:
Helpdesky Sections
Networky Section (site survey, etc.)
Case History (potentially long)
Network Description (potentially long)
INSTEAD OF:
Helpdesky Sections
Case History (potentially long)
Networky Section
Network Description (potentially long)
1.25 Repeat tge "IP Address" field up in the hardware section, not just
have in the networky section, as it is stored in the logs table, not the
network table and is in the initial scopus screen, but should also be near
the network info. This could be done by adding a row as follows:
<TR><TD COLSPAN=6><HR><P></TD></TR>
<tr>
<td valign=top align=right>
<p align=right>Hardware:
</td><td valign=top bgcolor=#ffffff colspan=2 align=left><P>
</td><td valign=top align=right>
<p align=right>Model:
</td><td valign=top bgcolor=#ffffff colspan=2 align=left><P>
</td></tr>
<tr>
<td valign=top align=right>
<p align=right>O.S.:
</td><td valign=top bgcolor=#ffffff colspan=2 align=left><P>
</td><td valign=top align=right>
<p align=right>Version:
</td><td valign=top bgcolor=#ffffff colspan=2 align=left><P>
</td></tr>
<tr>
<td valign=top align=right>
<p align=right>Software:
</td><td valign=top bgcolor=#ffffff colspan=2 align=left><P>
</td><td valign=top align=right>
<p align=right>Version:
</td><td valign=top bgcolor=#ffffff colspan=2 align=left><P>
</td></tr>
<tr>
<td valign=top align=right>
<p align=right>IP:
</td><td valign=top bgcolor=#ffffff colspan=2 align=left><P>
</td><td>
</td><td>
</td></tr>
1.5 Add the following fields to the networky section:
SP
--
Completed
Deployment
-------------
Purchased By:
Hesiod
IP Address (see above)
Hostname (see above)
Completed
Scheduled
Misc
-----
Network Type
Machine Type
Drop Loc
The code could be done by replacing the networky information as follows:
<TR><TD COLSPAN=6><HR><P></TD></TR>
<tr>
<td></td><td valign=bottom align=left><p align=left><i>(Site Prep)</i></td>
<td></td><td valign=bottom align=left><p align=left><i>(Deployment)</i></td>
<td></td><td valign=bottom align=left><p align=left><i>(Misc)</i></td>
</tr>
<tr>
<td valign=top align=right>
<p align=right>Survey:
</td><td valign=top bgcolor=#ffffff align=left><P>
</td><td valign=top align=right>
<p align=right>Purchased By:
</td><td valign=top bgcolor=#ffffff align=left><P>
</td><td valign=top align=right>
<p align=right>Network Type:
</td><td valign=top bgcolor=#ffffff align=left><P>
</td></tr>
<tr>
<td valign=top align=right>
<p align=right>Design:
</td><td valign=top bgcolor=#ffffff align=left><P>
</td><td valign=top align=right>
<p align=right>Hesiod:
</td><td valign=top bgcolor=#ffffff align=left><P>
</td><td valign=top align=right>
<p align=right>Machine Type:
</td><td valign=top bgcolor=#ffffff align=left><P>
</td></tr>
<tr>
<td valign=top align=right>
<p align=right>Estimate:
</td><td valign=top bgcolor=#ffffff align=left><P>
</td><td valign=top align=right>
<p align=right>IP#:
</td><td valign=top bgcolor=#ffffff align=left><P>
</td><td valign=top align=right>
<p align=right>Drop Loc:
</td><td valign=top bgcolor=#ffffff align=left><P>
</td></tr>
</td></tr>
<tr>
<td valign=top align=right>
<p align=right>FO Cut:
</td><td valign=top bgcolor=#ffffff align=left><P>
</td><td valign=top align=right>
<p align=right>Hostname:
</td><td valign=top bgcolor=#ffffff align=left><P>
</td><td valign=top align=right>
<p align=right>FO#:
</td><td valign=top bgcolor=#ffffff align=left><P>
</td></tr>
<tr>
<td valign=top align=right>
<p align=right>Completed:
</td><td valign=top bgcolor=#ffffff align=left><P>
</td><td valign=top align=right>
<p align=right>Completed:
</td><td valign=top bgcolor=#ffffff align=left><P>
</td><td valign=top align=right>
<p align=right>Req#:
</td><td valign=top bgcolor=#ffffff align=left><P>
</td></tr>
<tr>
<td></td><td>
</td><td valign=top align=right>
<p align=right>Scheduled:
</td><td valign=top bgcolor=#ffffff align=left><P>
</td><td valign=top align=right>
<p align=right>Account#:
</td><td valign=top bgcolor=#ffffff align=left><P>
</td></tr>
2. Add the Freeze Date, Close on Thaw Date, and Taker under the Log Number,
Category, and Status, respectively. This should only be on the log page
for consultants, not clients.
<tr>
<td valign=top align=right>
<p align=right>Freeze:
</td><td valign=top bgcolor=#ffffff align=left><P>nbsp;
</td><td valign=top align=right>
<p align=right>CloseOnThaw:
</td><td valign=top bgcolor=#ffffff align=left><P>nbsp;
</td><td valign=top align=right>
<p align=right>Taker:
</td><td valign=top bgcolor=#ffffff align=left><P>nbsp;
</td></tr>
3. Make the category and the status red, as has already been done with
several other fields.
4. Make email to user read something like:
To:
Subject: Help Desk Log XXXXXX
Your case (#xxxxxx) with the MIT Computing Help Desk has been updated as
follows. Please contact us at 3-1101 (Mac), 3-1102 (PC), 3-1103 (UNIX), or
3-1104 (General) for further information, or reply to this email.
=========================
(new stuff)
=========================
Your case history now reads
============================
Case History
============================
Sincerely,
The MIT Computing Help Desk
5. Put 'client' in Received by and Modified by field when client submits a log.
6. Pub 'client' in Modified by field when client adds an entry to a log.
7. Change log status to 'Unseen' when client adds an entry to log.
8. Indicate entries made by clients as follows:
10/31/97 @ 10:52:26 AM - joe (client) - blah blah blah.
instead of
10/31/97 @ 10:52:26 AM - joe - blah blah blah.
9.) Add following to the IP address request section on the submit screen
(under the checkbox: "If so, please include the following information:
hostname, machine location, and account number."
-------------
Debi Fuchs, Consultant
MIT Information Systems
Computing Help Desk Group
77 Massachusetts Avenue, 11-319
Cambridge, MA 02139
(617) 253-7812
debi@mit.edu
