ITPAM database tables for reporting

Document ID : KB000050517
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Below is a list of tables from the ITPAM database that you might want to report on.

Solution:

IT PAM Reporting Schema

c2oconfigcomponents

Fields

Field Description Type
NodeName This field stores the touchpoint name. varchar(255)
ObjectType This field stores the type of the object (C2OServer/C2OAgent) varchar(45)
EnvironmentName This field stores the display name of the environment varchar(255)
NodeID UUID of the touchpoint (Agent touchpoint / Orchestrator touchpoint) varchar(255)
HostID Stores the UUID of the Agent/orchestrator varchar(255)
DomainName This field stores the display name of the domain varchar(255)

This table will be populated when the domain object is saved.

c2oflowchartinstanceobject

Fields

FieldDescription Type
CallerRef Absolute path of the Process which invoked this process
Use to figure out parent process (if any)
varchar(100)
RefFlowPath This field stores the complete path of the process in the IT PAM Library longtext
UserName User name if from GUI, agenda name if agenda engine, when one process executes another process then "System" is stored in this field varchar(45)
EndTime Stores the End time of the process instance. datetime
ManualExecutionTime Total elapsed time for process to be completed manually in hours and minutes
Populated when ROI properties of Process are defined. You can right-click and set ROI properties from Library Browser view.
varchar(10)
ManualCost Total effort to perform process manually in hours and minutes
Populated when ROI properties of Process are defined. You can right-click and set ROI properties from Library Browser view.
varchar(10)
SystemGrpName App/System Group Name
Populated when ROI properties of Process are defined. You can right-click and set ROI properties from Library Browser view.
varchar(50)
ProcessExecutionTime The time elapsed for completing the process
Populated when ROI properties of Process are defined. You can right-click and set ROI properties from Library Browser view.
varchar(10)
CallerType States who started the process (User, Agenda ,Trigger etc) varchar(45)
CallingInstance Full reference to process instance that started this flow. This would be the RefID of the parent instance.
Used to figure out parent process (if any)
varchar(45)
RefID Reference ID of the process instance. varchar(255)
Debug This will be a flag which tells you whether the process was executed in the debug mode or in simple mode. tinyint(4)
NodeID UUID of the touchpoint (Agent Node/ Server Node) varchar(255)
Criticality Criticality of the instance
Populated when ROI properties of Process are defined. You can right-click and set ROI properties from Library Browser view.
varchar(20)
StartTime Stores the Start time of the process instance. datetime
State Stores the state of the process instance varchar(45)
HostID Stores the UUID of the Agent/Orchestrator varchar(255)
RefFlowVersion The version of the Process whose instance is this. varchar(255)

This table will be populated when a Process is executed.

c2oreferenceobject

Fields

Field Description Type
Owner Name of the owner of the object varchar(255)
HostID Host ID of the Orchestrator where object is created. varchar(255)
ModificationDate Latest modification date of the object datetime
CreationDate Creation date of the object. datetime
VersionNo Latest version number of the object varchar(255)
NodeID Node ID of the orchestrator where object is created. varchar(255)
ObjectId ObjectId of the object mediumint(9)
Keywords List of keywords defined in the object. longtext
ReferencePath The path of the object in the IT PAM library browser. longtext
DocumentType Type of the Object( Eg. Dataset, Resources etc) varchar(50)

This table will be populated when the user checks in the documents in IT PAM library.

c2oserviceoperationinstance

Fields

Field Description Type
CallerType The type of the object which started the operator(For example Agenda, Process) longtext
CallingInstance The absolute path of the calling object.
Used to figure out calling instance.
varchar(255)
ServiceGrpName The name of the module to which the operator belongs(For StartSystemProcess the ServiceGrpName will be Process Module.) varchar(100)
ServiceOpName The name of the Service operator varchar(100)
StartTime Start Time of the Operator datetime
State State of the Operator varchar(50)
NodeID Node Id of the touchpoint where operator is running varchar(255)
CallerReference The name of the Service operator in the process
Used to figure out RefID of calling instance.
varchar(100)
EndTime End Time of the Operator datetime
RefID Reference ID varchar(255)
HostID Host Id of the touchpoint where operator is running varchar(255)

This table will be populated when any operator will be executed.

filetransferserviceoperation

Fields

Field Description Type
IsSecureFTP Whether file transfer will be secured or not. tinyint(4)
IsInline Contents to be transferred are part of operation (inline) not from the external file. tinyint(4)
RemoteFile Name of the destination file the FTP server varchar(255)
RefID Reference ID varchar(255)
RemoteUserId User name on the FTP server varchar(255)
RemoteHost HostName/IP address of the FTP server varchar(255)
SiteParameters FTP site parameters varchar(255)
LocalFile Name/Path of the local file to be transferred on the FTP server varchar(255)
InlineData Contents which are to be transferred on the FTP server. varchar(255)
IsSiteCommand Boolean which tells that an FTP site command has to be executed. tinyint(4)
IsBinaryTransfer FTP transfer in binary mode. tinyint(4)

