Procedures

Procedure	Scheme	Description
spAddNodeCustColumn	dbo	Add new custom property for object to NodeCust table.
spAssetTreeNodeChilds	dbo	Returns the object off-springs in the tree.
spAssetTreeNodeChilds_Rights	dbo	Returns the object off-springs in the tree, adheres to the permission in the object tree.
spAssignLicenceItemToChildren	dbo	Assigns the license item to historical upgrades as well.
spCalcNodeName	dbo	Converts the tree object name according to the properties forming the object name.
spCalcNodeNameAll	dbo	Converts the names of all tree objects, the names of which are formed from properties.
spCalcNodeNameClass	dbo	Converts the names of all tree objects, the names of which are formed from properties, according to the group ID.
spCalcNodeNameList	dbo
spCalcNodeNameSubtree	dbo	Converts the names of sub-tree objects, the names of which are formed from properties.
spCalcUnreadTicket	dbo	Sets the flag of the ticket to read/unread by the person.
spCloseHdTicket	dbo	Required values will be stored in tHdTicket after closing the ticket.
spConvertPropertiesToDate	dbo	Converts text properties of the specific kind to date type.
spConvertPropertiesToFloat	dbo	Converts text properties of the specific kind to float type.
spCopySection	dbo	Copies the @srcSectionId service and sets it as the child of the @dstParentSectionId service. The service can be copied including (@copyChildren) Subtree. The newly created service ID is available from the @newSectionId output parameter.
spCreateDetects	dbo	Create scans according to parameters.
spCreateDetectsBySetting	dbo	Plans scans according to saved setting to a specific computer (or to all computers in the active registry).
spCreateNodeFromTemplate	dbo	Creates an object based of the object template definition.
spCustomColumn_Add	dbo	Add new custom field.
spCustomColumn_Drop	dbo	Removing custom fields.
spDropNodeCustColumn	dbo	Drop custom property of object from tblKind and NodeCust table.
spEvalFileRule	dbo	Evaluation of one rule for files recognition.
spEvalRegRule	dbo	Evaluation of the one rule for the recognition of registries.
spEvalSwDetection	dbo	Evaluates SW scan based on patterns from the software products library.
spGeneratePropValuesFromSequence	dbo	Sets other values ​​for properties by numeric sequences.
spGetNextNumFromIdSeq	dbo	Increments numerical row definition and returns current definition. If uniqueness is breached, it automatically searches the next free number based on the row definition.
spHdSection_UpdateName	dbo	Full service name update (@iHdSectionId) including path in service tree.
spHdSectionForRequesterSearch	dbo	Searching for the Requester’s services. Returns a table of services matching the entered parameters arranged by the path in the tree. The procedure can be customized. In order to customize the procedure, create a new procedure named spHdSectionForRequesterSearch_Custom and assign a permission to run it to the "db_executor" group. For the proper functionality of ALVAO applications, the procedure must receive the same parameters as the original procedure and return the same columns.
spHdTicketPassToSolver_ExceptionalSolverList	dbo	Returns a list of exceptional solvers, used to assign tickets listed in table #temp1. The procedure can be customized. In order to customize the procedure, create a new procedure named spHdTicketPassToSolver_ExceptionalSolverList_SolverList_Custom and assign a permission to run it to the "db_executor" group. For the proper functionality of ALVAO applications, the procedure must receive the same parameters as the original procedure and return the same columns. The @iUserPersonId parameter, representing the signed in user, is not used in the standard procedure.
spHdTicketPassToSolver_SolverList	dbo	Returns a list of solvers, used to assign tickets listed in table #temp1. The procedure can be customized. In order to customize the procedure, create a new procedure named spHdTicketPassToSolver_SolverList_Custom and assign a permission to run it to the "db_executor" group. For the proper functionality of ALVAO applications, the procedure must receive the same parameters as the original procedure and return the same columns. The @iUserPersonId parameter, representing the signed in user, is not used in the standard procedure.
spHdTicketPassToSolverInHdSection_ExceptionalSolverList	dbo	Returns a list of exceptional solvers, used to assign the ticket when transitioning to the @iHdSectionId service.
spHdTicketPassToSolverInHdSection_SolverList	dbo	Returns a list of solvers, used to assign the ticket when transitioning to the @iHdSectionId service.
spHdTicketRecalcFirstReaction	dbo	Recomputes the solution of the first reaction for the ticket.
spHdTicketRecalcNextActionDeadline	dbo	Recomputes the target date of the current target for the ticket.
spHdTicketResolve	dbo	Switches the ticket to Resolved.
spHdTicketSolverOpen	dbo	Reopens the ticket by the solver.
spInsertToOperatorServiceUsage	dbo	A new record is inserted to the OperatorServiceUsage table or the LastUsed value is updated at the existing record. Only 20 latest records are saved in the table for each user.
spInsertToPersonEmailUsage	dbo	Inserts a new record into the PersonEmailUsage table.
spMakeKindUnique	dbo	Update table tblKind and column txtName to be unique.
spMoveNode	dbo	Moves the object in the object tree.
spMoveNodes	dbo	Bulk transfer of objects.
spNodeProperty	dbo	Returns the list of object properties with values converted to string.
spNotifyMacros	dbo	Auxiliary procedure which inserts the values of the macros used for configuring notifications into the #T table.
spOpeningHoursCache_Update	dbo	Updates the tOpeningHoursCache table for specific operating hours.
spPersonByPhoneNumber	dbo	Finds the user based on telephone number.
spPersonSearch	dbo	The procedure returns the list of persons according to the searched chain. The procedure can be customized. In order to customize the procedure, create a new procedure named spPersonSearch_Custom2 and assign a permission to run it to the "db_executor" group. For a proper functionality of ALVAO applications, the procedure must receive the same parameters as the original ones (see below) and return the same columns. The procedure returns the table containing the following columns: PersonId - contains Id of the User found. We do not recommend customizing. PersonEmail - contains the primary e-mail of the User found. We do not recommend customizing. PersonEmail2 - it contains the secondary e-mail of the User found by default. We do not recommend customizing. DisplayLine1 - it contains the User name and surname by default. The value of this column is used in prompting the persons on the first line of the item on the WebApp. The column can be customized. DisplayLine2 - contains the department, office, personal number, organization, office phone and cell phone of the person. The value of this column is used in prompting the persons on the second line of item on the WebApp. The column can be customized. DisplaySingleLine - it contains DisplayLine1 and DisplayLine2 combined columns by default. The column can be customized.
spReadAllCommunication	dbo	Marks all communication within the ticket regarding the entered person as read.
spReadAllDiary	dbo	Marks all ticket events with regard to the entered person as read.
spRebuildHdSectionLocalizationCache	dbo	Restores the localization cache for services.
spRebuildLocalizationCache	dbo	Restores all the localization cache.
spRebuildReorganizeIndexes	dbo	Rebuild or reorganize all indexes in the database based on their current fragmentation.
spRecalcCustColInformation	dbo	Recalculates information about the type and length of records in the tColumn table.
spRefreshLicProductCoverage	dbo	Updates the ProductCoverage table (the whole one or only a specific license)
spRefreshNodeParent	dbo	Recalculates the parent-child object cache in the tblNodeParent table.
spRefreshNodePath	dbo	Updates the cache of the path in the tree (tblNode.txtPath).
spRefreshRolePersonMembership	dbo	Updates the cache of the persons' membership in groups.
spRefreshSwProfileProductMembership	dbo	Updates the cache of the software sub-profiles membership in profiles.
spRemoveDetectResults	dbo	Removes the results of specific scans (ID,ID,...).
spRemoveDetects	dbo	Removes the specific scan (ID,ID,...).
spRemoveNodes	dbo	Permanently removes specific objects from tree (ID,ID,...).
spRemoveObjects	dbo	Permanently deletes specific objects from the tree, including child objects (ID, ID ...).
spReplaceSectionRights	dbo	Overwrites the permissions of the @dstSectionId service by permissions according to @srcSectionId service.
spReplaceSectionSLA	dbo	Overwrites the SLA setting of the @dstSectionId service by SLA setting according to @srcSectionId service.
spRequestCommunication	dbo	Ticket events in the Communication, Important or Detailed log mode.
spRequiredPropertyValuesCheck	dbo	Converts the warning cache to blank mandatory properties in the tblNode table.
spRequiredPropertyValuesCheck_TemplateProp	dbo
spSavePersonTicketDisplay	dbo	Inserts a record in the history of the last viewed tickets of the requester.
spSetContextInfo	dbo	Will set the user’s ID and date of action within the context of the database connection. These data are used, e.g., in the triggers which create the audit trace.
spStateReqCol	dbo	Returns a table with required items for transitioning the ticket @TicketId to @NewStateId.
spTakeLicence	dbo	Withdraws license for the computer software.
spTicketSearch	dbo	Returns a list of tickets by the specified string.
spTransferLicence	dbo	Transfers the license on a different computer / to a different cost center.
spUpdateColumnValuePath	dbo	Updates values in hierarchic list of values (tColumnValue) for the @ColumnId custom field.
spUpdateFTS	dbo	Update data in the FullTextSearch column for a specific @iHdTicketId ticket or for all tickets when entering 0 to the parameter.
spUpdateHdSectionRightsCache	dbo	Updates the authorization cache on services.
spUpdateInsertProperty	dbo	Updates the value of ALVAO system settings. If the setting does not exist, it is created.
spUpdateNodeCachedCols	dbo	Updates values in cached object columns.
spUpdateNodeCust_All	dbo	Updates property inheritance for the whole database.
spUpdateNodeCust_Nodes	dbo	Updates property inheritance for a specific nodes and subtrees.
spUpdateNodeCust_ObjNew	dbo	Updates property inheritance after a new object was created.
spUpdateNodeCust_PropNew	dbo	Updates property inheritance after a new object property was added.
spUpdateNodeCust_PropValChanged	dbo	Updates property inheritance after a change in the property value.
spUpdateNodeCust_Subtree	dbo	Updates the property inheritance for a specific subtree.
spUpdateNodeCust_TemplateProp	dbo
spUpdateNodeSearch	dbo	Update data in the Search column for a specific object or for all objects when entering invalid NodeId.
spUpdatePersonManager	dbo	The procedure for the update of the pre-counted structure of managers and employees.
spUpdatePropertyValue	dbo	Changes the value of the object property in AM. If history is permitted for the object, the change will be recorded in the log. If the property is the name of the object, it will be converted according to the new value.
spUpdateSlaPausedHours	dbo	Recalculates the time period of the SLA ticket pause.
spUpdateStatistics	dbo	Updating statistics of all tables in the database.
spUpdateTicketAlert	dbo	Updates the record in tHdTicket based on the current TicketAlert content.
spUpdateTicketHoursToCurrentTarget	dbo	Recomputes the time elapsed from the previous operating hours interval to the due date of the current target, either for all tickets with an internal target (when 1 is in @forceALL), for a specific ticket (when @ticketID is entered), or for all tickets which were transferred to the next interval of the operating hours (when NULL is entered in both parameters).
spUpdateTicketLastAction	dbo	Coverts the date of the last action related to the entered ticket number.
spWebAppLoginDelay	dbo	Protection against password-guessing attack.

