Thanks Michael, I was looking for an SQL way to do it. I guess I should have mentioned that in my original post.
Dean Eshleman
Software Development Architect
Everence
1110 North Main Street
PO Box 483
Goshen, IN 46527
(800) 348-7468 ext. 3528
(574) 533-9515 ext. 3528
[Join our Talent Network]<
http://www.everence.com/careers>
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Michael Mayer
Sent: Friday, September 15, 2023 4:08 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: [EXTERNAL] RE: . Re: Finding libraries in BRMS control groups
This email originated outside of Everence. Do not click links or attachments unless you recognize the sender.
In fact this is better for lists - added an order by:
select * from qusrbrm.qa1aob;
order by olname, ollib
Respectfully,
Michael Mayer
IBM i on Power System Admin
ERMCO-ECI
2225 Industrial Rd
Dyersburg, Tennessee 38024
Office and OnCall: 731.676.4318
Cell: 518.641.8906
Email: michael.mayer@xxxxxxxxxxxxx<mailto:michael.mayer@xxxxxxxxxxxxx>
https://www.ermco-eci.com/<
https://www.ermco-eci.com>
IBM i Personal Blog:
https://ibmireference.blogspot.com/<
https://ibmireference.blogspot.com>
"Success is not final. Failure is not fatal. It is the courage to continue that counts".
-----Original Message-----
From: Michael Mayer
Sent: Friday, September 15, 2023 3:05 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: . Re: Finding libraries in BRMS control groups
Jim's spot on but also here's an alternative for future ref using SQL.
For BRMS control group listings:
SELECT * FROM qusrbrm.qa1acg;
ORDER BY CNTLIST
For BRMS Lists:
select * from qusrbrm.qa1aob;
Respectfully,
Michael Mayer
IBM i on Power System Admin
ERMCO-ECI
2225 Industrial Rd
Dyersburg, Tennessee 38024
Office and OnCall: 731.676.4318
Cell: 518.641.8906
Email: michael.mayer@xxxxxxxxxxxxx<mailto:michael.mayer@xxxxxxxxxxxxx>
https://www.ermco-eci.com/<
https://www.ermco-eci.com/>
IBM i Personal Blog:
https://ibmireference.blogspot.com/<
https://ibmireference.blogspot.com/>
"Success is not final. Failure is not fatal. It is the courage to continue that counts".
1. Re: Finding libraries in BRMS control groups (Jim Oberholtzer)
----------------------------------------------------------------------
message: 1
date: Fri, 15 Sep 2023 14:01:56 -0500
from: Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx<mailto:midrangel@xxxxxxxxxxxxxxxxx>>
subject: Re: Finding libraries in BRMS control groups
There are two places. First look at the control groups to see if they are listed there. Typically we just use *ALLUSR in which case you have nothing to do.
The second place is to look in the BRMS lists to see if they are in a list.
Jim Oberholtzer
Agile Technology Architects
Office: 414-433-4363
Mobile: 414-915-1445
Sent from mobile device
On Sep 15, 2023, at 1:42 PM, Dean Eshleman via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>> wrote:
?Hi,
I uninstalled a product on our system and deleted the associated libraries. How can I search BRMS to see if the libraries are in any of the control groups?
Dean Eshleman
Software Development Architect
Everence
1110 North Main Street
PO Box 483
Goshen, IN 46527
(800) 348-7468 ext. 3528
(574) 533-9515 ext. 3528
[Join our Talent
Network]<https://nam12.safelinks.protection.outlook.com/?url=http%3A%252<https://nam12.safelinks.protection.outlook.com/?url=http%3A%252>
F%2Fwww.everence.com%2Fcareers&data=05%7C01%7Cmichael.mayer%40ermco-ec
i.com%7Cb5fe65acfb964ca694bd08dbb6227a70%7Cd2deeaf270e4425c91d7d99d784
e89d6%7C0%7C0%7C638304031443677173%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4
wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7
C&sdata=v2uiStWHQp09ttgr3S56evtc9EP93OL9BHlb%2FiptCHM%3D&reserved=0>
Confidentiality Notice: This information is intended only for the individual or entity named. If you are not the intended recipient, do not use or disclose this information. If you received this e-mail in error, please delete or otherwise destroy it and contact us at (800) 348-7468 so we can take steps to avoid such transmission errors in the future. Thank you.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx> To
subscribe, unsubscribe, or change list options,
visit:
https://list/
s.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l<http://s.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l> &data=05%7C01%7Cmichae
l.mayer%40ermco-eci.com%7Cb5fe65acfb964ca694bd08dbb6227a70%7Cd2deeaf27
0e4425c91d7d99d784e89d6%7C0%7C0%7C638304031443677173%7CUnknown%7CTWFpb
GZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0
%3D%7C3000%7C%7C%7C&sdata=xLgoPqp5udi1C7ZfP2QVX1%2FkDj1B%2BoW5a1G3f3So
4zs%3D&reserved=0 or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l<https://archive.midrange.com/midrange-l>.
Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.
------------------------------
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l<
https://lists.midrange.com/mailman/listinfo/midrange-l>
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at
https://archive.midrange.com/midrange-l<
https://archive.midrange.com/midrange-l>.
Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.
midrange.com
