Thank you! 😊
/b;
Brian Piotrowski
Manager, I.S.
-----Original Message-----
From: WEB400 <web400-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of stefan@xxxxxxxxxx
Sent: Tuesday, February 27, 2024 2:31 PM
To: 'Web Enabling the IBM i (AS/400 and iSeries)' <web400@xxxxxxxxxxxxxxxxxx>
Subject: Re: [WEB400] 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@xxxxxxxxxx
-----Original Message-----
From: WEB400 <web400-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Brian Piotrowski via WEB400
Sent: Tuesday, February 27, 2024 8:23 PM
To: web400@xxxxxxxxxxxxxxxxxx
Cc: Brian Piotrowski <bpiotrowski@xxxxxxxxxxxxxxx>
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@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.
--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing list To post a message email: WEB400@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxxxxxxxx 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: WEB400@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxxxxxxxx Before posting, please take a moment to review the archives at
https://archive.midrange.com/web400.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CAUTION: This email originated from outside of the organization. Please do not click links or open attachments unless you recognize the sender and know the content is safe.
PRECAUCI?N: Este correo electr?nico se origin? desde fuera de la empresa. NO HAGA!!! clic en los enlaces(links), NI ABRA!!! los archivos adjuntos a menos que reconozca al remitente y sepa que el contenido es seguro.
??:?????????????????????????????????????????????????????????????????????????????????????
midrange.com
