Absent Member.. Mohit_Agrawal Absent Member..
Absent Member..
156 views

Find total time for a time period

HI All, I need to fine total time charged for a time period, for all project, all resources... Just one number: total time charged for a period or for a year.... do you know of any report or have sql query? Thanks
0 Likes
2 Replies
Natalia_R_PPM Absent Member.
Absent Member.

Re: Find total time for a time period

Hello Mohit, 

I didnt find any query. You can build a query with the Data model guide in order to look the tables taht you need to extract the information requested.

- KTMG_PERIODS
This table stores the information that defines the time periods used in Time Management.

 

For reports , PPM have the following ootb reports

Actual Time Summary Shows actual time information by a variety of groupings and filters
Delinquent Time Sheets Shows information on Delinquent Time Sheets in the Time Management module
Time Sheet Details Detailed information for one or more Time Sheets. Includes work item information and time reported against each work item.
Time Sheet Summary Shows time sheet information by a variety of groupings and filters
Work Allocation Details Shows information on Work Allocations in the Time Management module

 

Hope it helps. 

Thanks 

Natalia 

HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
0 Likes
rc9 Trusted Contributor.
Trusted Contributor.

Re: Find total time for a time period

Hi Mohit,

I am following up with you to see if this is already addressed.

You can run out of the box "Actual Time Summary Report" for a the same Starting and End Period. You do not need to choose any other parameters like Work Item Type or Work Item or Resource. Such report should give you total time for a time period. I am attaching a screen shot that shows how to choose the parameters so total time for a time period can be obtained.

Hope this helps

Thanks

Raji

HPE Support

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.