This table will be populated when any operator from File Transfer Module is executed.

mapialertserviceoperation

Fields

Field Description Type
Subject Subject of the Email Alert operator varchar(255)
RefID Reference ID of the operator varchar(255)
Attachment Path of the attachment in the file system varchar(2048)
Message Message of the Email Alert operator varchar(255)
MAPICC CC list of the Email Alert operator varchar(255)
UserProfile User profile of Email Alert operator varchar(255)
Receipt Value of the Receipt parameter of the Email Alert operator tinyint(4)
MAPITO To list of the Email Alert operator varchar(255)

This table will be populated when Email Alert operator is executed.

playwaveformalertsvc

Fields

Field Description Type
RefID Reference ID varchar(255)
IsLoop Shows that is wave is playing in loop or not. tinyint(4)
Wavefile Path of the sound file provided(in the file system) varchar(255)
RepeatCount Repeat count specified in the operator mediumint(9)

This table will be populated when Sound Alert operator is executed.

promptuserserviceoperation

Fields

Field Description Type
Description This field represents the description of the User Prompt varchar(255)
Title This field represents the title of the User Prompt varchar(255)
TimeoutDays This field represents the value timeout days field of the User Prompt(It Is not applicable since IT PAM 3.0) mediumint(9)
NoTimeout This field represents the value of NoTimeout checkbox of the User Prompt(It Is not applicable since IT PAM 3.0) tinyint(4)
TimeoutMinutes This field represents the value timeout days minutes of the User Prompt(It Is not applicable since IT PAM 3.0) mediumint(9)
Users This field represents the list of users to whom the user prompt was assigned. The list is colon separated varchar(255)
TimeoutHours This field represents the value timeout days hours of the User Prompt(It Is not applicable since IT PAM 3.0) mediumint(9)
Groups This field represents the list of Groups to whom the user prompt was assigned. The list is colon separated varchar(255)
UserInputForm This field contains the absolute path of the Interaction Request Form in the Orchestrator which was used in the User Prompt varchar(255)
RefID This field represents the UUID of the User Prompt varchar(255)

This table will be populated when User Prompt operator is executed.

soapclientcall

Fields

Field Description Type
MethodName Method name called using soap client call service operator varchar(255)
RefID Reference Id varchar(255)
ServiceURL Soap Service URL varchar(255)
SavedCallFile The path of the file where the soap request will be saved varchar(255)
AuthorisedUser Name of the authorized user provided in the input parameter of the operator varchar(255)
ResponseFile The path of the file where the soap response will be saved varchar(255)

This table will be populated when Soap Client Call operator is executed.

startprocessserviceoperation

Fields

Field Description Type
IsLoadOSProfile Value of the Load OS User profile checkbox in the operator properties tinyint(4)
Parameter1 Value of the Parameter1 in the operator properties varchar(255)
StdErrFileName Path of the Standard error file provided in the operator properties varchar(255)
WorkingDir Path of the Working directory provided in the operator properties varchar(255)
Parameter5 Value of the Parameter5 in the operator properties varchar(255)
RefID Reference ID varchar(255)
Parameter3 Value of the Parameter3 in the operator properties varchar(255)
ScriptType Script extension provided in the operator properties varchar(255)
Profile Value of Profile entered by user in the operator properties varchar(255)
IsTruncateForStdErr Value of the Truncate log file for standard error checkbox in the operator properties tinyint(4)
IsTruncateForStdOut Value of Truncate log file for standard out checkbox in the operator properties tinyint(4)
UserID Value of the user Id provided in the operator properties varchar(255)
Parameter4 Value of the Parameter4 in the operator properties varchar(255)
ProgramName Value of the Program Name provided in the operator properties varchar(255)
StdOutFileName Path of the Standard out file in the operator properties varchar(255)
InLineScript Value of the in line script in the operator properties varchar(255)
IsPostToGlobalLog Value of the post out to global logs checkbox in the operator properties tinyint(4)
Parameter2 Value of the Parameter2 in the operator properties varchar(255)

This table will be populated when Start Script or Start System Process Operator is executed.

tapialertserviceoperation

Fields

Field Description Type
Phone3 Phone number 3 provided in the properties of operator varchar(255)
Phone1 Phone number 1 provided in the properties of operator varchar(255)
RepeatTimes The value of repeat count provided in the properties of operator mediumint(9)
Waveform The path of the sound wave form used in the operator varchar(255)
RefID Reference ID. varchar(255)
Phone4 Phone number 4 provided in the properties of operator varchar(255)
Phone2 Phone number 2 provided in the properties of operator varchar(255)
Phone5 Phone number 5 provided in the properties of operator varchar(255)

This table will be populated when Telephone Operator is executed.