Easy way to locate Premium App assets created by Deactivated User

Chizu Hieida

I just had this case where the Calendar App Owner left the company a few months ago, and I had to transfer ownership. 

Before I could transfer the app's ownership, I had to locate the source sheet and share it with our System Admin account. 

As both a Plan Asset Admin and a System Admin, we must have a notification or an easier way to track premium apps created by deactivated users. This would enable us to promptly transfer ownership to the appropriate user, a capability we currently lack.

Erin Horiuchi Green

@Chizu Hieida I use Visual Studio with Python.

How to get Smartsheet User ID?

import smartsheet
smartsheet_client = smartsheet.Smartsheet('INSERT YOUR TOKEN HERE')
user_profile = smartsheet_client.Users.list_users(email='INSERT TARGETED EMAIL ADDRESS')
print(user_profile)

If you are not an Administrator, then the above will omit: (1) admin, (2) groupAdmin, (3) licenseSheetCreator, (4) resourceViewer, (5) sheetCount, (6) status AND (7) lastLogin.

(1) admin is just a boolean. Either they are or are not a System Administrator.
(2) groupAdmin is just a boolean confirms if the User has the ability to create and edit groups.
(3) license SheetCreator is just a boolean. Either they can or cannot create sheets.
(4) resourceViewer is jsut a boolean confirms they can access resource views.
(5) sheetCount is a number reflecting the number of sheets owned by the User.
(6) status is a set list of values "ACTIVE", "DECLINED", "PENDING" and "DEACTIVATED".
(7) lastLogin is string with date and time based on system setup.

How to get list of Smartsheets created by User ID?

import smartsheet
smartsheet_client = smartsheet.Smartsheet('INSERT YOUR TOKEN HERE')
user_licensed_to_create = smartsheet_client.Sheets.list_sheets(USER ID)
print(user_license_to_create)