From the Learn administrator panel, you can search to list all users with a non-empty username, which will list all users registered in the system. The problem we have is that we cannot download the list or copy it in its entirety, since the maximum page size is 1,000 users. This means that, if I have 15,000 users, I will have to copy and paste 15 pages, which will then also need to be "cleaned up"... would it be possible to do this another way?
The answer is yes, it can be done... from Illuminate. Use the following query in the Snowflake console to obtain a list of all the users registered in your system:
select first_name, last_name, stage:user_id, stage:batch_uid
from CDM_LMS.PERSON
You can download this list as a CSV so you can work with it.
In this article, you can see how to obtain the accounts needed to access Illuminate and in this one, how to access the Snowflake console.
Queries are offered without any kind of guarantee. The code worked when we created this articule, but due to changes in a constantly evolving software, we cannot assure its accuracy at the moment in time when is tested in your system.
Comments
0 comments
Please sign in to leave a comment.