{code}
# count_jobs_by_owner.cpf
-# aggregate by the given attributes, and return unique attrib values + count + jobids.
+# aggregate by the given attributes, return unique values plus count and jobids.
+# This query builds an autocluster set in the schedd on the fly using all of the displayed attributes
+# And all of the GROUP BY attributes (except JobCount and JobIds)
SELECT UNIQUE NOSUMMARY
Owner AS OWNER WIDTH -20
- JobCount AS COUNT PRINTF %5d
- JobStatus AS STATUS PRINTAS JOB_STATUS_RAW
JobUniverse AS "UNIVERSE " PRINTAS JOB_UNIVERSE
- DAGManJobID AS " DAGID" WIDTH 10
+ JobStatus AS STATUS PRINTAS JOB_STATUS_RAW
+ RequestCpus AS CPUS
+ RequestMemory AS MEMORY
+ JobCount AS COUNT PRINTF %5d
JobIDs
GROUP BY
Owner
- JobIDs
{endcode}
{code}