There are many things that I find frustrating about the GUI tools for EnterpriseOne (E1), especially when doing Systems Administration functions.
Apparently, I’m not the only one. We give read-only access to most of the SysAdmin applications to our developers. You may have your own opinions about that, but it’s what we chose to do.
Anyway, our development manager gets a lot of CNC-type questions from our users and doesn’t like to always “bother” us with them. One of the questions she gets is “Who has access to the application or UBE?”. She got tired of wading through the multiple GUI applications required to get that information and came up with a very slick SQL query that returns the information quickly:
Note: iSeries DB2 syntax
123456 SELECT ABALPH, FSOBNM, RLFRROLE, RLTOROLEFROM SY811/F00950, SY811/F95921, SY811/F0092, PRODDTA/F0101WHERE FSOBNM = 'PXXXX' ANDFSUSER = RLFRROLE ANDRLTOROLE = ULUSER ANDULAN8 = ABAN8