Query to return which users have adjusted thier views

[Anon Anon]

Our Business Team wants to know the impact of how many users will be affected when an object is published. I was wondering if anyone had a query which told you based on the object which portlet/views were affected, how many users would be affected and who those users are?

"Do you want to publish this object's views? All user views will be reset. If partitions are being used, this will only affect the current partition. "

[Legacy User]

Hi Becky,
this should give you the names. the dal_code is the object id.

select u.user_name , u.first_name||' '||u.last_name Who , cg.last_updated_date When_Customised
from cmn_grids cg, cmn_sec_users u
where dal_code='project'
and principal_type = 'USER' and principal_id = u.id and u.USER_STATUS_ID = 200

[Deactivated User]

You could also experiment with the conditions from CMN_GRIDS
like replacing dal_code='project' wtih dal_type='object'

Martti K.

[Anon Anon]

Yeah I actually ended up going with this which is a slight modification to the original

select dal_code, cg.code, u.user_name , u.first_name||' '||u.last_name Who , cg.last_updated_date When_Customised
from cmn_grids cg
inner join cmn_sec_users u on cg.principal_id = u.id
where dal_code='teams'
and principal_type = 'USER' and u.USER_STATUS_ID = 200
and cg.code is not null

[Anon Anon]

Thats very helpful, thank you.

Does anyone has a query that can provide list of resources who have configured portlets (custom and ootb)?

Regards,
Akhil

[Deactivated User]

cmn_grids should give you that infromation,too.

To see how have changed the global or system configuraiton of the portlets see the cmn_portlets.last_update_by


Martti K.

[Anon Anon]

Ahh... thanks Martti . did not initially realise that the code is blank for portlets.