dbo.spAddNodeCustColumn

Add new custom property for object to NodeCust table.

Parameters

Name	Type	Description
@intKindId	int	Property kind ID (tblKind.intKindId)

dbo.spAssetTreeNodeChilds

Returns the object off-springs in the tree.

Parameters

Name	Type	Description
@nodeId	int

dbo.spAssetTreeNodeChilds_Rights

Returns the object off-springs in the tree, adheres to the permission in the object tree.

Parameters

Name	Type	Description
@nodeId	int
@personId	int

dbo.spAssignLicenceItemToChildren

Assigns the license item to historical upgrades as well.

Parameters

Name	Type	Description
@LicHistItemId	int

dbo.spCalcNodeName

Converts the tree object name according to the properties forming the object name.

Parameters

Name	Type	Description
@nodeId	int

dbo.spCalcNodeNameAll

Converts the names of all tree objects, the names of which are formed from properties.

Parameters

dbo.spCalcNodeNameClass

Converts the names of all tree objects, the names of which are formed from properties, according to the group ID.

Parameters

Name	Type	Description
@TemplateNodeId	int

dbo.spCalcNodeNameList

Parameters

Name	Type	Description
@NodeIds	nvarchar(max)

dbo.spCalcNodeNameSubtree

Converts the names of sub-tree objects, the names of which are formed from properties.

