persistent class %Net.Remote.ActivityLog
extends %Persistent
Recent activity log for Object Gateway Servers.
• property DateTime
as %TimeStamp;
• property GatewayName
as %String;
• property GatewayType
as %String;
• property Job
as %String;
• property Port
as %String;
• property RecordType
as %String(DISPLAYLIST=",Debug,Info,Warning,Error",VALUELIST=",0,1,2,3");
• property Server
as %String;
• property Text
as %String(MAXLEN="");
• classmethod Purge(pDays As %Integer = 7, Output pDeleted As %Integer)
as %Status
Purge Gateway activity log records older than a given number of days (default 7 days).
• query ByDateTime(ts1 As %TimeStamp = "1900-01-10", ts2 As %TimeStamp = "2030-01-10")
Selects
ID, DateTime, GatewayName, GatewayType, RecordType, Job, Text
SQL Query
:
SELECT %ID, DateTime, GatewayName, %EXTERNAL(GatewayType) As Type, %EXTERNAL(RecordType) As RecordType, Job, Text
FROM ActivityLog
WHERE DateTime >= :ts1 AND DateTime <= :ts2
ORDER BY %ID DESC
Lookup all Gateways by DateTime range.
• query ByName(name As %String)
Selects
ID, DateTime, RecordType, Job, Text
SQL Query
:
SELECT %ID, DateTime, RecordType, Job, Text
FROM ActivityLog
WHERE GatewayName = :name
ORDER BY %ID DESC
Lookup by Gateway Name.
• query ByNameDateTime(name As %String, ts1 As %TimeStamp = "1900-01-10", ts2 As %TimeStamp = "2030-01-10")
Selects
ID, DateTime, RecordType, Job, Text
SQL Query
:
SELECT %ID, DateTime, RecordType, Job, Text
FROM ActivityLog
WHERE GatewayName = :name AND DateTime >= :ts1 AND DateTime <= :ts2
ORDER BY %ID DESC
Lookup by Gateway Name and DateTime range.
• index (NameTSIndex on GatewayName,DateTime);
• index (TSIndex on DateTime);
