Re: Disabled User Profiles

An interesting article (at least I think so) on this:
http://www.mcpressonline.com/tips-techniques/security/techtip-clean-up-those-unused-user-profiles.html

Leo
--
Leo Ridderikhoff
SafeWare v.o.f.



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: 09 March 2011 20:46
To: Midrange Systems Technical Discussion
Subject: RE: Disabled User Profiles

Program? Who needs a stinking program?

SELECT upuprf, upstat, qcmdexc('DLTUSRPRF ' CONCAT UPUPRF)
FROM routines/userlist
WHERE UPSTAT='*DISABLED'

Whether or not doing it this way is a good idea, I'll leave up to you.
(ie, do you really want to delete all disabled user profiles?)

Rob Berendt
--
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: "Needles,Stephen J"
To: "Midrange Systems Technical Discussion"

Date: 03/09/2011 03:37 PM
Subject: RE: Disabled User Profiles
Sent by: midrange-l-bounces@xxxxxxxxxxxx



Forgot to mention that you will need to run this as a user with *SECADM
authority or you will not "see" them all.

And since you are running this with all of this power, you could
probably
develop a program to use this table as a feed to delete these profiles
as
well.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [
mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Needles,Stephen J
Sent: Wednesday, March 09, 2011 2:27 PM
To: Midrange Systems Technical Discussion
Subject: RE: Disabled User Profiles

DSPUSRPRF USRPRF(*ALL)
OUTPUT(*OUTFILE)
OUTFILE(QTEMP/USERS)

Then run SQL, WRKQRY or what have you to select those rows whose UPSTAT
value is *DISABLED.

steve

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [
mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Robert Ostrowski
Sent: Wednesday, March 09, 2011 2:08 PM
To: Midrange Systems Technical Discussion
Subject: Disabled User Profiles

Over time, bad economy, and downsizing, we've ended up with a lot of
user profiles on the system
for people that are no longer with the company and have been *DISABLED.

Is there a quick way to get a report out to a file of all disabled user
profiles as opposed to going through
them all one by one?

Thanks for any help.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.