Home > IT Answers > AS/400 > Query for users that have not signed on in 60 days or more?
Rrockk2000
20 pts.
 Query for users that have not signed on in 60 days or more?
AS/400 administration, Display User Profile, DSPUSRPRF, UPPSOD, User Profile Name
I need to write a query for users that have not signed on in 60 days or more. I used DSPUSRPRF to an outfile (field) uppsod gt '60' ? i think that is wrong. Thank you

Software/Hardware used:
ASKED: February 17, 2009  1:50 AM
UPDATED: February 18, 2009  7:15 AM
RELATED QUESTIONS
Answer Wiki:
Hi Rrockk2000 Fields that should be useful Previous sign-on century: UPPSOC A 1 Previous sign-on date: YY UPPSOD A 6 Note UPPSOD is A6. it contains a value like 090217 YYMMDD. So you need to compare it with 081217 (for 2 months or you could get fancy and go for 60 days) not with 60 and you are looking for dates that are less than 081217. UPPSOC should contain a 1 (through 2050) a 0 indicates 19' but you probably don't need that,until the year 2100. Phil
Last Wiki Answer Submitted:  February 17, 2009  2:09 pm  by  philpl1jb   44,630 pts.
All Answer Wiki Contributors:  philpl1jb   44,630 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

or you could just run the GO SECTOOLS command menu and run the option as a report only to disable users that have not signed on in xxx days.

Lovemyi
 2,310 pts.
 

From the Security Tools select option 4. Analyze profile activity and insert the Number of inactive days.

Bsd167
 65 pts.