Parameters

Name	Type	Description
@parentId	int

dbo.spCalcUnreadTicket

Sets the flag of the ticket to read/unread by the person.

Parameters

Name	Type	Description
@PersonId	int
@HdTicketId	int
@ActId	int
@ApprovalItemId	int

dbo.spCloseHdTicket

Required values will be stored in tHdTicket after closing the ticket.

Parameters

Name	Type	Description
@iHdTicketId	int
@iSolverPersonId	int
@bIgnoreRights	bit

dbo.spConvertPropertiesToDate

Converts text properties of the specific kind to date type.

Parameters

Name	Type	Description
@intKindId	int
@newKindName	nvarchar(255)

dbo.spConvertPropertiesToFloat

Converts text properties of the specific kind to float type.

Parameters

Name	Type	Description
@intKindId	int
@newKindName	nvarchar(255)

dbo.spCopySection

Copies the @srcSectionId service and sets it as the child of the @dstParentSectionId service. The service can be copied including (@copyChildren) Subtree. The newly created service ID is available from the @newSectionId output parameter.

Parameters

Name	Type	Description
@srcSectionId	int
@dstParentSectionId	int
@copyChildren	bit
@newSectionId	int

dbo.spCreateDetects

Create scans according to parameters.

Parameters

Name	Type	Description
@nodes	nvarchar(max)	List of computer Ids separated with commas.
@kindId	int	Scan type ID (1=HW, 2=SW).
@isManual	bit	Scan immediately. Note: If the value is 1, the existing pending tickets are overwritten in order to accelerate them.
@methodId	int	Scan method ID. If it is NULL, the scan for this type is disabled.
@tcpIpPort	int	Agent TCP/IP port.
@isSwFull	bit	Full SW scan.
@swInclude	nvarchar(255)	SW scan, include files.
@swExclude	nvarchar(255)	SW scan, skip files.
@period	int	Scan period (days).
@personId	int	Person ID. If it is NULL, use the system account.

