Mobile Device Access
We would like to run a report that shows who has this tag turned on in their user record. The problem is that this value is not available in the reporting tool. We are planning to report monthly on those that have this turned on as a management process to ensure those that shouldnt have it dont.
Has anyone created a report that shows this?
0 Comments
[ + ] Show comments
Answers (3)
Please log in to answer
Posted by:
Nico_K
3 years ago
You can create the report via the wizard.
Under Users the field you need to report is "API enabled".
Posted by:
KevinG
3 years ago
Or you can create a SQL report.
IF(API_ENABLED, 'Yes', 'No') as 'Mobile Access' FROM USER
Posted by:
kiwiblue
3 years ago
thanks for that. I should have assumed that API enabled was the variable. Have run the report I want to include only those users.
Comments:
-
You can use the filter for that (API_ENABLED = 1 ) in the Filter section or as full (example) report:
SELECT USER.USER_NAME, USER.ID, USER.FULL_NAME , IF(USER.API_ENABLED,'Yes','No') as 'Has mobile access' FROM USER
WHERE ((USER.API_ENABLED = '1'))
ORDER BY USER_NAME - Nico_K 3 years ago