RE: Bulk delete of user profiles

I can't count the number of times I've used Excel or NotePad++ to do exactly that...



-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Don Brown via MIDRANGE-L
Sent: Tuesday, January 19, 2021 3:59 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Cc: Don Brown <DBrown@xxxxxxxxxx>
Subject: RE: Bulk delete of user profiles

Thanks for the suggestions.

As there was no way to set filters to select the profiles to be deleted I
ended up writing a program.

I had an excel list of the profiles to be deleted so I used the excel
concatenate function to create the dltusrprf command and the profile name
etcetera.

Then copy and paste into RDi.

Compile
Run

Done in 11 minutes.


Don







From: "Rob Berendt" <rob@xxxxxxxxx>
To: "Midrange Systems Technical Discussion"
<midrange-l@xxxxxxxxxxxxxxxxxx>
Date: 19/01/2021 10:31 PM
Subject: RE: Bulk delete of user profiles
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxxxxxxxx>



There's a few parts:
- Selecting the user profiles
- Determining what actions should be taken with objects they own.
- Deleting the user profiles

You could write a program to cycle through this:
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Furldefense.proofpoint.com%2Fv2%2Furl%3Fu%3Dhttps-3A__www.ibm.com_support_knowledgecenter_ssw-5Fibm-5Fi-5F74_rzajq_rzajqviewuserinfo.htm%26d%3DDwICAg%26c%3DeuGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM%26r%3DKys-lxRCMpPr7up01Pp1FRjOe49ne6imWwi1b-ue8yQ%26m%3D-U-GyW-Nd1CM0nAhRfsrbuov-yEeIJNjMIqBGvsz7pg%26s%3DF7LHPN8qTkfnhy1IL8JOmKYgn76G3pG18cUsj01hTHY%26e%3D&amp;data=04%7C01%7C%7C1d0822e4e685459cba8908d8bcd64c68%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637466975877388768%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=SA9rE9ZvDbNDePW8tBPB0ENvwdGi2WGBouIxrPZuR9Y%3D&amp;reserved=0


If you want to just delete the owned objects, or just assign all of them
to someone else those are options on DLTUSRPRF ... OWNOBJOPT(*CHGOWN SSA)
If you want to be more granular on it there's
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Furldefense.proofpoint.com%2Fv2%2Furl%3Fu%3Dhttps-3A__www.ibm.com_support_knowledgecenter_ssw-5Fibm-5Fi-5F74_rzajq_rzajqviewobjown.htm%26d%3DDwICAg%26c%3DeuGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM%26r%3DKys-lxRCMpPr7up01Pp1FRjOe49ne6imWwi1b-ue8yQ%26m%3D-U-GyW-Nd1CM0nAhRfsrbuov-yEeIJNjMIqBGvsz7pg%26s%3Di5bH7tGOGIfIQo46kCX59cpOLKCTXhM-j9tu5nkB6Bo%26e%3D&amp;data=04%7C01%7C%7C1d0822e4e685459cba8908d8bcd64c68%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637466975877388768%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=iI3jUfoBG%2B%2B7Rh8E4b2g6eOi5uU3eGG8W9u5D9WSpA0%3D&amp;reserved=0


If you got some grit you could write this all as an SQL stored procedure.
Set up a cursor on user_info, call this
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Furldefense.proofpoint.com%2Fv2%2Furl%3Fu%3Dhttps-3A__www.ibm.com_support_knowledgecenter_ssw-5Fibm-5Fi-5F74_rzajq_rzajqprocqcmdexc.htm%26d%3DDwICAg%26c%3DeuGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM%26r%3DKys-lxRCMpPr7up01Pp1FRjOe49ne6imWwi1b-ue8yQ%26m%3D-U-GyW-Nd1CM0nAhRfsrbuov-yEeIJNjMIqBGvsz7pg%26s%3DKopG_5cwd5GWKqF_k68tqFutk1Zt_K3ANTn9S780XCk%26e%3D&amp;data=04%7C01%7C%7C1d0822e4e685459cba8908d8bcd64c68%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637466975877388768%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=SIBRKKZOtgysaDMg13Zfxcyji2E3WWV3gdbdoK8jiuI%3D&amp;reserved=0

to call either DLTUSRPRF, or CHGOBJOWN or CHGOWN then DLTUSRPRF

Rob Berendt