We would like to have in the admin provisioning report to have a new column next to the account_id column to read the name of the subaccount. The account_Id column is designated in the red column below.
No, please don't change that column. Pragmatically, that ID number is invaluable. Instead, please consider requesting a new column with the information you're interested in obtaining.
Thank you for the feedback I will update this.
I'm in favor of adding a column that contains the name of the sub-account, and leaving the account_id column as it is.
I can definitely appreciate this as an administrative need, as we should all be regularly reviewing who has elevated Canvas access.
I wonder, however, if this is something that could be easily accomplished with 2 Provisioning reports and an Excel VLookup. For example: download both the "Accounts" and "Admins" provisioning reports and import them into 2 Excel sheets, add a column between "canvas_account_id" and "account_id" (for me this is D), and add this following in the empty cell: =VLOOKUP(D2,Sheet2!A:E,5,FALSE). You might have to play with the ordering of columns and sorting of the numeric IDs, but it should get you the names you're looking for.
I'm not sure if this is a well-know admin pro tip, but it's the type of thing I find myself doing frequently. Would be nice not to have to jump through these hoops
But the Admin report won't be complete if there are not Admins in every sub-account, correct? If that is true, would someone here like to suggest other reports contain the name as well as the ID number of every sub-account? I looked in the Canvas documentation and didn't find a comprehensive gloss on which reports have which information. That would be useful, I think.
Thank you, Peter for the suggestion.
Peter and Jessica, I believe the best information about the current of contents each report is in the Canvas Default Account Reports PDF, linked from this Guides page:
How do I view reports for an account?
Thank you for this information. I will take a look at it.
The data can easily come from another report and is superfluous. I much prefer supplying keys to the other reports instead of bulky extra columns.
Everyone has their preference.
It's easier to delete an unwanted column that to run two reports and VLOOKUP.
Retrieving data ...