Re: Updating PREVIOUS_SIGNON date in User Profile

Hi Brian,

Have a look at Change Previous Sign-On Date (QSYCHGPR) API and see if you can use it.

Best regards

Stefan

-- 
No trees were killed in the sending of this message, but a large number of electrons were terribly upset.

Stefan Tageson
+46 732 369934
stefan-6HgPSzB/[email protected]

-----Original Message-----
From: WEB400 <[email protected]> On Behalf Of Brian Piotrowski via WEB400
Sent: Tuesday, February 27, 2024 8:23 PM
To: [email protected]
Cc: Brian Piotrowski <bpiotrowski-UA/[email protected]>
Subject: [WEB400] Updating PREVIOUS_SIGNON date in User Profile

Good afternoon, everyone.

Wondering if someone has any advice on how to handle this problem...many of our users sign into our web pages which use the IBM iSeries as the backend for the data.  However, unlike when someone logs into a 5250 session, the system does not update the PREVIOUS_SIGNON field in the user profile when they log into the webpage.

So, when I run my report to clear out records that have not logged in, I have these account appearing, which leads to a false positive (they all show up as if the user has never logged on).  Does anyone have any thoughts on either how to update this field manually through an SQL statement, or is there another table or field I can check to see if the user's account has logged in?

Thanks!

/b;

Brian Piotrowski (He/him/his)
IS Manager at Simcoe Parts Service, Inc.

Phone:
705-435-7814 x5995
Cell:
705-440-7430
Email:
bpiotrowski-UA/[email protected]<mailto:bpiotrowski-UA/[email protected]>
6795 Industrial Pkwy, Alliston, ON, L9R 1W1, Canada www.simcoeparts.com<http://www.simcoeparts.com>
[Title: LinkedIn - Description: LinkedIn icon]<https://www.linkedin.com/in/brian-piotrowski-513b1811/>



[cid:[email protected]]
[envimage]
Please consider the environment!  Don't print this email unless you really need to do so!

[sps logo (small)]

CONFIDENTIALITY NOTICE
This e-mail message and any attached files are confidential and are intended solely for the use of the addressee(s) named above. This communication may contain material protected by attorney-client, work product, or other privileges. If you are not the intended recipient or person responsible for delivering this confidential communication to the intended recipient, you have received this communication in error, and any review, use, dissemination, forwarding, printing, copying, or other distribution of this e-mail message and any attached files is strictly prohibited. If you have received this confidential communication in error, please notify the sender immediately by reply e-mail message and permanently delete the original message.

--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing list To post a message email: [email protected] To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/web400
or email: [email protected] Before posting, please take a moment to review the archives at https://archive.midrange.com/web400.


-- 
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/web400
or email: [email protected]
Before posting, please take a moment to review the archives
at https://archive.midrange.com/web400.