You can optimize your query as follows [root@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 (< snbaner...@iitgn.ac.in>) escribió: > Dear Michael: Thank you, I also did the same now and seems to work !!! > Thanks > > [root@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 / Tennessee Tech University > > On Apr 11, 2020, at 10:05 AM, Sudeep Narayan Banerjee > <snbaner...@iitgn.ac.in> <snbaner...@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@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 > > --
