Stored Query to extract usage information

[simon-leech]

I am often asked for usage statistics about users from administrators.
XYZ should have a stored query that enables us to add a button in the admin panel for admins to download this insight.
The query should include:

• Email
• Most recent login date
• Total logins [last 30, 60 and 90 days]
• Days with login [last 30, 60 and 90 days]
• First login date of user

[dbauszus-glx]

This is not currently possible.

The ACL connection is not stored as a DBS_* connection.

ACL queries are not stored as query templates but in user endpoints which use the /mod/user/acl.js module to query the ACL.

eg. /mod/user/list.js returns a list of users.

/mod/user/log.js

It is possible to limit a template to admin use only.

But you cannot use the ACL connection for a custom template.

[dbauszus-glx]

At first the /mod/user/acl module should be removed to make use of the node-pg dbs module.

The user/list and user/log endpoints should make use of stored templates.

The query module must be able to query the ACL connection.

However, the admin view itself should probably be a ui/element and the view should not be a language view but make use of the dictionary.

Hence the dictionary issues must be addressed first before we can dive into reworking the admin user interface as well as the admin query pipeline.