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.