%CSP.Util.CSPLogEvent

persistent class %CSP.Util.CSPLogEvent extends %Library.Persistent

SQL Table Name: %CSP_Util.CSPLogEvent

Class allowing to load CSP.log into %CSP.Util.CSPLogEvent class and search it using SQL.

Property Inventory

Method Inventory

Properties

property CachePID as %String;
Property methods: CachePIDDisplayToLogical(), CachePIDGet(), CachePIDGetStored(), CachePIDIsValid(), CachePIDLogicalToDisplay(), CachePIDLogicalToOdbc(), CachePIDNormalize(), CachePIDSet()
property CallType as %String;
Property methods: CallTypeDisplayToLogical(), CallTypeGet(), CallTypeGetStored(), CallTypeIsValid(), CallTypeLogicalToDisplay(), CallTypeLogicalToOdbc(), CallTypeNormalize(), CallTypeSet()
property ConnectionNo as %Integer;
Property methods: ConnectionNoDisplayToLogical(), ConnectionNoGet(), ConnectionNoGetStored(), ConnectionNoIsValid(), ConnectionNoLogicalToDisplay(), ConnectionNoNormalize(), ConnectionNoSet()
property CookieAppNo as %Integer;
Property methods: CookieAppNoDisplayToLogical(), CookieAppNoGet(), CookieAppNoGetStored(), CookieAppNoIsValid(), CookieAppNoLogicalToDisplay(), CookieAppNoNormalize(), CookieAppNoSet()
property CookieConn as %Integer;
Property methods: CookieConnDisplayToLogical(), CookieConnGet(), CookieConnGetStored(), CookieConnIsValid(), CookieConnLogicalToDisplay(), CookieConnNormalize(), CookieConnSet()
property CookieName as %String (MAXLEN = 255);
Property methods: CookieNameDisplayToLogical(), CookieNameGet(), CookieNameGetStored(), CookieNameIsValid(), CookieNameLogicalToDisplay(), CookieNameLogicalToOdbc(), CookieNameNormalize(), CookieNameSet()
property CookiePath as %String (MAXLEN = 1000);
Property methods: CookiePathDisplayToLogical(), CookiePathGet(), CookiePathGetStored(), CookiePathIsValid(), CookiePathLogicalToDisplay(), CookiePathLogicalToOdbc(), CookiePathNormalize(), CookiePathSet()
property CookiePrivateSession as %Boolean;
Property methods: CookiePrivateSessionDisplayToLogical(), CookiePrivateSessionGet(), CookiePrivateSessionGetStored(), CookiePrivateSessionIsValid(), CookiePrivateSessionLogicalToDisplay(), CookiePrivateSessionNormalize(), CookiePrivateSessionSet()
property CookieSP as %Integer (MAXVAL = 65536, MINVAL = 1);
Property methods: CookieSPDisplayToLogical(), CookieSPGet(), CookieSPGetStored(), CookieSPIsValid(), CookieSPLogicalToDisplay(), CookieSPNormalize(), CookieSPSet()
property CookieServer as %Integer;
Property methods: CookieServerDisplayToLogical(), CookieServerGet(), CookieServerGetStored(), CookieServerIsValid(), CookieServerLogicalToDisplay(), CookieServerNormalize(), CookieServerSet()
property CookieUP as %String (MAXLEN = 255);
Property methods: CookieUPDisplayToLogical(), CookieUPGet(), CookieUPGetStored(), CookieUPIsValid(), CookieUPLogicalToDisplay(), CookieUPLogicalToOdbc(), CookieUPNormalize(), CookieUPSet()
property CookieValue as %String (MAXLEN = 100);
Property methods: CookieValueDisplayToLogical(), CookieValueGet(), CookieValueGetStored(), CookieValueIsValid(), CookieValueLogicalToDisplay(), CookieValueLogicalToOdbc(), CookieValueNormalize(), CookieValueSet()
property EvtDate as %Date [ Calculated ];
Property methods: EvtDateCompute(), EvtDateDisplayToLogical(), EvtDateGet(), EvtDateIsValid(), EvtDateLogicalToDisplay(), EvtDateLogicalToOdbc(), EvtDateNormalize(), EvtDateOdbcToLogical(), EvtDateSQLCompute()
property EvtTimestamp as %TimeStamp [ Required ];
Property methods: EvtTimestampDisplayToLogical(), EvtTimestampExists(), EvtTimestampGet(), EvtTimestampGetStored(), EvtTimestampIsValid(), EvtTimestampLogicalToDisplay(), EvtTimestampNormalize(), EvtTimestampOdbcToLogical(), EvtTimestampSet()
property GatewayID as %String;
Property methods: GatewayIDDisplayToLogical(), GatewayIDGet(), GatewayIDGetStored(), GatewayIDIsValid(), GatewayIDLogicalToDisplay(), GatewayIDLogicalToOdbc(), GatewayIDNormalize(), GatewayIDSet()
property GatewayPID as %Integer;
Property methods: GatewayPIDDisplayToLogical(), GatewayPIDGet(), GatewayPIDGetStored(), GatewayPIDIsValid(), GatewayPIDLogicalToDisplay(), GatewayPIDNormalize(), GatewayPIDSet()
property GatewayTID as %Integer;
Property methods: GatewayTIDDisplayToLogical(), GatewayTIDGet(), GatewayTIDGetStored(), GatewayTIDIsValid(), GatewayTIDLogicalToDisplay(), GatewayTIDNormalize(), GatewayTIDSet()
property ImportTS as %TimeStamp;
used to be able to filter/delete a bad dataload
Property methods: ImportTSDisplayToLogical(), ImportTSGet(), ImportTSGetStored(), ImportTSIsValid(), ImportTSLogicalToDisplay(), ImportTSNormalize(), ImportTSOdbcToLogical(), ImportTSSet()
property LogLevel as %Integer;
Property methods: LogLevelDisplayToLogical(), LogLevelGet(), LogLevelGetStored(), LogLevelIsValid(), LogLevelLogicalToDisplay(), LogLevelNormalize(), LogLevelSet()
property Page as %String (MAXLEN = 300);
Property methods: PageDisplayToLogical(), PageGet(), PageGetStored(), PageIsValid(), PageLogicalToDisplay(), PageLogicalToOdbc(), PageNormalize(), PageSet()
property Payload as %String (MAXLEN = 32000);
Property methods: PayloadDisplayToLogical(), PayloadGet(), PayloadGetStored(), PayloadIsValid(), PayloadLogicalToDisplay(), PayloadLogicalToOdbc(), PayloadNormalize(), PayloadSet()
property RTBuild as %String;
Property methods: RTBuildDisplayToLogical(), RTBuildGet(), RTBuildGetStored(), RTBuildIsValid(), RTBuildLogicalToDisplay(), RTBuildLogicalToOdbc(), RTBuildNormalize(), RTBuildSet()
property RemoteAddr as %String;
Property methods: RemoteAddrDisplayToLogical(), RemoteAddrGet(), RemoteAddrGetStored(), RemoteAddrIsValid(), RemoteAddrLogicalToDisplay(), RemoteAddrLogicalToOdbc(), RemoteAddrNormalize(), RemoteAddrSet()
property RequestID as %String;
Property methods: RequestIDDisplayToLogical(), RequestIDGet(), RequestIDGetStored(), RequestIDIsValid(), RequestIDLogicalToDisplay(), RequestIDLogicalToOdbc(), RequestIDNormalize(), RequestIDSet()
property Server as %String;
Property methods: ServerDisplayToLogical(), ServerGet(), ServerGetStored(), ServerIsValid(), ServerLogicalToDisplay(), ServerLogicalToOdbc(), ServerNormalize(), ServerSet()
property SessionID as %String;
Property methods: SessionIDDisplayToLogical(), SessionIDGet(), SessionIDGetStored(), SessionIDIsValid(), SessionIDLogicalToDisplay(), SessionIDLogicalToOdbc(), SessionIDNormalize(), SessionIDSet()

