Date: Fri, 29 Mar 2024 15:00:18 +0100 (CET) Message-ID: <617202825.4195.1711720818634@static.9.57.119.168.clients.your-server.de> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_4194_406771303.1711720818631" ------=_Part_4194_406771303.1711720818631 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
PrivateServer logs three types of security events that can= be accessed trough a read-only SQL view:
These informations are viewable through administration cons= ole and could also be exported through read-only SQL views.
View: V_AUDIT_EVENT
Field |
Type |
Description = |
id |
bigint(20) |
PK - autoincrement |
date_created |
datetime |
event timestamp |
event_type |
varchar(255) |
type of object change |
actor |
varchar(255) |
user=E2=80=99s login |
class_name |
varchar(255) |
type of object changed |
object_id |
varchar(255) |
ID of changed object |
View: V_AUTH_EVENT
Field |
Type |
Description = |
id |
bigint(20) |
PK - autoincrement |
date_created |
datetime |
event timestamp |
event_type |
varchar(255) |
login/logout/login failed |
ip_address |
varchar(255) |
IP address of remote client <= /td> |
principal |
varchar(255) |
username used for authentication= event |
View: V_SIP_SESSION
Field |
Type |
Description = |
id |
bigint(20) |
PK - autincrement |
date_created |
datetime |
event timestamp |
event_type |
varchar(10) |
type of network event <= /td> |
username |
varchar(80) |
SIP peername |
useragent |
varchar(255) |
SIP useragent when applicable |
remoteaddr |
varchar(150) |
IP and port of client |
tlscipher |
varchar(100) |
Negotiated TLS cipher cuite <= /td> |
View: V_CDR
Field |
Type |
Description = |
id |
bigint(20) |
PK - autincrement |
calldate |
datetime |
event timestamp |
src |
varchar(80) |
caller number |
src_user_agent |
varchar(80) |
caller useragent |
dst |
varchar(80) |
called number |
dst_user_agent |
varchar(80) |
called useragent |
duration |
int(11) |
call duration (counting from dia= ling) |
billsec |
int(11) |
call duration (counting from ans= wer) |
=20
REST APIs =E2=86=92
=20