Re: User Login/off data on Power Link

Dear Kevin, Rick, Joe, Josh, Rad, James,

Thanks a lot to all of you for your responses. I'm extremely sorry about
this delayed response. I was at a program during last few days and couldn't
access the email on a regular basis due to the nature of the program I was
attending. 

Kevin/Rick : Yes, Link manager gives the detail but I want to access it from
a database to run my own programs for certain analysis which should include
other AS/400 application access running on the server including few
environments on Rel 6.0.

Rad : Might be able to use it for my purpose. As you have said correctly it
might be lengthy process.

Joe : Looks I might be able to make use of your solution easily.

Once again thanks to all of you and for the forum as well.

Rgds
Shuhail




-----Original Message-----
From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]]
On Behalf Of Kevin D. Fox
Sent: Monday, February 22, 2010 9:50 PM
To: 'MAPICS ERP System Discussion'
Subject: Re: [MAPICS-L] User Login/off data on Power Link

Link Manager (R7.8) gives you the details.  Enjoy.

-----Original Message-----
From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]]
On Behalf Of Joe Perrault
Sent: Monday, February 22, 2010 7:14 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] User Login/off data on Power Link

You can query the file LOGINS in AMCESSQL but you need to change the
CCSID of your job to 37 (CHGJOB CCSID(37)).  This will make the file
'readable' and you will have to decipher the start and stop times as
they are linux/unix timestamps. These timestamps refer to the number of
seconds past midnight, January 1, 1970.  There are probably some web
scripts to convert these.

Joe Perrault

-----Original Message-----
From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]
[mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Shuhail Mohamed
Sent: Sunday, February 21, 2010 5:28 AM
To: MAPICS ERP System Discussion
Subject: [MAPICS-L] User Login/off data on Power Link

Hi Group,

Can some one let me know how to extract user log in and log out times of
power link (Rel 7.8) user sessions? The file LOGINS on AMCESSQL library
in
unreadable. I need to accumulate the usage of Power link sessions by
user ID
for a given day/period.

Thanks in advance
Shuhail

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
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-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
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-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
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-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.