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@xxxxxxxxxxxxxxx<mailto:bpiotrowski@xxxxxxxxxxxxxxx>
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:image002.png@01DA6988.7D419650]
[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.