[598] in Tooltime
Find Result on Network Logs
daemon@ATHENA.MIT.EDU (Debi Fuchs)
Tue Nov 25 14:37:58 1997
Date: Tue, 25 Nov 1997 14:37:51 -0500
To: dho@MIT.EDU, pragone@MIT.EDU
From: Debi Fuchs <debi@MIT.EDU>
Cc: tooltime@MIT.EDU
Hello David,
I just talked to the Network folks. Here is the result set they would like
when one does a "find by example" on the Network logs:
SELECT
l.mit_log_id "Log",
l.mit_pri_lastname "Last Name",
l.mit_pri_firstname "First Name",
n.mit_net_fo "FO",
substr(to_char(n.mit_sp_fo_ts, 'MM/DD/YYYY'),1,10) "FO Cut",
n.mit_net_acct_no "Acct No"
FROM mit_logs l, mit_ni n
WHERE l.mit_log_id = n.mit_log_id AND [find by example stuff]
If this is not possible in a "query by example", then:
SELECT
mit_log_id "Log",
mit_net_fo "FO",
substr(to_char(mit_sp_fo_ts, 'MM/DD/YYYY'),1,10) "FO Cut",
mit_net_acct_no "Acct No"
FROM mit_ni
WHERE [find by example stuff]
Hope this helps.
-Debi
P.S. There is no "Clear" button on the Network screen. I guess that needs
to be added, too, if one is to be able to do a query by example there.
-------------
Debi Fuchs, Consultant
MIT Information Systems
Computing Help Desk Group
77 Massachusetts Avenue, 11-319
Cambridge, MA 02139
(617) 253-7812
debi@mit.edu
