RE: . Re: Finding libraries in BRMS control groups

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
https://www.ermco-eci.com/
IBM i Personal Blog: 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
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
https://www.ermco-eci.com/
IBM i Personal Blog: 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>
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> 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
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 To
subscribe, unsubscribe, or change list options,
visit:
https://list/
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
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

------------------------------