Query for users that have not signed on in 60 days or more?
Home > IT Answers > AS/400 > Query for users that have not signed on in 60...
Rrockk2000
5 pts.
0
Q:
Query for users that have not signed on in 60 days or more?
UPPSOD, DSPUSRPRF, Display User Profile, User Profile Name, AS/400 administration
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
ASKED: Feb 17 2009  1:50 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Philpl1jb
24610 pts.
0
A:
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
  • AddThis Social Bookmark Button
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 Answered: Feb 17 2009  2:09 PM GMT by Philpl1jb   24610 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Lovemyi   1470 pts.  |   Feb 17 2009  7:21PM GMT

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.

 

Bsd167   65 pts.  |   Feb 18 2009  7:15AM GMT

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

 
0