|
On Thu, 3 Jul 2003 09:35:27 -0400, "Steve Johnson" <sjohnson@xxxxxxxx> 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? >Thanks, >Steve > Sorry for the late reply. You can get the last signon date from the last used date of the *usrprf object. Gord -- Gord Hutchinson Database Administrator, IT TST Overland Express ghutchinson@xxxxxxxxxxxxxxx 905-212-6330 fax: 905-602-8895
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.