/build/static/layout/Breadcrumb_cap_w.png

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)

Posted by: Nico_K 3 years ago
Red Belt
1

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
Red Belt
1

Or you can create a SQL report.


Select ID, FULL_NAME, USER_NAME, EMAIL,
IF(API_ENABLED, 'Yes', 'No') as 'Mobile Access' FROM USER
Posted by: kiwiblue 3 years ago
Fourth Degree Green Belt
0

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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