Methods

classmethod CheckTS(TS1, TS2) as %String [ Language = objectscript ]
Returns 1 If TS1
classmethod DateCvt(pDate="") as %String [ Language = objectscript ]
classmethod DumpEvents(pFile, pLogLevel, pServer, pStartTime, pEndTime, pConnectionNo, pThreadId, pServerPID) as %String [ Language = objectscript ]
classmethod FileImport(pFile) as %String [ Language = objectscript ]
Imports CSP.log from from CSP.log file
Displays all registered CSP Gateways and allow to select what log to load

dateFromTS - timestamp in ODBC format or leave empty to load all data from the beginning of the log
dateToTS - timestamp in ODBC format or leave empty to load all data to the end of the log
Example:
Set res=##class(%CSP.Util.CSPLogEvent).FileImport()
classmethod FileImportNoPrompt(pFile As %String, dateFromTS As %TimeStamp = "", dateToTS As %TimeStamp = "", pGatewayID=1, pRunTuneTable=0, pFilterGZIPErrors=0, pDeleteExtent=0, display=0) as %String [ Language = objectscript ]
Imports CSP.log from CSP.log file

dateFromTS - timestamp in ODBC format or leave empty to load all data from the beginning of the log
dateToTS - timestamp in ODBC format or leave empty to load all data to the end of the log
Example:
Set res=##class(%CSP.Util.CSPLogEvent).FileImport(pFile,from,to,1,1,0,1,1)
classmethod GetTS(pStream As %Stream.GlobalCharacter) as %TimeStamp [ Language = objectscript ]
classmethod GtwImport() as %String [ Language = objectscript ]
Imports CSP.log from CSP Gateway registry
Displays all registered CSP Gateways and allow to select what log to load

