Triggers

Trigger	Scheme	Table	Operation	Description
T_tAct_Insert	dbo	tAct	Insert	Writes the current date and time of event creation into tAct.dRecordCreated.
T_tHdTicketCust_Insert	dbo	tHdTicket	Insert	A new record will be created for custom items of the ticket in the tHdTicketCust table.
TR_LicDowngrade_LogChanges	dbo	LicDowngrade	Insert, Delete	Enters the change in "substitute products" into the license log. (LicHistLog)
TR_LicHist_LogChanges	dbo	tblLicHist	Insert, Update	Enters the change of the license properties into the license log. (LicHistLog)
TR_LicHistCust	dbo	tblLicHist	Insert	A new record will be created for custom items of the license in the LicHistCust table.
TR_LicHistCust_LogChanges	dbo	LicHistCust	Insert, Update, Delete	Enters the change of the value of the license custom fields into the license log. (LicHostLog)
TR_LicHistDocument_LogChanges	dbo	LicHistDocument	Insert, Delete	Logs changes to the Document bindings of a license to the license log. (LicHistLog)
TR_LicHistItem_LogChanges	dbo	tblLicHistItem	Insert, Update, Delete	Enters the change of the value of the license item into the license log. (LicHostLog)
TR_LicHistMedia_LogChanges	dbo	LicHistMedia	Insert, Delete	Logs changes to the Media bindings of a license to the license log (LicHistLog).
TR_LicHistRelation_LogChanges	dbo	LicHistRelation	Insert, Update, Delete	Enters the change of links between licenses item into the license log. (LicHostLog)
TR_News_MarkEmbededImagesInHtml	dbo	News	Update	Images in the text of news are marked as intext in the tDocument table.
TR_ProductCust	dbo	tblProduct	Insert
TR_tAccountCust	dbo	tAccount	Insert	A new record will be created for custom items of the organization in the tAccountCust table.
TR_tAct_Delete_UpdatePersonTicketDisplay	dbo	tAct	Delete	Updates the "read" ticket status when an event is deleted
TR_tAct_Insert_Update_Delete	dbo	tAct	Insert, Update, Delete	Recomputes the time elapsed waiting for requester and possibly shifts the due date for resolving of the ticket if SLA is paused. Checks the completion of the first reaction to the requester. Recomputes the due date of the current target for the ticket. Recomputes the reported work for the given ticket.
TR_tAct_Insert_UpdatePersonTicketDisplay	dbo	tAct	Insert	Updates the "read" ticket status when a new event is created
TR_tAct_MarkEmbededImagesInActHtml	dbo	tAct	Update	Images in the text of events are marked as intext in the tDocument table.
TR_tAct_Update_UpdatePersonTicketDisplay	dbo	tAct	Update	Updates the "read" ticket status when an event is edited
TR_tArticle_MarkEmbededImagesInHtml	dbo	tArticle	Update	Images in the text of knowledge base articles are marked as intext in the tDocument table.
TR_tblInstHist_RemoveLicTrans	dbo	tblInstHist	Update, Delete	Deletes the coverage of the product by licenses in case the product will be uninstalled or deleted.
TR_tblNode_InsertNodeCust	dbo	tblNode	Insert	A new record will be created for custom properties of the object in the NodeCust table.
TR_tColumnValue_UpdateLocCache	dbo	tColumnValue	Insert, Update, Delete	Updates the cache via localizing values of custom fields.
TR_tEmailSignature_MarkEmbededImagesInHtml	dbo	tEmailSignature	Update	Images in the text of signatures are marked as intext in the tDocument table.
TR_tHdSection_UpdateLocCache	dbo	tHdSection	Insert, Update, Delete	Updates the cache by localizing the service name and description.
TR_tHdSectionCust	dbo	tHdSection	Insert	A new record will be created for custom items of the service in the tHdSectionCust table.
TR_tHdTicketApprovalItem_Insert_Update_Delete	dbo	tHdTicketApprovalItem	Insert, Update, Delete	Starts the procedure spUpdateTicketLastAction. (Converts the date of the last action related to the entered ticket number.)
TR_tHdTicketApprovalItem_MarkEmbededImagesInHtml	dbo	tHdTicketApprovalItem	Update	Images in the text of messages from approver are marked as intext in the tDocument table.
TR_TicketAlertSeverity_UpdateLocCache	dbo	TicketAlertSeverity	Insert, Update, Delete
TR_TicketAlertType_UpdateLocCache	dbo	TicketAlertType	Insert, Update, Delete
TR_TicketChange_Insert_Update_Delete	dbo	TicketChange	Insert, Update, Delete	Starts the procedure spUpdateTicketLastAction. (Converts the date of the last action related to the entered ticket number.)
TR_TicketState_MarkEmbededImagesInHtml	dbo	TicketState	Update	Images in the instructions for resolvers are marked as intext in the tDocument table.
TR_TicketState_UpdateLocCache	dbo	TicketState	Insert, Update, Delete	Updates the cache by localizing the name, status description and instructions for solvers.
TR_TicketStateCust	dbo	TicketState	Insert	A new record will be created for custom items of the ticket state in the TicketStateCust table.
TR_TicketTagType_UpdateLocCache	dbo	TicketTagType	Insert, Update, Delete
TR_TicketType_UpdateLocCache	dbo	TicketType	Insert, Update, Delete	Updates the cache by localizing the process name and description.
TR_tLocale_UpdateLocCache	dbo	tLocale	Insert, Update, Delete	Updates the cache by the means of localization.
TR_tLocalization_UpdateLocCache	dbo	tLocalization	Insert, Update, Delete	Updates the cache by the means of localization.
TR_tPersonCust	dbo	tPerson	Insert	A new record will be created for custom items of the person in the tPersonCust table.
TR_tSla_UpdateLocCache	dbo	tSla	Insert, Update, Delete	Updates the cache by localizing the SLA name and description.
TR_tSlaCust	dbo	tSla	Insert	A new record will be created for custom items of the SLA in the tSlaCust table.
TR_tString_UpdateLocCache	dbo	tString	Insert, Update, Delete	Updates the cache by localizing system texts.