Re: User Login/off data on Power Link
Shuhail Mohamed <shuhail.mohamed-Tk0obHxzyZymfq+dHQEUb0EOCMrvLtNR@public.gmane.org>
| Newsgroups | gmane.comp.systems.as400.mapics |
|---|---|
| Message-ID | <[email protected]> |
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-Zwy7GipZuJhWk0Htik3J/[email protected] [mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Kevin.Gerard-IaJHbxZe/[email protected] [Kevin.Gerard-IaJHbxZe/[email protected]] 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-IaJHbxZe/[email protected] 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-Zwy7GipZuJhWk0Htik3J/[email protected] wrote: ----- To: "'MAPICS ERP System Discussion'" <mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]> From: Shuhail Mohamed <shuhail.mohamed-Tk0obHxzyZymfq+dHQEUb0EOCMrvLtNR@public.gmane.org> Sent by: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] 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-Zwy7GipZuJhWk0Htik3J/[email protected] [[3]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] [[4]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] [[5]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: [6]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 [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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: [8]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 [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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: [10]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 [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-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: [12]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 [13]http://archive.midrange.com/mapics-l. References Visible links 1. mailto:kevin.gerard-IaJHbxZe/[email protected] 2. http://www.triminmfg.com/ 3. mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] 4. mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] 5. mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] 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-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. 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. _______________________________________________ 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.