compability with external account systems like ldap
norbekaiser opened this issue · 0 comments
norbekaiser commented
hi, in case this is intended please close this issue
however: the table users only contains locally stored users
chaning users.uid to accounts.uid would make it possible to also have an overview over users which are originated from e.g.: an ldap source
e.g. diff
16c16
< query="SELECT ${envtableprefix}users.uid, COUNT(${envtableprefix}authtoken.uid) AS count FROM ${envtableprefix}users LEFT JOIN ${envtableprefix}authtoken ON ${envtableprefix}authtoken.uid = ${envtableprefix}users.uid GROUP BY ${envtableprefix}users.uid ORDER BY ${envtableprefix}users.uid ASC"
---
> query="SELECT ${envtableprefix}accounts.uid, COUNT(${envtableprefix}authtoken.uid) AS count FROM ${envtableprefix}accounts LEFT JOIN ${envtableprefix}authtoken ON ${envtableprefix}authtoken.uid = ${envtableprefix}accounts.uid GROUP BY ${envtableprefix}accounts.uid ORDER BY ${envtableprefix}accounts.uid ASC"
20c20
< echo "graph_title Cloud users sessions"
---
> echo "graph_title Cloud accounts sessions"
24c24
< echo "graph_info Show the number of users opened sessions."
---
> echo "graph_info Show the number of accounts opened sessions."
best regard norb