%Net.Remote.ActivityLog
persistent class %Net.Remote.ActivityLog
extends
Recent activity log for Object Gateway Servers.
Inventory
Summary
Properties | ||||
---|---|---|---|---|
DateTime | GatewayName | GatewayType | Job | Port |
RecordType | Server | Text |
Properties
Methods
Purge Gateway activity log records older than a given number of days (default 7 days).
Queries
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.
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.
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.