<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div>This HQL query will get you the uid, username, session-start and session-end times, it must be run by an admin:</div>
<div><br>
</div>
<div>omero hql 'SELECT <a href="http://owner.id" target="_blank">owner.id</a>, owner.omeName, started, closed FROM Session ORDER BY started DESC'</div>
<div><br>
</div>
<div>You could either post-process the list to find out which user's haven't logged in, or figure out a more complicated HQL query to get what you want.</div>
<div><br>
</div>
<div>Simon<br>
</div>
<div><br>
</div>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu, 16 May 2019 at 14:22, Andreas Mueller <<a href="mailto:Andreas.Mueller@biologie.uni-osnabrueck.de" target="_blank">Andreas.Mueller@biologie.uni-osnabrueck.de</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
Hi All,<br>
<br>
I want to disable all users who have not logged in for more than a<br>
half year<br>
<br>
does anyone have some hints for me ?<br>
<br>
- thanks in advance -<br>
<br>
Andreas<br>
<br>
_______________________________________________<br>
ome-users mailing list<br>
<a href="mailto:ome-users@lists.openmicroscopy.org.uk" target="_blank">ome-users@lists.openmicroscopy.org.uk</a><br>
<a href="https://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users" rel="noreferrer" target="_blank">https://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users</a><br>
</blockquote>
</div>
</div>
<br>
<span style="font-size:10pt;">The University of Dundee is a registered Scottish Charity, No: SC015096</span>
</body>
</html>