cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
patfm
Community Participant

How to distinguish SIS added users vs. Manually added.

Jump to solution

Hi,

I have heard that it is possible to distinguish Canvas users who are added by an SIS process vs. manually added users.  We would like to know what the relevant Canvas data attribute would be to distinguish them.  We need to remove some previously added SIS TAs who are no longer assigned that role, but our SIS process does not currently address that, so we need to run a separate upload to delete them but we want to EXCLUDE manually added TAs since those need to remain intact.

Thanks,

Pat

Labels (2)
Tags (2)
0 Kudos
2 Solutions

Accepted Solutions
robotcars
Community Champion

Hi @patfm,

Using Canvas Data the the pseudonym_dim.sis_user_id will identify users who were created with an SIS_ID. Manually created users could have an SIS_ID if they were added via the UI, but this will depend on your process.

You could JOIN (user_dim and pseudonym_dim) your enrollment_dim for TA's and look for those without an SIS_ID.

Another option would be to use Account Reports
*.instructure.com/accounts/self/settings#tab-reports

The Provisioning Report particularly can be useful here, as you can get the users and role, and remove all users that aren't currently found in your SIS, or delete that role for all users where user_id (user sis_id) is null.

 

 

View solution in original post

0 Kudos
bmerkel
Community Contributor

There is a setting when you run the provisioning report. If you run it through the front end, make sure to check the box that says "Include deleted items" and those enrollments will be included in the report. I forget what the argument is for pulling it through the API but it's there.

View solution in original post

6 Replies
robotcars
Community Champion

Hi @patfm,

Using Canvas Data the the pseudonym_dim.sis_user_id will identify users who were created with an SIS_ID. Manually created users could have an SIS_ID if they were added via the UI, but this will depend on your process.

You could JOIN (user_dim and pseudonym_dim) your enrollment_dim for TA's and look for those without an SIS_ID.

Another option would be to use Account Reports
*.instructure.com/accounts/self/settings#tab-reports

The Provisioning Report particularly can be useful here, as you can get the users and role, and remove all users that aren't currently found in your SIS, or delete that role for all users where user_id (user sis_id) is null.

 

 

View solution in original post

0 Kudos
patfm
Community Participant

Thanks for this help.  Exactly what we needed!

Pat

patfm
Community Participant

Thanks for this help.  Exactly what we needed!

I have another question --if we deleted some instructors from course sites and need to do a report to find those deleted instructors how might we go about doing that?  The Provisioning Report does not seem to include 'deleted' users.  Can we find them through a Canvas DAta query?

Pat

robotcars
Community Champion

You can complete the enrollment instead of deleting it, I think would keep the enrollment visible in the course when looking at it in the UI. But yes, Canvas Data should contain the state of the enrollment, even if it's deleted.

bmerkel
Community Contributor

There is a setting when you run the provisioning report. If you run it through the front end, make sure to check the box that says "Include deleted items" and those enrollments will be included in the report. I forget what the argument is for pulling it through the API but it's there.

View solution in original post

patfm
Community Participant

Thanks, yes we found that option and it was very helpful!

Pat