Date:         Mon, 9 Oct 1995 09:31:00 -0700
Reply-To:     The NOMAD2 Discussion List
Sender:       The NOMAD2 Discussion List
From:         Jerry Knowles
Subject:      Re: User Survalance
In-Reply-To:  "Mail dated 95/10/09 15:50:43 UT from (NOMAD2-L) The NOMAD2
              Discussion List"

Hello Daniel,

  I have developed an exec which notifies me when a user logs
onto my system.  My current process is pretty manual; I have
been meaning to evolve it, but there has been no need for it
as yet.

  What I do is call my TRACKLOG exec in the beginning of the nomad
procedure.  So, whenever a user logs onto my system, they call
up the nomad procedure, which calls the Tracklog exec.  In
effect, this exec sends to my account (R18658) reader list
a small file indicating the user's userid, date, and time.
I then have to manually pull the reader file in (at my
convenience) and process it (usually add it to a master file
of total transactions)

  Perhaps you can modify your uproc/rproc statements to
call an exec which does a similar function?  My thoughts
on next steps for this procedure were automating my account
to pull these files in and add them to a NOMAD database.
Anyway, here's the execs:  they query the userid, place
the userid, date, and time onto the stack, create a file on the user's
A disk (called LOG userid A), send the file to me, and then erase the file.


/* TRACKLOG EXEC
MINIATURE EXEC WHICH CALLS MAKELOG - USED FOR TRACKING LOG ONS TO
ACCOUNTS.
CREATED 1/12/95 BY JERRY D. KNOWLES II  */

USERID
pull a1 a2 a3 a4 a5 a6 a7 a8 a9 a10 a11;
makelog a2 a4 a5;

/* END OF TRACKLOG  */


* MAKELOG EXEC
&STACK   INPUT &1 &2 &3
&STACK   FILE
XEDIT LOG &1 A
EXEC SENDFILE LOG &1 R18658
ERASE LOG &1 A

Please let me know if you modify this to an automatic and/or database
program, and how.  The crux of the matter is it has to create some output
on the user's A disk, which is sent to a admin. account, and auto-processed.

Good Luck!
Jerry D. Knowles II
Motorola ASIC Business Systems
R18658@email.sps.mot.com

P.s.  Sorry for the under documentation.

P.p.s.  As I was about to send this off, I saw a new file just arrive
from my TRACKLOG; talk about coincidence!  (Usually only 2-3 a month)


>___Original Letter _______________________________________
>Date: 09 Oct 1995 08:10:30 -0700
>Sender:   The NOMAD2 Discussion List           (NOMAD2-L)
>From:     DANIEL J. YEAGER ([216] 471-6371)    (YEAGERD)
>To:       Multiple recipients of list NOMAD2-L (NOMAD2-L)
>Reply-To: The NOMAD2 Discussion List           (NOMAD2-L)
>Subject: User Survalance
>
>     I have a rather large application that users from two separate
>geographic areas use.  The two areas are competing for the same type
>of work from a series of customers.  I have run into a situation where
>one area is deleting the other areas records and creating their own
>so that the system directs the work their way.  I have put a stop to
>this by checking the user security in the procedures that are used and
>either allow or disallow the action.
>     My situation is that one of the users in the area in question is
>capable of creating procedures that he can give to his users that will
>over ride my changes.  Our environment is VM with Nomad 6.03 and SQL/DS.
>     My question is --- is there a way to have the Schema write info to
>a data audit table if a delete is performed?  I've looked at the Rule
>and uproc statements but these appear to either allow or disallow a
>function, not track a function.  Audit appears to write to a dataset
>and not to a table.  Our users don't access any disks as read/write so
>the only location I could write the audit file to is their 191 disk.
>This would not allow me to view the audit file.  Any ideas?
>                                            Thanks, Daniel J. Yeager
>                                                    Yeagerd@Timken.com
>___End of Original Letter_________________________________
back to index