[uportal-dev] SQL for users that customize layout

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

[uportal-dev] SQL for users that customize layout

Benito Gonzalez-2
Hi folks,

If you wonder who has customized their uPortal layout, this SQL will list the user names:

select user_id, user_name from up_user_layout
left join up_user on up_user_layout.user_id = up_user.user_id
where user_name not like '%-lo'
and user_name <> 'system';

Hope this helps someone!

Benito J. Gonzalez
Software Architect
Unicon, Inc.
Voice:  209.777.2754
 Text:  209.777.2754
GitHub:  bjagg
GitLab:  bjagg
BitBucket:  bjagg

You received this message because you are subscribed to the Google Groups "uPortal Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To view this discussion on the web visit https://groups.google.com/a/apereo.org/d/msgid/uportal-dev/CAJ_1GkTRzZ7RzpwRn8HeuZGLwQdQW7LZZ2eQaOiLniOFj7F2dg%40mail.gmail.com.