How to generate report on "Users who are using UI-16 and users who are using Next-UI"?

[Cameron13]

Team, an interesting question. Our company asked people to move to Next UI. Still some people has updated but still some are using UI16. I was asked to generate a report to show how many users has adapted Next and how many are still on UI16.

Any idea/guide how can I generate report ?

[Niklas Peterson · Accepted solution]

Hi @Cameron13 ,

If you have this setting on user level then there should be a user preference controlling it. 

So you should be able to report on the sys_user_preference table capturing all users that has glide.ui.polaris.use set to true or false.

Regards,
Niklas

[tsulli02]

This is not giving me all the licensed users - I have 4300+ and I am only seeing 183 total True / False (both)

[Niklas Peterson]

Hi @tsulli02 ,

If you have the system property glide.ui.polaris.on_off_user_pref_enabled set to true, users are able to activate the Next Experience. When they do, there is a "glide.ui.polaris.use" record created in sys_user_preference. If they have not  activated the Next  Experience , then there is no record.

Regards,
Niklas