Re: User Login/off data on Power Link -- MAPICS-L

My initial purpose is to monitor the usage of Power Link, and with your approach definitely I can make use of it further for what you ar edoing.

Thanks Kevin, for your additional thoughts/advice/inputs.

Shuhail
________________________________________
From: mapics-l-bounces@xxxxxxxxxxxx [mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Kevin.Gerard@xxxxxxxxxxxxx [Kevin.Gerard@xxxxxxxxxxxxx]
Sent: Friday, February 26, 2010 8:20 PM
To: MAPICS ERP System Discussion
Cc: 'MAPICS ERP System Discussion'
Subject: Re: [MAPICS-L] User Login/off data on Power Link

This probably isn't what you need or not related, but I'll add this to the
thread. A while back we wanted to monitor Power LInk usage (vs. legacy
activity). The issue was are the people embracing for example entering
PO's using Procurement vs going back to old habits.

We found the MNHHDR/MNHDTL maintenance history files useful. You can query
these directly in Power Link by user. As long as audit/maintenance history
is active, and it already is defaulted on most areas, you can at least get
the volume of activity being done on the client side. In our situation, we
found two buyers not doing what they were trained to do.
Again, not your initial question but wonder if somewhat related.

Kevin

-------------------------------------------
Kevin Gerard, Senior Technical Consultant
TriMin Systems, Inc. - Infor Channel Partner
[1]kevin.gerard@xxxxxxxxxxxxx
Direct 309-932-3103
Mobile 309-883-1689
[2]www.triminmfg.com

"We are committed to helping manufacturing companies improve their
Visibility, Productivity, Growth and Profitability"
-----mapics-l-bounces@xxxxxxxxxxxx wrote: -----

To: "'MAPICS ERP System Discussion'" <mapics-l@xxxxxxxxxxxx>
From: Shuhail Mohamed <shuhail.mohamed@xxxxxxxxxxxxxxxxxxx>
Sent by: mapics-l-bounces@xxxxxxxxxxxx
Date: 02/26/2010 08:16AM
Subject: Re: [MAPICS-L] 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@xxxxxxxxxxxx
[[3]mailto:mapics-l-bounces@xxxxxxxxxxxx]
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@xxxxxxxxxxxx
[[4]mailto:mapics-l-bounces@xxxxxxxxxxxx]
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@xxxxxxxxxxxx
[[5]mailto:mapics-l-bounces@xxxxxxxxxxxx] 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@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: [6]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 [7]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: [8]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 [9]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: [10]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 [11]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: [12]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 [13]http://archive.midrange.com/mapics-l.

References

Visible links
1. mailto:kevin.gerard@xxxxxxxxxxxxx
2. http://www.triminmfg.com/
3. mailto:mapics-l-bounces@xxxxxxxxxxxx
4. mailto:mapics-l-bounces@xxxxxxxxxxxx
5. mailto:mapics-l-bounces@xxxxxxxxxxxx
6. http://lists.midrange.com/mailman/listinfo/mapics-l
7. http://archive.midrange.com/mapics-l
8. http://lists.midrange.com/mailman/listinfo/mapics-l
9. http://archive.midrange.com/mapics-l
10. http://lists.midrange.com/mailman/listinfo/mapics-l
11. http://archive.midrange.com/mapics-l
12. http://lists.midrange.com/mailman/listinfo/mapics-l
13. 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.

Confidentiality and Disclaimer

* This email has been scanned by Hayleys PLC Group IT Risk Management Services *

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the Hayleys PLC system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.