Export user details as csv or excel

Support_user
Support_user Registered Posts: 3

Hi all,
I was trying to export list of users in to an excel or export as CSV. I couldn't find an option under Administration->Security->Users.

Tried exporting via dsscli command but the list doesnt have information if the user is enabled/disabled, last login , created date etc.

Any other ways to get this?


Operating system used: RHEL

Answers

  • Catalina
    Catalina Dataiker, Dataiku DSS Core Designer, Registered Posts: 135 Dataiker
    edited July 17

    Below is an example on how to get the list of users, if the user is enabled/disabled and their last login that is retrieved using function last_successful_login.

    You can use a notebook to run below code and the output will be written to a CSV file called users.csv located in the folder tmp.

    import dataiku
    
    client = dataiku.api_client()
    dss_users = client.list_users()
    
    with open('/tmp/users.csv', 'w') as f:
        for user in dss_users:
            dss_user = client.get_user(user["login"])
            enabled = dss_user.get_settings().get_raw()["enabled"]
            last_login_date = dss_user.get_activity().last_successful_login
            print(user["login"]+","+ str(enabled) + "," +str(last_login_date)+"\r\n")
            f.write(user["login"]+","+ str(enabled) +"," +str(last_login_date)+"\r\n")

Setup Info
    Tags
      Help me…