× 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.



Rob,

Could you use EIM for that user?

-Eric

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Thursday, September 24, 2009 9:46 AM
To: Midrange Systems Technical Discussion
Subject: Notifying C/S users to change their passwords

Think this, the only access a user uses on the i is a shared drive via
NetServer. QPWDEXPITV is set to 90 days. He's set to *SYSVAL. I don't

believe that connecting to the share will activate the window "Dude, you

password will expire in x days, would you like to change it now?". How
do
you notify them?


create table rob/userexp as (
With T1 as(
SELECT UPUPRF as UserId, UPTEXT as Text,
Date('20' concat substr(UPPWCD,1,2) concat '-' concat
substr(uppwcd,3,2) concat '-' concat substr(uppwcd,5,2))
as PassWordChanged,
Date('20' concat substr(UPPSOD,1,2) concat '-' concat
substr(UPPSOD,3,2) concat '-' concat substr(UPPSOD,5,2))
as SignOnDate,
days(current date) - days(
Date('20' concat substr(UPPWCD,1,2) concat '-' concat
substr(uppwcd,3,2) concat '-' concat substr(uppwcd,5,2)))
as ChangedDaysAgo,
days(current date) - days(
Date('20' concat substr(UPPSOD,1,2) concat '-' concat
substr(UPPSOD,3,2) concat '-' concat substr(UPPSOD,5,2)))
as SignedonDaysAgo
FROM userlist
where upstat<>'*DISABLED' and UPPWEI<>-1 and uppsod<>' ')
select * from t1
where ChangedDaysAgo>70
and SignedonDaysAgo<45
) with data

Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.