dbo.spCreateDetectsBySetting

Plans scans according to saved setting to a specific computer (or to all computers in the active registry).

Parameters

Name	Type	Description
@nodes	nvarchar(max)	List of computer Ids separated with commas. If the parameter is NULL, detections are planned according to the saved setting to all computers in the active registry.
@isManual	bit	Scan immediately. Note: If the value is 1, the existing pending tickets are overwritten in order to accelerate them.
@personId	int	Person ID. If it is NULL, use the system account.
@detectProfileId	int	Scan profile ID. If set, scans for selected computer nodes are scheduled according to this profile. Note: If the value of @nodes is null, the parameter has no effect.

dbo.spCreateNodeFromTemplate

Creates an object based of the object template definition.

Parameters

Name	Type	Description
@templateClass	int
@name	nvarchar(255)
@target	int
@person	int
@skipGenerateFromSequence	bit
@computerSetId	int

dbo.spCustomColumn_Add

Add new custom field.

Parameters

Name	Type	Description
@sTable	nvarchar(255)
@sColumn	nvarchar(255)
@sTitle	nvarchar(255)
@mDescription	nvarchar(1024)
@nOrder	float
@bUseColumnValue	bit
@sType	nvarchar(255)
@nLength	int
@Multiline	bit
@Localize	bit
@RoleId	int

dbo.spCustomColumn_Drop

Removing custom fields.

Parameters

Name	Type	Description
@sTable	nvarchar(255)
@sColumn	nvarchar(255)

dbo.spDropNodeCustColumn

Drop custom property of object from tblKind and NodeCust table.

Parameters

Name	Type	Description
@intKindId	int	Property kind ID (tblKind.intKindId)

dbo.spEvalFileRule

Evaluation of one rule for files recognition.

Parameters

Name	Type	Description
@FileImageId	int

dbo.spEvalRegRule

Evaluation of the one rule for the recognition of registries.

Parameters

Name	Type	Description
@RegImageId	int

dbo.spEvalSwDetection

Evaluates SW scan based on patterns from the software products library.

Parameters

Name	Type	Description
@DetectId	int

dbo.spGeneratePropValuesFromSequence

Sets other values ​​for properties by numeric sequences.

Parameters

Name	Type	Description
@NodeId	int
@person	int

dbo.spGetNextNumFromIdSeq

Increments numerical row definition and returns current definition. If uniqueness is breached, it automatically searches the next free number based on the row definition.

