Absent Member.. Mohit_Agrawal Absent Member..
Absent Member..
222 views

How to get delegation report

Hi All,

There are some users who are addeed in the delegates and create the time sheets for their users.

Is there any way yo get the list of such users who are added to anyone's delegate access under "Time Mgmt" tab of the user profile?

0 Likes
1 Reply
Derek Giedd Honored Contributor.
Honored Contributor.

Re: How to get delegation report

There is not a report for this, but here is a script to give you the info.  You can build this into a portlet or a custom report.  You might want to modify this code to remove disabled users or add other fields.

  SELECT ku1.full_name "USER", ku2.full_name Delegated_To, rd.start_date, rd.end_date
    FROM rsc_resource_delegations rd, knta_users ku1, knta_users ku2
   WHERE rd.start_date < SYSDATE
     AND rd.end_date > SYSDATE
     AND ku1.user_id = rd.resource_id
     AND ku2.user_id = rd.delegated_to_user_id;
-- Remember to give Kudos to answers! (click the KUDOS star)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.