persistent class %CSP.Util.CSPLogEvent
extends %Persistent
Class allowing to load CSP.log into %CSP.Util.CSPLogEvent class and
search it using SQL.
• property CachePID
as %String;
• property CallType
as %String;
• property ConnectionNo
as %Integer;
• property CookieAppNo
as %Integer;
• property CookieConn
as %Integer;
• property CookieName
as %String(MAXLEN=255);
• property CookiePath
as %String(MAXLEN=1000);
• property CookiePrivateSession
as %Boolean;
• property CookieSP
as %Integer(MAXVAL=65536,MINVAL=1);
• property CookieServer
as %Integer;
• property CookieUP
as %String(MAXLEN=255);
• property CookieValue
as %String(MAXLEN=100);
• property EvtDate
as %Date [ Calculated ];
• property EvtTimestamp
as %TimeStamp [ Required ];
• property GatewayID
as %String;
• property GatewayPID
as %Integer;
• property GatewayTID
as %Integer;
• property ImportTS
as %TimeStamp;
used to be able to filter/delete a bad dataload
• property LogLevel
as %Integer;
• property Page
as %String(MAXLEN=300);
• property Payload
as %String(MAXLEN=32000);
• property RTBuild
as %String;
• property RemoteAddr
as %String;
• property RequestID
as %String;
• property Server
as %String;
• property SessionID
as %String;
• classmethod CheckTS(TS1, TS2)
as %String
Returns 1 If TS1
• classmethod DateCvt(pDate="")
as %String
• classmethod DumpEvents(pFile, pLogLevel, pServer, pStartTime, pEndTime, pConnectionNo, pThreadId, pServerPID)
as %String
• classmethod FileImport(pFile)
as %String
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
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
• classmethod GtwImport()
as %String
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
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
Returns selected Option
• classmethod SqlToFile(pFile, pSQL, display=1)
as %String
•index (ApplicationNumber on CookieAppNo) [Type = bitmap];
•index (CallType on CallType) [Type = bitmap];
•index (Connection on ConnectionNo) [Type = bitmap];
•index (EvtTimestamp on EvtTimestamp);
•index (GatewayID on GatewayID) [Type = bitmap];
•index (LogLevel on LogLevel) [Type = bitmap];
•index (Page on Page) [Type = bitmap];
•index (RemoteAddr on RemoteAddr) [Type = bitmap];
•index (Server on Server) [Type = bitmap];
•index (ServerNumberC on CookieServer) [Type = bitmap];
•index (Session on SessionID) [Type = bitmap];
•index (SessionServer on SessionID,Server);
