IBM i Global

IBM i 

A space for professionals working with IBM’s integrated OS for Power systems to exchange ideas, ask questions, and share expertise on topics like RPG and COBOL development, application modernization, open source integration, system administration, and business continuity.


#Power


#IBMi
#Power
 View Only

  • 1.  Report for enabled users only

    Posted 13 hours ago

    I'm attempting to get a report for specific user profiles that are enabled. I ran this command , DSPUSRPRF USRPRF(*ALL) OUTPUT(*OUTFILE) OUTFILE(LIBRARY/FILE), so I can create a query against it. I ran WRKQRY,  and under 'Select Records I put the following:  When I run the query I get no data???

     

    Michael Ruth

    iSeries(AS/400) Support – SiteOps IT North American MQ & RD

     

     

    CONFIDENTIALITY NOTICE: This email message (including all attachments) is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, copying or distribution is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.

    PRIVACY NOTICE: Your privacy is important to us. To find out more about the information that Elanco may collect, how we use it, how we protect it, and your rights and choices with respect to your Personal Data, go to privacy.elanco.com

     



  • 2.  RE: Report for enabled users only

    Posted 10 hours ago

    SELECT *
        FROM QSYS2.USER_INFO
        WHERE STATUS = '*ENABLED';

    ... or variations thereof ... see https://www.ibm.com/docs/en/i/7.6.0?topic=services-user-info-view



    ------------------------------
    Jack Woehr
    Senior Consultant
    Seiden Group LLC
    Beulah CO
    3038478442
    ------------------------------

    Original Message


Related Content