{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}