Re: Need "previous sign-on date/time" info for users accessingiSeries through TCP/IP -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

At 08:35 07/03/2003, Steve Johnson wrote:

I'm trying to write a simple query that will show when users last signed on to the AS/400 using our GUI interface (Lawson LID) which accesses the iSeries using a port number created in wrksrvtble to connect through TCP/IP. When I created an output file of DSPUSRPRF data I discovered that the "previous sign-on date/time" fields have no entries for the users that only ever access the AS/400 through the GUI interface. The "previous sign-on date/time" fields apparently only record green-screen sign-ons. Might the information I'm seeking be stored elsewhere (hopefully aside from QHST) so I can easily access it for my simple query?

Far as I know, unless Lawson specifically updates the date, it won't be stored anywhere. You can use the QSYCHGPR API to set the date in an initial program. Just pass a standard API error structure to the API. No other parameters. It's one of the dynamically called APIs, so you don't have to bind a service program or anything. You could even execute it from CL if you wanted to. In RPG, you can prototype it like this:

     D QSYCHGPR        PR                  ExtPgm('QSYCHGPR')
     D  ErrorStruct               32767    Options(*VARSIZE)


Pete Hall
pbhall@xxxxxxxxxxxxx
http://www.pbhall.us/

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.