summaryrefslogtreecommitdiffstats
path: root/database/sqlite/administration/lastlog.c
diff options
context:
space:
mode:
Diffstat (limited to 'database/sqlite/administration/lastlog.c')
-rw-r--r--database/sqlite/administration/lastlog.c2
1 files changed, 1 insertions, 1 deletions
diff --git a/database/sqlite/administration/lastlog.c b/database/sqlite/administration/lastlog.c
index e850d94..64adf78 100644
--- a/database/sqlite/administration/lastlog.c
+++ b/database/sqlite/administration/lastlog.c
@@ -96,7 +96,7 @@ xmlDoc *eDBadminGetLastlog(eurephiaCTX *ctx, xmlDoc *srch_xml, const char *sortk
" vpnipaddr, vpnipmask, sessionstatus, sessionkey,"
" login, logout, session_duration, session_deleted,"
" bytes_sent, bytes_received, uicid, accessprofile,"
- " access_descr, fw_profile, depth, digest,"
+ " access_descr, fw_profile, depth, lower(digest),"
" common_name, organisation, email, username, ll.uid"
" FROM openvpn_lastlog ll"
" LEFT JOIN openvpn_usercerts USING (uid, certid)"