<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: "Courier New", monospace; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
I cooked one up myself using Python (with Pandas) which I feel is more</div>
<div style="font-family: "Courier New", monospace; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
maintainable.</div>
<div style="font-family: "Courier New", monospace; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: "Courier New", monospace; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<a href="https://github.com/prehensilecode/slurm_utilization/blob/main/utilization_from_sacct.py">https://github.com/prehensilecode/slurm_utilization/blob/main/utilization_from_sacct.py</a></div>
<div style="font-family: "Courier New", monospace; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: "Courier New", monospace; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
It's still in pretty rough shape, and could certainly use some refining.</div>
<div style="font-family: "Courier New", monospace; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
<br>
</div>
<div style="font-family: "Courier New", monospace; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
Cheers,</div>
<div style="font-family: "Courier New", monospace; font-size: 12pt; color: rgb(0, 0, 0);" class="elementToProof">
    Dave<br>
</div>
<div>
<div style="font-family: "Courier New", monospace; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id="Signature">
<div>
<div></div>
<div></div>
<div></div>
<div></div>
<div></div>
<div id="divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:'Courier New',monospace">
<div class="BodyFragment"><font size="2"><span style="font-size:10pt">
<div class="PlainText"></div>
<div class="PlainText" style="font-family:"Courier New",monospace; font-size:13.3333px">
</div>
<span id="ms-rterangepaste-start"></span>
<div>--</div>
<div>
<div>David Chin, PhD (he/him)   Sr. SysAdmin, URCF, Drexel</div>
<div>dwc62@drexel.edu                     215.571.4335 (o)</div>
<div>For URCF support: urcf-support@drexel.edu</div>
<div>https://proteusmaster.urcf.drexel.edu/urcfwiki</div>
<div>github:prehensilecode</div>
<div>researchgate.NET:David-Chin-6<br>
</div>
</div>
<div class="PlainText"><span></span></div>
</span></font></div>
</div>
</div>
</div>
</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> slurm-users <slurm-users-bounces@lists.schedmd.com> on behalf of Chin,David <dwc62@drexel.edu><br>
<b>Sent:</b> Friday, November 5, 2021 14:50<br>
<b>To:</b> Slurm User Community List <slurm-users@lists.schedmd.com><br>
<b>Subject:</b> Re: [slurm-users] Possible to get cluster utilization by partition?</font>
<div> </div>
</div>
<style type="text/css" style="display:none">
<!--
p
        {margin-top:0;
        margin-bottom:0}
-->
</style>
<div dir="ltr">
<table width="100%">
<tbody>
<tr>
<td style="border-left:4px solid goldenrod; background:cornsilk; padding:0 3pt">
<p style="font:small-caps bold 100% sans-serif">External.</p>
</td>
</tr>
</tbody>
</table>
<div>
<div style="font-family:"Courier New",monospace; font-size:12pt; color:rgb(0,0,0)">
Hi, Ole:</div>
<div style="font-family:"Courier New",monospace; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:"Courier New",monospace; font-size:12pt; color:rgb(0,0,0)">
Thanks for the link to your tools. I'll take a closer look at them. </div>
<div style="font-family:"Courier New",monospace; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:"Courier New",monospace; font-size:12pt; color:rgb(0,0,0)">
I wanted to make sure it wasn't something <span style="color:rgb(0,0,0); font-family:"Courier New",monospace; font-size:12pt">Slurm already had before I </span></div>
<div style="font-family:"Courier New",monospace; font-size:12pt; color:rgb(0,0,0)">
<span style="color:rgb(0,0,0); font-family:"Courier New",monospace; font-size:12pt">started writing my own.</span></div>
<div style="font-family:"Courier New",monospace; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:"Courier New",monospace; font-size:12pt; color:rgb(0,0,0)">
Perhaps someone out there can make that feature request and sponsor its</div>
<div style="font-family:"Courier New",monospace; font-size:12pt; color:rgb(0,0,0)">
development at SchedMD. I feel like it would be a generally useful feature.</div>
<div style="font-family:"Courier New",monospace; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div style="font-family:"Courier New",monospace; font-size:12pt; color:rgb(0,0,0)">
Cheers,</div>
<div style="font-family:"Courier New",monospace; font-size:12pt; color:rgb(0,0,0)">
    Dave</div>