Parameters

Name	Type	Description
@IdSeqId	int
@actualNum	nvarchar(255)

dbo.spHdSection_UpdateName

Full service name update (@iHdSectionId) including path in service tree.

Parameters

Name	Type	Description
@iHdSectionId	int

dbo.spHdSectionForRequesterSearch

Searching for the Requester’s services. Returns a table of services matching the entered parameters arranged by the path in the tree. The procedure can be customized. In order to customize the procedure, create a new procedure named spHdSectionForRequesterSearch_Custom and assign a permission to run it to the "db_executor" group. For the proper functionality of ALVAO applications, the procedure must receive the same parameters as the original procedure and return the same columns.

Parameters

Name	Type	Description
@sample	nvarchar(300)
@count	int
@personId	int
@requesterId	int
@isForMoveToService	bit

dbo.spHdTicketPassToSolver_ExceptionalSolverList

Returns a list of exceptional solvers, used to assign tickets listed in table #temp1. The procedure can be customized. In order to customize the procedure, create a new procedure named spHdTicketPassToSolver_ExceptionalSolverList_SolverList_Custom and assign a permission to run it to the "db_executor" group. For the proper functionality of ALVAO applications, the procedure must receive the same parameters as the original procedure and return the same columns. The @iUserPersonId parameter, representing the signed in user, is not used in the standard procedure.

Parameters

Name	Type	Description
@iUserPersonId	int

dbo.spHdTicketPassToSolver_SolverList

Returns a list of solvers, used to assign tickets listed in table #temp1. The procedure can be customized. In order to customize the procedure, create a new procedure named spHdTicketPassToSolver_SolverList_Custom and assign a permission to run it to the "db_executor" group. For the proper functionality of ALVAO applications, the procedure must receive the same parameters as the original procedure and return the same columns. The @iUserPersonId parameter, representing the signed in user, is not used in the standard procedure.

Parameters

Name	Type	Description
@iUserPersonId	int

dbo.spHdTicketPassToSolverInHdSection_ExceptionalSolverList

Returns a list of exceptional solvers, used to assign the ticket when transitioning to the @iHdSectionId service.

Parameters

Name	Type	Description
@iHdSectionId	int

dbo.spHdTicketPassToSolverInHdSection_SolverList

Returns a list of solvers, used to assign the ticket when transitioning to the @iHdSectionId service.

Parameters

Name	Type	Description
@iHdSectionId	int

dbo.spHdTicketRecalcFirstReaction

Recomputes the solution of the first reaction for the ticket.

Parameters

Name	Type	Description
@ticketId	int

dbo.spHdTicketRecalcNextActionDeadline

Recomputes the target date of the current target for the ticket.

Parameters

Name	Type	Description
@ticketId	int

dbo.spHdTicketResolve

Switches the ticket to Resolved.

Parameters

Name	Type	Description
@iHdTicketId	int
@iSolverPersonId	int
@bIgnoreRights	bit
@dResolved	datetime

dbo.spHdTicketSolverOpen

Reopens the ticket by the solver.

Parameters

Name	Type	Description
@iHdTicketId	int
@iSolverPersonId	int

dbo.spInsertToOperatorServiceUsage

A new record is inserted to the OperatorServiceUsage table or the LastUsed value is updated at the existing record.
Only 20 latest records are saved in the table for each user.

Parameters

Name	Type	Description
@PersonId	int	ID of the main solver who used the given service while registering the ticket.
@HdSectionId	int	Used service ID while registering the ticket.

dbo.spInsertToPersonEmailUsage

Inserts a new record into the PersonEmailUsage table.

Parameters

Name	Type	Description
@UsedByPersonId	int	ID of the user who used the e-mail address.
@UsedEmail	varchar	Used e-mail address for sending the message.

dbo.spMakeKindUnique

Update table tblKind and column txtName to be unique.

Parameters

dbo.spMoveNode

Moves the object in the object tree.

Parameters

Name	Type	Description
@node	int
@target	int
@person	int

dbo.spMoveNodes

Bulk transfer of objects.

Parameters

