ITPAM database tables for reporting

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent
• CA Process Automation Base

Issue/Introduction

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

Field	Description	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.

Environment

Release:
Component: ITPAM