[ome-users] last logon time stamps for the users

[Simon Li]

This HQL query will get you the uid, username, session-start and session-end times, it must be run by an admin:

omero hql 'SELECT owner.id<http://owner.id>, owner.omeName, started, closed FROM Session ORDER BY started DESC'

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.

Simon


On Thu, 16 May 2019 at 14:22, Andreas Mueller <Andreas.Mueller at biologie.uni-osnabrueck.de<mailto:Andreas.Mueller at biologie.uni-osnabrueck.de>> wrote:
  Hi All,

  I want to disable all users who have not logged in for more than a
  half year

  does anyone have some hints for me ?

   - thanks in advance -

  Andreas

_______________________________________________
ome-users mailing list
ome-users at lists.openmicroscopy.org.uk<mailto:ome-users at lists.openmicroscopy.org.uk>
https://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users

The University of Dundee is a registered Scottish Charity, No: SC015096
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openmicroscopy.org.uk/pipermail/ome-users/attachments/20190516/988791fc/attachment.html>