Name	Type	Description
@nodeIds	nvarchar(max)	List of object IDs, separated by commas.
@destNodeId	int	ID of target object.
@personId	int	ID of the person who is performing the operation.
@dteHist	datetime	Date of transfer.
@retCode	int	Returned value in the form of a bit array: 0 = operation was successful. 1 = user is not authorized to transfer objects (role). Some objects were not transferred because: 2 = the user is not authorized to carry out the transfer (object security). 4 = the object has the attribute "immovable". 8 = the transferred object is also the target object. 16 = the target object is also a child object of one of the moved objects. 32 = the transferred object is already a child object of the target object. 64 = is moved to the Recycle Bin or Discarded assets and some objects have their own propertyIt is responsible for the assets together with a specific user

dbo.spNodeProperty

Returns the list of object properties with values converted to string.

Parameters

Name	Type	Description
@nodes	Node	Table with object IDs (tblNode.intNodeId) for which all their properties are returned. If empty, properties for all objects are returned.
@kindId	int	Specific property kind (tblKind.intKindId).
@inherited	bit	Whether to return inherited properties.
@localeId	int

dbo.spNotifyMacros

Auxiliary procedure which inserts the values of the macros used for configuring notifications into the #T table.

Parameters

Name	Type	Description
@iHdTicketId	int

dbo.spOpeningHoursCache_Update

Updates the tOpeningHoursCache table for specific operating hours.

Parameters

Name	Type	Description
@openingHoursId	int	ID of operating hours (tOpeningHours.iOpeningHoursId).

dbo.spPersonByPhoneNumber

Finds the user based on telephone number.

Parameters

Name	Type	Description
@caller	nvarchar(255)

dbo.spPersonSearch

The procedure returns the list of persons according to the searched chain. The procedure can be customized. In order to customize the procedure, create a new procedure named spPersonSearch_Custom2 and assign a permission to run it to the "db_executor" group. For a proper functionality of ALVAO applications, the procedure must receive the same parameters as the original ones (see below) and return the same columns. The procedure returns the table containing the following columns:
PersonId - contains Id of the User found. We do not recommend customizing.
PersonEmail - contains the primary e-mail of the User found. We do not recommend customizing.
PersonEmail2 - it contains the secondary e-mail of the User found by default. We do not recommend customizing.
DisplayLine1 - it contains the User name and surname by default. The value of this column is used in prompting the persons on the first line of the item on the WebApp. The column can be customized.
DisplayLine2 - contains the department, office, personal number, organization, office phone and cell phone of the person. The value of this column is used in prompting the persons on the second line of item on the WebApp. The column can be customized.
DisplaySingleLine - it contains DisplayLine1 and DisplayLine2 combined columns by default. The column can be customized.

Parameters

Name	Type	Description
@sample	nvarchar(100)	Searched string. If the procedure is not customized, the search proceeds in the person's name, department, office, personal number, organization, office phone number and cell phone number.
@accountId	int	Id of the organization in which the persons are to be searched. If the value is NULL the search will take place among all persons.
@guest	bit	It specifies whether the Host type user will also be shown in the results.
@personId	int	Person Id. If it is filled and the @sample parameter is NULL, the procedure returns a person with the given Id.
@where	nvarchar(4000)	Text string in which it is possible to define the custom part of the where condition for an assembled query. For proper functionality of ALVAO applications it is necessary that the custom procedure contains a tPerson table with a p alias.
@top	int	Specifies the number of selected records. If the @top is not filled in, the procedure returns 100 records.
@onlyCustomizableUsers	bit
@rightLimitationPersonId	int

dbo.spReadAllCommunication

Marks all communication within the ticket regarding the entered person as read.

Parameters

Name	Type	Description
@PersonId	int
@TicketId	int

dbo.spReadAllDiary

Marks all ticket events with regard to the entered person as read.

Parameters

Name	Type	Description
@PersonId	int
@TicketId	int

dbo.spRebuildHdSectionLocalizationCache

Restores the localization cache for services.

Parameters

dbo.spRebuildLocalizationCache

Restores all the localization cache.

Parameters

dbo.spRebuildReorganizeIndexes

Rebuild or reorganize all indexes in the database based on their current fragmentation.

Parameters

dbo.spRecalcCustColInformation

Recalculates information about the type and length of records in the tColumn table.

Parameters

dbo.spRefreshLicProductCoverage

Updates the ProductCoverage table (the whole one or only a specific license)

