[slurm-users] How to print a user's creation timestamp from the Slurm database?

[Marcus Wagner]

Hi Juergen,


THAT's a cool feature, never knew about that. But this leads to other 
questions.
Short excerpt:
2020-01-19T00:00:18      Modify Clusters   slurmadm name='rcc' 
control_host='134.6+
2020-01-19T03:24:16      Modify Clusters   slurmadm name='rcc' 
control_host='134.6+
2020-01-19T03:34:05      Modify Clusters   slurmadm name='rcc' 
control_host='134.6+
2020-01-19T19:43:52            Add Users   slurmadm dj770060        
admin_level=1
2020-01-19T19:43:52     Add Associations   slurmadm id_assoc=5181 
mod_time=1579459432+
2020-01-19T19:43:53     Add Associations   slurmadm id_assoc=5182 
mod_time=1579459433+
2020-01-19T19:44:25            Add Users   slurmadm ff912680        
admin_level=1
2020-01-19T19:44:25     Add Associations   slurmadm id_assoc=5183 
mod_time=1579459465+
2020-01-19T21:01:16         Add Accounts   slurmadm thes0725 
description='thes07+
2020-01-19T21:01:16     Add Associations   slurmadm id_assoc=5184 
mod_time=1579464076+
2020-01-19T21:01:17     Add Associations   slurmadm id_assoc=5185 
mod_time=1579464077+
2020-01-19T22:52:04            Add Users   slurmadm tb258730        
admin_level=1
2020-01-19T22:52:04     Add Associations   slurmadm id_assoc=5186 
mod_time=1579470724+
2020-01-20T00:00:13      Modify Clusters   slurmadm name='rcc' 
control_host='134.6+

I was astonished about the "Modify Clusters" transactions, so I looked a 
bit further:
$> sacctmgr list transactions Action="Modify Clusters" -p
2020-01-15T00:00:12|Modify 
Clusters|slurmadm|name='rcc'|control_host='134.61.193.19', 
control_port=6750, last_port=6750, rpc_version=8448, dimensions=1, 
plugin_id_select=101, flags=0|
2020-01-16T00:01:29|Modify 
Clusters|slurmadm|name='rcc'|control_host='134.61.193.20', 
control_port=6750, last_port=6750, rpc_version=8448, dimensions=1, 
plugin_id_select=101, flags=0|
2020-01-16T00:01:30|Modify 
Clusters|slurmadm|name='rcc'|control_host='134.61.193.19', 
control_port=6750, last_port=6750, rpc_version=8448, dimensions=1, 
plugin_id_select=101, flags=0|
2020-01-16T00:01:41|Modify 
Clusters|slurmadm|name='rcc'|control_host='134.61.193.19', 
control_port=6750, last_port=6750, rpc_version=8448, dimensions=1, 
plugin_id_select=101, flags=0|
2020-01-17T00:00:14|Modify 
Clusters|slurmadm|name='rcc'|control_host='134.61.193.19', 
control_port=6750, last_port=6750, rpc_version=8448, dimensions=1, 
plugin_id_select=101, flags=0|
2020-01-18T00:00:18|Modify 
Clusters|slurmadm|name='rcc'|control_host='134.61.193.19', 
control_port=6750, last_port=6750, rpc_version=8448, dimensions=1, 
plugin_id_select=101, flags=0|
2020-01-19T00:00:18|Modify 
Clusters|slurmadm|name='rcc'|control_host='134.61.193.19', 
control_port=6750, last_port=6750, rpc_version=8448, dimensions=1, 
plugin_id_select=101, flags=0|
2020-01-19T03:24:16|Modify 
Clusters|slurmadm|name='rcc'|control_host='134.61.193.19', 
control_port=6750, last_port=6750, rpc_version=8448, dimensions=1, 
plugin_id_select=101, flags=0|
2020-01-19T03:34:05|Modify 
Clusters|slurmadm|name='rcc'|control_host='134.61.193.19', 
control_port=6750, last_port=6750, rpc_version=8448, dimensions=1, 
plugin_id_select=101, flags=0|
2020-01-20T00:00:13|Modify 
Clusters|slurmadm|name='rcc'|control_host='134.61.193.19', 
control_port=6750, last_port=6750, rpc_version=8448, dimensions=1, 
plugin_id_select=101, flags=0|

It seems, there is nothing modified. Do you have any idea, why these are 
generated?

Best
Marcus




On 1/19/20 2:38 PM, Juergen Salk wrote:
> * Ole Holm Nielsen <Ole.H.Nielsen at fysik.dtu.dk> [200118 12:06]:
>
>> When we have created a new Slurm user with "sacctmgr create user name=xxx",
>> I would like inquire at a later date about the timestamp for the user
>> creation.  As far as I can tell, the sacctmgr command cannot show such
>> timestamps.
> Hi Ole,
>
> for me (currently running Slurm version 19.05.2) the command
>
>   sacctmgr list transactions Action="Add Users"
>
> also shows timestamps. Isn't this what you are looking for?
>
> Best regards
> Jürgen
>

-- 
Marcus Wagner, Dipl.-Inf.

IT Center
Abteilung: Systeme und Betrieb
RWTH Aachen University
Seffenter Weg 23
52074 Aachen
Tel: +49 241 80-24383
Fax: +49 241 80-624383
wagner at itc.rwth-aachen.de
www.itc.rwth-aachen.de