Extract Users List in Procedure

I'm looking to build a procedure that clears down an entity which holds the users of our platform, programatically extracts the current user list and then loads it back into the entity.

 

I've been able to do this manually by using the 'Export User List' function in the security screen, but I would really like this to be a procedure that I can run (say once a day) to account for joiners and leavers.

 

I have Board cubes that are dimensioned by user so I'm keen to keep the list current. 

 

Any ideas?

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary
    edited April 2020

    Hi Neil Chapman,

    I'd suggest you opened a new idea in the Ideas section. There currently is no direct way of doing this programmatically. But, you could use the system's logfiles (namely the user logs) which will be found in %BOARDPATH%\Dataset\Logs\Users. There are files for

    • created users
    • modified users
    • removed users

    and a login-log.

    "created - removed" will give you the currently active users you are looking for.

    Of course--this will mean defining datareaders and -flows, but after all, you were looking for a programmatic solution, weren't you? ;-)

     

    Kind Regards,

    Helmut

  •  Thanks Helmut, I will definitely give that a go. Sounds like it should work to me!

     

    I will also raise an Idea in that section.