Re: BRMS: how to retrieve the system name

not sure if the help text for the field sheds any light on it.

*LCL
Specifies that the system is the local system. BRMS uses the
default local location name, LCLLOCNAME and not the system name
SYSNAME. In most cases, the systems have the same value
specified in the LCLLOCNAME and in the SYSNAME. You can use the
DSPNETA command to view the system network attributes.



Rob Berendt wrote on 8/11/2022 8:09 AM:

Is there a BRMS Service to determine the system name? Basically what I am looking for is when you do WRKMEDBRM SYSNAME(*LCL) and it returns the media used by the local system. IDK if there's a function to return the local system name so I can do something like:

Select *
FROM QUSRBRM.MEDIA_INFO
where owning_system = qusrbrm.lcl()
;

https://helpsystemswiki.atlassian.net/wiki/spaces/IWT/pages/888963080/BRMS+SQL+Services

In case you're wondering DSPNETA / RTVNETA are only close. It can be different. Especially for those of us running software H/A.

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 7310 Innovation Blvd, Suite 104
Ft. Wayne, IN 46818
Ship to: 7310 Innovation Blvd, Dock 9C
Ft. Wayne, IN 46818
http://www.dekko.com