dateFromTS - timestamp in ODBC format or leave empty to load all data from the beginning of the log
dateToTS - timestamp in ODBC format or leave empty to load all data to the end of the log
Example:
Set res=##class(%CSP.Util.CSPLogEvent).GtwImport()
classmethod Import(pStream As %Stream.GlobalCharacter, dateFromTS As %TimeStamp = "", dateToTS As %TimeStamp = "", pGatewayID=1, pRunTuneTable=0, pFilterGZIPErrors=0, pDeleteExtent=0, display=0) as %String [ Language = objectscript ]
Imports CSP.log from stream

dateFromTS - timestamp in ODBC format or leave empty to load all data from the beginning of the log
dateToTS - timestamp in ODBC format or leave empty to load all data to the end of the log
classmethod OPTION(prompt, default, max) as %String [ Language = objectscript ]
Returns selected Option
classmethod SqlToFile(pFile, pSQL, display=1) as %String [ Language = objectscript ]

Indexes

index ($CSPLogEvent on ) [Extent, Type = bitmap];
index (ApplicationNumber on CookieAppNo) [Type = bitmap];
index (CallType on CallType) [Type = bitmap];
Index methods: CallTypeDisplayToLogical(), CallTypeGet(), CallTypeGetStored(), CallTypeIsValid(), CallTypeLogicalToDisplay(), CallTypeLogicalToOdbc(), CallTypeNormalize(), CallTypeSet()
index (Connection on ConnectionNo) [Type = bitmap];
Index methods: ConnectionNoDisplayToLogical(), ConnectionNoGet(), ConnectionNoGetStored(), ConnectionNoIsValid(), ConnectionNoLogicalToDisplay(), ConnectionNoNormalize(), ConnectionNoSet()
index (EvtTimestamp on EvtTimestamp);
Index methods: EvtTimestampDisplayToLogical(), EvtTimestampExists(), EvtTimestampGet(), EvtTimestampGetStored(), EvtTimestampIsValid(), EvtTimestampLogicalToDisplay(), EvtTimestampNormalize(), EvtTimestampOdbcToLogical(), EvtTimestampSet()
index (GatewayID on GatewayID) [Type = bitmap];
Index methods: GatewayIDDisplayToLogical(), GatewayIDGet(), GatewayIDGetStored(), GatewayIDIsValid(), GatewayIDLogicalToDisplay(), GatewayIDLogicalToOdbc(), GatewayIDNormalize(), GatewayIDSet()
index (IDKEY on ) [IdKey, Type = key];
Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()
index (LogLevel on LogLevel) [Type = bitmap];
Index methods: LogLevelDisplayToLogical(), LogLevelGet(), LogLevelGetStored(), LogLevelIsValid(), LogLevelLogicalToDisplay(), LogLevelNormalize(), LogLevelSet()
index (Page on Page) [Type = bitmap];
Index methods: PageDisplayToLogical(), PageGet(), PageGetStored(), PageIsValid(), PageLogicalToDisplay(), PageLogicalToOdbc(), PageNormalize(), PageSet()
index (RemoteAddr on RemoteAddr) [Type = bitmap];
Index methods: RemoteAddrDisplayToLogical(), RemoteAddrGet(), RemoteAddrGetStored(), RemoteAddrIsValid(), RemoteAddrLogicalToDisplay(), RemoteAddrLogicalToOdbc(), RemoteAddrNormalize(), RemoteAddrSet()
index (Server on Server) [Type = bitmap];
Index methods: ServerDisplayToLogical(), ServerGet(), ServerGetStored(), ServerIsValid(), ServerLogicalToDisplay(), ServerLogicalToOdbc(), ServerNormalize(), ServerSet()
index (ServerNumberC on CookieServer) [Type = bitmap];
index (Session on SessionID) [Type = bitmap];
Index methods: SessionIDDisplayToLogical(), SessionIDGet(), SessionIDGetStored(), SessionIDIsValid(), SessionIDLogicalToDisplay(), SessionIDLogicalToOdbc(), SessionIDNormalize(), SessionIDSet(), SessionServerExists()
index (SessionServer on SessionID,Server);
Index methods: SessionServerExists()

Inherited Members

Inherited Methods

Storage

Storage Model: Storage (%CSP.Util.CSPLogEvent)

^IRIS.Temp.CSPLogEventD(ID)
=
%%CLASSNAME
ImportTS
EvtTimestamp
RTBuild
LogLevel
GatewayPID
GatewayTID
ConnectionNo
Server
CachePID
RequestID
SessionID
RemoteAddr
Page
Payload
CookieName
CookieSP
CookieUP
CookieValue
CookiePath
CookieConn
CookieServer
CookieAppNo
CookiePrivateSession
CallType
GatewayID
Feedback