Get log

Retrieves connection log data (when in-memory logging is enabled)

Parameters

Function GetLog(Val Connection, Val AsString = False, Val EventCount = 100) Export

Parameter	CLI option	Type	Required	Description
Connection	-	Arbitrary	✔	AddIn object with open connection
AsString	-	Boolean	✖	True > returns log as a single string, False > as an array
EventCount	-	Number	✖	Number of recent events to retrieve. 0 > no limits

Returns

String, Map Of KeyAndValue - Log as a string or a map with the full execution result

Advanced call ?

This method has no additional advanced call parameters.

Caution

NOCLI: this method is not available in CLI version

1C:Enterprise/OneScript code example

    LogFile         = GetTempFileName("txt");
    LoggingSettings = OPI_MSSQL.GetLoggingSettings(True, 100, LogFile);

    Address  = "127.0.0.1";
    Login    = "SA";
    Password = "12we...";

    ConnectionString = OPI_MSSQL.GenerateConnectionString(Address, , Login, Password);
    TLSSettings      = OPI_MSSQL.GetTLSSettings(True);

    Connection = OPI_MSSQL.CreateConnection(ConnectionString, TLSSettings, LoggingSettings);

    If Not OPI_MSSQL.IsConnector(Connection) Then
        Raise OPI_Tools.JSONString(Connection);
    EndIf;

    Result = OPI_MSSQL.ExecuteSQLQuery("SELECT 1 AS n", , , Connection);

    Result = OPI_MSSQL.GetLog(Connection);

Result

{
 "logs": [
  "[2026-05-26 13:55:01.001] Connecting to MSSQL...",
  "[2026-05-26 13:55:01.016] Connected to MSSQL"
 ],
 "result": true,
 "returned": 2,
 "total": 2
}