<div>
<div style="font-family:"Courier New",monospace; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<div id="x_Signature">
<div>
<div></div>
<div></div>
<div></div>
<div></div>
<div></div>
<div id="x_divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:'Courier New',monospace">
<div class="x_BodyFragment"><font size="2"><span style="font-size:10pt">
<div class="x_PlainText"></div>
<div class="x_PlainText" style="font-family:"Courier New",monospace; font-size:13.3333px">
</div>
<span id="x_ms-rterangepaste-start"></span>
<div>--</div>
<div>
<div>David Chin, PhD (he/him)   Sr. SysAdmin, URCF, Drexel</div>
<div>dwc62@drexel.edu                     215.571.4335 (o)</div>
<div>For URCF support: urcf-support@drexel.edu</div>
<div>https://proteusmaster.urcf.drexel.edu/urcfwiki</div>
<div>github:prehensilecode</div>
</div>
<div class="x_PlainText"><span></span></div>
</span></font></div>
</div>
</div>
</div>
</div>
<div id="x_appendonsend"></div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> slurm-users <slurm-users-bounces@lists.schedmd.com> on behalf of Ole Holm Nielsen <Ole.H.Nielsen@fysik.dtu.dk><br>
<b>Sent:</b> Friday, November 5, 2021 03:26<br>
<b>To:</b> slurm-users@lists.schedmd.com <slurm-users@lists.schedmd.com><br>
<b>Subject:</b> Re: [slurm-users] Possible to get cluster utilization by partition?</font>
<div> </div>
</div>
<div class="x_BodyFragment"><font size="2"><span style="font-size:11pt">
<div class="x_PlainText">External.<br>
<br>
Hi Dave,<br>
<br>
On 11/4/21 21:47, Chin,David wrote:<br>
> I am running Slurm 20.02.7. I would like to generate cluster utilization<br>
> report based on the billing TRES, but separated by partition.<br>
><br>
> I can get full cluster utilization using:<br>
><br>
>      sreport cluster utilization -T billing start=2021-01-01 end=2021-06-30<br>
><br>
> but it would be useful for understanding usage if a similar report could<br>
> be produced for each partition.<br>
<br>
This should probably be a FAQ :-)  The sreport utility can't provide<br>
accounting information for partitions :-(<br>
<br>
Alternatively, I have written the accounting tools slurmacct and<br>
topreports which are available from<br>
<a href="https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FOleHolmNielsen%2FSlurm_tools%2Ftree%2Fmaster%2Fslurmacct&data=04%7C01%7Cdwc62%40drexel.edu%7C1c8abdb8ef854f6e544008d9a08d3a12%7C3664e6fa47bd45a696708c4f080f8ca6%7C0%7C0%7C637717350694465973%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=i%2BLRK3XNpAJx7Qfv4TSi%2BAcm96PXhjVDREh8JKr3hro%3D&reserved=0" originalsrc="https://github.com/OleHolmNielsen/Slurm_tools/tree/master/slurmacct" shash="PX2lUfsIK1GASk9lMfmiBkWe11MSqOgRJvccqugyTA/qYlZIwLYMQ8Lxn+ftP6D+1fRTvZVzUkA76wGFYv82mIKbDgqFy2Zuy5cck0iV/32RjMRMm9ZN3JWASosDitMhpEp3Msx4nKWhGXP3KmIzSGL+jSN8ZS+a3JOxoieQi/8=">https://nam10.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FOleHolmNielsen%2FSlurm_tools%2Ftree%2Fmaster%2Fslurmacct&amp;data=04%7C01%7Cdwc62%40drexel.edu%7C0973c68a3b754bce6d6908d9a02dc25d%7C3664e6fa47bd45a696708c4f080f8ca6%7C0%7C0%7C637716940669785528%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=sqLpg4Ep94EaCeKYR5funLXV4ukxb6WxY3%2Brgx2KG5s%3D&amp;reserved=0</a><br>
<br>
While the output has a different format, we find this more useful than<br>
sreport because the lines are sorted in the order of usage percentages.<br>
<br>
/Ole<br>
<br>
</div>
</span></font></div>
<br>
<p align="Left" style="font-family:Calibri; font-size:10pt; color:#000000; margin:5pt">
Drexel Internal Data<br>
</p>
</div>
<br>
<p align="Left" style="font-family:Calibri; font-size:10pt; color:#000000; margin:5pt">
Drexel Internal Data<br>
</p>
</div>
<br>
<p style="font-family:Calibri;font-size:10pt;color:#000000;margin:5pt;" align="Left">
Drexel Internal Data<br>
</p>
</body>
</html>