Hi Marcus, Thankyou for the response. I am working on this, I added a method for getting cpu usage. implementation of the handler is to be done.
Thanks & Regards, Saurav Kumar Jha On Mon, Aug 14, 2023 at 10:03 PM Christie, Marcus Aaron <machr...@iu.edu> wrote: > Hi Saurav, > > This is a little tricky to answer. I believe what you would need to do is > look at JOB_STATUS table for a given experiment/process. There will be a > SUBMITTED status, an ACTIVE status and then either a COMPLETED or FAILED or > CANCELED status. > > You would want to get the time different between the ACTIVE and the > COMPLETED/FAILED/CANCELED status. This would give the elapsed time of the > job. > > Then you would need to multiple this time, in hours, with the number of > cpus used in the job (USER_CONFIGURATION_DATA.TOTAL_CPU_COUNT). > > Someone on the list might have a better idea, but I think that's the > general gist of how you would get cpu hours used. > > Thanks, > > Marcus > > > On Aug 13, 2023, at 1:52 PM, saurav kumar jha < > imsauravgaurav...@gmail.com> wrote: > > > > Hi Community, > > I have a question regarding this jira. > > > > 10. The total cpu-hours used 1. by a user, 2. sorted, 3. quarterly, 4. > plotted over a period of time > > 11. The total cpu-hours consumed by application, sorted, quarterly, > plotted over a period of time > > > > These are the two requirements with respect to cpu hours. > > > > Although the COMPUTE_RESOURCE_SCHEDULING table has some of the > information, I couldn't find any table which stores cpu hours used > information. > > > > Can anyone please tell me where I can get this info? > > > > Thanks & Regards, > > Saurav Kumar Jha > >