%Net.Remote.ActivityLog

persistent class %Net.Remote.ActivityLog extends %Library.Persistent

SQL Table Name: %Net_Remote.ActivityLog

Recent activity log for Object Gateway Servers.

Property Inventory

Method Inventory

Purge()

Properties

property DateTime as %TimeStamp;

Property methods: DateTimeDisplayToLogical(), DateTimeGet(), DateTimeGetStored(), DateTimeIsValid(), DateTimeLogicalToDisplay(), DateTimeNormalize(), DateTimeOdbcToLogical(), DateTimeSet()

property GatewayName as %String;

Property methods: GatewayNameDisplayToLogical(), GatewayNameGet(), GatewayNameGetStored(), GatewayNameIsValid(), GatewayNameLogicalToDisplay(), GatewayNameLogicalToOdbc(), GatewayNameNormalize(), GatewayNameSet()

property GatewayType as %String;

Property methods: GatewayTypeDisplayToLogical(), GatewayTypeGet(), GatewayTypeGetStored(), GatewayTypeIsValid(), GatewayTypeLogicalToDisplay(), GatewayTypeLogicalToOdbc(), GatewayTypeNormalize(), GatewayTypeSet()

property Job as %String;

Property methods: JobDisplayToLogical(), JobGet(), JobGetStored(), JobIsValid(), JobLogicalToDisplay(), JobLogicalToOdbc(), JobNormalize(), JobSet()

property Port as %String;

Property methods: PortDisplayToLogical(), PortGet(), PortGetStored(), PortIsValid(), PortLogicalToDisplay(), PortLogicalToOdbc(), PortNormalize(), PortSet()

property RecordType as %String (DISPLAYLIST = ",Debug,Info,Warning,Error", VALUELIST = ",0,1,2,3");

Property methods: RecordTypeDisplayToLogical(), RecordTypeGet(), RecordTypeGetStored(), RecordTypeIsValid(), RecordTypeLogicalToDisplay(), RecordTypeLogicalToOdbc(), RecordTypeNormalize(), RecordTypeSet()

property Server as %String;

Property methods: ServerDisplayToLogical(), ServerGet(), ServerGetStored(), ServerIsValid(), ServerLogicalToDisplay(), ServerLogicalToOdbc(), ServerNormalize(), ServerSet()

property Text as %String);

Property methods: TextDisplayToLogical(), TextGet(), TextGetStored(), TextIsValid(), TextLogicalToDisplay(), TextLogicalToOdbc(), TextNormalize(), TextSet()

Methods

classmethod Purge(pDays As %Integer = 7, Output pDeleted As %Integer) as %Status [ Language = objectscript ]

Purge Gateway activity log records older than a given number of days (default 7 days).

Inherited Methods

%BuildIndicesAsyncResponse()

%CheckConstraintsForExtent()

%InsertBatch()

%ResolveConcurrencyConflict()

%ClassIsLatestVersion()

%DispatchClassMethod()

%LockId()

%SortEnd()

%DispatchGetModified()

%New()

%SyncObjectIn()

%DispatchGetProperty()

%DispatchSetModified()

%ObjectModified()

%UnlockId()

%DispatchSetMultidimProperty()

%Oid()

%ValidateIndices()

%DispatchSetProperty()

Queries

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.

Indexes

index (NameTSIndex on GatewayName,DateTime);

Index methods: NameTSIndexExists()

index (TSIndex on DateTime);

Index methods: TSIndexExists()

Storage

Storage Model: Storage (%Net.Remote.ActivityLog)

^IRIS.Temp.Gateway.ActivityLogD(ID)

%%CLASSNAME