SQL for users that customize layout

[Benito Gonzalez]

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

Email:  bgon...@unicon.net

GitHub:  bjagg

GitLab:  bjagg

BitBucket:  bjagg