Parameters

Name	Type	Description
@LicHistId	int

dbo.spRefreshNodeParent

Recalculates the parent-child object cache in the tblNodeParent table.

Parameters

Name	Type	Description
@parentId	int	The ID of the object in whose sub-tree the cache is to be recalculated. NULL = whole tree.

dbo.spRefreshNodePath

Updates the cache of the path in the tree (tblNode.txtPath).

Parameters

Name	Type	Description
@node	int

dbo.spRefreshRolePersonMembership

Updates the cache of the persons' membership in groups.

Parameters

dbo.spRefreshSwProfileProductMembership

Updates the cache of the software sub-profiles membership in profiles.

Parameters

dbo.spRemoveDetectResults

Removes the results of specific scans (ID,ID,...).

Parameters

Name	Type	Description
@detlist	nvarchar(max)

dbo.spRemoveDetects

Removes the specific scan (ID,ID,...).

Parameters

Name	Type	Description
@detlist	nvarchar(max)

dbo.spRemoveNodes

Permanently removes specific objects from tree (ID,ID,...).

Parameters

Name	Type	Description
@nodes	nvarchar(max)

dbo.spRemoveObjects

Permanently deletes specific objects from the tree, including child objects (ID, ID ...).

Parameters

Name	Type	Description
@nodes	nvarchar(max)
@childonly	bit
@maxremove	int

dbo.spReplaceSectionRights

Overwrites the permissions of the @dstSectionId service by permissions according to @srcSectionId service.

Parameters

Name	Type	Description
@srcSectionId	int
@dstSectionId	int

dbo.spReplaceSectionSLA

Overwrites the SLA setting of the @dstSectionId service by SLA setting according to @srcSectionId service.

Parameters

Name	Type	Description
@srcSectionId	int
@dstSectionId	int

dbo.spRequestCommunication

Ticket events in the Communication, Important or Detailed log mode.

Parameters

Name	Type	Description
@iHdTicketId	int	Ticket ID (tHdTicket.iHdTicketId).
@showRemoved	bit	Display deleted records. 0 = no, 1 = yes.
@iPersonId	int	Logged in person ID (tPerson.iPersonId).
@start	int	The order of the event from which the result will be returned (sorted chronologically).
@specificActId	int	Specific event ID (Tact.iActId). If entered, the content of only this one event is returned.
@mode	int	Mode. 1 = Communication, 2 = Important, 3 = Detailed log.
@localeId	int	LCID of the language in which the dynamically generated events will be generated. E.g. for CZ = 1029, EN = 1033.
@ftsConditions	nvarchar(max)
@query	nvarchar(max)
@top	int	Limits number of returned events.
@includeTotal	bit	1 = Total column contains number of all events, 0 = Total column is NULL

dbo.spRequiredPropertyValuesCheck

Converts the warning cache to blank mandatory properties in the tblNode table.

Parameters

Name	Type	Description
@nodeIds	nvarchar(max)	The ID of the object in which the cache is to be recalculated.
@recalculateAll	bit	Flag whether to recalculate the cache for all objects in the tblNode table.

dbo.spRequiredPropertyValuesCheck_TemplateProp

Parameters

Name	Type	Description
@kindId	int

dbo.spSavePersonTicketDisplay

Inserts a record in the history of the last viewed tickets of the requester.

Parameters

Name	Type	Description
@ticketId	int
@personId	int

dbo.spSetContextInfo

Will set the user’s ID and date of action within the context of the database connection. These data are used, e.g., in the triggers which create the audit trace.

Parameters

Name	Type	Description
@personId	int	User ID (tPerson.iPersonId)
@date	datetime	Date & time. If not entered, the current date and time will be used.

dbo.spStateReqCol

Returns a table with required items for transitioning the ticket @TicketId to @NewStateId.

Parameters

Name	Type	Description
@TicketId	int
@NewStateId	int
@LocaleId	int

dbo.spTakeLicence

Withdraws license for the computer software.

Parameters

Name	Type	Description
@LicHistItemId	int

dbo.spTicketSearch

Returns a list of tickets by the specified string.

Parameters

Name	Type	Description
@sample	nvarchar(100)
@personId	int
@count	int
@where	nvarchar(4000)

dbo.spTransferLicence

Transfers the license on a different computer / to a different cost center.

