Guest User!
You are not Sophos Staff.
Hallo Community,
wir haben eine Sophos SG330 Release 9.702-1 im Einsatz.
Hier eine kurze Frage: Es ist möglich in der Verwaltung die Anzahl der "Letzten WebAdmin Sitzungen" zu erhöhen ?
Aktuell zeigt er uns "nur" 20 Loggins an.
Vielen herzlichen Dank
Frank Schmidt
Hallo Frank,
(Sorry, my German-speaking brain isn't creating thoughts at the moment. 
)
There's no way to set that number, but you can get the info at the command line. Here are suggestions by two PostgreSQL guru's that participate here...
teched_01 26 Feb 2015 - All WebAdmin changes instead of the last 20 sessions:
psql reporting -U reporting -c "SELECT confd_sessions.*, confd_nodes.* FROM confd_sessions INNER JOIN confd_nodes ON confd_sessions.sid = confd_nodes.sid WHERE confd_sessions.facility = 'webadmin';"
Efren Gonzalez 5 Dec 2019 - WebAdmin changes over the last 30 days.
psql reporting -U reporting -c "SELECT confd_sessions.*, confd_nodes.* FROM confd_sessions INNER JOIN confd_nodes ON confd_sessions.sid = confd_nodes.sid WHERE confd_sessions.facility = 'webadmin' AND confd_sessions.time > now() - interval '30 days' ORDER BY confd_sessions.time desc;"
MfG - Bob (Bitte auf Deutsch weiterhin.)
Hallo Frank,
(Sorry, my German-speaking brain isn't creating thoughts at the moment. )
There's no way to set that number, but you can get the info at the command line. Here are suggestions by two PostgreSQL guru's that participate here...
teched_01 26 Feb 2015 - All WebAdmin changes instead of the last 20 sessions:
psql reporting -U reporting -c "SELECT confd_sessions.*, confd_nodes.* FROM confd_sessions INNER JOIN confd_nodes ON confd_sessions.sid = confd_nodes.sid WHERE confd_sessions.facility = 'webadmin';"
Efren Gonzalez 5 Dec 2019 - WebAdmin changes over the last 30 days.
psql reporting -U reporting -c "SELECT confd_sessions.*, confd_nodes.* FROM confd_sessions INNER JOIN confd_nodes ON confd_sessions.sid = confd_nodes.sid WHERE confd_sessions.facility = 'webadmin' AND confd_sessions.time > now() - interval '30 days' ORDER BY confd_sessions.time desc;"
MfG - Bob (Bitte auf Deutsch weiterhin.)
