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

[Josh Moore]

I'll chip in the rest (but please double check the results). The below
is: "all users who haven't logged in yesterday".

bash-4.2$ bin/omero hql -q "select o.omeName from Experimenter o where
o.omeName not in (select s.owner.omeName from Session s where
s.started < '2019-05-16' group by s.owner.omeName)" --limit=-1
 #  | Col1
----+------------
 0  | user-4
 1  | user-5
 2  | user-6
 3  | user-7
 4  | user-8
 5  | user-9
 6  | user-10
 7  | user-11
 8  | user-12
 9  | adm-user-1
 10 | adm-user-2
 11 | adm-user-3
 12 | adm-user-4
 13 | adm-user-5
 14 | adm-user-6

~J.

On Thu, May 16, 2019 at 5:11 PM Simon Li <spli at dundee.ac.uk> wrote:
>
> 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, 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> 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
>> https://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users
>
>
> The University of Dundee is a registered Scottish Charity, No: SC015096
> _______________________________________________
> ome-users mailing list
> ome-users at lists.openmicroscopy.org.uk
> https://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users