Hi James,
To extract AS/400 login & logout times you can use the system history log
(QHST) using the following command:
DSPLOG PERIOD((*AVAIL &BDTT) (*AVAIL &EDTT)) OUTPUT(*PRINT)
MSGID(CPF1124 CPF1164)
[&BDTT = Beginning time, &EDTT = Ending time, CPF1124 = Job/Session start
time, CPF1164 = Job/End time].
Then do few coding to copy the spool file to a physical file and read the
data from the file using field positioning/data structures. To find out a
user's one instance of login and logout time, use the Job number as the key
to map CPF1124 record and CPF1164 record.
Regards
Shuhail
Senior Manager - Application Systems, Hayleys PLC, 25 Foster Lane, Colombo
10, Sri Lanka. www.hayleys.com <
http://www.hayleys.com/>
_____
From: LeLeux@xxxxxxxxxxxx [mailto:LeLeux@xxxxxxxxxxxx]
Sent: Wednesday, February 06, 2008 10:31 PM
To: shuhail.mohamed@xxxxxxxxxxxxxxx
Subject: Re: [MAPICS-L] User Session Variables
Yes, exactly.
Thanks Shuhail.
Suhail Mohamed <shuhail.mohamed@xxxxxxxxxxxxxxx>
Sent by: mapics-l-bounces@xxxxxxxxxxxx
02/05/2008 09:21 PM
Please respond to
MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
To
MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
cc
Subject
Re: [MAPICS-L] User Session Variables
Hello James,
Do you want to extract AS/400 login/logout time or MAPICS session
login/logout times (in our case for some users they are not the same)?
Regards
Shuhail
Senior Manager - Application Systems, Hayleys PLC, 25 Foster Lane,
Colombo 10, Sri Lanka. www.hayleys.com
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of LeLeux@xxxxxxxxxxxx
Sent: Wednesday, February 06, 2008 7:22 AM
To: MAPICS ERP System Discussion
Subject: [MAPICS-L] User Session Variables
Hello group,
Has anyone ever extracted user start and stop times from sessions to
determine when an employee started working, and then ended?
I tried searching google and midrange.com, but did not find much.
I also see that the user profile has a 'last logged in time', but is not
extractable.
Although I toying with the idea of creating a custom initial program for
the user ID that will record start/stop time.
Any tips would be appreciated, as you can guess we want to compare it to
the clock in/out times.
Thanks in advance for your ideas...james
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/mapics-l.
As an Amazon Associate we earn from qualifying purchases.