<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi,<div class=""><br class=""></div><div class="">In the DB, yes, in <font face="Menlo" class="">resv_table</font> table. If you need usernames resolution, you need to use the <font face="Menlo" class="">assoc_table</font> table. You may also need to translate the flags and tres fields (look for slurm source code for that).</div><div class=""><br class=""></div><div class="">In slurm 17.02.9, the <font face="Menlo" class="">resv_table</font> has this form:</div><div class=""><font face="Menlo" class="">+------------+----------------------+------+-----+---------+-------+<br class="">| Field | Type | Null | Key | Default | Extra |<br class="">+------------+----------------------+------+-----+---------+-------+<br class="">| id_resv | int(10) unsigned | NO | PRI | 0 | |<br class="">| deleted | tinyint(4) | NO | | 0 | |<br class="">| assoclist | text | NO | | NULL | |<br class="">| flags | smallint(5) unsigned | NO | | 0 | |<br class="">| nodelist | text | NO | | NULL | |<br class="">| node_inx | text | NO | | NULL | |<br class="">| resv_name | text | NO | | NULL | |<br class="">| time_start | bigint(20) unsigned | NO | PRI | 0 | |<br class="">| time_end | bigint(20) unsigned | NO | | 0 | |<br class="">| tres | text | NO | | NULL | |<br class="">+------------+----------------------+------+-----+---------+</font><span style="font-family: Menlo;" class="">-------</span><font face="Menlo" class="">+</font></div><div class=""><br class=""><div class="">
<div dir="auto" style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div style="color: rgb(0, 0, 0); font-variant-caps: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;"><font face="Menlo" class="">Cordialement / Best regards,<br class=""><br class="">Sébastien VIGNERON <br class="">CRIANN, <br class="">Ingénieur / Engineer<br class="">Technopôle du Madrillet <br class="">745, avenue de l'Université <br class="">76800 Saint-Etienne du Rouvray - France <br class="">tél. +33 2 32 91 42 91 <br class="">fax. +33 2 32 91 42 92 <br class=""><a href="http://www.criann.fr" class="">http://www.criann.fr</a> <br class=""><a href="mailto:sebastien.vigneron@criann.fr" class="">mailto:sebastien.vigneron@criann.fr</a><br class="">support: support@criann.fr</font></div></div>
</div>
<div><br class=""><blockquote type="cite" class=""><div class="">Le 6 avr. 2018 à 15:46, De Giorgi Jean-Claude <<a href="mailto:jean-claude.degiorgi@epfl.ch" class="">jean-claude.degiorgi@epfl.ch</a>> a écrit :</div><br class="Apple-interchange-newline"><div class=""><div class="WordSection1" style="page: WordSection1; caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, sans-serif;" class=""><span style="font-size: 11pt;" class="">Hi all,<o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, sans-serif;" class=""><span style="font-size: 11pt;" class=""><o:p class=""> </o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, sans-serif;" class=""><span style="font-size: 11pt;" class="">Is there a way to get a list of the old reservations?<o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, sans-serif;" class=""><span style="font-size: 11pt;" class="">Maybe in the DB?<o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, sans-serif;" class=""><span style="font-size: 11pt;" class=""><o:p class=""> </o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, sans-serif;" class=""><span style="font-size: 11pt;" class="">Thanks,<o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri, sans-serif;" class=""><span style="font-size: 11pt;" class="">Jean-Claude</span></div></div></div></blockquote></div><br class=""></div></body></html>