Last Activity from Desktop Sync Clients¶

The desktop client is using app tokens to authenticate with the server. To be feature complete, the client also allows the use of BASIC AUTH with the real user credentials. However, this is highly discouraged and we recommend users to always use an app token.

Those tokens are stored on the server in the database and can be used to track the last connection activity of a client. Such data can be used to build usage statistics in big instances.

How to find the last access time of all users¶

You can use the following SQL request to query the information:

select id, uid, login_name, last_activity, name from oc_authtoken where type= 1 and name like '%Desktop Client%';