Data360 Govern

 View Only

  • 1.  Groups membership

    Posted 3 days ago

    Hi all

    I'm trying to get the Govern group's members from the system in a massive way. There is an API providing that info but you need to run the API call group by group. So, for a massive retrieval this not operative. Any idea in the D360 Govern community? 

    Thanks



    ------------------------------
    Enrique Rodríguez Alonso
    Data Governance lead
    Coca-Cola Europacific Partners plc
    Madrid
    ------------------------------


  • 2.  RE: Groups membership

    Employee
    Posted 2 days ago
      |   view attached

    Hi Enrique,

    This is relatively simple to do with a NodeJs script like the one attached.

    1. Install NodeJs from Node.js - Download Node.js® - any version should work
    2. Unzip attached zip file
    3. Open a command prompt or Windows Powershell and navigate to your unzipped folder.
    4. Enter you API Key & Secret in the env.js file and save it.
    5. In your command prompt enter: npm i --save
    6. In your command prompt enter: node listGroupsAndMembers
    7. Wait for it to finish running
    8. A nicely formatted Excel will appear in the "output" folder containing 2 sheets, "Groups & Members" and "Memberless Groups"
    9. I think Jennifer already shared the Excel output from this script for your prod environment with you by email.  If not, let me know and I will email it to you.

    Kind regards,

    Gaston



    ------------------------------
    Gaston Hummel (gaston.hummel@precisely.com)
    Solution Architect & Marketing
    EngageOne
    ------------------------------

    Attachment(s)

    zip
    ListGroupMembers.zip   2 KB 1 version
    Original Message


  • 3.  RE: Groups membership

    Employee
    Posted 2 days ago

    Enrique,

    I will reach out to you separately. I can create an Analyze dataflow for you and place on your server so you can execute.

    Regards

    Steve



    ------------------------------
    Steve Linsley
    Director International Services
    *Precisely Software Inc.Steve Linsley
    Director International Services
    *Precisely Software Inc.
    ------------------------------

    Original Message