[slurm-users] Need to calculate total runtime/walltime for one year

[Sudeep Narayan Banerjee]

Thank you so much.. already started working ..little optimized a bit .. 
Thanks again!

*sacct --format=user,ncpus,state,elapsed --starttime=04/1/17 
--endtime=03/31/18 | grep COMPLETED | grep mithunr | awk '{print $4}'
*

Thanks & Regards,
Sudeep Narayan Banerjee

On 12/04/20 5:43 am, Pablo Flores wrote:
> You can optimize your query as follows
>
> [root at hpc ~]# sacct  --format=user,ncpus,state,elapsed 
> --starttime=01/1/20 --endtime=03/31/20 --state=COMPLETED -u mithunr
>
>
> El sáb., 11 abr. 2020 a las 11:37, Sudeep Narayan Banerjee 
> (<snbanerjee at iitgn.ac.in <mailto:snbanerjee at iitgn.ac.in>>) escribió:
>
>     Dear Michael: Thank you, I also did the same now and seems to work
>     !!! Thanks
>
>     [root at hpc ~]# sacct --format=user,ncpus,state,elapsed
>     --starttime=01/1/20 --endtime=03/31/20 | grep COMPLETED | grep mithunr
>       mithunr         32  COMPLETED 1-12:36:02
>       mithunr         32  COMPLETED 1-08:36:56
>       mithunr         32  COMPLETED 1-14:54:28
>       mithunr         32  COMPLETED 1-02:46:46
>       mithunr         32  COMPLETED 1-11:07:10
>       mithunr         32  COMPLETED 1-21:47:19
>       mithunr         32  COMPLETED 1-12:38:04
>       mithunr         32  COMPLETED 1-21:44:05
>       mithunr         32  COMPLETED 1-09:34:25
>       mithunr         32  COMPLETED 1-09:25:49
>       mithunr         32  COMPLETED   20:46:55
>       mithunr         32  COMPLETED   22:56:59
>       mithunr         32  COMPLETED   16:05:14
>       mithunr         32  COMPLETED 1-16:32:38
>       mithunr         32  COMPLETED 1-23:55:13
>       mithunr         32  COMPLETED   16:36:48
>       mithunr         32  COMPLETED 1-11:40:56
>
>     Thanks & Regards,
>     Sudeep Narayan Banerjee
>     System Analyst | Scientist B
>     Information System Technology Facility
>     Academic Block 5 | Room 110
>     Indian Institute of Technology Gandhinagar
>     Palaj, Gujarat 382355 INDIA
>
>     On 11/04/20 9:00 pm, Renfro, Michael wrote:
>>     Unless I’m misreading it, you have a wall time limit of 2 days,
>>     and jobs that use up to 32 CPUs. So a total CPU time of up to 64
>>     CPU-days would be possible for a single job.
>>
>>     So if you want total wall time for jobs instead of CPU time, then
>>     you’ll want to use the Elapsed attribute, not CPUTime.
>>
>>     --
>>     Mike Renfro, PhD  / HPC Systems Administrator, Information
>>     Technology Services
>>     931 372-3601 <tel:931%20372-3601>      / Tennessee Tech University
>>
>>>     On Apr 11, 2020, at 10:05 AM, Sudeep Narayan Banerjee
>>>     <snbanerjee at iitgn.ac.in> <mailto:snbanerjee at iitgn.ac.in> wrote:
>>>
>>>     Hi,
>>>
>>>     I want to calculate the total walltime or runtime for all jobs
>>>     submitted by each user in a year. I am using the syntax as below
>>>     and it is also generating some output.
>>>
>>>     We have walltime set for queues (main & main_new) as 48hrs only
>>>     but the below is giving me hours ranging from 15hrs to 56 hours
>>>     of even more. I am missing anything from logical/analytical
>>>     point of view or the syntax is not correct with respect to the
>>>     desired information ? Many thanks for any suggestion.
>>>
>>>     [root at hpc ~]# sacct  --format=user,ncpus,state,CPUTime
>>>     --starttime=04/01/19 --endtime=03/31/20 | grep mithunr
>>>       mithunr         32  COMPLETED 15-10:34:40
>>>       mithunr         16  COMPLETED   00:02:56
>>>       mithunr         16  COMPLETED   02:22:40
>>>       mithunr         16  COMPLETED   00:00:48
>>>       mithunr         16  COMPLETED   00:00:32
>>>       mithunr         16     FAILED   00:00:32
>>>       mithunr         16     FAILED   00:00:32
>>>       mithunr         16     FAILED   00:00:48
>>>       mithunr         16     FAILED   00:00:32
>>>       mithunr         16     FAILED   00:00:32
>>>       mithunr          0 CANCELLED+   00:00:00
>>>       mithunr         16     FAILED   00:00:32
>>>       mithunr         32  COMPLETED   00:02:08
>>>       mithunr          0 CANCELLED+   00:00:00
>>>       mithunr         32  COMPLETED   00:01:36
>>>       mithunr         16     FAILED   00:00:48
>>>       mithunr         32  COMPLETED 33-02:58:08
>>>       mithunr         32  COMPLETED 56-01:23:12
>>>     .......................
>>>     ......................
>>>     ......................
>>>
>>>     -- 
>>>     Thanks & Regards,
>>>     Sudeep Narayan Banerjee
>>>     System Analyst | Scientist B
>>>     Information System Technology Facility
>>>     Academic Block 5 | Room 110
>>>     Indian Institute of Technology Gandhinagar
>>>     Palaj, Gujarat 382355 INDIA
>
>
>
> -- 
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.schedmd.com/pipermail/slurm-users/attachments/20200412/a888ce2f/attachment-0001.htm>