Parameters

Name	Type	Description
@itemId	int
@person	int
@NewComputerNodeId	int
@NewCostCentre	nvarchar(255)

dbo.spUpdateColumnValuePath

Updates values in hierarchic list of values (tColumnValue) for the @ColumnId custom field.

Parameters

Name	Type	Description
@ColumnId	int

dbo.spUpdateFTS

Update data in the FullTextSearch column for a specific @iHdTicketId ticket or for all tickets when entering 0 to the parameter.

Parameters

Name	Type	Description
@iHdTicketId	int

dbo.spUpdateHdSectionRightsCache

Updates the authorization cache on services.

Parameters

dbo.spUpdateInsertProperty

Updates the value of ALVAO system settings. If the setting does not exist, it is created.

Parameters

Name	Type	Description
@PropertyName	nvarchar(255)
@sPropertyValue	nvarchar(2048)
@bPropertyValue	bit
@iPropertyValue	int
@dPropertyValue	datetime

dbo.spUpdateNodeCachedCols

Updates values in cached object columns.

Parameters

Name	Type	Description
@nodeIds	nvarchar(max)	List of object IDs (tblNode.intNodeId), separated by commas. When NULL, procedure updates columns on all objects.

dbo.spUpdateNodeCust_All

Updates property inheritance for the whole database.

Parameters

dbo.spUpdateNodeCust_Nodes

Updates property inheritance for a specific nodes and subtrees.

Parameters

Name	Type	Description
@nodeIds	nvarchar(max)

dbo.spUpdateNodeCust_ObjNew

Updates property inheritance after a new object was created.

Parameters

Name	Type	Description
@objId	int

dbo.spUpdateNodeCust_PropNew

Updates property inheritance after a new object property was added.

Parameters

Name	Type	Description
@kindId	int

dbo.spUpdateNodeCust_PropValChanged

Updates property inheritance after a change in the property value.

Parameters

Name	Type	Description
@objId	int
@kindId	int

dbo.spUpdateNodeCust_Subtree

Updates the property inheritance for a specific subtree.

Parameters

Name	Type	Description
@objId	int

dbo.spUpdateNodeCust_TemplateProp

Parameters

Name	Type	Description
@kindId	int

dbo.spUpdateNodeSearch

Update data in the Search column for a specific object or for all objects when entering invalid NodeId.

Parameters

Name	Type	Description
@NodeId	int	Object ID (tblNode.intNodeId) to update.
@ClassId	int	Object type ID (tblClass.intClassId) to update. Only objects of that type are updated.

dbo.spUpdatePersonManager

The procedure for the update of the pre-counted structure of managers and employees.

Parameters

dbo.spUpdatePropertyValue

Changes the value of the object property in AM. If history is permitted for the object, the change will be recorded in the log. If the property is the name of the object, it will be converted according to the new value.

Parameters

Name	Type	Description
@nodeId	int
@kindId	int
@valueString	nvarchar(255)
@valueDate	date
@valueFloat	float
@valueInt	int
@personId	int
@shouldLog	bit

dbo.spUpdateSlaPausedHours

Recalculates the time period of the SLA ticket pause.

Parameters

Name	Type	Description
@ticketId	int

dbo.spUpdateStatistics

Updating statistics of all tables in the database.

Parameters

dbo.spUpdateTicketAlert

Updates the record in tHdTicket based on the current TicketAlert content.

Parameters

Name	Type	Description
@iHdTicketId	int	Ticket ID.

dbo.spUpdateTicketHoursToCurrentTarget

Recomputes the time elapsed from the previous operating hours interval to the due date of the current target, either for all tickets with an internal target (when 1 is in @forceALL), for a specific ticket (when @ticketID is entered), or for all tickets which were transferred to the next interval of the operating hours (when NULL is entered in both parameters).

Parameters

Name	Type	Description
@forceAll	bit	Decide whether the recalculation should be done for all tickets with an internal goal.
@ticketId	int	Ticket number for which a recalculation will be forced.

dbo.spUpdateTicketLastAction

Coverts the date of the last action related to the entered ticket number.

Parameters

Name	Type	Description
@TicketId	int

dbo.spWebAppLoginDelay

Protection against password-guessing attack.

Parameters

Name	Type	Description
@loginTry	int