Hi Urmas,
now that you have it working, i would recommend just writing a query to export the data, and paste it in to the excel.
If you do not have access to the DB, you can always use the XQ on the link i mentioned above. It has both pieces a XOG and a data extraction component.
the query would be something like (remove the columns you do not need.
SELECT
@SELECT:DIM:USER_DEF:IMPLIED:USERLIST:cmn.id:KEY_ID@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:USERLIST:srm.user_id:KEY_USER_ID@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:USERLIST:cmn.first_name:FIRSTNAME@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:USERLIST:CMN.USER_NAME:KEY_USER_NAME@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:USERLIST:cmn.last_name:LASTNAME@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:USERLIST:cmn.email_address:EMAILADDRESS@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:USERLIST:srm.unique_name:KEY_RESOURCEID@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:USERLIST:cmn.locale:USERLOCALE@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:USERLIST:cmn.timezone:USERTIMEZONE@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:USERLIST:LOWER(case when cmn.is_ldap = 1 then 'true'when cmn.is_ldap = 0 then 'false' else NULL end):LWR_ISLDAP@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:USERLIST:UPPER(case when cmn.user_status_id = 200 then 'ACTIVE' when cmn.user_status_id = 201 then 'INACTIVE' when cmn.user_status_id = 202 then 'LOCK' end
):USERSTATUS@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:USERLIST:UPPER(case when srm.is_external = 0 then 'INTERNAL'when srm.is_external = 1 then 'EXTERNAL' end):USERTYPE@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:USERLIST:SUBSTRING (NBI.PATH,1,4):UNITPATH@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:USERLIST:OBST.UNIQUE_NAME:ID@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:USERLIST:OBST.NAME:NAME@
FROM CMN_SEC_USERS CMN
LEFT JOIN odf_ca_resource odf ON odf.id=cmn.id
LEFT JOIN srm_resources srm ON srm.user_id=cmn.id
LEFT JOIN cmn_languages lan ON cmn.language_id = lan.id
LEFT JOIN PRJ_OBS_ASSOCIATIONS ASO ON ASO.RECORD_ID=srm.user_id AND ASO.TABLE_NAME='SRM_RESOURCES'
LEFT JOIN NBI_DIM_OBS NBI ON NBI.OBS_UNIT_ID=ASO.UNIT_ID
LEFT JOIN PRJ_OBS_TYPES OBST ON OBST.ID = NBI.OBS_TYPE_ID
WHERE 1=1
AND @WHERE:SECURITY:RESOURCE:cmn.ID@
AND @FILTER@
Hope this helps
Federico