Gayathri,
Sorry that query is not correct, cmn_page_portlets principal type = 'USER' contains where the portlet has been added to custom pages rather than where the portlet has actually been configured.
Here's the NSQL you can copy/paste into a query and build a grid portlet,
This will return all portlets (graph/grid) configured and you'll be able to filter on user or portlet.
I wrote some more portlets for object list config and page config, hope to share this dashboard at some point.
SELECT @SELECT:DIM:USER_DEF:IMPLIED:DATA:x.unique_key:unique_key@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:DATA:x.created_date:created_date@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:DATA:x.portlet_id:portlet_id@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:DATA:x.portlet_name:portlet_name@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:DATA:x.email_address:email_address@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:DATA:x.user_name:user_name@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:DATA:x.full_name:full_name@
FROM
(
SELECT
gr.created_date||gr.id||u.id unique_key,
gr.created_date,
gr.portlet_id,
cmn.name portlet_name,
u.email_address,
u.user_name,
u.last_name || ', '|| u.first_name full_name
FROM
cmn_sec_users u
INNER JOIN
(SELECT DISTINCT g.id, g.principal_id, g.portlet_id, g.created_date FROM cmn_grids g WHERE g.principal_type ='USER' AND g.dal_type = 'nsql'
UNION ALL
SELECT DISTINCT g.id, g.principal_id, g.portlet_id, g.created_date FROM cmn_graphs g WHERE g.principal_type ='USER' AND g.dal_type = 'nsql'
) gr ON gr.principal_id = u.id
INNER JOIN cmn_captions_nls cmn ON ( language_code = 'en' AND pk_id = gr.id AND table_name = 'CMN_GRIDS' )
WHERE u.user_status_id !=201
ORDER BY cmn.name) x
WHERE
@FILTER@
As always you use the code at your own risk