Skip Navigation LinksALVAO 10.1ALVAO Asset ManagementSystem Implementation in an OrganizationCustom Edits and ExtensionsALVAO database Skip Navigation Links. Skip Navigation Links Skip Navigation Links.


Change ALVAO version
Change language

ALVAO database

This section describes the ALVAO database structure.

It is intended for the develepers, who develop their own extensions for the ALVAO system.

This database is used together by all ALVAO products.

List of tables

Table Scheme Description
ActOperation dbo Kind of process in the request log
AdTrustedDomain dbo List of trustworthy domains.
AppCategory dbo Application category list. The list is predefined. Custom items cannot be added.
ArticleHdSection dbo Assigning articles from the knowledge base to services.
AssetDetectionUpload dbo Information on files received from autonomous Agents.
ColumnValueLoc dbo Cache of value list item localizations.
DetRegUninstall dbo Detected registry entries. The table contains records which may differ in various computers.
EmailSignatureHdSection dbo Assigning signatures to services.
HdSectionLoc dbo Cache of service localizations.
HdSectionManager dbo Effective service managers.
HdSectionMessageTag dbo Unique service prefix and suffix pair.
HdSectionOperator dbo Effective service operators.
HdSectionReader dbo Effective readers in services.
HdSectionSolver dbo Effective service solvers.
IdSeqType dbo Numeric sequence types.
IntegratedAuthIpRange dbo IP address range for Integrated Windows Authentication.
KindDataType dbo Property data types in AM.
KindRight dbo Security for properties.
LicDowngrade dbo License - downgrade.
LicHistCust dbo License custom items values.
LicHistItemAssign dbo Assigning/removing/moving license to/from/between computers.
LicHistLog dbo Change record for a license or a license item.
LicHistLogKind dbo Kind of change of a license or a license item.
LicHistRelation dbo A table containing links between licenses in AM Console
LicHistRelationType dbo Types of links between licenses in the AM
LicHistRelationTypeBehavior dbo Types of links between objects in the AM from the viewpoint of system/custom links.
LicKind dbo "CAL/Licensing" list, i.e. per device, per user, etc.
LicProductCoverage dbo Which of all products have license coverage.
LicType dbo License types.
MailMessage dbo Outgoing email queue.
News dbo Current messages.
NewsHdSection dbo Services for which the individual current messages are intended.
NodeRelation dbo Table with links between objects in AM Console
NodeRelationType dbo Types of links between objects in AM
NodeRelationTypeBehavior dbo Types of links between objects in AM from the viewpoint of system/custom links
NodeRightLog dbo Logging of changes in permissions of users in Asset Management.
PersonBehavior dbo People types. Normal users =1, system users >1.
PersonEmailUsage dbo Use of an e-mail address for sending the message by a specific user.
PersonEventDisplay dbo Events viewed by a person.
PersonManager dbo Pre-counted structure of managers and employees.
PersonPasswordHistory dbo Used people's passwords.
PersonTicketDisplay dbo A record from the history of the last viewed requests of the requester.
Printer dbo Printers
PrintJob dbo Printing tasks
PrivateModeInsertReq dbo Request to insert private mode.
ProductCust dbo
ProductState dbo Product status
ProductUsage dbo Table containing utilization of individual products on the computers over past 12 months.
ProfileValue dbo View settings table
ReanalyzeRecordsRequest dbo Request to recalculate statistics.
ReceivedMessage dbo Table for temporary storage of read messages for custom actions.
ReceivedMessageRule dbo Rules for incoming messages for MailboxReader
RoleBehavior dbo Types of system rolls, e.g. all users, administrators, ...
RoleMembershipLog dbo Logging of changes in membership in groups.
RoleMembershipLogMemberType dbo Kind of membership in the group.
RoleMembershipLogOperation dbo Executed operation which is logged.
SamAlert dbo SAM notifications sent.
SamAlertConfig dbo SAM configuration of notifications.
SamAlertRule dbo SAM notification rules.
SamType dbo SAM notification type - Audit: yes, no, via e-mail.
Server dbo Setting the ALVAO servers (AM Collector).
SlaAlertRuleReceiver dbo Notice for unresolved requests - other recipients.
SlaLoc dbo Cache of SLA localizations.
StringLoc dbo Cache of text string localizations.
Subscriber dbo A table containing information on the customer and on the request on which information is taken.
SwItemKind dbo Kinds of records in the views of software.
tAccount dbo Organization (in accordance with CRM, i.e. the company).
tAccountCust dbo Organization custom items values.
tAct dbo Request log record or message in "Current messages" block.
tActHd dbo Expanding tAct information for the request log.
tActKind dbo Record type tAct, e.g. "e-mail“, "phone“, "note“, "process“, …
tAddress dbo Address
tApprovalSchema dbo Approval schemes.
tApprovalSchemaItem dbo Approval scheme step.
tArticle dbo Article in Knowledge Base.
tBankHoliday dbo National holidays.
tBankHolidayLoaded dbo National holiday blocks included in the database. A block is a list of holidays belonging to one region and year.
tBankHolidayRegion dbo Local national holiday regions.
tblADMap dbo Mapping attributes from AD to AM properties. This configuration is used by ImportAD.
tblAsset dbo Identification numbers of documents and media.
tblAtom dbo Kind of record - document / medium.
tblAtomLend dbo Information on items lent and returned in the media library.
tblClass dbo ID of the objects types. Texts in tblDict.
tblCommandDef dbo Definitions of commands for the "Administrator's Tools" function.
tblCompany dbo Code list of organizations (software products library).
tblComputerIdClass dbo ID of the objects types based on which the computer is identified during the detection of HW and SW.
tblComputerLog dbo GTS NOVERA detections.
tblDetect dbo Information on HW and SW detections in the computers.
tblDetectAction dbo Scheduled evaluation of HW and SW by detection.
tblDetectKind dbo ID of the types of detection (HW, SW). Texts in tblDict.
tblDetectMethod dbo ID of the methods of detection (without Agent, Agent via TCP/IP, ...). Texts in tblDict.
tblDetectOpts dbo Detections setting.
tblDetectStatus dbo ID of the detections statuses. Texts in tblDict.
tblDetFile dbo Detected files on the computers (SW detection).
tblDict dbo Common table for the text code lists of the system tables values.
tblDocument dbo Documents.
tblDocumentKind dbo Kinds of documents. Texts in tblDict
tblEvent dbo Reminders.
tblFile dbo Detected files on the computer (SW detection).
tblFileImage dbo Recognition rules for files (software products library).
tblFileStringInfo dbo Information on detected files - texts.
tblFileVerInfo dbo Information on detected files - versions.
tblHistory dbo Log - history of objects in the tree - move, deletion, insertion, etc.
tblIcon dbo Icons.
tblIdSeq dbo Numerical series - definitions.
tblInstHist dbo Records on installation and uninstallation of products on the computers (manual as well as detected)
tblInstTrial dbo Special installation.
tblInventory dbo Stocktaking - list of stocktakings.
tblInventoryAsset dbo Stocktaking - assets in a specific stocktaking.
tblInventoryAssetPack dbo Stocktaking - list of reader's files.
tblInventoryAssetPackRel dbo Stocktaking - assignment of assets to readers.
tblInventoryAtom dbo Stocktaking - documents.
tblKind dbo Definitions of the objects properties.
tblKindValue dbo Value lists for the properties of objects.
tblLang dbo ID of languages. Text in tblDict
tblLicHist dbo License - list of purchased software licenses.
tblLicHistAtom dbo License - links to documents and media.
tblLicHistItem dbo License - license items.
tblLicTrans dbo License - shared licenses.
tblLog dbo Log - changes in the properties values and information on the detection results.
tblMedia dbo Media.
tblMediaType dbo ID of the media types. Texts in tblDict.
tblNetScanRange dbo Network search setting.
tblNode dbo Objects in the tree.
tblNodeAtom dbo Objects in the tree - links to documents.
tblNodeParent dbo Objects in the tree - tree.
tblNotice dbo Notes.
tblOsVersionInfo dbo Detection of SW - information on the operating system.
tblProduct dbo Products / software (software products library).
tblProductCategory dbo ID of the products categories (OS). Text in tblDict.
tblProductPack dbo Definition of software products packages (software products library).
tblProductType dbo ID of the products types (commercial, freeware, ...) (software products library).
tblProperty dbo Objects in the tree - properties.
tblPropertyMap dbo Mapping properties to system functions.
tblRegImage dbo Software products library - recognition rules for records from the register.
tblRegUninstall dbo Detected registry entries. The table contains records which may repeat in various computers.
tblRegValue dbo Detection - values of detected records from the register.
tblSetting dbo Mapping properties to system functions.
tblSwLibUpdate dbo Information on which computer is executing the software products library update.
tblSystemSetting dbo System settings.
tblUserNodeRight dbo Rights in the object tree to groups / users.
tblVersion dbo Software products library version.
tblWbemClassDesc dbo Code list of values for the detected HW properties.
tblWbemObject dbo HW detected in the computers.
tblWbemObjectProcess dbo Hardware "Blacklist".
tblWbemObjectRel dbo Links between the detected components of the computers.
tBuilding dbo Buildings, see item Request.Building.
tColumn dbo List of custom items and certain system items.
tColumnValue dbo Value lists for custom items.
tComputer dbo Computers for the ALVAO User Activity Monitoring and ALVAO HW/SW Usage Monitoring modules.
tDay dbo Calendar of days
tDb dbo Database version, database language ID, activation keys for the entire ALVAO.
tDetectedClassKind dbo Detected properties of the computer components.
tDocument dbo Attachments (to documents, notes, events, e-mails, ...) concerning the entire ALVAO system.
tEmailSignature dbo Signatures for e-mail messages.
tEmailTemplate dbo Templates of custom notifications and alerts sent by the ALVAO SAM Assistant module.
tHdSection dbo ALVAO Service Desk product services.
tHdSectionCust dbo Services custom items values.
tHdSectionPerson dbo Setting of notifications from the services to individual persons.
tHdSectionRights dbo Authorization individuals and groups have in services (Operator, Solver, ...).
tHdTicket dbo Requests.
tHdTicketAltMessageTag dbo Alternative request tags. Upon merging requests, the final request uses tags from original requests as alternative tags.
tHdTicketApproval dbo Request approval process instance - main record.
tHdTicketApprovalItem dbo Request approval step.
tHdTicketApprovalItemResult dbo List of approval step statuses.
tHdTicketCategory dbo Request.Category item values.
tHdTicketCust dbo Request custom items values.
TicketApprovalMessageForApproverLoc dbo Localized message for approvers.
TicketChange dbo Request log record for changes to the request item value.
TicketRelation dbo Links Between Requests.
TicketRelationType dbo Types of links between requests.
TicketRelationTypeBehavior dbo System types of links between requests.
TicketSequence dbo A table containing the next request number.
TicketState dbo Workflow statuses defined within Processes. Status names correspond with request states.
TicketStateBehavior dbo Workflow system statuses defined within Processes.
TicketStateLoc dbo Cache of the localizations of request states.
TicketStateRelation dbo Permitted transitions between Workflow statuses.
TicketStateRequiredColumn dbo Mandatory items for individual Workflow statuses.
TicketTemplate dbo List of request templates
TicketTemplateColumnValue dbo column values on request template.
TicketType dbo Processes. The processes define the workflow for resolving requests.
TicketTypeBehavior dbo System processes.
TicketTypeColumn dbo Request items used by the process.
TicketTypeLoc dbo Cache of process localizations.
tIdSeqClass dbo Numerical series - definitions for types of objects.
TimeZone dbo Time zone list.
TimeZoneBias dbo Time zone shifts compared to UTC for each year
tLocale dbo Language environments.
tLocalization dbo Language localization for selected database values. The following items are supported: tHdSection.sHdSectionShort, tHdSection.mHdSectionDesc.
tNodeProduct dbo Software profiles - exceptions for the computer.
tOpeningHours dbo Service working hours.
tOpeningHoursCache dbo Auxiliary records for optimizing time calculations according to service working hours.
tOpeningHoursException dbo Exceptions in service working hours.
tPerson dbo Persons in the ALVAO system.
tPersonCust dbo Persons in the ALVAO system - own items.
tPersonRights dbo Permission that people and groups have for records on the activities of other people and groups within the ALVAO User Activity Monitoring module.
tPreComputedDay dbo Daily user activity record summary.
tProperty dbo ALVAO system settings.
TransferConfirmAlert dbo Sent alerts to sign the handover protocols.
TransferConfirmAlertConfig dbo Setting time of sending an alert and the period of the last alert repetition.
TransferConfirmAlertRule dbo Settings of rules for sending alerts of not yet signed handover protocols.
TransferConfirmType dbo Method of the assets takeover signing.
tRole dbo Groups of persons for the entire ALVAO.
tRolePerson dbo Persons' membership in groups.
tRoleRole dbo Groups' membership in groups.
tRoom dbo Rooms, see item Request.Room.
tSla dbo SLA.
tSlaAlert dbo Request log records for notification sent for an unresolved issue or upcoming deadline.
tSlaAlertRule dbo Rule for sending notifications for unresolved issues or an upcoming deadline.
tSlaCust dbo SLA custom items values.
tSlaRights dbo Assigning SLA to individuals and groups.
tSmtp dbo Configuration of the SMTP server for ALVAO.
tString dbo System code list for texts.
tSwLibAddUnknown dbo Sending unrecognized records, request for adding product to the standard software products library.
tSwPresence dbo Software profiles - product statuses.
tSwProfile dbo Software profiles - list.
tSwProfileProduct dbo Software profiles - membership of products in profiles.
tSwProfileSwProfile dbo Software profiles - sub-profiles.
tTimeOff dbo Employee absence records.
tTimeOffKind dbo Types of employee absence records.
tUnassignedProcess dbo Processes which the ALVAO User Security Monitoring module was not able to assign to applications according to the Software Products Library.
tUserLogin dbo User sign in or out to/from the computer.
tWeekOpeningHours dbo Item in the definition of service working hours.
tWMIDefaultSetting dbo Default settings for using WMI technology in the ALVAO User Activity Monitoring module.
tWorkLoad dbo Employee labor contracts.
tWorkTime dbo Employee attendance record created in the ALVAO Attendance module.
tWorkTimeSnapshot dbo Employee attendance records used by the ALVAO User Activity Monitoring module to hide records for extracurricular activities.
UploadFileInfo dbo Information about the file uploaded via ServiceDesk WebService.
UserLogonLog dbo Logging of the users logon/logout to/from Admin and Asset Management Console.
UserLogonLogAction dbo Executed action which is logged.
UserLogonLogApplication dbo Application name.
WebAppActiveSession dbo Active session at ALVAO WebApp.
WorkOvertimeDisposal dbo Table with list of paid overtime hours

List of views

View Scheme Description
Computer Query View with objects of the computer in Asset type which are not hidden or in Discarded assets. In addition to described columns, the table contains the value of 100 most widely used properties. The column name and the property name are always identical.
Log dbo "Log" in AM.
Node dbo "Objects" in AM.
Node Query View with all objects in Asset which are not hidden or in Discarded assets. In addition to described columns, the table contains the value of 100 most widely used properties. The column name and the property name are always identical.
NodeDiary Query View with the log for objects.
NodeParent Query View with all objects in Asset and their child objects (including indirect links - deep immersion).
NodeRightLog Query View of the list of changes in permissions in the objects tree.
RequestContinualResponseCsy Query Continuous informing of the requester by the solver team in requests within the ALVAO Service Desk. Continuous informing is a message sent from the vendors to the customer during the solution of their request; such messages are not reactions to a previous message from the customer. This view is used to create reports and analyses.
RequestContinualResponseEnu Query Continuous informing of the requester by the solver team in requests within the ALVAO Service Desk. Continuous informing is a message sent from the vendors to the customer during the solution of their request; such messages are not reactions to a previous message from the customer. This view is used to create reports and analyses.
RequestCsy Query Requests in ALVAO Service Desk. This view is used to create reports and analyses.
RequestEnu Query Requests in ALVAO Service Desk. This view is used to create reports and analyses.
RequestFirstReactionCsy Query First reaction of the solver team in requests within the ALVAO Service Desk. The first reaction is the first message which the service vendor gave to the customer from receipt of their request. This view is used to create reports and analyses.
RequestFirstReactionEnu Query First reaction of the solver team in requests within the ALVAO Service Desk. The first reaction is the first message which the service vendor gave to the customer from receipt of their request. This view is used to create reports and analyses.
RequestLogCsy Query Records in request logs in ALVAO Service Desk. This view is used to create reports and analyses.
RequestLogEnu Query Records in request logs in ALVAO Service Desk. This view is used to create reports and analyses.
RequestOperationCsy Query Basic operations (Created, Deleted, Resolved, Closed) with requests in Alvao Service Desk over time. This view is used to create reports and analyses.
RequestOperationEnu Query Basic operations (Created, Deleted, Resolved, Closed) with requests in Alvao Service Desk over time. This view is used to create reports and analyses.
RequestReopenCsy Query Reopening of requests in ALVAO Service Desk. This view is used to create reports and analyses.
RequestReopenEnu Query Reopening of requests in ALVAO Service Desk. This view is used to create reports and analyses.
RequestResolutionCsy Query Solution of requests in ALVAO Service Desk. This view is used to create reports and analyses.
RequestResolutionEnu Query Solution of requests in ALVAO Service Desk. This view is used to create reports and analyses.
RequestSubsequentResponseCsy Query Follow-up reactions of the solver team in requests within the ALVAO Service Desk. The subsequent reaction is the first message from the vendor sent to the customer from the receipt of any message from the customer in the course of processing their request. This view is used to create reports and analyses.
RequestSubsequentResponseEnu Query Follow-up reactions of the solver team in requests within the ALVAO Service Desk. The subsequent reaction is the first message from the vendor sent to the customer from the receipt of any message from the customer in the course of processing their request. This view is used to create reports and analyses.
RoleMembershipLog Query View of the list of changes in permissions in the objects tree.
Software Query View with installed products (software) on not yet deleted computers.
User Query View with all objects of the User in Asset type which are not hidden or in Discarded assets. In addition to described columns, the table contains the value of 100 most widely used properties. The column name and the property name are always identical.
UserLogonLog Query View of the list of changes in permissions in the objects tree.
vAct dbo Request log. The view collects data from various tables.
vApprovalAuthority dbo Current approvers of requests that are currently in the process of being approved.
vApprovalAuthority_Custom dbo Current request approvers according to custom approval processes. The customer can define custom contents for this view.
vAssetPersonSystemRole dbo User membership in system roles of Asset Management.
vAssetUser dbo Users in the object tree.
vAssetUserPerson dbo The user's link in the object tree to the user in the Admin service (tPerson. Link based on priority: 1. AD GUID 2. Personal number 3. Login name 4. E-mail
vClass dbo Types of objects.
vColumnLoc dbo Translations of the names and descriptions of custom items in all languages ​​used.
vColumnValueLoc dbo Translations of custom items values in all languages ​​used.
vComputer dbo Computers.
vComputerDetectLast dbo Last detection of the computers.
vComputerSwManager dbo People and their superiors responsible for software installed on the computer
vComputerUsage dbo Displays the utilization of the computers (in hours) over the past month and year.
vDefaultSla dbo Default SLA for individuals and services.
vDetectKind dbo Types of detections (HW, SW).
vDetFiles dbo Detected files.
vDocument dbo Documents.
vDocumentKind dbo Kinds of documents.
vEmailTemplateLoc dbo Translations of custom notifications in all languages ​​used.
vEvent dbo Reminders.
vHdSectionEffectiveShowInServiceCatalog dbo View for effective viewing of the "View in the Service Catalogue" option. Takes into account settings in parent services.
vHdSectionExceptionalSolver dbo Effective irregular solvers in services.
vHdSectionLoc dbo Auxiliary view for the language localization of service names and descriptions.
vHdSectionOperator_Direct dbo Effective service operators without absentee stand-ins.
vHdSectionPerson dbo Effective settings of notifications sent from the services to individual persons.
vHdSectionSolverTake1 dbo Effective service solvers authorized to "retrieve another request - main".
vHdSectionSolverTake2 dbo Effective service solvers authorized to "retrieve another request - secondary".
vHdTicket dbo Values for dynamically calculated request items.
vHdTicketApprovalItemResultLoc dbo
vHdTicketCalc dbo Information whether the request can indeed be reopened.
vHdTicketPersonRead dbo Effective authorization to display requests.
vInstDetect dbo Installed software, detected version and activation code.
vInstTrial dbo Installations covered by "special installation", including the coverage for package components.
vKnowledgeRead dbo Knowledge that a user can read in services.
vLang dbo Languages.
vLastEvaluatedSwDetect dbo Last evaluated SW detection on the computer.
vLicHist_InvoiceAtomLast dbo Invoice attached to the license.
vLicHistItem dbo License items.
vLicHistLog dbo Log of changes in registered licenses.
vLicProductCoveredOnComputer dbo Which products on the computer have license coverage (per device or per user).
vLicTrans dbo Shared licenses.
vLog_DetectLast dbo Last record in the detection log.
vMediaList dbo List of media.
vMediaType dbo Types of media.
vNodeClass dbo Objects in the object tree. Classification into system objects and discarded assets.
vNodeCostCentre dbo Cost center of the objects in the tree.
vNodeDisposed dbo Discarded assets.
vNodeParentJoin dbo Objects in the tree - tree.
vNodePropertyMix dbo Objects and properties - Public + Asset + Computer1.
vNodePropertyMix_Asset dbo Objects and properties - Assets Number, Purchase Date, Warranty expiration, Manufacturer, Packing Slip Number.
vNodePropertyMix_Computer1 dbo Objects and properties - Computer - Motherboard (type), BIOS Serial Number.
vNodePropertyMix_Computer2 dbo Objects and properties - Computer - MAC address.
vNodePropertyMix_Public dbo Objects and properties - Type Designation, Serial Number, Manufacturer, Registration Number, Name.
vOnlyReader dbo Users that only have the right of reader in the services.
vPersonNodeRight dbo Rights in the object tree - main view.
vPersonNodeRight_Create dbo Rights in the objects tree - the right to "Create any objects".
vPersonNodeRight_Delete dbo Rights in the object tree - the right to "Remove".
vPersonNodeRight_Move dbo Rights in the object tree - the right to "Move".
vPersonNodeRight_Read dbo Rights in the object tree - the right to "Read".
vPersonNodeRight_Write dbo Rights in the object tree - the right to "Change".
vPersonRightRead dbo Effective permission of people and groups have for records on the activities of other people and groups within the ALVAO User Activity Monitoring module.
vProduct dbo Products (software).
vProductCategory dbo Products categories (OS).
vProductType dbo Products types.
vProductUsage dbo Displays the utilization of the products on the computers (in hours) over the past month and year.
vProperty dbo View of the properties of objects, including calculated value ​​for the "User" type property.
vPropertyFromAD dbo Properties of objects which are downloaded from AD.
vPropertyKind dbo Properties of objects.
vPropertyKind_Asset dbo Object properties - Serial number, Inventory number a Asset number.
vPropertyKind_AssetCategory dbo Properties of objects - Asset category.
vPropertyKind_BIOSSerialNumber dbo Properties of objects - BIOS serial number.
vPropertyKind_ChassisType dbo Properties of objects - Type of rack.
vPropertyKind_ComputerKind dbo Properties of objects - Type of computer.
vPropertyKind_ComputerName dbo Properties of objects - Name in the network.
vPropertyKind_Department dbo Properties of objects - Cost center.
vPropertyKind_Domain dbo Properties of objects - DNS domain.
vPropertyKind_EvidentiaryNumber dbo Properties of objects - registration number.
vPropertyKind_Frequency dbo Properties of objects - Frequency.
vPropertyKind_Interface dbo Properties of objects - Interface.
vPropertyKind_InventoryDate dbo Properties of objects - Stocktaking date.
vPropertyKind_InventoryNumber dbo Properties of objects - Asset number.
vPropertyKind_InvoiceNumber dbo Properties of objects - Packing slip number.
vPropertyKind_IPAddress dbo Properties of objects - IP address.
vPropertyKind_MACAddress dbo Properties of objects - MAC address.
vPropertyKind_Manufacturer dbo Properties of objects - Manufacturer.
vPropertyKind_MaxSize dbo Properties of objects - Maximum size.
vPropertyKind_MemoryDevices dbo Properties of objects - Sockets.
vPropertyKind_MemoryDevicesUsed dbo Properties of objects - Occupied sockets.
vPropertyKind_Model dbo Properties of objects - Model.
vPropertyKind_Name dbo Properties of objects - Name.
vPropertyKind_Office dbo Properties of objects - Office.
vPropertyKind_PartOfDomain dbo Properties of objects -Domain components.
vPropertyKind_PersonalId dbo Properties of objects - Personal number.
vPropertyKind_Place dbo Properties of objects - Location.
vPropertyKind_Port dbo Properties of objects - Port.
vPropertyKind_ProcessorId dbo Properties of objects - Processor ID.
vPropertyKind_Purchased dbo Properties of objects - Purchase date.
vPropertyKind_RefreshMax dbo Properties of objects - Maximum refresh.
vPropertyKind_SerialNumber dbo Properties of objects - Serial number.
vPropertyKind_Size dbo Properties of objects - Size.
vPropertyKind_Type dbo Properties of objects - Type.
vPropertyKind_TypeMark dbo Properties of objects - Type designation.
vPropertyKind_Vendor dbo Properties of objects - Vendor.
vPropertyKind_Version dbo Properties of objects - Version.
vPropertyKind_VideoRAM dbo Properties of objects - RAM size.
vPropertyKind_WakeUpType dbo Properties of objects - Wake-up method.
vPropertyKind_Warranty dbo Properties of objects - Warranty.
vPropertyKindInherited dbo Properties of objects - including inherited properties.
vPropertyLoc dbo Translations of tProperty settings in all languages ​​used.
vSamAlertLast dbo SAM notification - last unresolved notifications sent
vSectionLicence dbo Drawing of licenses by services
vSectionWithTreeOrder dbo For each service, it returns a string which guarantees queueing being the same as that in the tree.
vSlaAccess dbo Effective authorization requesters have for SLA and services.
vSlaAlertDeadline dbo Individual SLA notifications for the expiration of the request deadline.
vSlaAlertDeadlineSummary dbo Summary SLA notifications for the expiration of the request deadline.
vSlaAlertInactiveApprovers dbo Individual SLA notifications for approver inactivity.
vSlaAlertInactiveApproversSummary dbo Summary SLA alerts for approver inactivity.
vSlaAlertInactiveOperators dbo Individual SLA notifications for operator inactivity.
vSlaAlertInactiveOperatorsSummary dbo Summary SLA alerts for operator inactivity.
vSlaAlertInactiveRequesters dbo Individual SLA notifications for requester inactivity.
vSlaAlertInactiveRequestersSummary dbo Summary SLA alerts for requester inactivity.
vSlaAlertInactiveSolvers dbo Individual SLA notifications for solver inactivity.
vSlaAlertInactiveSolversSummary dbo Summary SLA alerts for solver inactivity.
vSlaAlertInternalTarget dbo Individual SLA alerts for the expiration of requests internal target date.
vSlaAlertInternalTargetSummary dbo Summary SLA alerts for the expiration of requests internal target date.
vSlaLoc dbo List of SLAs in all used languages.
vStringLoc dbo
vSwInst dbo Installed software - valid products and outside system objects.
vSwInst_ProductComputer dbo Software installed on the computers.
vSwInst_ProductComputerDetect dbo SW detected in the computers.
vSwInst_TreeCnt dbo Number of product installations in the subtree.
vSwInstLicProfile_ProductComputer dbo Installed software vs licenses and software profiles.
vSwLic_ProductComputer dbo Products covered by licenses on the computers.
vSwLic_UserComputer dbo Users' computers.
vSwProfileProduct_Node dbo Statuses of the software profile on the products installed on the computers.
vTicketRelation dbo Links Between Requests.
vTicketRelationTypeLoc dbo
vTicketStateLoc dbo List of statuses in all used languages.
vTicketStatePerTikcetLoc dbo List of current statuses regarding all requests in all languages used.
vTicketTemplateColumnValueLoc dbo Translations of custom items values specified in request templates.
vTicketTypeLoc dbo List of processes used in all used languages.
vTimeZone dbo Overview of time zones and shifts compared to UTC.
vTransferConfirmAlertLast dbo Last sent alerts of unsigned handover protocols.
vUserLicence dbo Drawing of licenses by users
vUserNodeRight dbo Rights in the object tree - users (including the rights allowed / prohibited by membership in roles).
vWbemObject dbo Detail of the HW detection - all.
vWbemObject_BIOS dbo Detail of the HW detection - BIOS.
vWbemObject_SystemEnclosure dbo Detail of the HW detection - Computer rack.
vWbemObjectPhysicalMedia dbo Detail of the HW detection - Hard disks.
wDocument dbo Documents.
wIdSeq dbo Numeric sequence.

List of procedures

Procedure Scheme Description
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.
spCalcNodeNameSubtree dbo Converts the names of sub-tree objects, the names of which are formed from properties.
spCalcUnreadTicket dbo Sets the flag of the request to read/unread by the person.
spCloseHdTicket dbo Required values will be stored in tHdTicket after closing the request.
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.
spCreateNodeFromTemplate dbo Creates an object based of the object template definition.
spCustomColumn_Add dbo Add new custom item.
spCustomColumn_Drop dbo Removing custom items.
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 detection based on patters 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 procedures, create a new procedure named spHdSectionForRequesterSearch_Custom. For the proper functionality of ALVAO applications, the procedure must receive the same parameters as the original procedure and return the same columns.
spHdSectionUpdateAllQueues dbo Updates the "Date according to queue" item for all requests within all services.
spHdSectionUpdateQueue dbo Updates the "Date according to queue" item for all requests within the @HdSectionId service.
spHdTicketChangeHdSection dbo Moves the @iHdTicketId request to the @iHdSectionId service.
spHdTicketPassToSolver_ExceptionalSolverList dbo Returns a list of irregular solvers, used to assign requests listed in table #temp1. The procedure can be overloaded by custom procedure spHdTicketPassToSolver_ExceptionalSolverList_SolverList_Custom. 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 requests listed in table #temp1. The procedure can be overloaded by custom procedure spHdTicketPassToSolver_SolverList_Custom. The @iUserPersonId parameter, representing the signed in user, is not used in the standard procedure.
spHdTicketPassToSolverInHdSection_ExceptionalSolverList dbo Returns a list of irregular solvers, used to assign the request when transitioning to the @iHdSectionId service.
spHdTicketPassToSolverInHdSection_SolverList dbo Returns a list of solvers, used to assign the request when transitioning to the @iHdSectionId service.
spHdTicketRecalcFirstReaction dbo Recomputes the solution of the first reaction for the request.
spHdTicketRecalcNextActionDeadline dbo Recomputes the target date of the current target for the request.
spHdTicketResolve dbo Switches the request to Resolved.
spHdTicketSolverAppointment dbo Returns the name and text of an event, which can be inserted into the solver's calendar via Assign to Solver.
spHdTicketSolverOpen dbo Reopens the request by the solver.
spInsertToPersonEmailUsage dbo Inserts a new record into the PersonEmailUsage table.
spMoveNode dbo Moves the object in the object tree.
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.
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 procedures, create a new procedure named spPersonSearch_Custom2. 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 value of this column is used in prompting persons in SD Console and in ALVAO Admin. The column can be customized.
spReadAllComunication dbo Marks all communication within the request regarding the entered person as read.
spReadAllDiary dbo Marks all request events with regard to the entered person as read.
spRebuildHdSectionLocalizationCache dbo Restores the localization cache for services.
spRebuildLocalizationCache dbo Restores all the localization cache.
spRecomputeStats dbo Recalculates the statistics for all products in Monitoring. This function must be called by the Mon Server only.
spRecomputeStatsForProduct dbo Recalculates the statistics for specific products in Monitoring. This function must be called by the Mon Server only.
spRefreshLicProductCoverage dbo Updates the ProductCoverage table (the whole one or only a specific license)
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.
spRemoveApp dbo Deletes own application from Monitoring.
spRemoveDetectResults dbo Removes the results of specific detections (ID,ID,...).
spRemoveDetects dbo Removes the specific detection (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.
spSavePersonTicketDisplay dbo Inserts a record in the history of the last viewed requests of the requester.
spSetDetailedRecordsAzureProperties dbo Sets the properties for saving detailed data from Monitoring to Azure.
spSetDetailedRecordsFolderProperties dbo Sets the properties for saving detailed data from Monitoring to a local folder.
spStateReqCol dbo Returns a table with required items for transitioning the request @TicketId to @NewStateId.
spTakeLicence dbo Withdraws license for the computer software.
spTicketSearch dbo Returns a list of requests 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 item.
spUpdateHdSectionRightsCache dbo Updates the authorization cache on services.
spUpdateInsertProperty dbo Updates the value of the object properties in the tree. If the property does not exist, it is created.
spUpdatePersonManager dbo The procedure for the update of the pre-counted structure of managers and employees.
spUpdatePropCache_All dbo Updates property inheritance for the whole database.
spUpdatePropCache_ObjMoved dbo Updates property inheritance after the object move in the tree.
spUpdatePropCache_ObjNew dbo Updates property inheritance after a new object was created.
spUpdatePropCache_PropDel dbo Updates property inheritance after the object properties were deleted.
spUpdatePropCache_PropNew dbo Updates property inheritance after a new object property was added.
spUpdatePropCache_PropValChanged dbo Updates property inheritance after a change in the property value.
spUpdatePropCache_Subtree dbo Updates the property inheritance for a specific subtree.
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.
spUpdateTicketDeadline dbo Updates the Request.Date item for changes made to the requested SLA.
spUpdateTicketHoursToCurrentTarget dbo Recomputes the time elapsed from the previous operating hours interval to the due date of the current target, either for all requests with an internal target (when 1 is in @forceALL), for a specific request (when @ticketID is entered), or for all requests 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 request number.
spUpdateTicketShiftedDeadlines dbo Adjusts the Due date of resolution on the requests with specific SLA.
spUpdateUnassignedProcess dbo Updates the list of unrecognized applications in Monitoring.
spWebAppLoginDelay dbo Protection against password-guessing attack.

List of scalar functions

Scalar function Scheme Description
DefaultSlaId dbo Returns the default SLA for on-duty requesters.
fAddressString dbo Formats the address properties from tAddress to one string.
fDate dbo Returns date without time only.
fDateHoursMinutes dbo Cut-off of seconds from date and time records.
fDeadline dbo Calculates deadline in the service working hours.
fGetServerFromURL dbo Extracts only the server address from URL. Used in Monitoring.
fHtmlString dbo Encodes a string as valid HTML, including ends of lines.
fLastLevelDomain dbo Returns the last level of the domain.
fnCheckRelCycles dbo Checks the circular task link between requests.
fnCheckRelCyclesLicHist dbo Function for reviewing a circular task.
fnCheckRelCyclesNode dbo Function for reviewing a circular task.
fnCheckRelDuplicity dbo Checks the link between requests for duplicity.
fnCheckRelOneToMany dbo Checks whether the request has maximum one link of the 1:N type.
fnFileStringInfoCsvSignature dbo CSV file signature from FileStringInfo part.
fnFindAssetUserFromPerson dbo According to PersonId of the user in Admin NodeId finds the user in the objects tree in AM.
fnFloatHourToTimeString dbo Converts the value of hours from a floating point number into a text string in the h:mm format.
fnFloatToCharExactLength dbo The function returns a number (float) as a string with the set minimum length of the integer part and the maximum length of the fractional part, which is guaranteed by completing with zeroes, or rounding where applicable. The maximum length is 50, which is an appropriately selected constant.
fnGetBackupKindName dbo Suffix of properties with original data in which the conversion to another data type failed.
fnGetNextTicketId dbo Function returns id of newly created request.
fnGetUnreadCount dbo Number of unread events of the person on request.
fnHdSectionWithoutLast dbo The function returns the full service name (path) excluding the name of the service
fnLastLocalMidnightUtc dbo The calculation of the last local midnight according to UTC time and the time zone.
fnLocalTime dbo Converts UTC data to the specific time zone.
fnNextLocalMidnightUtc dbo The calculation of the following local midnight according to UTC time and the time zone.
fnPersonLoginWithoutDomain dbo Username of a person without a domain.
fnReportedTime dbo The calculation of time reported on the selected day and for the selected employee.
fnStartWorkTime dbo The calculation of the time at which the selected employee began working on the selected day.
fnTodayHour dbo Converts a floating point number into the item type date and time where date is today's date and time is transferred from the parameter.
fnUtcTime dbo UTC time calculated from the local time and time zones.
fnWorkTimeAtDay dbo The calculation of the worked on the selected day for the selected employee.
fnWorkTimeToday dbo The calculation of the time at which the selected employee began working on the selected day. The calculation does not consider the end of the day, only up to "now"
fRelatedCompany dbo Request - "Related Organizations" item
fStripDomain dbo Username of a user without a domain.
fSuggestResolutionDate dbo Default due date by SLA.
GetProperty dbo Returns 1 value from the tProperty table based on the set code.

List of table functions

Table function Scheme Description
ftApprovers dbo Position for determining the approvers of a specific approval step”.
ftAttendanceMonthReport dbo Function that creates the table for the employee's monthly report
ftCanManageKnowledge dbo List of services and articles that the given user may administer.
ftCommaListToTableIds dbo Conversion of value list string (ID,ID,...) to value table.
ftCompanySearch dbo Search of organizations across all system items.
ftComputerSwManager dbo People responsible for software installed on the computer
ftDeviceSearch dbo Searching for a device in the tree. Returns a table of devices matching the entered parameters arranged by the path in the tree. The function can be customized. In order to customize the function, create a new function named ftDeviceSearch_Custom2. For a proper functionality of ALVAO applications, the function must receive the same parameters as the original functions and return the same columns.
ftLicHistBase dbo List of licenses.
ftLicHistRelations dbo The function to generate the list of links for the selected license.
ftLicHistSearch dbo The function to search for the license.
ftNodeRelations dbo Function that generates a list of links for the selected object with disabled tree rights.
ftPersonFromLogin dbo Search person according to login name
ftPersonSearchExtended dbo Extended search of persons across all system items.
ftRelation dbo Linked request. The function is used to populate the fields in the dialog for updating selected links (@trId) on the Request links tab @ticketId.
ftRelations dbo Linked requests to a specific request (@ticketId), which a specific user has the rights to view (@userId): The function is used to display linked requests on the Links tab.
ftRelationsAll dbo Linked requests to a specific request.
ftRelationsTypes dbo Types of links between requests. The function is used to populate the link menu.
ftTicketsStateIntersectList dbo The intersection of statuses for @TicketIds requests, which you can transition to from request statuses, with the exception to Resolved.
ftTicketStateList dbo The list of statuses for the @TicketIds request, which you can transition to from the current status, with the exception to Resolved.
ftTicketStateListIncResolved dbo The list of statuses for the @TicketIds request, which you can transition to from the current status.
ftTicketStateMultiList dbo Function for the return of the intersection of possible states (including Solved/Closed) for multiple requests.
tfDay dbo Calendar of days starting with @Begin to @End (excluding).
tfHdTicketFulltextSearch dbo Requests found by full text search of sample @sample.
tfPersonManager dbo Direct managers.
tfSplitString dbo The function divides the value based on a preset separator.

List of 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 request items in the tHdSectionCust 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_LicHistAtom_LogChanges dbo tblLicHistAtom Insert, Delete Enters the change of links to Documents, Media for a license into the license log. (LicHistLog)
TR_LicHistCust dbo tblLicHist Insert A new record will be created for custom license items in the LicHistCust table.
TR_LicHistCust_LogChanges dbo LicHistCust Insert, Update, Delete Enters the change of the value of the license custom items into the license log. (LicHostLog)
TR_LicHistItem_LogChanges dbo tblLicHistItem Insert, Update, Delete Enters the change of the value of the license item into the license log. (LicHostLog)
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 latest 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 organization items in the tAccountCust table.
TR_tAct_Delete_UpdatePersonTicketDisplay dbo tAct Delete Updates the “read” request 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 request if SLA is paused. Checks the completion of the first reaction to the requester. Recomputes the due date of the current target for the request. Recomputes the reported work for the given request.
TR_tAct_Insert_UpdatePersonTicketDisplay dbo tAct Insert Updates the “read” request 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” request 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_tblProperty_SetNodeIdValue dbo tblProperty Insert When creating a “User” property, this sets its value to the user object.
TR_tColumnValue_UpdateLocCache dbo tColumnValue Insert, Update, Delete Updates the cache via localizing values of custom items.
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 service items in the tHdSectionCust table.
TR_tHdTicket_CalculateTicketStateId dbo tHdTicket Insert, Update Updates the request status ID.
TR_tHdTicketApproval_MarkEmbededImagesInHtml dbo tHdTicketApproval Update Images in the text of messages for approver are marked as intext in the tDocument table.
TR_tHdTicketApproval_UpdatePersonTicketDisplay dbo tHdTicketApproval Insert Update the “read” request status.
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 request number.)
TR_tHdTicketApprovalItem_MarkEmbededImagesInHtml dbo tHdTicketApprovalItem Update Images in the text of messages from approver are marked as intext in the tDocument table.
TR_tHdTicketApprovalItem_UpdatePersonTicketDisplay dbo tHdTicketApprovalItem Insert Update the “read” request status.
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 request number.)
TR_TicketState_UpdateLocCache dbo TicketState Insert, Update, Delete Updates the cache by localizing the name, status description and instructions for solvers.
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 person items 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 SLA items in the tSlaCust table.
TR_tString_UpdateLocCache dbo tString Insert, Update, Delete Updates the cache by localizing system texts.

dbo.ActOperation

Kind of process in the request log

Column Type Description
id int, not null Record ID
Name nvarchar(255), not null Process kind name

dbo.AdTrustedDomain

List of trustworthy domains.

Column Type Description
id int, not null Record ID.
DomainName nvarchar(128), not null Domain name in a "dot" notation.
Hostname nvarchar(32), not null Network name of server where the domain controller is running.
Order int, not null Order in which ImportAD will try the servers of the replicated controller of the same domain.
Skip bit, not null 1=skip elements from this domain during import.

dbo.AppCategory

Application category list. The list is predefined. Custom items cannot be added.

Column Type Description
id int, not null
AppCategory nvarchar(60), not null
Description nvarchar(max), null

dbo.ArticleHdSection

Assigning articles from the knowledge base to services.

Column Type Description
id int, not null
ArticleId int, null
SectionId int, null

dbo.AssetDetectionUpload

Information on files received from autonomous Agents.

Column Type Description
Id uniqueidentifier, not null
ComputerNodeId int, not null
DetectionKind int, not null
TempFileName nvarchar(100), null

dbo.ColumnValueLoc

Cache of value list item localizations.

Column Type Description
ColumnValueId int, not null Value list item ID.
ColumnId int, not null Custom item ID.
LocaleId int, not null Language ID.
ColumnValue nvarchar(max), not null Localized item value.
ColumnValueShort nvarchar(max), not null Localized reduced item value.

dbo.DetRegUninstall

Detected registry entries. The table contains records which may differ in various computers.

Column Type Description
id int, not null Record ID.
DetectId int, not null ID detection.
RegUninstallId int, not null ID of the unique registry key.
EstimatedSize int, null
UninstallString nvarchar(255), null
ProductID nvarchar(255), null
InstallDate nvarchar(255), null
InstallLocation nvarchar(255), null
InstallSource nvarchar(255), null
LogFile nvarchar(255), null
ModifyPath nvarchar(255), null
Readme nvarchar(255), null
NoModify int, null
NoRemove int, null
NoRepair int, null
ALC_ProductPath nvarchar(255), null
PIDKey nvarchar(255), null
CD_KEY nvarchar(255), null Detected activation key.
DigitalProductId nvarchar(255), null Detected product key.

dbo.EmailSignatureHdSection

Assigning signatures to services.

Column Type Description
EmailSignatureId int, not null
HdSectionId int, null

dbo.HdSectionLoc

Cache of service localizations.

Column Type Description
HdSectionId int, not null Service ID.
LocaleId int, not null Language ID.
HdSection nvarchar(255), null Localized service name.
HdSectionShort nvarchar(255), null Located short service name.
HdSectionDesc nvarchar(max), null Located short service name.
HdSectionKeywords nvarchar(max), null Localized service keywords.
HdSectionLocId int, not null Record ID.

dbo.HdSectionManager

Effective service managers.

Column Type Description
id int, not null Record ID.
HdSectionId int, not null ID of the service where the user is a manager.
PersonId int, not null User ID.
RequesterRoleId int, not null ID of the group of requesters associated with the permissions (mapping of requesters to the solver team).

dbo.HdSectionMessageTag

Unique service prefix and suffix pair.

Column Type Description
id int, not null Record ID
Prefix nvarchar(255), null Prefix
Suffix nvarchar(255), null Suffix

dbo.HdSectionOperator

Effective service operators.

Column Type Description
id int, not null Record ID.
HdSectionId int, not null ID of the service where the user is an operator.
PersonId int, not null User ID.
RequesterRoleId int, not null ID of the group of requesters associated with the permissions (mapping of requesters to the solver team).

dbo.HdSectionReader

Effective readers in services.

Column Type Description
id int, not null Record ID.
HdSectionId int, not null ID of the service where the user is a reader.
PersonId int, not null User ID.
RequesterRoleId int, not null ID of the group of requesters associated with the permissions (mapping of requesters to the solver team).

dbo.HdSectionSolver

Effective service solvers.

Column Type Description
id int, not null Record ID.
HdSectionId int, not null ID of the service where the user is a solver.
PersonId int, not null User ID.
RequesterRoleId int, not null ID of the group of requesters associated with the permissions (mapping of requesters to the solver team).

dbo.IdSeqType

Numeric sequence types.

Column Type Description
id int, not null Record ID.
IdSeqType nvarchar(32), not null Numeric sequence type.

dbo.IntegratedAuthIpRange

IP address range for Integrated Windows Authentication.

Column Type Description
id int, not null Record ID.
FromIP bigint, null Beginning of the range of IP addresses, including.
ToIP bigint, null End of the range of IP addresses, including endpoint.

dbo.KindDataType

Property data types in AM.

Column Type Description
KindDataTypeId int, not null Property data type ID.
DataTypeName nvarchar(20), null Property data type name.

dbo.KindRight

Security for properties.

Column Type Description
id int, not null Record ID.
KindId int, not null Property definition ID.
RoleId int, not null Group ID.
ClassId int, null Object kind ID. The value NULL meals that the permission applies to all object kinds.
CanRead tinyint, null Permission to read.
CanModify tinyint, null Permission to change value.

dbo.LicDowngrade

License - downgrade.

Column Type Description
LicHistId int, not null License ID - tblListHist
ProductId int, not null Product ID - tblProduct
Desc nvarchar(255), null Note

dbo.LicHistCust

License custom items values.

Column Type Description
LicHistId int, null

dbo.LicHistItemAssign

Assigning/removing/moving license to/from/between computers.

Column Type Description
id int, not null Record ID
LicHistId int, not null License
LicHistItemId int, null License item
AssignedDate datetime, not null Date assigned/removed
AssignedPersonId int, not null Assigning/Removing author
SrcNodeId int, null Source object
DestNodeId int, null Target object
LicInfo nvarchar(1000), null Information on the assigned/removed license.
ItemInfo nvarchar(1000), null Information on the assigned/removed license item.

dbo.LicHistLog

Change record for a license or a license item.

Column Type Description
id int, not null Record ID.
LogDate datetime, not null Date and time of the event.
LicHistId int, null The license ID to which the change relates. A foreign key in the LicHist table.
LicHistLogKindId int, not null Change kind ID. The kinds of changes are specified in the LicHistLogKind table.
PersonId int, not null Change author ID. A foreign key in the tPerson table.
PropName nvarchar(100), null Name of the changed license property or license item property.
OldVal nvarchar(255), null The original property value.
NewVal nvarchar(255), null New property value.
Message nvarchar(max), null A message displayed in the license log.

dbo.LicHistLogKind

Kind of change of a license or a license item.

Column Type Description
id int, not null Record ID.
LogKind nvarchar(100), not null Kind of change.
MsgTemplate nvarchar(255), not null Template of the message for displaying the change in the license log.

dbo.LicHistRelation

A table containing links between licenses in AM Console

Column Type Description
id int, not null Record ID.
BeginLicHistId int, not null Initial license link ID. A foreign key on the tblLicHist table.
EndLicHistId int, not null End license link ID. A foreign key on the tblLicHist table.
LicHistRelationTypeId int, not null Link type. A foreign key on the LicHistRelationType table.
ModifiedDate datetime, not null Date of last link edit.
ModifiedByPersonId int, not null Person who performed the last link edit.

dbo.LicHistRelationType

Types of links between licenses in the AM

Column Type Description
id int, not null Record ID
BeginName nvarchar(32), not null Start of link (name).
EndName nvarchar(32), not null End of link (name).
Directional bit, not null If the link is directional or non-directional. 1 = directional, 0 = non-directional.
Cyclic bit, not null if creating circular tasks is permitted. 1 = Yes, 0 = No.
OneToMany bit, not null If the link type is OneToMany. 1 = OneToMany, 0 = ManyToMany.
LicHistRelationTypeBehaviorId int, not null Link behavior. If system or custom one. A foreign key on LicHistRelationTypeBehavior.

dbo.LicHistRelationTypeBehavior

Types of links between objects in the AM from the viewpoint of system/custom links.

Column Type Description
id int, not null Record ID
Name nvarchar(70), null Name

dbo.LicKind

"CAL/Licensing" list, i.e. per device, per user, etc.

Column Type Description
id int, not null
LicKind nvarchar(32), not null

dbo.LicProductCoverage

Which of all products have license coverage.

Column Type Description
LicHistId int, not null License ID - tblListHist
ProductId int, not null Product ID - tblProduct
ProductPackId int, null

dbo.LicType

License types.

Column Type Description
id int, not null Item ID.
LicType nvarchar(32), not null Type name.

dbo.MailMessage

Outgoing email queue.

Column Type Description
id int, not null
EmlMail varbinary, not null
SendAttempts int, null
LastErrorMsg nvarchar(200), null
LastAttemptTime datetime, null
Priority int, null Priority in the queue for sending. Larger numbers represent higher priority. The default value is 10000.
Recommended values:
- Urgent messages (e.g., synchronization messages between systems) = 15000
- Standard notifications and alerts = 10000
- Messages sent in bulk = 5000

dbo.News

Current messages.

Column Type Description
id int, not null Primary table key.
CreatedDate datetime, not null Creation date of current message
Subject nvarchar(max), not null Name of current message.
Text nvarchar(max), null Text of current message.
Order int, not null Current message display order.
ShowEndDate datetime, null Date until which the current message shall be displayed.
CreatedByPersonId int, not null User who created the current message.
HtmlText nvarchar(max), null HTML text of the current news
SentDate datetime, null Date and time of the last sending of the message.

dbo.NewsHdSection

Services for which the individual current messages are intended.

Column Type Description
id int, not null Primary table key.
NewsId int, not null id of the current message.
HdSectionId int, null id of the service for which the current message (NewsId) is intended. NULL of the current message is intended for all services.

dbo.NodeRelation

Table with links between objects in AM Console

Column Type Description
id int, not null Record ID.
BeginNodeId int, not null ID of start link object. Foreign key on tblNode table.
EndNodeId int, not null ID of end link object. Foreign key on tblNode table.
NodeRelationTypeId int, not null Link Type. Foreign key on NodeRelationType table.
ModifiedDate datetime, not null Date of last link edit.
ModifiedByPersonId int, not null Person who performed the last link edit.

dbo.NodeRelationType

Types of links between objects in AM

Column Type Description
id int, not null Record ID
BeginName nvarchar(32), not null Start of link (name).
EndName nvarchar(32), not null End of link (name).
Directional bit, not null If the link is directional or non-directional. 1 = directional, 0 = non-directional.
Cyclic bit, not null if creating circular tasks is permitted. 1 = Yes, 0 = No.
OneToMany bit, not null If the link type is OneToMany. 1 = OneToMany, 0 = ManyToMany.
NodeRelationTypeBehaviorId int, not null Link behavior. System or custom. Foreign key to NodeRelationTypeBehavior.

dbo.NodeRelationTypeBehavior

Types of links between objects in AM from the viewpoint of system/custom links

Column Type Description
id int, not null Record ID.
Name nvarchar(70), null Name.

dbo.NodeRightLog

Logging of changes in permissions of users in Asset Management.

Column Type Description
Id int, not null Record ID.
TimeStamp datetime, not null Date and time of the change execution.
User nvarchar(255), null User name.
Group nvarchar(255), null Group name.
Object nvarchar(255), null Object name.
ObjectOld nvarchar(255), null Object name - the previous value.
Recursive bit, not null Check box inclusive of child objects.
RecursiveOld bit, null Check box inclusive of child objects - the previous value.
Class nvarchar(255), null Object kind name.
ClassOld nvarchar(255), null Object kind name - the previous value.
Read bit, null Permission to read.
ReadOld bit, null Permission to read - the previous value.
Write bit, null Permission to edit.
WriteOld bit, null Permission to edit - the previous value.
Move bit, null Permission to move.
MoveOld bit, null Permission to move - the previous value.
Create bit, null Permission to create any objects.
CreateOld bit, null Permission to create any objects - the previous value.
Delete bit, null Permission to delete.
DeleteOld bit, null Permission to delete - the previous value.
ModifiedBy nvarchar(255), not null Logged-in user name.

dbo.PersonBehavior

People types. Normal users =1, system users >1.

Column Type Description
id int, not null Record ID.
Description nvarchar(max), null Description of the system person type.

dbo.PersonEmailUsage

Use of an e-mail address for sending the message by a specific user.

Column Type Description
id int, not null Record ID.
UsedByPersonId int, not null The user who used the e-mail address.
UsedEmail nvarchar(255), not null Used e-mail address for sending the message.
LastUsed datetime, not null Time of the last use of the email address.

dbo.PersonEventDisplay

Events viewed by a person.

Column Type Description
Id int, not null
PersonId int, null
ActId int, null
TicketApprovalId int, null
TicketApprovalItemId int, null

dbo.PersonManager

Pre-counted structure of managers and employees.

Column Type Description
ManagerPersonId int, not null Manager's ID.
EmployeePersonId int, not null Employee's ID.
Distance int, not null Hierarchical distance of a user from his/her supervisor. Automatically calculated column. Direct manager = 1, manager of a direct manager = 2 etc.

dbo.PersonPasswordHistory

Used people's passwords.

Column Type Description
id int, not null Record ID.
SinceDate datetime, not null Password setting date.
PersonId int, not null Person Id.
Password nvarchar(255), not null Hash of password used.

dbo.PersonTicketDisplay

A record from the history of the last viewed requests of the requester.

Column Type Description
TicketId int, not null Viewed request number.
PersonId int, not null ID of the person who viewed the request.
LastDisplayed datetime, null Date and time of the last view of the request.
EventsNotDisplayed bit, not null
Id int, not null

dbo.Printer

Printers

Column Type Description
id int, not null
Name nvarchar(100), not null
Model nvarchar(100), null

dbo.PrintJob

Printing tasks

Column Type Description
id int, not null
Name nvarchar(100), not null
Pages int, not null
Color bit, null
Submitted datetime, not null
PrintedByPersonId int, not null
PrintedOnComputerId int, not null
PrinterId int, not null
PaperType nvarchar(50), null
SubmittedUtc datetime, null

dbo.PrivateModeInsertReq

Request to insert private mode.

Column Type Description
id int, not null
ForPersonId int, not null
OnComputerId int, not null
PrivateModeStart datetime, not null
PrivateModeEnd datetime, not null
StartedToken nvarchar(50), null
Started datetime, null
Error nvarchar(200), null
PrivateModeUtcStart datetime, not null

dbo.ProductCust

Column Type Description
ProductId int, not null

dbo.ProductState

Product status

Column Type Description
id int, not null Product status - numerical (Primary key)
ProductState nvarchar(127), not null Product status - written
txtDesc nvarchar(255), not null txtDesc

dbo.ProductUsage

Table containing utilization of individual products on the computers over past 12 months.

Column Type Description
ComputerId int, not null Computer ID
ProductId int, not null Product ID
RuntimeHoursMonth0 float, null Run time in month 0 in hours (used as circular buffer, column number with actual month is in tProperty table)
RuntimeHoursMonth1 float, null Run time in month 1
RuntimeHoursMonth2 float, null Run time in month 2
RuntimeHoursMonth3 float, null Run time in month 3
RuntimeHoursMonth4 float, null Run time in month 4
RuntimeHoursMonth5 float, null Run time in month 5
RuntimeHoursMonth6 float, null Run time in month 6
RuntimeHoursMonth7 float, null Run time in month 7
RuntimeHoursMonth8 float, null Run time in month 8
RuntimeHoursMonth9 float, null Run time in month 9
RuntimeHoursMonth10 float, null Run time in month 10
RuntimeHoursMonth11 float, null Run time in month 11
RuntimeHoursMonth12 float, null Run time in month 12

dbo.ProfileValue

View settings table

Column Type Description
PersonId int, not null Foreign key to table tPerson - iPersonId. Specifies the settings "owner"
ValueName nvarchar(max), not null Name of settings including path used in registries. The path is provided for the purpose of product identification
StringValue nvarchar(max), null String settings value
IntValue int, null Int settings value
Backup bit, not null

dbo.ReanalyzeRecordsRequest

Request to recalculate statistics.

Column Type Description
id int, not null
StartDate datetime, null
EndDate datetime, null
PersonId int, null
ComputerId int, null
ReanalyzeStarted datetime, null

dbo.ReceivedMessage

Table for temporary storage of read messages for custom actions.

Column Type Description
id int, not null Message ID.
EmlMail varbinary, not null Message in EML format.
Created datetime, not null Date and time of message storage in the database.

dbo.ReceivedMessageRule

Rules for incoming messages for MailboxReader

Column Type Description
id int, not null Record ID
OrderNum int, not null Determines the order in which the rules are detected and applied.
RuleName nvarchar(255), not null Name of rules (must be unique).
SubjectCondition nvarchar(255), null Condition for comparing with the subject of the loaded mail.
BodyCondition nvarchar(255), null Condition for comparing with the body of the loaded mail.
SenderCondition nvarchar(255), null Condition for comparing with the recipient of the loaded mail.
ReceiverCondition nvarchar(255), null Condition for comparing with the sender of the loaded mail.
SendMessage bit, not null Permit "Send message" action (Yes/No).
MailTo nvarchar(255), null Message recipient for "Send message" action.
MailSubject nvarchar(255), null Message subject for "Send message" action.
MailText nvarchar(max), null Message text for "Send message" action.
MoveRequestToService bit, not null Permit "Move to service" action (Yes/No).
MoveToSectionId int, null If "Move to service" is permitted, the service id is displayed, otherwise NULL.
ResolveRequest bit, not null Enabling the option "Resolve request" (Yes/No).
DeleteRequest bit, not null Permit "Remove request" option (Yes/no).
ModifiedDate datetime, null Date and time of last rule edit.
ModifiedByPersonId int, null Person who edited the rules.

dbo.RoleBehavior

Types of system rolls, e.g. all users, administrators, ...

Column Type Description
id int, not null
RoleBehavior nvarchar(50), null

dbo.RoleMembershipLog

Logging of changes in membership in groups.

Column Type Description
Id int, not null Record ID.
TimeStamp datetime, not null Date and time of the operation execution.
MemberTypeId int, not null Kind of membership in the group.
Member nvarchar(255), not null User or group name.
OperationId int, not null Operation.
Group nvarchar(255), not null Group name.
ModifiedBy nvarchar(255), not null Logged-in user name.

dbo.RoleMembershipLogMemberType

Kind of membership in the group.

Column Type Description
Id int, not null Membership kind ID.
Name nvarchar(50), not null Membership kind name.

dbo.RoleMembershipLogOperation

Executed operation which is logged.

Column Type Description
Id int, not null Operation ID.
Name nvarchar(50), not null Operation name.

dbo.SamAlert

SAM notifications sent.

Column Type Description
id int, not null Record ID
ProductId int, not null Product
ComputerId int, not null Computer
SentDate datetime, not null Date on which the notification was sent
SamAlertRuleId int, not null Notification type
SequenceNum int, not null Sequence number of notification
Recipients nvarchar(max), null Recipients
ResolvedDate datetime, null Date on which the system determined the problem was resolved.

dbo.SamAlertConfig

SAM configuration of notifications.

Column Type Description
CheckingDetectPeriod int, not null
SendTimeHour float, not null
RepeatLastAlertAfterDays int, null
MaxDetectAgeDays int, null

dbo.SamAlertRule

SAM notification rules.

Column Type Description
id int, not null
Active bit, not null
AlertAfterDays int, null
AlertSwManager bit, not null
AlertSuperior bit, not null
AlertRoleId int, null

dbo.SamType

SAM notification type - Audit: yes, no, via e-mail.

Column Type Description
id int, not null
Name nvarchar(32), not null
Desc nvarchar(256), null

dbo.Server

Setting the ALVAO servers (AM Collector).

Column Type Description
id int, not null
Default bit, not null
Hostname nvarchar(20), null
Desc nvarchar(max), null
LastConnectDate datetime, null
Unknown bit, not null
ApprovedCollector bit, not null
DetEvalImmediately bit, not null
DetPingBeforeDirect bit, not null
DetPingBeforeAgent bit, not null
DetAfterPcOffMinutes int, not null
DetAafterErrorMinutes int, not null
DetCntAtOnce int, not null
DetEvalCntAtOnce int, not null
DetBlockSleepTimeMinutes int, not null
DetFilter nvarchar(max), null
DetEvalFilter nvarchar(max), null
PswdFilePath nvarchar(1024), null
NetScanActive bit, not null
NetScanRemoveDomain bit, not null
NetScanAlwaysSaveIP bit, not null
SchedEvalActive bit, not null
SchedEvalTimeFrom float, null
SchedEvalTimeTo float, null
SchedEvalDayExc int, null
SchedDetActive bit, not null
SchedDetTimeFrom float, null
SchedDetTimeTo float, null
SchedDetDayExc int, null
AutoLoadActive bit, not null
AutoLoadFolder nvarchar(1024), null
AutoLoadDeleteOnSucc bit, not null
AutoloadDeleteOnFail bit, not null
SwLibDownloadLib bit, not null
SwlibEvalAllDetAfterDownload bit, not null
SwlibCheckNewLibDays int, null
SwLibSendAddUnknownReq bit, not null
SwLibSearchUnknownSW bit, not null
SwlibSendAnon bit, not null
SwLibSendContactEmail nvarchar(255), null

dbo.SlaAlertRuleReceiver

Notice for unresolved requests - other recipients.

Column Type Description
id int, not null
SlaAlertRuleId int, not null
PersonId int, null
RoleId int, null

dbo.SlaLoc

Cache of SLA localizations.

Column Type Description
SlaId int, not null SLA ID.
LocaleId int, not null Language ID.
Sla nvarchar(255), null Localized SLA name.
SlaDesc nvarchar(max), null Localized SLA description.

dbo.StringLoc

Cache of text string localizations.

Column Type Description
StringId int, not null Text string ID.
LocaleId int, not null Language ID.
String nvarchar(max), null Localized string text.

dbo.Subscriber

A table containing information on the customer and on the request on which information is taken.

Column Type Description
id int, not null
PersonId int, not null
TicketId int, not null
SinceDate datetime, null
SubscribedByPerson int, null Id of the user who set the subscription.

dbo.SwItemKind

Kinds of records in the views of software.

Column Type Description
id int, not null Record ID.
Kind nvarchar(64), not null Kind of record.

dbo.tAccount

Organization (in accordance with CRM, i.e. the company).

Column Type Description
iAccountId int, not null
sAccount nvarchar(255), not null
sImportSystem nvarchar(255), null
sImportRecordId nvarchar(255), null
dRemoved datetime, null
liRemovedPersonId int, null
dCreated datetime, not null
liCreatedPersonId int, null
dModified datetime, not null
liModifiedPersonId int, null
Phone nvarchar(30), null Phone
Phone2 nvarchar(30), null Phone 2
Fax nvarchar(30), null Fax
Email nvarchar(50), null Email
Email2 nvarchar(50), null Email 2
AddressId int, null Address 1
Address2Id int, null Address 2
Web nvarchar(50), null Company web
IdentificationNumber nvarchar(20), null Company ID - company identification number
TaxIdentificationNumber nvarchar(20), null VAT ID - value added tax identification number

dbo.tAccountCust

Organization custom items values.

Column Type Description
liAccountId int, null

dbo.tAct

Request log record or message in "Current messages" block.

Column Type Description
iActId int, not null Record ID
liActKindId int, null Link to record type
dAct datetime, null Time at which the event occurred:
sAct nvarchar(max), null Name of event
mActNotice nvarchar(max), null Note to event
liActFromPersonId int, null Link to sender.
liActToPersonId int, null Link to recipient.
liActHdTicketId int, null Request to which the event belongs
sActFrom nvarchar(1024), null Sender name
sActFromEmail nvarchar(255), null Sender email
sActFromPhone nvarchar(255), null Sender's phone
mActFromContact nvarchar(max), null Sender contact details
sActFromMobile nvarchar(255), null Sender cell phone
sActFromOffice nvarchar(255), null Sender office
sActFromDepartment nvarchar(255), null Sender's department
sActFromWorkPosition nvarchar(255), null Sender's job
sActFromCompany nvarchar(255), null Sender's company
sActTo nvarchar(1024), null Recipient name
sActToEmail nvarchar(255), null Recipient email
nActWorkHours float, null Number of work hours
dActRemoved datetime, null Time at which the event was removed. The event is not removed for NULL
sActCc nvarchar(1024), null Copy
sActAutoSubmitted nvarchar(255), null Atribut AutoSubmitted read from email
sActMessageId nvarchar(255), null Atribut MessageId read from email
sActXSpamLevel nvarchar(255), null Atribut XSpamLever read from email
sActXSpamStatus nvarchar(255), null Atribut XSpamStatus read from email
nActTravelHours float, null Time spent on trip in hours
nActTravelKm float, null Travel distance in km
bNoCharge bit, not null If the value is 1, paid
bWaitingForUser bit, null 1 - Marks the start of waiting for the requisitioner from 0 - Marks the end of waiting for the requisitioner NULL - does not change the status of waiting for the requisitioner
dRecordCreated datetime, null Time at which the record was created. This attribute is only available from version 2.9, records created with an older version will have a NULL value
sRecordCreatedByMachine nvarchar(255), null Name of computer on which the record was created. This attribute is only filled in by the MailboxReader. This attribute is only available from version 2.9, records created with an older version will have a NULL value
iRecordCreatedByProcessPid int, null Process ID which created the record. This attribute is only available from version 2.9, records created with an older version will have a NULL value
CreatedByPersonId int, null User ID of the event creator
ActHtml nvarchar(max), null
ActOperationId int, null Process kind ID
EffectiveDate datetime, null

dbo.tActHd

Expanding tAct information for the request log.

Column Type Description
liActHdActId int, not null Link to event.
bActHdUserRead bit, not null The flag specifying whether this event can also be seen by requesters without additional permissions for the service

dbo.tActKind

Record type tAct, e.g. "e-mail“, "phone“, "note“, "process“, …

Column Type Description
iActKindId int, not null Record ID: 1 = e-mail, 2 = phone, 3 = personal meeting, 4 = letter, 5 = voice message, 6 = written message, 7 = form, 8 = note, 9 = process, 10 = other, 11 = alert.
sActKind nvarchar(255), null Naming the type of event
iActKindOrder int, null Order in which records are displayed.
Removable bit, not null

dbo.tAddress

Address

Column Type Description
id int, not null
Street nvarchar(max), not null Street
ZIP nvarchar(20), null ZIP code
City nvarchar(100), not null City
Country nvarchar(100), null Country

dbo.tApprovalSchema

Approval schemes.

Column Type Description
iApprovalSchemaId int, not null
sApprovalSchema nvarchar(255), null
mApprovalSchemaDescription nvarchar(max), null
dApprovalSchemaRemoved datetime, null
dApprovalSchemaCreated datetime, null
AutoApproveStepsSameApprover bit, not null Automatic approval of steps with the same approver.

dbo.tApprovalSchemaItem

Approval scheme step.

Column Type Description
iApprovalSchemaItemId int, not null
liApprovalSchemaItemApprovalSchemaId int, not null
iApprovalSchemaItemOrder int, not null
liApprovalSchemaItemAuthorityRoleId int, null
bApprovalSchemaItemAuthorityManagerOfUser bit, not null The “Requester's direct manager” approval step
bApprovalSchemaItemAuthorityRootManagerOfUser bit, not null
nExpirationHours float, null
sCustom nvarchar(255), null
sApprovalSchemaItemCustomUrl nvarchar(max), null Custom form for "approval/rejection".
AutoApproveByRequester bit, not null The step is automatically approved by the requester, if he is a member of the selected approval group.
AuthorityRequester bit, not null "Requester" approval step.
OnlyRequesterOrHisManager bit, not null Selection of the approval step “Group” - “only the requester or their manager”

dbo.tArticle

Article in Knowledge Base.

Column Type Description
iArticleId int, not null
sArticle nvarchar(1024), null
mArticleAnnotation nvarchar(max), null
mArticle nvarchar(max), null
dArticleCreated datetime, null
dArticleModified datetime, null
liArticleAuthorPersonId int, null
ModifierPersonId int, null
HtmlArticle nvarchar(max), null
Published bit, null
Order int, null
Removed datetime, null
HtmlArticleBinary varbinary, null
HtmlArticleBinaryExt nvarchar(10), null

dbo.tBankHoliday

National holidays.

Column Type Description
iBankHolidayId int, not null
liBankHolidayRegionId int, null
dBankHoliday datetime, not null
sBankHoliday nvarchar(255), null

dbo.tBankHolidayLoaded

National holiday blocks included in the database. A block is a list of holidays belonging to one region and year.

Column Type Description
liBankHolidayRegionId int, not null
iYear int, not null
dRevision datetime, not null

dbo.tBankHolidayRegion

Local national holiday regions.

Column Type Description
iBankHolidayRegionId int, not null
sBankHolidayRegion nvarchar(255), not null

dbo.tblADMap

Mapping attributes from AD to AM properties. This configuration is used by ImportAD.

Column Type Description
lintClassId int, null
lintKindId int, null
txtADClass nvarchar(255), null
txtADAttr nvarchar(255), null
bolKey bit, not null

dbo.tblAsset

Identification numbers of documents and media.

Column Type Description
lintAtomId int, not null AtomId - tblAtom
txtId nvarchar(255), null ID number 1

dbo.tblAtom

Kind of record - document / medium.

Column Type Description
intAtomId int, not null Record ID
lintAtomKindId int, not null Kind

dbo.tblAtomLend

Information on items lent and returned in the media library.

Column Type Description
lintAtomId int, not null Atom ID - tblAtom
lintPersonNodeId int, null Lended to person in tree - tblNode
txtPerson nvarchar(255), null Lended to
dteLended datetime, null Date lended
dteReturned datetime, null Date returned
txtNote nvarchar(max), null Note
liLendingPersonId int, not null Lended by - tPerson
liAcceptingPersonId int, null Taken over by - tPerson

dbo.tblClass

ID of the objects types. Texts in tblDict.

Column Type Description
intClassId int, not null Class Id
bComputer bit, not null

dbo.tblCommandDef

Definitions of commands for the "Administrator's Tools" function.

Column Type Description
intCommandDefId int, not null
intCommandDefUID int, null
txtName nvarchar(255), not null
txtCommand nvarchar(255), not null
txtRunDir nvarchar(255), null
intGroup int, null

dbo.tblCompany

Code list of organizations (software products library).

Column Type Description
intCompanyId int, not null
intCompanyUID int, null
txtName nvarchar(255), not null
txtAddress1 nvarchar(255), null
txtAddress2 nvarchar(255), null
txtCity nvarchar(255), null
txtZIP nvarchar(255), null
txtState nvarchar(255), null
txtWeb nvarchar(255), null
txtPhone nvarchar(255), null
bolProducer bit, not null
bolReseller bit, not null
bolPrint bit, not null
intFlags int, null
txtDescription nvarchar(255), null
dteTimeStamp datetime, not null
bolValid bit, not null
txtCertifiedBy nvarchar(255), null

dbo.tblComputerIdClass

ID of the objects types based on which the computer is identified during the detection of HW and SW.

Column Type Description
lintClassId int, null

dbo.tblComputerLog

GTS NOVERA detections.

Column Type Description
intComputerLogId int, not null
dteCreated datetime, null
dteProcessed datetime, null
intType int, null
intServiceType int, null
txtComputerName nvarchar(255), null
txtSNMP nvarchar(255), null
txtLDAPGUID nvarchar(255), null
txtIPAddress nvarchar(255), null
txtMACAddress nvarchar(255), null

dbo.tblDetect

Information on HW and SW detections in the computers.

Column Type Description
intDetectId int, not null Record ID
lintComputerNodeId int, not null Computer designated for detection (tblNode).
dteCreated datetime, null Time at which the detection is performed.
dteImported datetime, null Time at which the detection is loaded to the database
txtDescription nvarchar(255), null Note
lintDetectKindId int, not null 1=hw, 2=sw (see tblDetectKind, tblDict)
dteRqCreated datetime, null Time at which the request (manual or automatic) was created The request will be created once the detection is loaded from the file to the AM Console. The time of the detection is written to dteRqCreated. The "Detect Again" command writes the current time.
txtCollector nvarchar(255), null Name of server on which the AM Collector that reserved the request resolution is running.
txtShareRq nvarchar(255), null Name of request sub-folder for detection via shared folder.
lintDetectStatusId int, not null 1 = "no response so far" 2 = "ok" - carried out without warnings and errors. 3 = "warning" - Warnings were encountered during the detection process, but no errors. 4 = "error" - At least one error was encountered during the detection.
liRqCreatedPersonId int, not null The user that created this request, see tPerson.
dUpdated datetime, null
DetectSourceMethod int, null
ManualRq bit, not null If the value is 1, the request was created manually with the activated Detect and evaluate immediately option.

dbo.tblDetectAction

Scheduled evaluation of HW and SW by detection.

Column Type Description
intDetectActionId int, not null
lintDetectId int, not null
lintDetectActionKindId int, not null
txtCollector nvarchar(255), null
ManualRq bit, not null If the value is 1, the request was created manually by the Evaluate immediately command.

dbo.tblDetectKind

ID of the types of detection (HW, SW). Texts in tblDict.

Column Type Description
intDetectKindId int, not null

dbo.tblDetectMethod

ID of the methods of detection (without Agent, Agent via TCP/IP, ...). Texts in tblDict.

Column Type Description
intDetectMethodId int, not null

dbo.tblDetectOpts

Detections setting.

Column Type Description
lintDetectId int, null
lintComputerNodeId int, null
lintDetectMethodId int, null
txtSharePath nvarchar(255), null
intTcpipPort int, null
lintDetectKindId int, not null
bolSwFull bit, null
txtSwInclude nvarchar(255), null
txtSwExclude nvarchar(255), null
bolUpdate bit, not null
intDetectPeriod int, null

dbo.tblDetectStatus

ID of the detections statuses. Texts in tblDict.

Column Type Description
intDetectStatusId int, not null

dbo.tblDetFile

Detected files on the computers (SW detection).

Column Type Description
intDetFileId int, not null
lintFileId int, null
lintDetectId int, null
txtFolderPath nvarchar(255), null
dteCreated datetime, null
dteModified datetime, null
dteAccessed datetime, null
intAttribs int, null

dbo.tblDict

Common table for the text code lists of the system tables values.

Column Type Description
lintClassId int, null object class - tblClass
lintNameLangId int, null language name - tblLang
lintDetectKindId int, null
lintDetectStatusId int, null
lintDetectMethodId int, null
lintIdSeqId int, null
lintProductTypeId int, null
lintProductCategoryId int, null
lintMediaTypeId int, null
lintDocumentKindId int, null
lintHistoryFlags int, null
lintDiaryKindId int, null
txtText nvarchar(255), null Only one attribute (lintClassId, lintNameLangId, ..., lintDiaryKindId) must have a value other than null. The txtText attribute contains the name of the respective item in lintLangId language.
lintInstallMsgId int, null installation/uninstallation reports
lintPropEditMsgId int, null Log - edit
lintLicTypeId int, null License kind
lintLicModeId int, null License mode
lintLicHistCALId int, null Cal license
lintPropertyMapAssignId int, null
lintAssetStateId int, null Property status
lintInventoryStatusId int, null Stocktaking status
lintAllClassObjId int, null Text for "all objects" - combo box
lintLendSubjId int, null Log - rental
lintLendMsgId int, null Log - rental
liSwPresenceId int, null SW profiles - profile name
iLicenseStatusId int, null SW - license status - text
iLicErrMsgId int, null SW - error message for license on SW tab
iSwProfErrMsgId int, null SW - error message for profile on SW tab

dbo.tblDocument

Documents.

Column Type Description
lintAtomId int, not null Atom ID - tblAtom
lintDocumentKindId int, not null Type - tblDict
txtMemo nvarchar(max), null Note
dteCreated datetime, null Created
lintResellerCompanyId int, null Vendor - tblCompany
lintSrcNodeId int, null Handover protocol - source object in tree - tblNode
lintDestNodeId int, null Handover protocol - target object in tree - tblNode
txtIdNumber2 nvarchar(255), null ID number 2
dteRemoved datetime, null Voided
liCreatedPersonId int, null Author - tPerson
liRemovedPersonId int, null Voided by - tPerson
TransferConfirmTypeId int, not null Sign method.
SignDate datetime, null Date of signing.
SignPersonId int, null ID of the person who signed the document.
SignComputer nvarchar(255), null Name of the computer from which the document was signed.
SignedBy nvarchar(128), null The person who signed the document (if its ID cannot be obtained)

dbo.tblDocumentKind

Kinds of documents. Texts in tblDict

Column Type Description
intDocumentKindId int, not null

dbo.tblEvent

Reminders.

Column Type Description
intEventId int, not null
dteSignalDate datetime, null
dteDate datetime, not null
txtMemo nvarchar(max), null
bolChecked bit, not null
liPersonId int, not null

dbo.tblFile

Detected files on the computer (SW detection).

Column Type Description
intFileId int, not null
txtName nvarchar(255), null
txtExt nvarchar(255), null
intSize int, null
iInsertSourceRecordAuxId int, null
ProductId int, null Recognized product.
Monitoring bit, not null The file is linked to monitoring data.
FileImageId int, null Recognized based on the rule.
OriginalProductId int, null Original recognized product
Hash varbinary, not null File signature.
EvalSwLibDate datetime, null The date of the library according to which the file has been recognized.

dbo.tblFileImage

Recognition rules for files (software products library).

Column Type Description
intFileImageId int, not null
intFileImageUID int, not null
txtName nvarchar(255), null
txtExt nvarchar(255), null
intSize int, null
intFileVersionMSLo int, null
intFileVersionMSHi int, null
intFileVersionLSLo int, null
intFileVersionLSHi int, null
intProductVersionMSLo int, null
intProductVersionMSHi int, null
intProductVersionLSLo int, null
intProductVersionLSHi int, null
intLanguage int, null
intCodePage int, null
txtComments nvarchar(255), null
txtCompanyName nvarchar(255), null
txtFileDescription nvarchar(255), null
txtFileVersion nvarchar(255), null
txtInternalName nvarchar(255), null
txtLegalCopyright nvarchar(255), null
txtLegalTrademarks nvarchar(255), null
txtOriginalFilename nvarchar(255), null
txtProductName nvarchar(255), null
txtProductVersion nvarchar(255), null
txtPrivateBuild nvarchar(255), null
txtSpecialBuild nvarchar(255), null
bolProductKey bit, not null
intOrder int, null
intFlags int, null
dteTimeStamp datetime, not null
bolValid bit, not null
txtCertifiedBy nvarchar(255), null
lintProductId int, not null

dbo.tblFileStringInfo

Information on detected files - texts.

Column Type Description
lintFileId int, not null
intLanguage int, null
intCodePage int, null
txtComments nvarchar(255), null
txtCompanyName nvarchar(255), null
txtFileDescription nvarchar(255), null
txtFileVersion nvarchar(255), null
txtInternalName nvarchar(255), null
txtLegalCopyright nvarchar(255), null
txtLegalTrademarks nvarchar(255), null
txtOriginalFilename nvarchar(255), null
txtProductName nvarchar(255), null
txtProductVersion nvarchar(255), null
txtPrivateBuild nvarchar(255), null
txtSpecialBuild nvarchar(255), null

dbo.tblFileVerInfo

Information on detected files - versions.

Column Type Description
lintFileId int, not null
intFileVersionMS int, null
intFileVersionLS int, null
intProductVersionMS int, null
intProductVersionLS int, null
intFileFlagsMask int, null
intFileFlags int, null
intFileOS int, null
intFileType int, null
intFileSubtype int, null
intFileDateMS int, null
intFileDateLS int, null

dbo.tblHistory

Log - history of objects in the tree - move, deletion, insertion, etc.

Column Type Description
intHistoryId int, not null Record ID
lintNodeId int, not null object - tblNode; always different from null
lintDetectId int, null detection - tblDetect; Null is possible, provided the operation was executed manually without a link to the detection
dteDateTime datetime, null date and time
intFlags int, null bit field: 1 = move "X" here 2 = move "X" from here 3 = move to "X" 4 = new "X" inserted here 5 = created in "X" 6 = "X" moved here 7 = "X" moved from here 8 = moved from "Y" to "X" 9 = new "X" inserted here 10 = created in "X"
lintOpNodeId int, null object X - tblNodeId; This attribute can be NULL, if object X was removed from the database
txtOpNodeName nvarchar(255), null name of object X including full path
liPersonId int, not null Author of recorded operation - tPerson
lintOp2NodeId int, null object Y - tblNodeId; This attribute can be NULL, if object Y was removed from the database
txtOp2NodeName nvarchar(255), null name of object Y including full path
RemovedDate datetime, null
RemovedByPersonId int, null

dbo.tblIcon

Icons.

Column Type Description
intIconId int, not null icon Id
oleIcon image, null icon bitmap
txtDesc nvarchar(255), null icon name
uid int, null Unique identifier UID (only system icons)

dbo.tblIdSeq

Numerical series - definitions.

Column Type Description
intIdSeqId int, not null 1 = Media 2 = Invoices 3 = Acceptance Protocols 4 = Documents 5 = Certificates 6 = EULAs
txtPrefix nvarchar(255), null Prefix
NextNumber nvarchar(60), null Next number that will be used. Formatting including "0" is preserved.
txtSuffix nvarchar(255), null Suffix
sName nvarchar(255), null Series name
liKindId int, null Property
bUse bit, not null 1=series is active
IdSeqTypeId int, null Numeric sequence type.

dbo.tblInstHist

Records on installation and uninstallation of products on the computers (manual as well as detected)

Column Type Description
intInstHistId int, not null installation id
lintComputerNodeId int, not null Computer - tblNode
lintProductId int, not null Product - tblProduct
lintInstallDetectId int, null Which detection detected the installation - tblDetect
lintUnistallDetectId int, null Which detection detected the uninstallation - tblDetect
dteInstallDetected datetime, null Date on which the installation was detected
dteUninstallDetected datetime, null Date on which the uninstallation was detected
dteInstalled datetime, null Installed
dteUninstalled datetime, null Uninstalled
txtMemo nvarchar(max), null Note
txtDetProductName nvarchar(255), null Name of detected product
txtDetProductVersion nvarchar(255), null Version of detected product
intDetLanguage int, null Detection product language - LCID
txtDetProductId nvarchar(255), null Detected Product-ID
txtDetInstallDate nvarchar(255), null Detected installation date
txtDetRecognizedBy nvarchar(255), null Recognized by
txtDetCDKey nvarchar(255), null Detected CD-Key
liInstalledPersonId int, null Installed by - tPerson
liUninstalledPersonId int, null Uninstalled by - tPerson
Installed datetime, null Date of manual or detected installation of the product.
Uninstalled datetime, null Date of manual or detected uninstallation of the product.

dbo.tblInstTrial

Special installation.

Column Type Description
lintProductId int, not null Product - tblProduct
lintComputerNodeId int, not null Computer - tblNode
txtDesc nvarchar(255), null Note
ValidUntil datetime, null Date of expiration

dbo.tblInventory

Stocktaking - list of stocktakings.

Column Type Description
intInventoryId int, not null
dteCreated datetime, null
dteClosed datetime, null
txtDesc nvarchar(255), null
bolSelectionLocked bit, not null

dbo.tblInventoryAsset

Stocktaking - assets in a specific stocktaking.

Column Type Description
intInventoryAssetId int, not null
lintInventoryId int, null
lintNodeId int, null
txtDesc nvarchar(255), null
intSelectionNum int, null
dteCreated datetime, null
bolProcessed bit, not null
bolLocked bit, not null
bolTransfered bit, not null
txtAsset_Name nvarchar(255), null
txtAsset_InventoryNum nvarchar(255), null
txtAsset_EvidentaryNum nvarchar(255), null
txtAsset_User nvarchar(255), null
txtAsset_User_PersonalId nvarchar(255), null
txtAsset_Place nvarchar(255), null
txtAsset_SerialNum nvarchar(255), null
txtRead_Asset_Name nvarchar(255), null
txtRead_Asset_InventoryNum nvarchar(255), null
txtRead_Asset_EvidentaryNum nvarchar(255), null
txtRead_Asset_User nvarchar(255), null
txtRead_Asset_User_PersonalId nvarchar(255), null
txtRead_Asset_Place nvarchar(255), null
txtRead_Asset_SerialNum nvarchar(255), null
txtRead_State nvarchar(255), null
lintUserNodeId int, null
txtAsset_Centre nvarchar(255), null
txtRead_Asset_Centre nvarchar(255), null
txtRead_Asset_Class nvarchar(255), null
dRead_Date datetime, null

dbo.tblInventoryAssetPack

Stocktaking - list of reader's files.

Column Type Description
intInventoryAssetPackId int, not null
lintInventoryId int, null
txtName nvarchar(255), null
txtDesc nvarchar(255), null
dteCreated datetime, null
dteExported datetime, null
dteImported datetime, null
liPersonId int, null

dbo.tblInventoryAssetPackRel

Stocktaking - assignment of assets to readers.

Column Type Description
lintInventoryAssetPackId int, null
lintInventoryAssetId int, null

dbo.tblInventoryAtom

Stocktaking - documents.

Column Type Description
lintInventoryId int, not null
lintAtomId int, not null

dbo.tblKind

Definitions of the objects properties.

Column Type Description
intKindId int, not null primary key
txtName nvarchar(255), not null property name
lintIconId int, null icon - tblIcon
intFlags int, null bit field: 0x20 = property not inheritable
lintValueKindId int, null This attribute contains the tblKind.intKindId definition of the property, from which the list of values shall be used (tblKindValue)
bolGlobalScope bit, not null 1 = global property for a class of objects. "0" indicates the property is considered local for each class of objects (printers, computers etc.). An automatic list of values is then put together from the values of this property for the given object class,
bolUnique bit, not null 1 = property value must be unique
intOrder int, null The sequence for table filtering can be set
intKindCode int, null The unique number determines the property (integrated ones are numbered), user properties do not have this number
bSelectOnly bit, not null 1 = property value can only be selected from the list of values
CleanValueByCopying bit, not null 1 = Delete value when copying properties
KindDataTypeId int, not null Property data type ID.

dbo.tblKindValue

Value lists for the properties of objects.

Column Type Description
lintKindId int, not null definition of property - tblKind
txtValue nvarchar(255), null Value
KindValueBehaviorId int, null System item identification

dbo.tblLang

ID of languages. Text in tblDict

Column Type Description
intLangId int, not null language Id, e.g. 1029=Czech, 1051=Slovak, 1033=English

dbo.tblLicHist

License - list of purchased software licenses.

Column Type Description
intLicHistId int, not null Record ID
lintProductId int, not null Product - tblProduct
intCountChange int, null Number of purchased licenses
dteDate datetime, not null Purchase date
dteDateExpire datetime, null Date of expiration
txtLicName nvarchar(255), null License name
txtLicMode nvarchar(255), null License mode
txtMemo nvarchar(max), null Note
lintCancelLicHistId int, null License terminated by license number ID - tblLicHist
txtDepartment nvarchar(255), null Cost center
txtInventoryNum nvarchar(255), null Inventory number
bolHardlock bit, not null License protected with HW key
intLanguage int, null LCID language
dteUpgradeTo datetime, null Date of upgrading to ...
txtBuyRequest nvarchar(255), null Request
txtWebDownloadAddr nvarchar(1024), null Download website URL
txtActivationKey nvarchar(1024), null Activation Key
bolBundle bit, not null Bundle licenses
CreatedPersonId int, null Author - tPerson
CreatedDate datetime, null Created.
LicKindId int, not null 1 = devices 2 = user 3 = connection 4 = processor
Price float, null Price
AutoAssign bit, not null Assign automatically
MultiAssign bit, not null
LicTypeId int, null License type.
AutoAssignFilter nvarchar(max), null Filter for automatic assignment of licenses.
RemovedDate datetime, null Date and time of the license deletion.
RemovedByPersonId int, null Date and time of the license deletion.
Valid int, not null Is the license currently valid?
AutoAssignNow bit, not null A tag indicating whether the license should be automatically and immediately assigned.

dbo.tblLicHistAtom

License - links to documents and media.

Column Type Description
lintLicHistId int, not null License ID - tblLicHist
lintAtomId int, not null Atom ID - tblAtom

dbo.tblLicHistItem

License - license items.

Column Type Description
intLicHistItemId int, not null Record ID
lintLicHistId int, not null License ID - tblLicHist
NodeId int, null Computer ID - tblNode
ActivationKey nvarchar(255), null Serial number
lintCancelledByLicHistId int, null Voided by license ID
txtMemo nvarchar(max), null Note
txtInventoryNum nvarchar(255), null Inventory number
txtDepartment nvarchar(255), null Center
txtRequest nvarchar(255), null Request
AutoAssigned bit, not null Automatically assigned item
UpgradedFromLicHistItemId int, null

dbo.tblLicTrans

License - shared licenses.

Column Type Description
lintProductId int, not null Product - tblProduct
NodeId int, not null Computer - tblNode
LicNodeId int, not null Computer from which the license is shared - tblNode
txtDesc nvarchar(255), null Note

dbo.tblLog

Log - changes in the properties values and information on the detection results.

Column Type Description
intLogId int, not null Record ID
lintNodeId int, null object - tblNode
lintDetectId int, null detection - tblDetect
dteLog datetime, null date and time
lintLogKindId int, null record type: 0 =unclassified 1 = information 2 = warning 3 = error 4 = edit property value 5 = computer offline 6 = file with detection does not exist yet (shared folder detection) 7 = detection data differs from data in records 8 = object cannot be automatically updated according to detection 9 = hw detection executed 10 = sw detection executed 11 = inventory executed
txtLog nvarchar(max), null record text
lintInventoryId int, null inventory - tblInventory
liLogPersonId int, null author - tPerson
RemovedDate datetime, null
RemovedByPersonId int, null
KindId int, null ID of the property definition related to the change.

dbo.tblMedia

Media.

Column Type Description
lintAtomId int, not null Record ID
lintMediaTypeId int, not null Type - tblMediaTypeId
txtTitle nvarchar(255), null Name
txtAuthor nvarchar(255), null Author
txtMemo nvarchar(max), null Note
txtLocation nvarchar(255), null Location

dbo.tblMediaType

ID of the media types. Texts in tblDict.

Column Type Description
intMediaTypeId int, not null

dbo.tblNetScanRange

Network search setting.

Column Type Description
intRangeId int, not null
intFromIP bigint, null
intToIP bigint, null
txtCollector nvarchar(255), null
nPeriodHours float, null
dteLastScan datetime, null

dbo.tblNode

Objects in the tree.

Column Type Description
intNodeId int, not null Object Id
lintParentId int, null Id of parent object, foreign key to tblNode
lintIconId int, null icon - tblIcon
intState int, null bit field: 1 = Recycle Bin object 2 = the object is protected against deletion 4 = Object Template object 8 = object cannot obe moved 0x10 = hidden object 0x20 = object template 0x40 = property list tabs 0x80 = history is not kept for the object 0x100 = folder "Computer found in network"
txtName nvarchar(255), null object name
bolHidden bit, not null 1=object is hidden; Objects Objects Templates, Properties list tabs and Recycle bin, including child objects, are hidden
lintClassId int, null object type - tblClass
bolAutoUpdate bit, not null 1=according to hardware detection; automatic object update is enabled; Objects with an attribute value of 1 are displayed in this tree as a "yellow triangle" symbol
txtLDAPGUID nvarchar(255), null GUID object value in ActiveDirectory, according to which the object was created.
bolComputerStateOn bit, null 1=object represents the last computer to respond to ping, 0=computer did not respond, NULL=ping not applied
txtPath nvarchar(1024), null path to tree object, for example, "Company/Prague Office/Sales Department"
bolIgnoreDifferences bit, not null 1=any differences found on this object during hardware detection will be ignored and the program will not attempt to update the tree object
liSwProfileId int, null which SW profile does the computer use
bSwAllAllowed bit, not null "All SW permitted" enabled on PC for profiles
LastAgentWSContact datetime, null
NotNullParentId int, not null The ID of the parent object; in the case of no parent object, 0 is here.

dbo.tblNodeAtom

Objects in the tree - links to documents.

Column Type Description
lintNodeId int, not null
lintAtomId int, not null
RemovedDate datetime, null Date of link deletion.
RemovedByPersonId int, null ID of the person who deleted the link.

dbo.tblNodeParent

Objects in the tree - tree.

Column Type Description
lintNodeId int, not null object - tblNode
lintParentNodeId int, not null object on path to tree root - tblNode

dbo.tblNotice

Notes.

Column Type Description
intNoticeId int, not null Record ID
lintNodeId int, not null object - tblNodeId
dteDateTime datetime, null date and time the note was created
txtSubject nvarchar(255), null subject
txtDesc nvarchar(max), null text
liPersonId int, null author - tPerson
RemovedDate datetime, null
RemovedByPersonId int, null

dbo.tblOsVersionInfo

Detection of SW - information on the operating system.

Column Type Description
lintDetectId int, not null
intMajorVersion int, null
intMinorVersion int, null
intBuildNumber int, null
intPlatformId int, null
txtCSDVersion nvarchar(255), null
intServicePackMajor int, null
intServicePackMinor int, null
intSuiteMask int, null
intProductType int, null

dbo.tblProduct

Products / software (software products library).

Column Type Description
intProductId int, not null
intProductUID int, null
txtName nvarchar(255), not null
txtVersion nvarchar(255), null
txtEdition nvarchar(255), null
txtPlatform nvarchar(255), null
lintLangId int, null
lintProducerCompanyId int, null
lintProductTypeId int, not null
lintProductCategoryId int, null
txtDescription nvarchar(255), null
intFlags int, null
dteTimeStamp datetime, not null
bolValid bit, not null
txtCertifiedBy nvarchar(255), null
txtParam1 nvarchar(255), null
txtParam2 nvarchar(255), null
nPrice float, null
AppCategoryId int, null
SamTypeId int, not null
AlternateApprovedProduct nvarchar(max), null
MonOnly bit, not null
ProductStateId int, not null
SupportedVersion nvarchar(32), null
ProductStateModifiedPersonId int, null
ProductStateModifiedDate datetime, null
ProductRejectedFrom datetime, null
Request nvarchar(32), null
FullName nvarchar(1023), null

dbo.tblProductCategory

ID of the products categories (OS). Text in tblDict.

Column Type Description
intProductCategoryId int, not null

dbo.tblProductPack

Definition of software products packages (software products library).

Column Type Description
lintProductPackId int, not null
lintProductId int, not null
intFlags int, null
dteTimeStamp datetime, not null
bolValid bit, not null
txtCertifiedBy nvarchar(255), null

dbo.tblProductType

ID of the products types (commercial, freeware, ...) (software products library).

Column Type Description
intProductTypeId int, not null

dbo.tblProperty

Objects in the tree - properties.

Column Type Description
intPropertyId int, not null primary key
lintNodeId int, not null object - tblNode
lintKindId int, not null property type - tblKind
txtValue nvarchar(255), null property value
intState int, null bite field: 2 = property locked against deletion
intNameOrder int, null property value order in object name; If the object name is not created from the property value, the value is 0 or NULL
bolInheritable bit, not null 1=property is inherited into the child objects
ParentNodeId int, null ID of the parent object from which the property is inherited.
NodeIdValue int, null Object ID - property value for the "User" type property.

dbo.tblPropertyMap

Mapping properties to system functions.

Column Type Description
intPropertyMapId int, not null
lintPropertyMapTypeId int, null
lintObjClassId int, null
lintObjKindId int, null
lintKindId int, null
lintMapObjClassId int, null
lintMapObjKindId int, null
lintMapKindId int, null

dbo.tblRegImage

Software products library - recognition rules for records from the register.

Column Type Description
intRegImageId int, not null
intRegImageUID int, not null
txtDisplayName nvarchar(255), null
txtDisplayVersion nvarchar(255), null
intVersionMajorLo int, null
intVersionMinorLo int, null
intVersionMajorHi int, null
intVersionMinorHi int, null
intLanguage int, null
txtPublisher nvarchar(255), null
txtComments nvarchar(255), null
txtPath nvarchar(255), null
bolProductKey bit, not null
intOrder int, null
intFlags int, null
dteTimeStamp datetime, not null
bolValid bit, not null
txtCertifiedBy nvarchar(255), null
lintProductId int, not null

dbo.tblRegUninstall

Detected registry entries. The table contains records which may repeat in various computers.

Column Type Description
intRegUninstallId int, not null
lintRootRegKeyId int, not null
txtPath nvarchar(255), not null
txtDisplayName nvarchar(255), null
txtDisplayVersion nvarchar(255), null
intVersion int, null
intLanguage int, null
txtPublisher nvarchar(255), null
txtComments nvarchar(255), null
txtAuthorizedCDFPrefix nvarchar(255), null
txtContact nvarchar(255), null
txtHelpLink nvarchar(255), null
txtHelpTelephone nvarchar(255), null
intSystemComponent int, null
txtSize nvarchar(255), null
txtURLInfoAbout nvarchar(255), null
txtURLUpdateInfo nvarchar(255), null
intVersionMajor int, null
intVersionMinor int, null
intWindowsInstaller int, null
lintProductId int, null
lintRegImageId int, null
lintOriginalProductId int, null
Hash varbinary, not null
EvalSwLibDate datetime, null
FullName nvarchar(511), not null

dbo.tblRegValue

Detection - values of detected records from the register.

Column Type Description
intRegValueId int, not null
lintDetectId int, not null
lintRootRegKeyId int, not null
txtPath nvarchar(255), null
txtName nvarchar(255), null
txtValue nvarchar(255), null

dbo.tblSetting

Mapping properties to system functions.

Column Type Description
txtKey nvarchar(255), not null
txtValue nvarchar(255), null
intValue int, null

dbo.tblSwLibUpdate

Information on which computer is executing the software products library update.

Column Type Description
txtCollector nvarchar(255), null
dteUpdateStart datetime, null

dbo.tblSystemSetting

System settings.

Column Type Description
bolDetect_RestrictDetectionCnt bit, not null
bolNode_Rights bit, not null

dbo.tblUserNodeRight

Rights in the object tree to groups / users.

Column Type Description
intUserNodeRightId int, not null
lintNodeId int, null
lintClassId int, null
bolRecursive bit, not null
bolRead bit, null
bolWrite bit, null
bolMove bit, null
bolDelete bit, null
liPersonId int, null
liRoleId int, null
CreateObj bit, null

dbo.tblVersion

Software products library version.

Column Type Description
intVersion int, null database version number (=35 and further recorded in tDb)
intDataVersion int, null basic data version number
dteSwLib datetime, null Software product library version date
intLangId int, null Database language
intLanguage int, null Database language
SwLibExtDate datetime, null Date on which the software product library version was expanded

dbo.tblWbemClassDesc

Code list of values for the detected HW properties.

Column Type Description
txtCLASS nvarchar(255), null
txtPropName nvarchar(255), null
intPropValueIndex int, null
txtPropValueDesc nvarchar(255), null

dbo.tblWbemObject

HW detected in the computers.

Column Type Description
intWbemObjectId int, not null
lintDetectId int, not null
bolVirtualObject bit, not null
__CLASS nvarchar(255), null
AdapterRAM float, null
AdapterType nvarchar(255), null
AttachedTo nvarchar(255), null
Availability int, null
BankLabel nvarchar(255), null
BaseBoard nvarchar(255), null
Capacity bigint, null
Caption nvarchar(255), null
ChassisTypes int, null
txtChassisTypesDesc nvarchar(255), null
Compressed bit, null
CSDVersion nvarchar(255), null
CurrentClockSpeed int, null
CurrentRefreshRate int, null
DataWidth int, null
Description nvarchar(255), null
DeviceID nvarchar(255), null
DeviceLocator nvarchar(255), null
DeviceType nvarchar(255), null
DHCPEnabled bit, null
DNSServerSearchOrder nvarchar(255), null
Prop_Domain nvarchar(255), null
Drive nvarchar(255), null
DriveType int, null
EDIDVersion nvarchar(255), null
FileSystem nvarchar(255), null
FormFactor int, null
txtFormFactorDesc nvarchar(255), null
FreeSpace float, null
InstallDate datetime, null
InfraredSupported bit, null
InterfaceType nvarchar(255), null
IPAddress nvarchar(255), null
IPEnabled bit, null
IPSubnet nvarchar(255), null
IRQNumber int, null
MACAddress nvarchar(255), null
ManufactureDate datetime, null
Manufacturer nvarchar(255), null
MaxCapacity int, null
MaxClockSpeed int, null
MaxRefreshRate int, null
MediaType nvarchar(255), null
MemoryDevices int, null
MemoryType int, null
txtMemoryTypeDesc nvarchar(255), null
MinRefreshRate int, null
Model nvarchar(255), null
MonitorManufacturer nvarchar(255), null
Monochrome bit, null
PartOfDomain bit, null
Prop_Name nvarchar(255), null
NetConnectionID nvarchar(255), null
Organization nvarchar(255), null
OSLanguage int, null
PNPDeviceID nvarchar(255), null
PortName nvarchar(255), null
ProcessorId nvarchar(255), null
Prop_Product nvarchar(255), null
RegisteredUser nvarchar(255), null
ScreenHeight int, null
ScreenWidth int, null
SerialNumber nvarchar(255), null
Prop_Size float, null
Service nvarchar(255), null
ServiceName nvarchar(255), null
SMBIOSBIOSVersion nvarchar(255), null
SocketDesignation nvarchar(255), null
Speed nvarchar(255), null
StatusInfo int, null
txtStatusInfoDesc nvarchar(255), null
SystemDirectory nvarchar(255), null
SystemType nvarchar(255), null
TotalPhysicalMemory bigint, null
TypeDetail int, null
txtTypeDetailDesc nvarchar(255), null
UPSPort nvarchar(255), null
UserName nvarchar(255), null
Version nvarchar(255), null
VideoModeDescription nvarchar(255), null
VolumeSerialNumber nvarchar(255), null
WakeUpType int, null
txtWakeUpTypeDesc nvarchar(255), null
AlvaoVirtualMachineHostname nvarchar(128), null
NumberOfLogicalProcessors int, null
Active bit, null
MaxHorizontalImageSize int, null
MaxVerticalImageSize int, null

dbo.tblWbemObjectProcess

Hardware "Blacklist".

Column Type Description
txtCLASS nvarchar(255), null
txtPropName nvarchar(255), null
txtPropValue nvarchar(255), null
bolSetObjectAsVirtual bit, not null
bolClearObjectProp bit, not null

dbo.tblWbemObjectRel

Links between the detected components of the computers.

Column Type Description
lintWbemObjectId1 int, not null
lintWbemObjectId2 int, not null

dbo.tBuilding

Buildings, see item Request.Building.

Column Type Description
iBuildingId int, not null
sBuilding nvarchar(255), null

dbo.tColumn

List of custom items and certain system items.

Column Type Description
iColumnId int, not null Item ID.
sTable nvarchar(128), null Name of the table where the values of the item are stored.
sColumn nvarchar(128), null Name of the column in the table where the values of the item are stored.
sTitle nvarchar(255), not null Displayed item name.
mDescription nvarchar(max), null Item description.
nOrder float, not null The order of items as they are described on the forms.
bUseColumnValue bit, not null Use the value list.
Removed int, null Date of item removal.
Multiline bit, not null Multi-row text.
Localize bit, not null The flag specifying whether translation of value lists of a custom item into other languages is enabled / allowed.

dbo.tColumnValue

Value lists for custom items.

Column Type Description
iColumnValueId int, not null Record ID.
liColumnId int, not null Link to custom item record.
liHdSectionId int, null NULL represents an item on the list of values applies to all services. The view is otherwise limited only to the configured service.
mColumnValue nvarchar(max), not null Displayed item name.
nOrder float, not null Order for displaying items, sorted from lowest to highest number.
sExtra1 nvarchar(255), null
ParentValue int, null Parent tree item.
ColumnValueShort nvarchar(max), not null Full name including path via parent items.

dbo.tComputer

Computers for the ALVAO User Activity Monitoring and ALVAO HW/SW Usage Monitoring modules.

Column Type Description
iComputerId int, not null Record ID.
sComputer nvarchar(255), null computer name
mComputerNotes nvarchar(max), null
sComputerMonitoringAgentVersion nvarchar(255), null
dComputerMonitoringAgentVersionLastDetected datetime, null
dComputerMonitoringAgentLastDataTransition datetime, null
dComputerMonitoringAgentLastDataTransitionTry datetime, null
sComputerAdGuid nvarchar(255), null
sComputerOperatingSystem nvarchar(255), null
sComputerOperatingSystemVersion nvarchar(255), null
sComputerOperatingSystemServicePack nvarchar(255), null
dComputerCreated datetime, null
dComputerRemoved datetime, null Time at which the computer was deleted. If the computer was not deleted NULL.
bComputerWMIEnabled bit, null
sComputerWMIUser nvarchar(255), null
bComputerWMIIntegratedLogin bit, null
sComputerWMIAgentInstallRemotePath nvarchar(255), null
sComputerWMIAgentInstallPackagePath nvarchar(255), null
sComputerMonitoringAgentLastDataTransitionMessage nvarchar(255), null
bOldAgent bit, not null
UploadSessionId uniqueidentifier, null
UploadLastCall datetime, null
UploadFilename nvarchar(256), null
UploadLastPart int, null
RuntimeHoursMonth0 float, null Run time in month 0 in hours.
RuntimeHoursMonth1 float, null Run time in month 1 in hours.
RuntimeHoursMonth2 float, null Run time in month 2 in hours.
RuntimeHoursMonth3 float, null Run time in month 3 in hours.
RuntimeHoursMonth4 float, null Run time in month 4 in hours.
RuntimeHoursMonth5 float, null Run time in month 5 in hours.
RuntimeHoursMonth6 float, null Run time in month 6 in hours.
RuntimeHoursMonth7 float, null Run time in month 7 in hours.
RuntimeHoursMonth8 float, null Run time in month 8 in hours.
RuntimeHoursMonth9 float, null Run time in month 9 in hours.
RuntimeHoursMonth10 float, null Run time in month 10 in hours.
RuntimeHoursMonth11 float, null Run time in month 11 in hours.
RuntimeHoursMonth12 float, null Run time in month 12 in hours.

dbo.tDay

Calendar of days

Column Type Description
dDay datetime, not null

dbo.tDb

Database version, database language ID, activation keys for the entire ALVAO.

Column Type Description
iDbVersion int, null
sDb nvarchar(255), null
sDbActivation nvarchar(max), null
iDbLocaleId int, not null
LastDevUpgradeScriptPos int, null
LastDevUpgradeScriptHash nvarchar(64), null
Version nvarchar(32), not null
AlvaoVersion nvarchar(50), null Product version for which the database is intended.

dbo.tDetectedClassKind

Detected properties of the computer components.

Column Type Description
liClassId int, not null
liKindId int, not null

dbo.tDocument

Attachments (to documents, notes, events, e-mails, ...) concerning the entire ALVAO system.

Column Type Description
iDocumentId int, not null Record ID.
sDocument nvarchar(255), null File name.
sDocumentContentType nvarchar(255), null MIME file type.
oDocument image, null Binary file data.
liDocumentActId int, null Link to event to which the file is attached.
liDocumentArticleId int, null Link to article to which the file is attached.
Url nvarchar(max), null
AMDocumentId int, null
AMNoticeId int, null
TicketTemplateId int, null Request template ID, if the document belongs to a template.
NewsId int, null Remote key to current message.
EmailSignatureId int, null
HdTicketApprovalId int, null Reference to the commencement of approving to which the file is attached.
HdTicketApprovalItemId int, null
EmbededImage bit, not null

dbo.tEmailSignature

Signatures for e-mail messages.

Column Type Description
iEmailSignatureId int, not null
liEmailSignaturePersonId int, null
sEmailSignature nvarchar(255), not null
mEmailSignatureText nvarchar(max), null
EmailSignatureHtml nvarchar(max), null Description in HTML

dbo.tEmailTemplate

Templates of custom notifications and alerts sent by the ALVAO SAM Assistant module.

Column Type Description
liHdSectionId int, null
sNotificationKind nvarchar(64), null
bActive bit, not null
mSubject nvarchar(max), null
mTextBody nvarchar(max), null
SamAlertRuleId int, null
TransferConfirmAlertRuleId int, null Kind of alert to sign the handover protocol.
id int, not null Template Id.

dbo.tHdSection

ALVAO Service Desk product services.

Column Type Description
iHdSectionId int, not null Record ID.
sHdSection nvarchar(255), null Full service name, including location. For example "Helpdesk/Technical Support“.
sHdSectionShort nvarchar(255), null Service short name. For example "Technical Support“.
mHdSectionDesc nvarchar(max), null Description of service.
sHdSectionImageFile nvarchar(255), null Service image location. This image is displayed on the Portal.
nHdSectionOrder float, null Order in which services are displayed.
liHdSectionParentHdSectionId int, null Link to ancestor in tree.
liHdSectionBuildingId int, null Link to building.
sHdSectionEmail nvarchar(255), null Service email.
sHdSectionMessageTagPrefix nvarchar(255), null Prefix in request number.
sHdSectionMessageTagSuffix nvarchar(255), null Suffix in request number.
sHdSectionExchangeMailboxUri nvarchar(255), null URI for loading messages via MailboxReader for WebDAV.
bHdSectionDefault bit, not null Flaf to determine whether the service is default. 1 - service is default 0 - service is not default NULL - service is not default. Only one service can be default.
sHdSectionPhone nvarchar(255), null Phone number.
sHdSectionImapServer nvarchar(255), null Address of IMAP server for loading messages from MailboxReader.
sHdSectionNewHdTicketShowFields nvarchar(1024), null List of optional items that shall be displayed on the portal during the process of creating a new request.
sHdSectionUserShowFields nvarchar(1024), null List of optional items that shall be displayed on the portal during the process of editing/viewing the request.
nHdSectionUserReopenDays float, null The number of days when the requester may reopen their request until the request is resolved.
bHdSectionMessageRemove bit, not null MailboxReader removes read messages from the server for "1".
sHdSectionMailboxLogin nvarchar(255), null Username used by MailboxReader to read messages.
sHdSectionMailboxPassword nvarchar(255), null Password used by MailboxReader to read messages.
bHdSectionHdTicketUserRead bit, not null If the value is 1, the user can view the requests of other users within this service.
bHdSectionFolder bit, not null If the service is only a folder containing other services and the user cannot insert requests, the value is 1. The button for creating a request for this service is not displayed in the portal.
sHdSectionNewHdTicketUrl nvarchar(1024), null URL of the custom form to create a new request.
sHdSectionHdTicketCustomWorkflowUrl nvarchar(1024), null Custom workflow URL.
nHdSectionQueueHoursPerWeek float, null Number of work hours per week. This value is used for calculating the deadline for the request in the queue.
dHdSectionRemoved datetime, null Time at which the service was removed. The service is not removed for NULL.
sHdSectionEWSUri nvarchar(255), null URI EWS, from which MailboxReader reads mails.
bHdSectionMessageReadOnlyUnread bit, not null If the value is 1, MailboxReader only reads unread messages.
bHdSectionMessageMarkRead bit, not null If the value is 1, MailboxReader identifies the message as read once the message is loaded.
sHdSectionMessageFolder nvarchar(255), null MailboxReader moves the message to this folder.
bHdSectionImapSsl bit, not null MailboxReader uses SSL for connecting to the IMAP server for "1".
TicketTypeId int, not null
ImapPort int, null
UseFeedback bit, not null
CustomFeedbackUrl nvarchar(max), null
TileColor int, null
TileType int, not null
AllowSkipCustomForm bit, not null If the value is 1 and a custom form is used for the service, a request can be created via the SD Console
DefaultLanguageId int, null Service local language.
DefaultTimeZone nvarchar(64), null Service local time zone.
CreateNewFollowingRequest bit, not null
CreateNewFollowingRequestToSection int, null
ShowInServiceCatalog bit, not null Column for the "View in the Service Catalogue" option.
ForceUseSolverLicense bit, not null
Keywords nvarchar(max), null Service keywords.
DefaultTicketTemplateId int, null Default request template.
TargetHdSectionId int, null Target service of the service shortcut.

dbo.tHdSectionCust

Services custom items values.

Column Type Description
liHdSectionId int, null

dbo.tHdSectionPerson

Setting of notifications from the services to individual persons.

Column Type Description
iHdSectionPersonId int, not null
liHdSectionPersonHdSectionId int, null
liHdSectionPersonPersonId int, null
bHdSectionPersonNotifySolverOnHdTicketPassed bit, null
bHdSectionPersonNotifySolverOnHdTicketCreated bit, null
bHdSectionPersonNotifySolverOnHdTicketHdSectionChanged bit, null
bHdSectionPersonNotifySolverOnHdTicketOpen bit, null
bHdSectionPersonNotifySolverOnNewMessageReceived bit, null
bHdSectionPersonNotifyUserOnHdTicketCreated bit, null
bHdSectionPersonNotifyUserOnHdTicketDeadlineChanged bit, null
bHdSectionPersonNotifyUserOnHdTicketResolved bit, null
bHdSectionPersonNotifyUserOnHdTicketSolverOpen bit, null
bNotifySolverOnHdTicketReturnedToOperators bit, null

dbo.tHdSectionRights

Authorization individuals and groups have in services (Operator, Solver, ...).

Column Type Description
iHdSectionRightsId int, not null
liHdSectionRightsHdSectionId int, not null
liHdSectionRightsRoleId int, null
liHdSectionRightsPersonId int, null
bHdSectionRightsOperator bit, null
bHdSectionRightsSolver bit, null
bHdSectionRightsSolverTake1 bit, null
bHdSectionRightsSolverTake2 bit, null
bHdSectionRightsManager bit, null
Reader bit, null
ExceptionalSolver bit, null
RequesterRoleId int, not null ID of the group of requesters associated with the permissions (mapping of requesters to the solver team).

dbo.tHdTicket

Requests.

Column Type Description
sHdTicket nvarchar(1024), null Request name
mHdTicketNotice nvarchar(max), null Notes to the request.
liHdTicketUserPersonId int, not null Link to requester.
dHdTicket datetime, null Time at which the request was created.
dHdTicketDeadline datetime, null Deadline.
sHdTicketCategory nvarchar(255), null Category.
sHdTicketStateNotice nvarchar(255), null Status.
sHdTicketGroup nvarchar(255), null Group.
liHdTicketSolverPersonId int, null Link to solver. The operators have the request if NULL.
dHdTicketReceived datetime, null TIme at which the request was received. MailboxReader stores the moment the request was read here. The email time is considered the time created.
dHdTicketResolved datetime, null Time to solve request by solver.
sHdTicketDeviceCode nvarchar(255), null device number.
Priority int, null Link to priority.
sHdTicketUser nvarchar(255), null Requester name.
sHdTicketUserEmail nvarchar(255), null Requester email.
sHdTicketUserPhone nvarchar(255), null Requester's phone.
mHdTicketUserContact nvarchar(max), null Requester contact details.
liHdTicketHdSectionId int, not null Link to service in which the request is found.
sHdTicketUserMobile nvarchar(255), null Requester cell phone
sHdTicketUserOffice nvarchar(255), null Requester office.
sHdTicketUserDepartment nvarchar(255), null Requester's department.
sHdTicketUserWorkPosition nvarchar(255), null Requester's job.
sHdTicketUserCompany nvarchar(255), null Requester's company.
liHdTicketStartingActId int, null Link to event that establishes the request.
liHdTicketRoomId int, null Link to room.
sHdTicketMessageTag nvarchar(255), null Request number. Contains the prefix and suffix of the service in which the request is found as the root of the record ID.
liHdTicketNodeId int, null Link to devices. Database integrity check does not work here.
dHdTicketRemoved datetime, null Time at which the request was deleted.
liHdTicketSlaId int, not null Link to SLA, used for this request.
liHdTicketResolvedPersonId int, null
iHdTicketSolverOrder int, null
dHdTicketUserCloseLastAdvised datetime, null
nHdTicketEstimatedHours float, null
iHdTicketQueueOrder int, null
dHdTicketQueueDeadline datetime, null
liHdTicketHdTicketApprovalItemId int, null
sHdTicketWaitingForEmail nvarchar(255), null
Impact int, not null
Urgency int, not null
UserEmail2 nvarchar(255), null
UserPhone2 nvarchar(255), null
RelatedAccountId int, null Organization for which the request is implemented.
FeedbackLinkId uniqueidentifier, null Contains a unique guid ticket identifier.
FeedbackSolveSpeed int, null The “Resolution speed” item of the satisfaction survey. This is a foreign key in the tColumnValue table. tColumnValue.nOrder contains a numerical representation of the score.
FeedbackProfessionality int, null The “Professionalism” item of the satisfaction survey. This is a foreign key in the tColumnValue table. tColumnValue.nOrder contains a numerical representation of the score.
FeedbackExpertise int, null The “Expertise” item of the satisfaction survey. This is a foreign key in the tColumnValue table. tColumnValue.nOrder contains a numerical representation of the score.
FeedbackComment nvarchar(max), null "Comments and notes" item on satisfaction survey.
ClosedDate datetime, null Request close date
ClosedByPersonId int, null ID of the person who closed the request
FirstReactionDeadline datetime, null
LastActionDate datetime, null Date of the last reaction
WaitingActId int, null The last event related to the request where the requester is waited for
WaitedForUserHours float, null Number of hours waited for the requester. The sum does not include an interval from the last event to the present; it is to be added after the vHdTicket view is called.
HasReaction bit, not null A flag indicating that the request has been responded to by the solver/operator.
WorkHours float, null Number of hours worked in relation to the request.
TravelHours float, null Number of hours spent on the way in respect of the request.
TravelKm float, null Number of kms reported in relation to the request.
NextActionDeadline datetime, null The current target date of the request.
iHdTicketId int, not null
OriginalDeadline datetime, null
ShiftedDeadline datetime, null
InternalTarget nvarchar(255), null Internal target name.
InternalTargetDeadline datetime, null Internal target date.
sHdTicketFullName nvarchar(1280), null
TicketStateId int, null Request status ID.
FeedbackGeneral int, null The “Overall satisfaction” item of the satisfaction survey. This is a foreign key in the tColumnValue table. tColumnValue.nOrder contains a numerical representation of the score.
SumOfAllOpeningHoursIntervalsToCurrentTarget float, null Time elapsed from the beginning of the next interval of the operating time up to the due date of the current target (in the operating hours).

dbo.tHdTicketAltMessageTag

Alternative request tags. Upon merging requests, the final request uses tags from original requests as alternative tags.

Column Type Description
iHdTicketAltMessageTagId int, not null
liHdTicketAltMessageTagHdTicketId int, not null
sHdTicketAltMessageTag nvarchar(255), null

dbo.tHdTicketApproval

Request approval process instance - main record.

Column Type Description
iHdTicketApprovalId int, not null
liHdTicketApprovalHdTicketId int, not null
dHdTicketApprovalStarted datetime, null
liHdTicketApprovalStartedPersonId int, null
liHdTicketApprovalApprovalSchemaId int, null
ApprovalNotice nvarchar(max), null Instructions for the approver.
ApprovalNoticeHtml nvarchar(max), null
CanceledPersonId int, null ID of the person who canceled approving.

dbo.tHdTicketApprovalItem

Request approval step.

Column Type Description
iHdTicketApprovalItemId int, not null
dHdTicketApprovalItem datetime, null
liHdTicketApprovalItemPersonId int, null
liHdTicketApprovalItemHdTicketApprovalItemResultId int, not null
mHdTicketApprovalItemNotes nvarchar(max), null
liHdTicketApprovalItemApprovalSchemaItemId int, null
liHdTicketApprovalItemHdTicketApprovalId int, not null
dExpiration datetime, null
ApprovalItemNotesHtml nvarchar(max), null

dbo.tHdTicketApprovalItemResult

List of approval step statuses.

Column Type Description
iHdTicketApprovalItemResultId int, not null
sHdTicketApprovalItemResult nvarchar(255), null

dbo.tHdTicketCategory

Request.Category item values.

Column Type Description
sHdTicketCategory nvarchar(255), not null Request category

dbo.tHdTicketCust

Request custom items values.

Column Type Description
liHdTicketId int, not null Link to request to which the values belong.

dbo.TicketApprovalMessageForApproverLoc

Localized message for approvers.

Column Type Description
Id int, not null Record ID.
HdTicketApprovalId int, not null Approval link
LocaleId int, not null Language ID.
MessageHtml nvarchar(max), null Localized message for approvers (HTML). Attachments and images in the message body are stored as attachments corresponding to an entry in tHdTicketApproval (see HdTicketApprovalId).
Message nvarchar(max), null Localized message for approvers (plaintext).

dbo.TicketChange

Request log record for changes to the request item value.

Column Type Description
id int, not null
TicketId int, not null
PersonId int, not null
ChangeDate datetime, not null
ColumnId int, not null
ValueOld nvarchar(max), null
ValueNew nvarchar(max), null

dbo.TicketRelation

Links Between Requests.

Column Type Description
id int, not null
BeginHdTicketId int, not null
EndHdTicketId int, not null
TicketRelationTypeId int, not null
Created datetime, null
Removed datetime, null
CreatedByPersonId int, null
RemovedByPersonId int, null

dbo.TicketRelationType

Types of links between requests.

Column Type Description
id int, not null
BeginName nvarchar(30), not null
EndName nvarchar(30), not null
Directional bit, not null
Cyclic bit, not null
OneToMany bit, not null
MenuOrder int, not null
TicketRelationTypeBehaviorId int, not null
CustomField1 int, null

dbo.TicketRelationTypeBehavior

System types of links between requests.

Column Type Description
id int, not null
TicketRelationTypeBehavior nvarchar(50), null

dbo.TicketSequence

A table containing the next request number.

Column Type Description
NextTicketId int, not null Next request number

dbo.TicketState

Workflow statuses defined within Processes. Status names correspond with request states.

Column Type Description
id int, not null Record ID
TicketTypeId int, null
TicketState nvarchar(64), not null State text
Description nvarchar(max), null
SolverInstructions nvarchar(max), null
Order int, not null
TicketStateBehaviorId int, not null
CustomField1 int, null
TransitToAllStates bit, not null
ApprovalAutoStart bit, not null
IsApprovalState bit, not null
OnRejectedStateId int, null
OnApprovalStateId int, null
OnCanceledStateId int, null
OnExpiredStateId int, null
ApprovalSchemaId int, null
ApprovalPersonId int, null
ApprovalExpirationHours float, null
CloseAfterSolution bit, not null Automatic closing of request after changing to status - value = 1 is only possible in the Solved status.
CustomMessageForApproverTemplate nvarchar(max), null Custom message template for approvers. If the record has a value of NULL, then the default template is used (available in tString).

dbo.TicketStateBehavior

Workflow system statuses defined within Processes.

Column Type Description
id int, not null
TicketStateBehavior nvarchar(50), not null

dbo.TicketStateLoc

Cache of the localizations of request states.

Column Type Description
TicketStateId int, not null Request status ID.
LocaleId int, not null Language ID.
TicketState nvarchar(64), null Localized request status name.
Description nvarchar(max), null Localized request status description.
SolverInstructions nvarchar(max), null Localized instructions for solver.
CustomMessageForApproverTemplate nvarchar(max), null Localized customer message template for approvers. If the record has a value of NULL, then the default template is used (available in tString).

dbo.TicketStateRelation

Permitted transitions between Workflow statuses.

Column Type Description
id int, not null
BeginTicketStateId int, not null
EndTicketStateId int, not null

dbo.TicketStateRequiredColumn

Mandatory items for individual Workflow statuses.

Column Type Description
id int, not null
TicketStateId int, not null
ColumnId int, not null

dbo.TicketTemplate

List of request templates

Column Type Description
id int, not null Record ID
Name nvarchar(255), null Template name (must be unique).
Description nvarchar(max), null Description of template.
HdSectionId int, not null ID of service in which the template is created.
RemovedByPersonId int, null Link to user that deleted the template. The template is not deleted for NULL.
RemovedDate datetime, null Date on which the template was deleted. The template is not deleted for NULL.
LastTicketId int, null ID of the last request automatically created based on this template (FK).
LastTicketCreationDate datetime, null Creation date of the last request automatically created based on this template.
NextDate datetime, null Next deadline for the planned request - only date (you cannot work with time).
Planning bit, not null Planning (0 - off, 1 - on).
UserId int, null Requester ID (FK).
StartDate datetime, null Beginning of repetition - only date (time is ignored).
EndAfter int, null Number of occurrences upon which planning is finished.
TicketCreatedCount int, not null Number of created requests based on this template in the current planning.
EndDate datetime, null End of repetition - only the date of the last available creation (you cannot work with time).
Daily bit, not null Daily (0 - off, 1 - on).
DailyEveryXDays int, null Repetition period in days.
DailyEveryWeekday bit, not null On weekdays (0 - off, 1 - on).
DailyAfterClosing int, null Upon closing the previous.
Weekly bit, not null Weekly (0 - off, 1 - on).
WeeklyEveryXDays int, null Repetition period in weeks.
WeeklyMonday bit, not null On Mondays.
WeeklyTuesday bit, not null On Tuesdays.
WeeklyWednesday bit, not null On Wednesdays.
WeeklyThursday bit, not null On Thursdays.
WeeklyFriday bit, not null On Fridays.
WeeklySaturday bit, not null On Saturdays.
WeeklySunday bit, not null On Sundays.
WeeklyAfterClosing int, null Upon closing the previous.
Monthly bit, not null Monthly (0 - off, 1 - on).
MonthlyDayInMonth int, null Which day in the month.
MonthlyDayInMonthEveryXMonths int, null Every X month.
MonthlyEveryXDayInWeek int, null Which weekday in the month (1 - first, 2 - second, 3 - third, 4 - fourth, 5 - last).
MonthlyDayInWeek int, null Which weekday (1 - Monday, …, 8 - day, 9 - weekday).
MonthlyDayInWeekEveryXMonths int, null Every X month.
MonthlyAfterClosing int, null Upon closing the previous.
Yearly bit, not null Yearly (0 - off, 1 - on).
YearlyDayInMonth int, null Which day in the month.
YearlyDayInMonthOnMonth int, null Which month (1 - January, …).
YearlyEveryXDayInWeek int, null Which weekday in the month (1 - first, 2 - second, 3 - third, 4 - fourth, 5 - last).
YearlyDayInWeek int, null Which weekday (1 - Monday, …).
YearlyDayInWeekOnMonth int, null Which month (1 - January, …).
YearlyAfterClosing int, null Upon closing the previous.
SolverId int, null Solver ID (FK).

dbo.TicketTemplateColumnValue

column values on request template.

Column Type Description
id int, not null Record ID
TicketTemplateId int, not null Id of template to which the column belongs.
ColumnId int, not null Column Id.
DefaultValue nvarchar(max), not null Value stored in the column.
DefaultValueHtml nvarchar(max), null Value saved in a column in HTML.

dbo.TicketType

Processes. The processes define the workflow for resolving requests.

Column Type Description
id int, not null
TicketType nvarchar(30), not null
Description nvarchar(max), null
TicketTypeBehaviorId int, not null
CustomField1 int, null
BackResolveDeadlineHours float, null

dbo.TicketTypeBehavior

System processes.

Column Type Description
id int, not null
TicketTypeBehavior nvarchar(30), not null

dbo.TicketTypeColumn

Request items used by the process.

Column Type Description
id int, not null
TicketTypeId int, not null
ColumnId int, not null
ShowInGeneralTab bit, null

dbo.TicketTypeLoc

Cache of process localizations.

Column Type Description
TicketTypeId int, not null Process ID.
LocaleId int, not null Language ID.
TicketType nvarchar(255), null Localized process name.
TicketTypeDesc nvarchar(max), null Localized process description.

dbo.tIdSeqClass

Numerical series - definitions for types of objects.

Column Type Description
liIdSeqId int, not null
liClassId int, null

dbo.TimeZone

Time zone list.

Column Type Description
id int, not null Record ID.
uid nvarchar(128), not null Unique identifier (matches the key in the registry).
DisplayName nvarchar(128), not null Localized name.

dbo.TimeZoneBias

Time zone shifts compared to UTC for each year

Column Type Description
TimeZoneId int, not null Link to time zone.
FromDate datetime, null From date.
ToDate datetime, null Until.
Bias int, not null Shift compared to UTC in minutes.

dbo.tLocale

Language environments.

Column Type Description
iLocaleId int, not null LocaleID. The list of these, for example, can be found here http://msdn.microsoft.com/en-us/goglobal/bb964664.aspx.
sLocale nvarchar(255), not null Language name in Czech.
bLocaleEnabled bit, not null If set to 1, the language is used and is displayed in menus.
sLangAbbr nvarchar(10), null Three-letter language abbreviations. Used in all names of localization dll files. The list of these, for example, can be found here http://www.microsoft.com/resources/msdn/goglobal/default.mspx.

dbo.tLocalization

Language localization for selected database values. The following items are supported: tHdSection.sHdSectionShort, tHdSection.mHdSectionDesc.

Column Type Description
iLocalizationId int, not null Record ID.
sTable nvarchar(128), null Name of table.
sAttribute nvarchar(128), null Column name.
iRecordId int, not null ID of record in target table designated for localization.
iLocaleId int, not null LCID of the language for which the localization is being executed.
mLocalization nvarchar(max), null Localized text.
NeedsUpdate bit, not null If there is 1, this translation needs to be updated because the original text has been modified since last translation.

dbo.tNodeProduct

Software profiles - exceptions for the computer.

Column Type Description
liNodeId int, null
liProductId int, null
liSwPresenceId int, not null

dbo.tOpeningHours

Service working hours.

Column Type Description
iOpeningHoursId int, not null
sOpeningHours nvarchar(255), null
mDescription nvarchar(max), null
mNotes nvarchar(max), null
TimeZoneId int, null
ActualOpeningHoursEnd datetime, null End of the current operating hours interval.
NextOpeningHoursStart datetime, null Beginning of the next operating hours interval.
BankHolidayRegionId int, null Public holiday region. A foreign key on the tBankHolidayRegion table.

dbo.tOpeningHoursCache

Auxiliary records for optimizing time calculations according to service working hours.

Column Type Description
liOpeningHoursId int, not null
dFrom datetime, not null
dTo datetime, not null
nTotalDays float, not null

dbo.tOpeningHoursException

Exceptions in service working hours.

Column Type Description
iOpeningHoursExceptionId int, not null
liOpeningHoursId int, not null
dFrom datetime, not null
dTo datetime, not null
bOpen bit, not null
mNotes nvarchar(max), null

dbo.tPerson

Persons in the ALVAO system.

Column Type Description
iPersonId int, not null Record ID
sPerson nvarchar(255), null displayed username
sPersonLogin nvarchar(255), null user login
sPersonAdGuid nvarchar(255), null
sPersonEmail nvarchar(255), null e-mail
sPersonPhone nvarchar(255), null phone
sPersonMobile nvarchar(255), null mobile phone
sPersonOffice nvarchar(255), null office
sPersonDepartment nvarchar(255), null department
dPersonCreated datetime, null date on which the user was created
bPersonSystem bit, not null system user
sPersonWorkPosition nvarchar(255), null job
bHidden bit, not null Hide in menus
sPersonPswd nvarchar(255), null
bPersonShared bit, not null Shared account
bPersonAccountDisabled bit, not null Account is disabled
mPersonContact nvarchar(max), null Other contacts
sPersonCalendarWebDAVUri nvarchar(1024), null Calendar (WebDAV Uri)
sPersonUrgentEmail nvarchar(255), null E-mail for urgent messages
bPersonGuest bit, not null
dPersonRemoved datetime, null date on which the user was removed
mPersonNotes nvarchar(max), null
sPersonCountry nvarchar(255), null
sPersonCountryAbbr nvarchar(2), null
iPersonCountryCode int, null
sPersonPreferredLanguage nvarchar(2), null
sPersonCity nvarchar(255), null
oPersonSID image, null
sPersonAdPath nvarchar(1024), null
dPersonAdCreated datetime, null
sPersonSID nvarchar(255), null
liPersonManagerPersonId int, null
sPersonPersonalNumber nvarchar(255), null
liPersonDelegatePersonId int, null
OutOfOfficeSince datetime, null Starting date and time of absence.
iPersonLocaleId int, null Language number. This is the Microsoft LocaleID. The list of these, for example, can be found here http://msdn.microsoft.com/en-us/goglobal/bb964664.aspx. The list of similar Locale ID can be found in the tLocale table
sPersonAdName nvarchar(255), null
liAccountId int, null
sFirstName nvarchar(255), null
sLastName nvarchar(255), null
sImportSystem nvarchar(255), null
sImportRecordId nvarchar(255), null
sAdDisplayName nvarchar(255), null
TimeZone nvarchar(64), null
Email2 nvarchar(255), null
Phone2 nvarchar(255), null
PersonPortrait varbinary, null
PersonPortraitHash varchar, null
PersonBehaviorId int, not null For user type, see the PersonBehavior table.
WebAppLoginGUID uniqueidentifier, null GUID for signing into WA from a console.
OutOfOfficeUntil datetime, null Ending date and time of absence.
IsOutOfOffice bit, not null Identifier specifying whether the user is absent. Automatically calculated column.
ImportAdLastFound datetime, null Date and time when the user was last found during AD import.

dbo.tPersonCust

Persons in the ALVAO system - own items.

Column Type Description
liPersonId int, null

dbo.tPersonRights

Permission that people and groups have for records on the activities of other people and groups within the ALVAO User Activity Monitoring module.

Column Type Description
iPersonRightsId int, not null
liPersonRightsSubjectPersonId int, null
liPersonRightsSubjectRoleId int, null
liPersonRightsPersonId int, null
liPersonRightsRoleId int, null
bPersonRightsRead bit, null

dbo.tPreComputedDay

Daily user activity record summary.

Column Type Description
iPreComputedDayId int, not null
dPreComputedDay datetime, null
nPreComputedDaySecondsElapsed float, null
nPreComputedDayUserInactiveSeconds float, null
nPreComputedDayCpuOverloadSeconds float, null
nPreComputedDayMemoryOverloadSeconds float, null
nPreComputedDayAverageCpuUsage float, null
nPreComputedDayAverageMemoryUsage float, null
liPreComputedDayComputerId int, null
liPreComputedDayPersonId int, null
iPrivateMode int, not null
Web nvarchar(100), null
ProductId int, null

dbo.tProperty

ALVAO system settings.

Column Type Description
sProperty nvarchar(255), not null Name of settings.
sPropertyValue nvarchar(2048), null Text value
bPropertyValue bit, null Truth value.
iPropertyValue int, null Integer value.
nPropertyValue float, null Real value
dPropertyValue datetime, null Time value
id int, not null Record ID

dbo.TransferConfirmAlert

Sent alerts to sign the handover protocols.

Column Type Description
id int, not null Record ID.
DocumentId int, not null Document ID.
RuleId int, not null Kind of alert.
SentDate datetime, not null Date of sending the alert.

dbo.TransferConfirmAlertConfig

Setting time of sending an alert and the period of the last alert repetition.

Column Type Description
SendTimeHour float, not null Alert send time.
RepeatTeamAlertAfterDays int, null Repetition period of the last alert.

dbo.TransferConfirmAlertRule

Settings of rules for sending alerts of not yet signed handover protocols.

Column Type Description
id int, not null Rule ID.
Active bit, not null A flag indicating whether or not the alert is active.
AlertAfterDays int, null Send an alert after a specified number of days.
AlertRoleId int, null The group to which the last alert is sent.

dbo.TransferConfirmType

Method of the assets takeover signing.

Column Type Description
id int, not null Item ID.
Name nvarchar(32), not null Name.

dbo.tRole

Groups of persons for the entire ALVAO.

Column Type Description
iRoleId int, not null Record ID.
sRole nvarchar(255), null Group name.
sRoleAdGuid nvarchar(255), null GUID in Active Directory
bRoleEveryone bit, not null Only one group "all", which has a value of 1, exists in ALVAO.
dRoleCreated datetime, null Time at which the group was created.
sDesc nvarchar(255), null
RoleBehaviorId int, not null

dbo.tRolePerson

Persons' membership in groups.

Column Type Description
iRolePersonId int, not null Record ID.
liRolePersonRoleId int, not null Link to group.
liRolePersonPersonId int, not null Link to user within group.
liRolePersonIncludedRoleId int, null ID of the group from which the membership is promoted. NULL if the user has direct group membership.

dbo.tRoleRole

Groups' membership in groups.

Column Type Description
iRoleRoleId int, not null Record ID.
liRoleRoleRoleId int, not null Link to group owners.
liRoleRoleMemberRoleId int, not null Link to owned group.

dbo.tRoom

Rooms, see item Request.Room.

Column Type Description
iRoomId int, not null
sRoom nvarchar(255), null
sRoomKind nvarchar(255), null
sRoomFloor nvarchar(255), null
liRoomBuildingId int, null

dbo.tSla

SLA.

Column Type Description
iSlaId int, not null
sSla nvarchar(255), null
mSlaDesc nvarchar(max), null
nSlaDeadlineHours float, null
dSlaRemoved datetime, null
nSlaReactionHours float, null
sSlaContract nvarchar(255), null
mSlaNotes nvarchar(max), null
nSlaQuality float, null
liOpeningHoursId int, null
Pause bit, not null

dbo.tSlaAlert

Request log records for notification sent for an unresolved issue or upcoming deadline.

Column Type Description
id int, not null
liHdTicketId int, not null
liSlaAlertRuleId int, null
dHdTicketDeadline datetime, null
dSent datetime, not null
sTo nvarchar(1024), not null
sError nvarchar(max), null
InternalTargetDeadline datetime, null Internal target date.

dbo.tSlaAlertRule

Rule for sending notifications for unresolved issues or an upcoming deadline.

Column Type Description
id int, not null
liSlaId int, not null
liToRoleStringId int, not null
liInactiveRoleStringId int, null
fInactiveHours float, null
fDeadlineExpireHours float, null
fRepeatEveryHours float, null
fSummarySendHour float, null
dSummaryLastSent datetime, null
InternalTargetExpireHours float, null Number of hours until the expiry of the internal target date.

dbo.tSlaCust

SLA custom items values.

Column Type Description
liSlaId int, null

dbo.tSlaRights

Assigning SLA to individuals and groups.

Column Type Description
iSlaRightsId int, not null
liSlaRightsSlaId int, not null
liSlaRightsRoleId int, null
liSlaRightsPersonId int, null
bSlaRightsAccess bit, null
bSlaRightsDefault bit, null
liHdSectionId int, not null

dbo.tSmtp

Configuration of the SMTP server for ALVAO.

Column Type Description
sSmtpAddress nvarchar(255), null SMTP server address.
nSmtpPort int, null SMTP Server port.
sSmtpLogin nvarchar(255), null Username for SMTP server access.
sSmtpPswd nvarchar(255), null Password for SMTP server access.
bSmtpSsl bit, not null 1, should SSL be used for connecting to the SMTP server.
bWindowsAuth bit, not null

dbo.tString

System code list for texts.

Column Type Description
iStringId int, not null
mString nvarchar(max), null

dbo.tSwLibAddUnknown

Sending unrecognized records, request for adding product to the standard software products library.

Column Type Description
iSwLibAddUnknownId int, not null
dCreated datetime, not null
liCreatedPersonId int, not null
mEntries nvarchar(max), null
sAttachmentName nvarchar(255), null
oAttachment image, null
sCollector nvarchar(255), null
dNextTry datetime, null
sEmail nvarchar(255), null
bInform bit, not null
liProductId int, null
iRequestUID int, null
iNewProductUID int, null
IsFromMonitoring bit, not null

dbo.tSwPresence

Software profiles - product statuses.

Column Type Description
iSwPresenceId int, not null
sSwPresence nvarchar(255), not null

dbo.tSwProfile

Software profiles - list.

Column Type Description
iSwProfileId int, not null
sSwProfile nvarchar(255), null
bMemberSwProfile bit, not null
mDescription nvarchar(max), null
mNotes nvarchar(max), null

dbo.tSwProfileProduct

Software profiles - membership of products in profiles.

Column Type Description
liSwProfileId int, not null
liProductId int, not null
liSwPresenceId int, not null
liMemberSwProfileId int, null

dbo.tSwProfileSwProfile

Software profiles - sub-profiles.

Column Type Description
liSwProfileId int, not null
liMemberSwProfileId int, not null

dbo.tTimeOff

Employee absence records.

Column Type Description
iTimeOffId int, not null
liPersonId int, not null
liTimeOffKindId int, not null
dTimeOff datetime, not null
bHalf bit, not null
mNotes nvarchar(max), null
dCreated datetime, not null
liCreatedPersonId int, null
dModified datetime, not null
liModifiedPersonId int, null

dbo.tTimeOffKind

Types of employee absence records.

Column Type Description
iTimeOffKindId int, not null
sTimeOffKind nvarchar(255), not null

dbo.tUnassignedProcess

Processes which the ALVAO User Security Monitoring module was not able to assign to applications according to the Software Products Library.

Column Type Description
nDurationDays float, null
UniqueFileId int, not null
LastWeekDurationDays float, null

dbo.tUserLogin

User sign in or out to/from the computer.

Column Type Description
iUserLoginId int, not null
dUserLoginSessionStart datetime, null
dUserLoginSessionStop datetime, null
liUserLoginPersonId int, null
liUserLoginComputerId int, null
SessionStartUtc datetime, null

dbo.tWeekOpeningHours

Item in the definition of service working hours.

Column Type Description
iWeekOpeningHoursId int, not null
liOpeningHoursId int, not null
nOpeningHour float, not null
nClosingHour float, not null
bSunday bit, not null
bMonday bit, not null
bTuesday bit, not null
bWednesday bit, not null
bThursday bit, not null
bFriday bit, not null
bSaturday bit, not null
dValidSince datetime, not null
dInvalidSince datetime, null

dbo.tWMIDefaultSetting

Default settings for using WMI technology in the ALVAO User Activity Monitoring module.

Column Type Description
bWMIDefaultSettingWMIEnabled bit, not null
sWMIDefaultSettingWMIUser nvarchar(255), null
bWMIDefaultSettingWMIIntegratedLogin bit, not null
sWMIDefaultSettingWMIAgentInstallRemotePath nvarchar(255), null
sWMIDefaultSettingWMIAgentInstallPackagePath nvarchar(255), null
iWMIDefaultSettingWMIMaxThreadCount int, null

dbo.tWorkLoad

Employee labor contracts.

Column Type Description
iWorkLoadId int, not null Record ID.
liPersonId int, not null ID of the person assigned this labor contract
dStart datetime, not null Labor contract start date (UTC)
dEnd datetime, null Labor contract end date + 1 (UTC). NULL represents a labor contract for an indefinite period.
iWorkHoursPerDay float, not null Number of work hours per day.

dbo.tWorkTime

Employee attendance record created in the ALVAO Attendance module.

Column Type Description
iWorkTimeId int, not null Record ID
liPersonId int, not null User ID
dStart datetime, not null Time at which the work started
dStop datetime, null Time at which work started/finished
mNotes nvarchar(max), null Note
dCreated datetime, not null Time at which the record for starting work was inserted
liCreatedPersonId int, null ID of the person that entered the record for starting work
dStopped datetime, null Time at which the record for finishing work was inserted
liStoppedPersonId int, null ID of the person that entered the record for completing work
dModified datetime, not null Time at which the record was last updated
liModifiedPersonId int, null ID of the last person to update the record

dbo.tWorkTimeSnapshot

Employee attendance records used by the ALVAO User Activity Monitoring module to hide records for extracurricular activities.

Column Type Description
id int, not null
liPersonId int, not null
dStart datetime, not null
dStop datetime, not null
iExtra1 int, null
sExtra2 nvarchar(100), null
sExtra3 nvarchar(100), null

dbo.UploadFileInfo

Information about the file uploaded via ServiceDesk WebService.

Column Type Description
id int, not null Record ID
FileName nvarchar(255), null Name of uploaded file
FileType nvarchar(255), null File type
UploadFileName nvarchar(255), not null Name of temporary file on server
UploadSessionId uniqueidentifier, null File transfer session ID
LastCall datetime, null date and time of last communication with server
LastPart int, null Sequence number of last uploaded file segments

dbo.UserLogonLog

Logging of the users logon/logout to/from Admin and Asset Management Console.

Column Type Description
Id int, not null Record ID.
TimeStamp datetime, not null Date and time of logon/logout.
ActionId int, not null Kind of action from UserLogonLogAction.
PersonLogin nvarchar(255), not null The username of the logged-in user.
Person nvarchar(255), null Logged-in user name.
Computer nvarchar(255), null Computer name.
IsAdmin bit, not null Identifier of whether or not the user was entitled to change the object security.
ApplicationId int, not null Application to which the user has logged in.

dbo.UserLogonLogAction

Executed action which is logged.

Column Type Description
Id int, not null Action ID.
Name nvarchar(50), not null Action name.

dbo.UserLogonLogApplication

Application name.

Column Type Description
Id int, not null Application ID.
Name nvarchar(50), not null Application name.

dbo.WebAppActiveSession

Active session at ALVAO WebApp.

Column Type Description
id int, not null Session ID.
PersonId int, not null Signed-in user ID.
ExpireDate datetime, not null Date and time of session expiration.
TicketGUID uniqueidentifier, not null Authentication ticket Id.

dbo.WorkOvertimeDisposal

Table with list of paid overtime hours

Column Type Description
id int, not null Record ID
PersonId int, not null ID of the person who received payment for overtime hours
Hours float, not null Number of paid overtime hours
Date datetime, not null Date of overtime hour payment
CreatedByPersonId int, not null ID of the person who paid for overtime hours
Notes nvarchar(max), null Notes
RemovedByPersonId int, null ID of the person that deleted the record
RemovedDate datetime, null Date on which the record was deleted.

Query.Computer

View with objects of the computer in Asset type which are not hidden or in Discarded assets. In addition to described columns, the table contains the value of 100 most widely used properties. The column name and the property name are always identical.

Column Type Description
NodeId int, not null Node ID of the computer in the tree.
ParentNodeId int, null Node ID of the parent's object in the tree.
UserNodeId int, null Node ID of the object owner's object in the tree. NULL, if the object is not in the tree under the Object of the User type.
NodeName nvarchar(255), null Computer object name.
NodePath nvarchar(1024), null Full object path in the tree.
Class int, null Kind of object (Computer/desktop, etc.).
RAMSizeGB bigint, null RAM size.
TotalHDDSizeGB float, null HDD size.
HDDCount int, null Number of HDDs.
TotalHDDFreeSpaceGB float, null Free space on the HDD.
CPUName nvarchar(255), null CPU name.
CPUCount int, null Number of CPUs.
CPUFreq int, null CPU frequency.
OS nvarchar(255), null OS name.
LastSWDetected datetime, null Date of the last SW detection.
LastHWDetected datetime, null Date of the last HW detection.
Manufacturer nvarchar(255), null
Serial number nvarchar(255), null
Name nvarchar(255), null
Model nvarchar(255), null
Note nvarchar(255), null
Warranty expiration datetime, null
Vendor nvarchar(255), null
Purchase date datetime, null
Packing slip number nvarchar(255), null
Inventory number nvarchar(255), null
Price nvarchar(255), null
IP address nvarchar(255), null
Hostname nvarchar(255), null
Size nvarchar(255), null
Quantity nvarchar(255), null
Disk interface nvarchar(255), null
Cost center nvarchar(255), null
MAC address nvarchar(255), null
Last imported from AD datetime, null
Version nvarchar(255), null
Refresh maximum nvarchar(255), null
Frequency nvarchar(255), null
Type nvarchar(255), null
Diagonal nvarchar(255), null
BIOS serial number nvarchar(255), null
Maximum vertical resolution nvarchar(255), null
Maximum horizontal resolution nvarchar(255), null
RAM size nvarchar(255), null
Maximum size nvarchar(255), null
Occupied sockets nvarchar(255), null
Sockets nvarchar(255), null
Part of the domain nvarchar(255), null
Last logged-on user (user name) nvarchar(255), null
Person responsible for software nvarchar(255), null
Number of logical CPU cores nvarchar(255), null
Case kind nvarchar(255), null
Monitor type nvarchar(255), null
Screen resolution nvarchar(255), null
Organization name nvarchar(255), null
__order nvarchar(255), null
User nvarchar(255), null
Network branch name nvarchar(255), null
Site name nvarchar(255), null
Organization code nvarchar(255), null
Address nvarchar(255), null
Department nvarchar(255), null
Room nvarchar(255), null
Floor nvarchar(255), null
Building nvarchar(255), null
E-mail nvarchar(255), null
Fax nvarchar(255), null
Phone nvarchar(255), null
Description nvarchar(255), null
Segment nvarchar(255), null
Subnet name nvarchar(255), null
Division nvarchar(255), null
Site nvarchar(255), null
Subdivision nvarchar(255), null
IMEI nvarchar(255), null
Data recording medium nvarchar(255), null
Center nvarchar(255), null
IP phone nvarchar(255), null
Pager nvarchar(255), null
Home phone nvarchar(255), null
ZIP code nvarchar(255), null
State or Province nvarchar(255), null
PO Box nvarchar(255), null
Company nvarchar(255), null
Country nvarchar(255), null
Street nvarchar(255), null
City nvarchar(255), null
Position nvarchar(255), null
Mobile phone nvarchar(255), null
Subsidiary nvarchar(255), null
Section nvarchar(255), null
Ethernet 100 Mbit nvarchar(255), null
Ethernet 10 Mbit nvarchar(255), null
DVD write speed nvarchar(255), null
CD write speed nvarchar(255), null
DVD read speed nvarchar(255), null
CD read speed nvarchar(255), null
Computer kind nvarchar(255), null
Facility nvarchar(255), null
Office nvarchar(255), null
Personal number nvarchar(255), null
IRQ nvarchar(255), null
IPX address nvarchar(255), null
DHCP Server nvarchar(255), null
DNS domain nvarchar(255), null
Unit nvarchar(255), null
Contact person nvarchar(255), null
Username nvarchar(255), null
Free space nvarchar(255), null
Picture height nvarchar(255), null
Picture width nvarchar(255), null
Video mode nvarchar(255), null
Maximum frequency nvarchar(255), null
Logical device nvarchar(255), null
File system nvarchar(255), null
Country code nvarchar(255), null

dbo.Log

"Log" in AM.

Column Type Description
Time datetime, null
Author nvarchar(255), null
Node Id int, null
Description nvarchar(max), null
Log Kind Id int, null
History Argument Node Id int, null
History Argument Node Name nvarchar(255), null
History Operation nvarchar(255), null
Notice Subject nvarchar(255), null
Notice nvarchar(max), null
Document Id nvarchar(255), null
Document Id2 nvarchar(255), null
Document Kind Id int, null
Document Link int, null
Document Memo nvarchar(max), null
Document Reseller nvarchar(255), null
Document Source Node Id int, null
Document Destination Node Id int, null
Sw Installed datetime, null
Sw Detected datetime, null
Sw Uninstalled datetime, null
Sw Removal Detected datetime, null
Sw Product nvarchar(1023), null
Sw Detected Product Name nvarchar(255), null
Sw Detected Product Version nvarchar(255), null
Sw Detected Product Id nvarchar(255), null
Sw Detected CD Key nvarchar(255), null
Sw Memo nvarchar(max), null
Ticket Id int, null
Ticket Tag nvarchar(255), null
Ticket nvarchar(1024), null
Ticket Service nvarchar(255), null
Ticket Status nvarchar(255), null
Ticket Sla nvarchar(255), null
Lend Asset Id nvarchar(255), null
Lend Media Type nvarchar(255), null
Lend Media Title nvarchar(255), null
Lend Media Location nvarchar(255), null
Borrower nvarchar(255), null
Lended datetime, null
Returned datetime, null

dbo.Node

"Objects" in AM.

Column Type Description
Node Id int, not null

Query.Node

View with all objects in Asset which are not hidden or in Discarded assets. In addition to described columns, the table contains the value of 100 most widely used properties. The column name and the property name are always identical.

Column Type Description
NodeId int, not null Node ID of the object in the tree.
ParentNodeId int, null Node ID of the parent's object in the tree.
UserNodeId int, null Node ID of the object owner's object in the tree. NULL, if the computer is not in the tree under the Object of the User type.
Class nvarchar(255), null Object kind name.
NodeName nvarchar(255), null Object name.
NodePath nvarchar(1024), null Full object path in the tree.
Manufacturer nvarchar(255), null
Serial number nvarchar(255), null
Name nvarchar(255), null
Model nvarchar(255), null
Note nvarchar(255), null
Warranty expiration datetime, null
Vendor nvarchar(255), null
Purchase date datetime, null
Packing slip number nvarchar(255), null
Inventory number nvarchar(255), null
Price nvarchar(255), null
IP address nvarchar(255), null
Hostname nvarchar(255), null
Size nvarchar(255), null
Quantity nvarchar(255), null
Disk interface nvarchar(255), null
Cost center nvarchar(255), null
MAC address nvarchar(255), null
Last imported from AD datetime, null
Version nvarchar(255), null
Refresh maximum nvarchar(255), null
Frequency nvarchar(255), null
Type nvarchar(255), null
Diagonal nvarchar(255), null
BIOS serial number nvarchar(255), null
Maximum vertical resolution nvarchar(255), null
Maximum horizontal resolution nvarchar(255), null
RAM size nvarchar(255), null
Maximum size nvarchar(255), null
Occupied sockets nvarchar(255), null
Sockets nvarchar(255), null
Part of the domain nvarchar(255), null
Last logged-on user (user name) nvarchar(255), null
Person responsible for software nvarchar(255), null
Number of logical CPU cores nvarchar(255), null
Case kind nvarchar(255), null
Monitor type nvarchar(255), null
Screen resolution nvarchar(255), null
Organization name nvarchar(255), null
__order nvarchar(255), null
User nvarchar(255), null
Network branch name nvarchar(255), null
Site name nvarchar(255), null
Organization code nvarchar(255), null
Address nvarchar(255), null
Department nvarchar(255), null
Room nvarchar(255), null
Floor nvarchar(255), null
Building nvarchar(255), null
E-mail nvarchar(255), null
Fax nvarchar(255), null
Phone nvarchar(255), null
Description nvarchar(255), null
Segment nvarchar(255), null
Subnet name nvarchar(255), null
Division nvarchar(255), null
Site nvarchar(255), null
Subdivision nvarchar(255), null
IMEI nvarchar(255), null
Data recording medium nvarchar(255), null
Center nvarchar(255), null
IP phone nvarchar(255), null
Pager nvarchar(255), null
Home phone nvarchar(255), null
ZIP code nvarchar(255), null
State or Province nvarchar(255), null
PO Box nvarchar(255), null
Company nvarchar(255), null
Country nvarchar(255), null
Street nvarchar(255), null
City nvarchar(255), null
Position nvarchar(255), null
Mobile phone nvarchar(255), null
Subsidiary nvarchar(255), null
Section nvarchar(255), null
Ethernet 100 Mbit nvarchar(255), null
Ethernet 10 Mbit nvarchar(255), null
DVD write speed nvarchar(255), null
CD write speed nvarchar(255), null
DVD read speed nvarchar(255), null
CD read speed nvarchar(255), null
Computer kind nvarchar(255), null
Facility nvarchar(255), null
Office nvarchar(255), null
Personal number nvarchar(255), null
IRQ nvarchar(255), null
IPX address nvarchar(255), null
DHCP Server nvarchar(255), null
DNS domain nvarchar(255), null
Unit nvarchar(255), null
Contact person nvarchar(255), null
Username nvarchar(255), null
Free space nvarchar(255), null
Picture height nvarchar(255), null
Picture width nvarchar(255), null
Video mode nvarchar(255), null
Maximum frequency nvarchar(255), null
Logical device nvarchar(255), null
File system nvarchar(255), null
Country code nvarchar(255), null

Query.NodeDiary

View with the log for objects.

Column Type Description
NodeId int, null Node ID of the object in the tree.
Subject nvarchar(max), null The text of the object log item title.
Date datetime, null Date of the record insert.
Flag int, null As far as the object history record is concerned, it contains the value determining the even kind. For more information, please refer to tblHistory.
Text nvarchar(max), null The text of the object log item.
Type int, not null 0=object history, 1=object note.

Query.NodeParent

View with all objects in Asset and their child objects (including indirect links - deep immersion).

Column Type Description
ChildNodeId int, not null Node ID of the object in the tree.
ParentNodeId int, not null Node ID of the parent object in the tree.

Query.NodeRightLog

View of the list of changes in permissions in the objects tree.

Column Type Description
TimeStamp datetime, not null Date and time of the change execution.
ModifiedBy nvarchar(255), not null Logged-in user name.
User nvarchar(255), null User name.
Group nvarchar(255), null Group name.
Object nvarchar(255), not null Object name.
ObjectOld nvarchar(255), null Object name - the previous value.
Recursive bit, not null Check box inclusive of child objects.
RecursiveOld bit, null Check box inclusive of child objects - the previous value.
Class nvarchar(255), null Object kind name.
ClassOld nvarchar(255), null Object kind name - the previous value.
Read bit, null Permission to read.
ReadOld bit, null Permission to read - the previous value.
Write bit, null Permission to edit.
WriteOld bit, null Permission to edit - the previous value.
Move bit, null Permission to move.
MoveOld bit, null Permission to move - the previous value.
Create bit, null Permission to create any objects.
CreateOld bit, null Permission to create any objects - the previous value.
Delete bit, null Permission to delete.
DeleteOld bit, null Permission to delete - the previous value.

Query.RequestContinualResponseCsy

Continuous informing of the requester by the solver team in requests within the ALVAO Service Desk. Continuous informing is a message sent from the vendors to the customer during the solution of their request; such messages are not reactions to a previous message from the customer. This view is used to create reports and analyses.

Column Type Description
Číslo požadavku int, not null The request identification number.
Název požadavku nvarchar(1024), null
Služba nvarchar(255), null Name of the service including the path in the tree.
SLA nvarchar(255), null SLA name.
Žadatel nvarchar(255), null First and last name of the requester.
Organizace (žadatel) nvarchar(255), null Name of the requester’s organization.
Kategorie nvarchar(255), null
Řešitel nvarchar(255), null Name and surname of the solver.
Termín (UTC) datetime, null
Interní cíl nvarchar(255), null Internal target name.
Interní cíl (termín) (UTC) datetime, null
Datum (UTC) datetime, null Date of message sending.
Týden od (UTC) datetime, null Date of the beginning of the week in which the message was sent.
Měsíc od (UTC) datetime, null Date of the beginning of the month in which the message was sent.
Rok (UTC) int, null year in which the message was sent.
Čtvrtletí (UTC) int, null Quarter in which the message was sent (1-4).
Měsíc (UTC) int, null Month in which the message was sent (1-12).
Týden (UTC) int, null Week in which the message was sent (1-53).
Hodina (UTC) int, null Hour in which the message was sent (0-23).
Značka a název požadavku nvarchar(1280), null Tag and name of the request, e.g., „T123456COMPANY Request for a new printer“.
Nejvyšší požadavek int, null Identification number of the root parent request.
Nejvyšší služba nvarchar(255), null Name of root service in the service tree.
Informoval nvarchar(255), null Name and surname of the solver who sent the message.
Doba (hodiny) float, not null Time elapsed from the sending of the previous message from the supplier to the sending of this message, in hours.
Související organizace nvarchar(255), not null Name of the organization for which the request is being implemented.
Proces nvarchar(30), null Process name.

Query.RequestContinualResponseEnu

Continuous informing of the requester by the solver team in requests within the ALVAO Service Desk. Continuous informing is a message sent from the vendors to the customer during the solution of their request; such messages are not reactions to a previous message from the customer. This view is used to create reports and analyses.

Column Type Description
Request number int, not null The request identification number.
Request name nvarchar(1024), null
Service nvarchar(255), null Name of the service including the path in the tree.
SLA nvarchar(255), null SLA name.
Requester nvarchar(255), null First and last name of the requester.
Organization (requester) nvarchar(255), null Name of the requester’s organization.
Category nvarchar(255), null
Solver nvarchar(255), null Name and surname of the solver.
Due date (UTC) datetime, null
Internal target nvarchar(255), null Internal target name.
Internal target (due date) (UTC) datetime, null
Date (UTC) datetime, null Date of message sending.
Week starting (UTC) datetime, null Date of the beginning of the week in which the message was sent.
Month starting (UTC) datetime, null Date of the beginning of the month in which the message was sent.
Year (UTC) int, null year in which the message was sent.
Quarter (UTC) int, null Quarter in which the message was sent (1-4).
Month (UTC) int, null Month in which the message was sent (1-12).
Week (UTC) int, null Week in which the message was sent (1-53).
Hour (UTC) int, null Hour in which the message was sent (0-23).
Request tag and title nvarchar(1280), null Tag and name of the request, e.g., „T123456COMPANY Request for a new printer“.
Highest request int, null Identification number of the root parent request.
Highest service nvarchar(255), null Name of root service in the service tree.
Informed by nvarchar(255), null Name and surname of the solver who sent the message.
Time (hours) float, not null Time elapsed from the sending of the previous message from the supplier to the sending of this message, in hours.
Related organization nvarchar(255), not null Name of the organization for which the request is being implemented.
Process nvarchar(30), null Process name.

Query.RequestCsy

Requests in ALVAO Service Desk. This view is used to create reports and analyses.

Column Type Description
Číslo požadavku int, not null The request identification number.
Nejvyšší požadavek int, null Identification number of the root parent request.
Nejvyšší služba nvarchar(255), null Name of root service in the service tree.
Žadatel nvarchar(255), null First and last name of the requester.
Organizace (žadatel) nvarchar(255), null Name of the requester’s organization.
Služba nvarchar(255), null Name of the service including the path in the tree.
Skupina nvarchar(255), null
Název požadavku nvarchar(1024), null
Řešitel nvarchar(255), null Name and surname of the solver.
Oddělení (řešitel) nvarchar(255), null Name of the solver’s department.
Oddělení (žadatel) nvarchar(255), null Name of the requester’s department
Funkce (řešitel) nvarchar(255), null Name of the solver’s job title.
Funkce (žadatel) nvarchar(255), null Name of the requester’s job title.
Kategorie nvarchar(255), null
Termín (UTC) datetime, null
Interní cíl nvarchar(255), null Internal target name.
Interní cíl (termín) (UTC) datetime, null
Priorita nvarchar(max), null Priority name.
Proces nvarchar(30), null Process name.
SLA nvarchar(255), null SLA name.
Stav nvarchar(255), null Request status name.
Značka a název požadavku nvarchar(1280), null Tag and name of the request, e.g., „T123456COMPANY Request for a new printer“.
Způsob podání nvarchar(255), null Request submission method, e.g., e-mail, phone, form.
Datum (UTC) datetime, null Date of request creation.
Týden od (UTC) datetime, null Date of the beginning of the week in which the request was created.
Měsíc od (UTC) datetime, null Date of the beginning of the month in which the request was created.
Rok (UTC) int, null Year of request creation.
Čtvrtletí (UTC) int, null Quarter in which the request was created (1-4).
Měsíc (UTC) int, null Month in which the request was created (1-12).
Týden (UTC) int, null Week of request creation (1-53).
Den v týdnu (UTC) int, null Day of the week of request creation (1-7).
Hodina (UTC) int, null Hour in which the request was created (0-23).
Hrubý stav nvarchar(10), not null Name of general status (Open, Resolved, Closed, Deleted)
Související organizace nvarchar(255), not null Name of the organization for which the request is being implemented.

Query.RequestEnu

Requests in ALVAO Service Desk. This view is used to create reports and analyses.

Column Type Description
Request number int, not null The request identification number.
Highest request int, null Identification number of the root parent request.
Highest service nvarchar(255), null Name of root service in the service tree.
Requester nvarchar(255), null First and last name of the requester.
Organization (requester) nvarchar(255), null Name of the requester’s organization.
Service nvarchar(255), null Name of the service including the path in the tree.
Group nvarchar(255), null
Request name nvarchar(1024), null
Solver nvarchar(255), null Name and surname of the solver.
Department (solver) nvarchar(255), null Name of the solver’s department.
Department (requester) nvarchar(255), null Name of the requester’s department
Position (solver) nvarchar(255), null
Position (requester) nvarchar(255), null
Category nvarchar(255), null
Due date (UTC) datetime, null
Internal target nvarchar(255), null Internal target name.
Internal target (due date) (UTC) datetime, null
Priority nvarchar(max), null Priority name.
Process nvarchar(30), null Process name.
SLA nvarchar(255), null SLA name.
Status nvarchar(255), null Request status name.
Request tag and title nvarchar(1280), null Tag and name of the request, e.g., „T123456COMPANY Request for a new printer“.
Submission method nvarchar(255), null Request submission method, e.g., e-mail, phone, form.
Date (UTC) datetime, null Date of request creation.
Week starting (UTC) datetime, null Date of the beginning of the week in which the request was created.
Month starting (UTC) datetime, null Date of the beginning of the month in which the request was created.
Year (UTC) int, null Year of request creation.
Quarter (UTC) int, null Quarter in which the request was created (1-4).
Month (UTC) int, null Month in which the request was created (1-12).
Week (UTC) int, null Week of request creation (1-53).
Weekday (UTC) int, null Day of the week of request creation (1-7).
Hour (UTC) int, null Hour in which the request was created (0-23).
Overall status nvarchar(8), not null Name of general status (Open, Resolved, Closed, Deleted)
Related organization nvarchar(255), not null Name of the organization for which the request is being implemented.

Query.RequestFirstReactionCsy

First reaction of the solver team in requests within the ALVAO Service Desk. The first reaction is the first message which the service vendor gave to the customer from receipt of their request. This view is used to create reports and analyses.

Column Type Description
Číslo požadavku int, not null The request identification number.
Nejvyšší požadavek int, null Identification number of the root linked parent request.
Název požadavku nvarchar(1024), null
Značka a název požadavku nvarchar(1280), null Tag and name of the request, e.g., „T123456COMPANY Request for a new printer“.
Služba nvarchar(255), null Name of the service including the path in the tree.
Nejvyšší služba nvarchar(255), null Name of root service in the service tree.
SLA nvarchar(255), null SLA name.
Žadatel nvarchar(255), null First and last name of the requester.
Organizace (žadatel) nvarchar(255), null Name of the requester’s organization.
Kategorie nvarchar(255), null
Datum (UTC) datetime, null Date of first reaction.
Týden od (UTC) datetime, null Date of the beginning of the week of the first reaction.
Měsíc od (UTC) datetime, null Date of the beginning of the month of the first reaction.
Rok (UTC) int, null Year of the first reaction.
Čtvrtletí (UTC) int, null Quarter of the first reaction.
Měsíc (UTC) int, null Month of the first reaction.
Týden (UTC) int, null Week of the first reaction.
Hodina (UTC) int, null Hour of the first reaction.
Termín (UTC) datetime, null
Interní cíl nvarchar(255), null Internal target name.
Interní cíl (termín) (UTC) datetime, null
Doba do reakce (hodiny) float, not null Hours until first reaction.
Překročení SLA (hodiny) float, null By how many hours was the SLA first reaction deadline exceeded.
Splnění SLA (hodiny) float, null How many hours earlier was the first reaction met than as required by the SLA limit.
Řešitel nvarchar(255), null Name and surname of the current solver.
Reagoval nvarchar(255), null Name and surname of the solver who completed the first reaction.
Reagoval (oddělení) nvarchar(255), null Name of the department of the solver who completed the first reaction.
Reagoval (funkce) nvarchar(255), null Name of the job title of the solver who completed the first reaction.
Reagoval (organizace) nvarchar(255), null Name of the organization of the solver who completed the first reaction.
Související organizace nvarchar(255), not null Name of the organization for which the request is being implemented.
Proces nvarchar(30), null Process name.

Query.RequestFirstReactionEnu

First reaction of the solver team in requests within the ALVAO Service Desk. The first reaction is the first message which the service vendor gave to the customer from receipt of their request. This view is used to create reports and analyses.

Column Type Description
Request number int, not null The request identification number.
Highest request int, null Identification number of the root linked parent request.
Request name nvarchar(1024), null
Request tag and title nvarchar(1280), null Tag and name of the request, e.g., „T123456COMPANY Request for a new printer“.
Service nvarchar(255), null Name of the service including the path in the tree.
Highest service nvarchar(255), null Name of root service in the service tree.
SLA nvarchar(255), null SLA name.
Requester nvarchar(255), null First and last name of the requester.
Organization (requester) nvarchar(255), null Name of the requester’s organization.
Category nvarchar(255), null
Date (UTC) datetime, null Date of first reaction.
Week starting (UTC) datetime, null Date of the beginning of the week of the first reaction.
Month starting (UTC) datetime, null Date of the beginning of the month of the first reaction.
Year (UTC) int, null Year of the first reaction.
Quarter (UTC) int, null Quarter of the first reaction.
Month (UTC) int, null Month of the first reaction.
Week (UTC) int, null Week of the first reaction.
Hour (UTC) int, null Hour of the first reaction.
Due date (UTC) datetime, null
Internal target nvarchar(255), null Internal target name.
Internal target (due date) (UTC) datetime, null
Time until response (hours) float, not null Hours until first reaction.
SLA breached by (hours) float, null By how many hours was the SLA first reaction deadline exceeded.
Time until SLA breach (hours) float, null How many hours earlier was the first reaction met than as required by the SLA limit.
Solver nvarchar(255), null Name and surname of the current solver.
Responded nvarchar(255), null Name and surname of the solver who completed the first reaction.
Responded (department) nvarchar(255), null Name of the department of the solver who completed the first reaction.
Responded (position) nvarchar(255), null Name of the job title of the solver who completed the first reaction.
Responded (organization) nvarchar(255), null Name of the organization of the solver who completed the first reaction.
Related organization nvarchar(255), not null Name of the organization for which the request is being implemented.
Process nvarchar(30), null Process name.

Query.RequestLogCsy

Records in request logs in ALVAO Service Desk. This view is used to create reports and analyses.

Column Type Description
Číslo požadavku int, not null The request identification number.
Název požadavku nvarchar(1024), null
Služba nvarchar(255), null Name of the service including the path in the tree.
SLA nvarchar(255), null SLA name.
Kategorie nvarchar(255), null
Řešitel nvarchar(255), null Name and surname of the solver.
Datum (UTC) datetime, null Date of record creation.
Datum účinnosti (UTC) datetime, null In case of records of retrospective resolution of requests, this column specifies the date of retrospective resolution. For other records, the same value is listed as in the Date (UTC) column.
Týden od (UTC) datetime, null Date of the beginning of the week in which the record was created.
Měsíc od (UTC) datetime, null Date of the beginning of the month in which the record was created.
Rok (UTC) int, null Year of record creation.
Čtvrtletí (UTC) int, null Quarter in which the request was created (1-4).
Měsíc (UTC) int, null Month in which the record was created (1-12).
Týden (UTC) int, null Week of record creation (1-53).
Hodina (UTC) int, null Hour in which the record was created (0-23).
Od nvarchar(255), null Name and surname of the person who created the record.
Čas celkem (hodiny) float, not null Total recorded time (Work + Travel time), in hours.
Značka a název požadavku nvarchar(1280), null Tag and name of the request, e.g., „T123456COMPANY Request for a new printer“.
Žadatel nvarchar(255), null First and last name of the requester.
Oddělení (žadatel) nvarchar(255), null Name of the requester’s department.
Organizace (žadatel) nvarchar(255), null Name of the requester’s organization.
Pracovní pozice (žadatel) nvarchar(255), null Name of the requester’s job title.
Práce (hodiny) float, null Reported work in hours.
Čas na cestě (hodiny) float, null Reported time spent on trip in hours.
Vzdálenost (km) float, null Reported distance in km.
Druh nvarchar(255), null Type of record (e-mail, note, ...).
Druh objektu nvarchar(255), null Object kind in ALVAO Asset Management that the request is related to.
Název objektu nvarchar(255), null Object name in ALVAO Asset Management that the request is related to.
Nejvyšší požadavek int, null Identification number of the root parent request.
Nejvyšší služba nvarchar(255), null Name of root service in the service tree.
Nefakturovat bit, not null The “Exclude from invoice to the requester” flag.
Předmět nvarchar(max), null Subject of the record in the log.
Stav nvarchar(255), null Request status name.
Termín (UTC) datetime, null
Interní cíl nvarchar(255), null Internal target name.
Interní cíl (termín) (UTC) datetime, null
Související organizace nvarchar(255), not null Name of the organization for which the request is being implemented.
Proces nvarchar(30), null Process name.

Query.RequestLogEnu

Records in request logs in ALVAO Service Desk. This view is used to create reports and analyses.

Column Type Description
Request number int, not null The request identification number.
Request name nvarchar(1024), null
Service nvarchar(255), null Name of the service including the path in the tree.
SLA nvarchar(255), null SLA name.
Category nvarchar(255), null
Solver nvarchar(255), null Name and surname of the solver.
Date (UTC) datetime, null Date of record creation.
Effective date (UTC) datetime, null In case of records of retrospective resolution of requests, this column specifies the date of retrospective resolution. For other records, the same value is listed as in the Date (UTC) column.
Week starting (UTC) datetime, null Date of the beginning of the week in which the record was created.
Month starting (UTC) datetime, null Date of the beginning of the month in which the record was created.
Year (UTC) int, null Year of record creation.
Quarter (UTC) int, null Quarter in which the request was created (1-4).
Month (UTC) int, null Month in which the record was created (1-12).
Week (UTC) int, null Week of record creation (1-53).
Hour (UTC) int, null Hour in which the record was created (0-23).
From nvarchar(255), null Name and surname of the person who created the record.
Total time (hours) float, not null Total recorded time (Work + Travel time), in hours.
Request tag and title nvarchar(1280), null Tag and name of the request, e.g., „T123456COMPANY Request for a new printer“.
Requester nvarchar(255), null First and last name of the requester.
Department (requester) nvarchar(255), null Name of the requester’s department.
Organization (requester) nvarchar(255), null Name of the requester’s organization.
Job title (requestor) nvarchar(255), null Name of the requester’s job title.
Work (hours) float, null Reported work in hours.
Time traveled (hours) float, null Reported time spent on trip in hours.
Distance (km) float, null Reported distance in km.
Kind nvarchar(255), null Type of record (e-mail, note, ...).
Object kind nvarchar(255), null Object kind in ALVAO Asset Management that the request is related to.
Object name nvarchar(255), null Object name in ALVAO Asset Management that the request is related to.
Highest request int, null Identification number of the root parent request.
Highest service nvarchar(255), null Name of root service in the service tree.
Exclude from invoice bit, not null The “Exclude from invoice to the requester” flag.
Subject nvarchar(max), null Subject of the record in the log.
Status nvarchar(255), null Request status name.
Due date (UTC) datetime, null
Internal target nvarchar(255), null Internal target name.
Internal target (due date) (UTC) datetime, null
Related organization nvarchar(255), not null Name of the organization for which the request is being implemented.
Process nvarchar(30), null Process name.

Query.RequestOperationCsy

Basic operations (Created, Deleted, Resolved, Closed) with requests in Alvao Service Desk over time. This view is used to create reports and analyses.

Column Type Description
Číslo požadavku int, null The request identification number.
Nejvyšší požadavek int, null Identification number of the root linked parent request.
Žadatel nvarchar(255), null First and last name of the requester.
Organizace (žadatel) nvarchar(255), null Name of the requester’s organization.
Služba nvarchar(255), null Name of the service including the path in the tree.
Nejvyšší služba nvarchar(255), null Name of root service in the service tree.
Název požadavku nvarchar(1024), null
Řešitel nvarchar(255), null Name and surname of the solver.
Oddělení (řešitel) nvarchar(255), null Name of the solver’s department.
Oddělení (žadatel) nvarchar(255), null Name of the requester’s department.
Funkce (řešitel) nvarchar(255), null Name of the solver’s job title.
Funkce (žadatel) nvarchar(255), null Name of the requester’s job title.
Kategorie nvarchar(255), null
Skupina nvarchar(255), null
Termín (UTC) datetime, null
Interní cíl nvarchar(255), null Internal target name.
Interní cíl (termín) (UTC) datetime, null
Priorita nvarchar(max), null Priority name.
Značka a název požadavku nvarchar(1280), null Tag and name of the request, e.g., „T123456COMPANY Request for a new printer“.
SLA nvarchar(255), null SLA name.
Operace nvarchar(10), not null Performed operation (Created, Deleted, Resolved, Closed).
Změna počtu otevřených požadavků int, not null Change of the number of open requests after performing the operation (+1, -1)
Datum (UTC) datetime, null Date of operation.
Týden od (UTC) datetime, null Date of the beginning of the week of the operation.
Měsíc od (UTC) datetime, null Date of the beginning of the month of the operation.
Rok (UTC) int, null Year of the operation.
Čtvrtletí (UTC) int, null Quarter in which the operation was executed (1-4).
Měsíc (UTC) int, null Month in which the operation was executed (1-12).
Týden (UTC) int, null Week of the operation (1-53).
Hodina (UTC) int, null Hour in which the operation was executed (0-23).
Druh objektu nvarchar(255), null Object kind in ALVAO Asset Management that the request applies to.
Název objektu nvarchar(255), null Object name in ALVAO Asset Management that the request applies to.
Související organizace nvarchar(255), not null Name of the organization for which the request is being implemented.
Proces nvarchar(30), null Process name.

Query.RequestOperationEnu

Basic operations (Created, Deleted, Resolved, Closed) with requests in Alvao Service Desk over time. This view is used to create reports and analyses.

Column Type Description
Request number int, null The request identification number.
Highest request int, null Identification number of the root linked parent request.
Requester nvarchar(255), null First and last name of the requester.
Organization (requester) nvarchar(255), null Name of the requester’s organization.
Service nvarchar(255), null Name of the service including the path in the tree.
Highest service nvarchar(255), null Name of root service in the service tree.
Request name nvarchar(1024), null
Solver nvarchar(255), null Name and surname of the solver.
Department (solver) nvarchar(255), null Name of the solver’s department.
Department (requester) nvarchar(255), null Name of the requester’s department.
Job title (solver) nvarchar(255), null Name of the solver’s job title.
Job title (requester) nvarchar(255), null Name of the requester’s job title.
Category nvarchar(255), null
Group nvarchar(255), null
Due date (UTC) datetime, null
Internal target nvarchar(255), null Internal target name.
Internal target (due date) (UTC) datetime, null
Priority nvarchar(max), null Priority name.
Request tag and title nvarchar(1280), null Tag and name of the request, e.g., „T123456COMPANY Request for a new printer“.
SLA nvarchar(255), null SLA name.
Operation nvarchar(8), not null Performed operation (Created, Deleted, Resolved, Closed).
Change of the number of open requests int, not null Change of the number of open requests after performing the operation (+1, -1)
Date (UTC) datetime, null Date of operation.
Week starting (UTC) datetime, null Date of the beginning of the week of the operation.
Month starting (UTC) datetime, null Date of the beginning of the month of the operation.
Year (UTC) int, null Year of the operation.
Quarter (UTC) int, null Quarter in which the operation was executed (1-4).
Month (UTC) int, null Month in which the operation was executed (1-12).
Week (UTC) int, null Week of the operation (1-53).
Hour (UTC) int, null Hour in which the operation was executed (0-23).
Object kind nvarchar(255), null Object kind in ALVAO Asset Management that the request applies to.
Object name nvarchar(255), null Object name in ALVAO Asset Management that the request applies to.
Related organization nvarchar(255), not null Name of the organization for which the request is being implemented.
Process nvarchar(30), null Process name.

Query.RequestReopenCsy

Reopening of requests in ALVAO Service Desk. This view is used to create reports and analyses.

Column Type Description
Číslo požadavku int, not null The request identification number.
Název požadavku nvarchar(1024), null
Služba nvarchar(255), null Name of the service including the path in the tree.
SLA nvarchar(255), null SLA name.
Žadatel nvarchar(255), null First and last name of the requester.
Organizace (žadatel) nvarchar(255), null Name of the requester’s organization.
Kategorie nvarchar(255), null
Řešitel nvarchar(255), null Name and surname of the solver.
Vyřešil nvarchar(255), null Name and surname of the solver who resolved the request.
Termín (UTC) datetime, null
Interní cíl nvarchar(255), null Internal target name.
Interní cíl (termín) (UTC) datetime, null
Nejvyšší požadavek int, null Identification number of the root parent request.
Nejvyšší služba nvarchar(255), null Name of root service in the service tree.
Datum (UTC) datetime, null Date of request reopening.
Týden od (UTC) datetime, null Date of the beginning of the week in which the request was reopened.
Měsíc od (UTC) datetime, null Date of the beginning of the month in which the request was reopened.
Rok (UTC) int, null Year of request reopening.
Čtvrtletí (UTC) int, null Quarter in which the request was reopened (1-4).
Měsíc (UTC) int, null Month in which the request was reopened (1-12).
Týden (UTC) int, null Week of request reopening (1-53).
Hodina (UTC) int, null Hour in which the request was reopened (0-23).
Značka a název požadavku nvarchar(1280), null Tag and name of the request, e.g., „T123456COMPANY Request for a new printer“.
Vyřešeno (UTC) datetime, null Date and time of request solution.
Znovu otevřeno (UTC) datetime, null Date and time of request reopening.
Doba vyřešení (hodiny) float, not null Time elapsed in hours from the solution up to the reopening of the request.
Související organizace nvarchar(255), not null Name of the organization for which the request is being implemented.
Proces nvarchar(30), null Process name.

Query.RequestReopenEnu

Reopening of requests in ALVAO Service Desk. This view is used to create reports and analyses.

Column Type Description
Request number int, not null The request identification number.
Request name nvarchar(1024), null
Service nvarchar(255), null Name of the service including the path in the tree.
SLA nvarchar(255), null SLA name.
Requester nvarchar(255), null First and last name of the requester.
Organization (requester) nvarchar(255), null Name of the requester’s organization.
Category nvarchar(255), null
Solver nvarchar(255), null Name and surname of the solver.
Resolved by nvarchar(255), null Name and surname of the solver who resolved the request.
Due date (UTC) datetime, null
Internal target nvarchar(255), null Internal target name.
Internal target (due date) (UTC) datetime, null
Highest request int, null Identification number of the root parent request.
Highest service nvarchar(255), null Name of root service in the service tree.
Date (UTC) datetime, null Date of request reopening.
Week starting (UTC) datetime, null Date of the beginning of the week in which the request was reopened.
Month starting (UTC) datetime, null Date of the beginning of the month in which the request was reopened.
Year (UTC) int, null Year of request reopening.
Quarter (UTC) int, null Quarter in which the request was reopened (1-4).
Month (UTC) int, null Month in which the request was reopened (1-12).
Week (UTC) int, null Week of request reopening (1-53).
Hour (UTC) int, null Hour in which the request was reopened (0-23).
Request tag and title nvarchar(1280), null Tag and name of the request, e.g., „T123456COMPANY Request for a new printer“.
Resolved (UTC) datetime, null Date and time of request solution.
Reopened (UTC) datetime, null Date and time of request reopening.
Resolution time (hours) float, not null Time elapsed in hours from the solution up to the reopening of the request.
Related organization nvarchar(255), not null Name of the organization for which the request is being implemented.
Process nvarchar(30), null Process name.

Query.RequestResolutionCsy

Solution of requests in ALVAO Service Desk. This view is used to create reports and analyses.

Column Type Description
Číslo požadavku int, not null The request identification number.
Název požadavku nvarchar(1024), null
Služba nvarchar(255), null Name of the service including the path in the tree.
SLA nvarchar(255), null SLA name.
Žadatel nvarchar(255), null First and last name of the requester.
Organizace (žadatel) nvarchar(255), null Name of the requester’s organization.
Řešitel nvarchar(255), null Name and surname of the solver.
Kategorie nvarchar(255), null
Datum (UTC) datetime, null Date for request resolution.
Týden od (UTC) datetime, null Date of the beginning of the week in which the request was solved.
Měsíc od (UTC) datetime, null Date of the beginning of the month in which the request was solved.
Rok (UTC) int, null Year of request resolution.
Čtvrtletí (UTC) int, null Quarter in which the request was resolved (1-4).
Měsíc (UTC) int, null Month in which the request was resolved (1-12).
Týden (UTC) int, null Week of request resolution (1-53).
Den v týdnu (UTC) int, null Day of the week of request solution (1-7).
Hodina (UTC) int, null Hour in which the request was resolved(0-23).
Značka a název požadavku nvarchar(1280), null Tag and name of the request, e.g., „T123456COMPANY Request for a new printer“.
Nejvyšší požadavek int, null Identification number of the root parent request.
Nejvyšší služba nvarchar(255), null Name of root service in the service tree.
Čekáno na žadatele float, null Total waiting time for requesters during the whole solution of a request, in hours, during the operating hours of the service.
Doba do vyřešení (hodiny) float, not null Hours from the creation to the resolution of the request during the operating hours of the service.
Termín (UTC) datetime, null
Interní cíl nvarchar(255), null Internal target name.
Interní cíl (termín) (UTC) datetime, null
Překročení SLA (hodiny) float, null By how many hours was the deadline for solving the request as per SLA exceeded.
Splnění SLA (hodiny) float, null How many hours earlier the request was resolved than the SLA limit.
Překročení termínu (hodiny) float, null By how many hours was the deadline for resolution of the request exceeded (Request time/Due date item).
Splnění termínu (hodiny) float, null How many hours earlier the request was resolved than the value listed in the Request time/Due date item.
Související organizace nvarchar(255), not null Name of the organization for which the request is being implemented.
Proces nvarchar(30), null Process name.
Rychlost řešení float, null Satisfaction survey - Resolution speed field.
Profesionalita float, null Satisfaction survey - Professionalism field.
Odbornost float, null Satisfaction survey - Expertise field.
Komentáře a poznámky nvarchar(max), null Satisfaction survey - Comments and remarks field.
Celková spokojenost float, null Satisfaction survey - General satisfaction field.

Query.RequestResolutionEnu

Solution of requests in ALVAO Service Desk. This view is used to create reports and analyses.

Column Type Description
Request number int, not null The request identification number.
Request name nvarchar(1024), null
Service nvarchar(255), null Name of the service including the path in the tree.
SLA nvarchar(255), null SLA name.
Requester nvarchar(255), null First and last name of the requester.
Organization (requester) nvarchar(255), null Name of the requester’s organization.
Solver nvarchar(255), null Name and surname of the solver.
Category nvarchar(255), null
Date (UTC) datetime, null Date for request resolution.
Week starting (UTC) datetime, null Date of the beginning of the week in which the request was solved.
Month starting (UTC) datetime, null Date of the beginning of the month in which the request was solved.
Year (UTC) int, null Year of request resolution.
Quarter (UTC) int, null Quarter in which the request was resolved (1-4).
Month (UTC) int, null Month in which the request was resolved (1-12).
Week (UTC) int, null Week of request resolution (1-53).
Weekday (UTC) int, null Day of the week of request solution (1-7).
Hour (UTC) int, null Hour in which the request was resolved(0-23).
Request tag and title nvarchar(1280), null Tag and name of the request, e.g., „T123456COMPANY Request for a new printer“.
Highest request int, null Identification number of the root parent request.
Highest service nvarchar(255), null Name of root service in the service tree.
Waiting for requester float, null Total waiting time for requesters during the whole solution of a request, in hours, during the operating hours of the service.
Time to resolve (hours) float, not null Hours from the creation to the resolution of the request during the operating hours of the service.
Due date (UTC) datetime, null
Internal target nvarchar(255), null Internal target name.
Internal target (due date) (UTC) datetime, null
SLA breached by (hours) float, null By how many hours was the deadline for solving the request as per SLA exceeded.
Time until SLA breach (hours) float, null How many hours earlier the request was resolved than the SLA limit.
Exceeding of due date (hours) float, null By how many hours was the deadline for resolution of the request exceeded (Request time/Due date item).
Meeting of due date (hours) float, null How many hours earlier the request was resolved than the value listed in the Request time/Due date item.
Related organization nvarchar(255), not null Name of the organization for which the request is being implemented.
Process nvarchar(30), null Process name.
Resolution speed float, null Satisfaction survey - Resolution speed field.
Professionalism float, null Satisfaction survey - Professionalism field.
Expertise float, null Satisfaction survey - Expertise field.
Comments and notes nvarchar(max), null Satisfaction survey - Comments and remarks field.
Overall satisfaction float, null Satisfaction survey - General satisfaction field.

Query.RequestSubsequentResponseCsy

Follow-up reactions of the solver team in requests within the ALVAO Service Desk. The subsequent reaction is the first message from the vendor sent to the customer from the receipt of any message from the customer in the course of processing their request. This view is used to create reports and analyses.

Column Type Description
Číslo požadavku int, not null The request identification number.
Název požadavku nvarchar(1024), null
Služba nvarchar(255), null Name of the service including the path in the tree.
SLA nvarchar(255), null SLA name.
Žadatel nvarchar(255), null First and last name of the requester.
Organizace (žadatel) nvarchar(255), null Name of the requester’s organization.
Kategorie nvarchar(255), null
Řešitel nvarchar(255), null Name and surname of the solver.
Termín (UTC) datetime, null
Interní cíl nvarchar(255), null Internal target name.
Interní cíl (termín) (UTC) datetime, null
Datum (UTC) datetime, null Date of follow-up reaction.
Týden od (UTC) datetime, null Date of the beginning of the week of follow-up reaction.
Měsíc od (UTC) datetime, null Date of the beginning of the month of follow-up reaction.
Rok (UTC) int, null Year of follow-up reaction.
Čtvrtletí (UTC) int, null Quarter of reaction (1-4).
Měsíc (UTC) int, null Month of follow-up reaction (1-12).
Týden (UTC) int, null Week of follow-up reaction (1-53).
Hodina (UTC) int, null Hour of follow-up reaction (0-23).
Reagoval nvarchar(255), null Name and surname of the solver who sent the message.
Doba do reakce (hodiny) float, not null Hours until follow-up reaction.
Překročení SLA (hodiny) float, null By how many hours was the SLA time to first reaction deadline exceeded.
Splnění SLA (hodiny) float, null How many hours earlier was the reaction met than as required by the SLA limit.
Značka a název požadavku nvarchar(1280), null Tag and name of the request, e.g., „T123456COMPANY Request for a new printer“.
Související organizace nvarchar(255), not null Name of the organization for which the request is being implemented.
Nejvyšší požadavek int, null Identification number of the root parent request.
Nejvyšší služba nvarchar(255), null Name of root service in the tree.
Proces nvarchar(30), null Process name.

Query.RequestSubsequentResponseEnu

Follow-up reactions of the solver team in requests within the ALVAO Service Desk. The subsequent reaction is the first message from the vendor sent to the customer from the receipt of any message from the customer in the course of processing their request. This view is used to create reports and analyses.

Column Type Description
Request number int, not null The request identification number.
Request name nvarchar(1024), null
Service nvarchar(255), null Name of the service including the path in the tree.
SLA nvarchar(255), null SLA name.
Requester nvarchar(255), null First and last name of the requester.
Organization (requester) nvarchar(255), null Name of the requester’s organization.
Category nvarchar(255), null
Solver nvarchar(255), null Name and surname of the solver.
Due date (UTC) datetime, null
Internal target nvarchar(255), null Internal target name.
Internal target (due date) (UTC) datetime, null
Date (UTC) datetime, null Date of follow-up reaction.
Week starting (UTC) datetime, null Date of the beginning of the week of follow-up reaction.
Month starting (UTC) datetime, null Date of the beginning of the month of follow-up reaction.
Year (UTC) int, null Year of follow-up reaction.
Quarter (UTC) int, null Quarter of reaction (1-4).
Month (UTC) int, null Month of follow-up reaction (1-12).
Week (UTC) int, null Week of follow-up reaction (1-53).
Hour (UTC) int, null Hour of follow-up reaction (0-23).
Responded nvarchar(255), null Name and surname of the solver who sent the message.
Time until response (hours) float, not null Hours until follow-up reaction.
SLA breached by (hours) float, null By how many hours was the SLA time to first reaction deadline exceeded.
Time until SLA breach (hours) float, null How many hours earlier was the reaction met than as required by the SLA limit.
Request tag and title nvarchar(1280), null Tag and name of the request, e.g., „T123456COMPANY Request for a new printer“.
Related organization nvarchar(255), not null Name of the organization for which the request is being implemented.
Highest request int, null Identification number of the root parent request.
Highest service nvarchar(255), null Name of root service in the tree.
Process nvarchar(30), null Process name.

Query.RoleMembershipLog

View of the list of changes in permissions in the objects tree.

Column Type Description
TimeStamp datetime, not null Date and time of the change execution.
MemberType nvarchar(50), null User or group.
Member nvarchar(255), not null User name or group name.
Operation nvarchar(50), null Operation - added or removed.
Group nvarchar(255), not null Name of the group in which membership changed.
ModifiedBy nvarchar(255), not null The name of the user who did the change.

Query.Software

View with installed products (software) on not yet deleted computers.

Column Type Description
ComputerNodeId int, not null Node ID of the computer in the tree.
ParentNodeId int, null Node ID of the parent's object in the tree.
Product nvarchar(1023), null Product name.
Category int, null Product category (e.g. 1 - OS).
NeedsLicense int, not null 1=product requires license.
FirstInstallationDetected datetime, null Date of the installation first detection.
Installed datetime, null Date of installation.
LastDetectionDateTime datetime, null Date of the last detection.
LastDetectedProductVersion nvarchar(255), null Last detected version.
LastDetectedProductName nvarchar(255), null Last detected product name.
LicenseInventoryNumber nvarchar(255), null Inventory number for license.
LicenseActivationKey nvarchar(1024), null License activation number.
LicenseInvoiceNumber nvarchar(255), null License invoice number.
LicenseCertificateNumber nvarchar(255), null License certificate number.
Authorized int, not null The software installation on the computer is confirmed or a license has been assigned to that computer.
CDKey nvarchar(255), null CD key for the software product.
Description nvarchar(max), null Last note at an installation history record.
LicenceName nvarchar(255), null License name.
Publisher nvarchar(255), null Software manufacturer.
SoftwarePack int, not null The product is from the SW package.
Type int, not null Software product type. 1 - commercial 2 - freeware 3 - shareware/trial 4 - not specified
User int, null Author of the product installation.
Comment nvarchar(max), null Installation comment.

Query.User

View with all objects of the User in Asset type which are not hidden or in Discarded assets. In addition to described columns, the table contains the value of 100 most widely used properties. The column name and the property name are always identical.

Column Type Description
NodeId int, not null Node ID of the object in the tree.
ParentNodeId int, null Node ID of the parent's object in the tree.
NodeName nvarchar(255), null Object name.
NodePath nvarchar(1024), null Full object path in the tree.
Manufacturer nvarchar(255), null
Serial number nvarchar(255), null
Name nvarchar(255), null
Model nvarchar(255), null
Note nvarchar(255), null
Warranty expiration datetime, null
Vendor nvarchar(255), null
Purchase date datetime, null
Packing slip number nvarchar(255), null
Inventory number nvarchar(255), null
Price nvarchar(255), null
IP address nvarchar(255), null
Hostname nvarchar(255), null
Size nvarchar(255), null
Quantity nvarchar(255), null
Disk interface nvarchar(255), null
Cost center nvarchar(255), null
MAC address nvarchar(255), null
Last imported from AD datetime, null
Version nvarchar(255), null
Refresh maximum nvarchar(255), null
Frequency nvarchar(255), null
Type nvarchar(255), null
Diagonal nvarchar(255), null
BIOS serial number nvarchar(255), null
Maximum vertical resolution nvarchar(255), null
Maximum horizontal resolution nvarchar(255), null
RAM size nvarchar(255), null
Maximum size nvarchar(255), null
Occupied sockets nvarchar(255), null
Sockets nvarchar(255), null
Part of the domain nvarchar(255), null
Last logged-on user (user name) nvarchar(255), null
Person responsible for software nvarchar(255), null
Number of logical CPU cores nvarchar(255), null
Case kind nvarchar(255), null
Monitor type nvarchar(255), null
Screen resolution nvarchar(255), null
Organization name nvarchar(255), null
__order nvarchar(255), null
User nvarchar(255), null
Network branch name nvarchar(255), null
Site name nvarchar(255), null
Organization code nvarchar(255), null
Address nvarchar(255), null
Department nvarchar(255), null
Room nvarchar(255), null
Floor nvarchar(255), null
Building nvarchar(255), null
E-mail nvarchar(255), null
Fax nvarchar(255), null
Phone nvarchar(255), null
Description nvarchar(255), null
Segment nvarchar(255), null
Subnet name nvarchar(255), null
Division nvarchar(255), null
Site nvarchar(255), null
Subdivision nvarchar(255), null
IMEI nvarchar(255), null
Data recording medium nvarchar(255), null
Center nvarchar(255), null
IP phone nvarchar(255), null
Pager nvarchar(255), null
Home phone nvarchar(255), null
ZIP code nvarchar(255), null
State or Province nvarchar(255), null
PO Box nvarchar(255), null
Company nvarchar(255), null
Country nvarchar(255), null
Street nvarchar(255), null
City nvarchar(255), null
Position nvarchar(255), null
Mobile phone nvarchar(255), null
Subsidiary nvarchar(255), null
Section nvarchar(255), null
Ethernet 100 Mbit nvarchar(255), null
Ethernet 10 Mbit nvarchar(255), null
DVD write speed nvarchar(255), null
CD write speed nvarchar(255), null
DVD read speed nvarchar(255), null
CD read speed nvarchar(255), null
Computer kind nvarchar(255), null
Facility nvarchar(255), null
Office nvarchar(255), null
Personal number nvarchar(255), null
IRQ nvarchar(255), null
IPX address nvarchar(255), null
DHCP Server nvarchar(255), null
DNS domain nvarchar(255), null
Unit nvarchar(255), null
Contact person nvarchar(255), null
Username nvarchar(255), null
Free space nvarchar(255), null
Picture height nvarchar(255), null
Picture width nvarchar(255), null
Video mode nvarchar(255), null
Maximum frequency nvarchar(255), null
Logical device nvarchar(255), null
File system nvarchar(255), null
Country code nvarchar(255), null

Query.UserLogonLog

View of the list of changes in permissions in the objects tree.

Column Type Description
TimeStamp datetime, not null Date and time of the change execution.
Username nvarchar(255), not null The username of the user.
User nvarchar(255), null User name.
Action nvarchar(50), null Executed action - logon, logout.
Application nvarchar(50), null Name of the application in which he executed the action.
Computer nvarchar(255), null Name of the computer to which he logged in.
IsAdmin bit, not null Identifier of whether or not the user was logged in with the administrator permission.

dbo.vAct

Request log. The view collects data from various tables.

Column Type Description
iActId int, null
liActKindId int, null
dAct datetime, null
sAct nvarchar(max), null
mActNotice nvarchar(max), null
liActFromPersonId int, null
liActToPersonId int, null
liActHdTicketId int, null
sActFrom nvarchar(1024), null
sActFromEmail nvarchar(255), null
sActFromPhone nvarchar(255), null
mActFromContact nvarchar(max), null
sActFromMobile nvarchar(255), null
sActFromOffice nvarchar(255), null
sActFromDepartment nvarchar(255), null
sActFromWorkPosition nvarchar(255), null
sActFromCompany nvarchar(255), null
sActTo nvarchar(1024), null
sActToEmail nvarchar(1024), null
nActWorkHours float, null
dActRemoved datetime, null
sActCc nvarchar(1024), null
sActAutoSubmitted nvarchar(255), null
sActMessageId nvarchar(255), null
sActXSpamLevel nvarchar(255), null
sActXSpamStatus nvarchar(255), null
nActTravelHours float, null
nActTravelKm float, null
bNoCharge bit, not null
liActHdTicketApprovalItemId int, null
liActHdTicketApprovalId int, null
bWaitingForUser bit, null
CreatedByPersonId int, null
TicketChangeId int, null
ActOperationId int, null
HdTicketApprovalId int, null
RelationId int, null
ActLocaleId int, null

dbo.vApprovalAuthority

Current approvers of requests that are currently in the process of being approved.

Column Type Description
liApprovalAuthorityHdTicketId int, null
liApprovalAuthorityPersonId int, null

dbo.vApprovalAuthority_Custom

Current request approvers according to custom approval processes. The customer can define custom contents for this view.

Column Type Description
liHdTicketId int, null
liPersonId int, null

dbo.vAssetPersonSystemRole

User membership in system roles of Asset Management.

Column Type Description
PersonId int, not null
SysAdmin bit, null
SwLic bit, null
Reader bit, null
Hw bit, null
Detect bit, null
Inventory bit, null
RelationReader bit, null
RelationWriter bit, null

dbo.vAssetUser

Users in the object tree.

Column Type Description
intNodeId int, not null
txtName nvarchar(255), null
bolHidden bit, not null
txtLDAPGUID nvarchar(255), null
User nvarchar(255), null
Department nvarchar(255), null
Phone nvarchar(255), null
Email nvarchar(255), null
Login nvarchar(255), null
PersonalNum nvarchar(255), null
Office nvarchar(255), null
Mobile nvarchar(255), null
WorkPosition nvarchar(255), null
City nvarchar(255), null

dbo.vAssetUserPerson

The user's link in the object tree to the user in the Admin service (tPerson. Link based on priority: 1. AD GUID 2. Personal number 3. Login name 4. E-mail

Column Type Description
NodeId int, not null
User nvarchar(255), null
PersonId int, not null
PersonManagerId int, null

dbo.vClass

Types of objects.

Column Type Description
intClassId int, not null
txtClass nvarchar(255), null
bComputer bit, not null

dbo.vColumnLoc

Translations of the names and descriptions of custom items in all languages ​​used.

Column Type Description
bUseColumnValue bit, not null
iColumnId int, not null
mDescription nvarchar(max), null
Multiline bit, not null
nOrder float, not null
Removed int, null
sColumn nvarchar(128), null
sTable nvarchar(128), null
sTitle nvarchar(255), not null
ColumnLocaleId int, not null
LocalizedTitle nvarchar(max), not null
LocalizedDescription nvarchar(max), null

dbo.vColumnValueLoc

Translations of custom items values in all languages ​​used.

Column Type Description
ColumnValueShort nvarchar(max), not null
iColumnValueId int, not null
liColumnId int, not null
liHdSectionId int, null
mColumnValue nvarchar(max), not null
nOrder float, not null
ParentValue int, null
sExtra1 nvarchar(255), null
ColumnValueLocaleId int, not null
LocalizedColumnValue nvarchar(max), null
LocalizedColumnValueShort nvarchar(max), null

dbo.vComputer

Computers.

Column Type Description
intNodeId int, not null
lintParentId int, null
lintIconId int, null
intState int, null
txtName nvarchar(255), null
bolHidden bit, not null
lintClassId int, null
bolAutoUpdate bit, not null
txtLDAPGUID nvarchar(255), null
bolComputerStateOn bit, null
txtPath nvarchar(1024), null
bolIgnoreDifferences bit, not null
liSwProfileId int, null
bSwAllAllowed bit, not null
txtComputerName nvarchar(255), null
txtIPAddress nvarchar(255), null
txtDomain nvarchar(255), null
txtFullComputerName nvarchar(511), null
bolScrapped int, not null

dbo.vComputerDetectLast

Last detection of the computers.

Column Type Description
lintDetectId int, null
lintComputerNodeId int, not null
lintDetectKindId int, not null

dbo.vComputerSwManager

People and their superiors responsible for software installed on the computer

Column Type Description
ComputerId int, null
SwManagerPersonId int, null
SwManagerSuperiorId int, null

dbo.vComputerUsage

Displays the utilization of the computers (in hours) over the past month and year.

Column Type Description
iComputerId int, not null
sComputer nvarchar(255), null
iUsageLastMonth float, not null
sUsageLastMonth varchar, null
iUsageLastYear float, not null
sUsageLastYear varchar, null

dbo.vDefaultSla

Default SLA for individuals and services.

Column Type Description
liDefaultSlaPersonId int, not null
liDefaultSlaHdSectionId int, not null
liDefaultSlaSlaId int, null

dbo.vDetectKind

Types of detections (HW, SW).

Column Type Description
intDetectKindId int, not null
txtDetectKind nvarchar(255), null

dbo.vDetFiles

Detected files.

Column Type Description
intFileId int, not null
txtFileName nvarchar(255), null
txtExt nvarchar(255), null
intSize int, null
lintFileStringInfoFileId int, null
intLanguage int, null
intCodePage int, null
txtComments nvarchar(255), null
txtCompanyName nvarchar(255), null
txtFileDescription nvarchar(255), null
txtFileVersion nvarchar(255), null
txtInternalName nvarchar(255), null
txtLegalCopyright nvarchar(255), null
txtLegalTrademarks nvarchar(255), null
txtOriginalFilename nvarchar(255), null
txtProductName nvarchar(255), null
txtProductVersion nvarchar(255), null
txtPrivateBuild nvarchar(255), null
txtSpecialBuild nvarchar(255), null
lintFileVerInfoFileId int, null
intFileVersionMS int, null
intFileVersionLS int, null
intProductVersionMS int, null
intProductVersionLS int, null
intFileFlagsMask int, null
intFileFlags int, null
intFileOS int, null
intFileType int, null
intFileSubtype int, null
intFileDateMS int, null
intFileDateLS int, null
intDetFileId int, not null
lintDetFileFileId int, null
lintDetectId int, null
txtFolderPath nvarchar(255), null
dteCreated datetime, null
dteModified datetime, null
dteAccessed datetime, null
intAttribs int, null
lintProductId int, null
lintFileImageId int, null
lintOriginalProductId int, null

dbo.vDocument

Documents.

Column Type Description
lintAtomId int, not null
lintDocumentKindId int, not null
txtIdNumber2 nvarchar(255), null
txtMemo nvarchar(max), null
dteCreated datetime, null
lintResellerCompanyId int, null
lintSrcNodeId int, null
lintDestNodeId int, null
liCreatedPersonId int, null
sCreatedPersonName nvarchar(255), null
dteRemoved datetime, null
liRemovedPersonId int, null
TransferConfirmTypeId int, not null
SignDate datetime, null
SignPersonId int, null
SignedBy nvarchar(128), null
SignComputer nvarchar(255), null
sRemovedPersonName nvarchar(255), null
txtId nvarchar(255), null
txtResellerCompany nvarchar(255), null
txtLink int, null

dbo.vDocumentKind

Kinds of documents.

Column Type Description
intDocumentKindId int, not null
txtDocumentKind nvarchar(255), null

dbo.vEmailTemplateLoc

Translations of custom notifications in all languages ​​used.

Column Type Description
bActive bit, not null
id int, not null
liHdSectionId int, null
mSubject nvarchar(max), null
mTextBody nvarchar(max), null
SamAlertRuleId int, null
sNotificationKind nvarchar(64), null
TransferConfirmAlertRuleId int, null
EmailTemplateLocaleId int, not null
LocalizedSubject nvarchar(max), null
LocalizedTextBody nvarchar(max), null

dbo.vEvent

Reminders.

Column Type Description
intEventId int, not null
dteSignalDate datetime, null
dteDate datetime, not null
txtMemo nvarchar(max), null
liPersonId int, not null
bolChecked bit, not null
sPerson nvarchar(255), null

dbo.vHdSectionEffectiveShowInServiceCatalog

View for effective viewing of the "View in the Service Catalogue" option. Takes into account settings in parent services.

Column Type Description
iHdSectionId int, null
EffectiveShowInServiceCatalog bit, null

dbo.vHdSectionExceptionalSolver

Effective irregular solvers in services.

Column Type Description
SectionId int, not null
PersonId int, null
RequesterRoleId int, not null Link to the group of requesters for which the permission for the given person is valid.

dbo.vHdSectionLoc

Auxiliary view for the language localization of service names and descriptions.

Column Type Description
iHdSectionId int, not null ID of record with service.
sHdSection nvarchar(255), null Localized full service name.
sHdSectionShort nvarchar(255), null Localized short service name.
mHdSectionDesc nvarchar(max), null Localized service description.
sHdSectionImageFile nvarchar(255), null
nHdSectionOrder float, null
liHdSectionParentHdSectionId int, null
liHdSectionBuildingId int, null
sHdSectionEmail nvarchar(255), null
sHdSectionMessageTagPrefix nvarchar(255), null
sHdSectionMessageTagSuffix nvarchar(255), null
sHdSectionExchangeMailboxUri nvarchar(255), null
bHdSectionDefault bit, not null
sHdSectionPhone nvarchar(255), null
sHdSectionImapServer nvarchar(255), null
sHdSectionNewHdTicketShowFields nvarchar(1024), null
sHdSectionUserShowFields nvarchar(1024), null
nHdSectionUserReopenDays float, null
bHdSectionMessageRemove bit, not null
sHdSectionMailboxLogin nvarchar(255), null
sHdSectionMailboxPassword nvarchar(255), null
bHdSectionHdTicketUserRead bit, not null
bHdSectionFolder bit, not null
sHdSectionNewHdTicketUrl nvarchar(1024), null
sHdSectionHdTicketCustomWorkflowUrl nvarchar(1024), null
nHdSectionQueueHoursPerWeek float, null
dHdSectionRemoved datetime, null
sHdSectionEWSUri nvarchar(255), null
bHdSectionMessageReadOnlyUnread bit, not null
bHdSectionMessageMarkRead bit, not null
sHdSectionMessageFolder nvarchar(255), null
bHdSectionImapSsl bit, not null
TicketTypeId int, not null
ImapPort int, null
UseFeedback bit, not null
CustomFeedbackUrl nvarchar(max), null
TileColor int, null
TileType int, null
AllowSkipCustomForm bit, not null
DefaultLanguageId int, null
DefaultTimeZone nvarchar(64), null
CreateNewFollowingRequest bit, not null
CreateNewFollowingRequestToSection int, null
ShowInServiceCatalog bit, not null
ForceUseSolverLicense bit, not null
Keywords nvarchar(max), null
TargetHdSectionId int, null
DefaultTicketTemplateId int, null
iHdSectionLocaleId int, not null LCID of the language for which the localization is executed
LocalizedSection nvarchar(255), null Localized full service name.
LocalizedSectionShort nvarchar(255), null Localized short service name.
LocalizedSectionDesc nvarchar(max), null Localized service description.
LocalizedKeywords nvarchar(max), null

dbo.vHdSectionOperator_Direct

Effective service operators without absentee stand-ins.

Column Type Description
liHdSectionOperatorHdSectionId int, not null
liHdSectionOperatorPersonId int, null
RequesterRoleId int, not null Link to the group of requesters for which the permission for the given person is valid.

dbo.vHdSectionPerson

Effective settings of notifications sent from the services to individual persons.

Column Type Description
liHdSectionPersonHdSectionId int, not null
liHdSectionPersonPersonId int, not null
bHdSectionPersonNotifySolverOnHdTicketPassed bit, not null
bHdSectionPersonNotifySolverOnHdTicketCreated bit, not null
bHdSectionPersonNotifySolverOnHdTicketHdSectionChanged bit, not null
bHdSectionPersonNotifySolverOnHdTicketOpen bit, not null
bHdSectionPersonNotifySolverOnNewMessageReceived bit, not null
bNotifySolverOnHdTicketReturnedToOperators int, null
bHdSectionPersonNotifyUserOnHdTicketCreated bit, not null
bHdSectionPersonNotifyUserOnHdTicketDeadlineChanged bit, not null
bHdSectionPersonNotifyUserOnHdTicketResolved bit, not null
bHdSectionPersonNotifyUserOnHdTicketSolverOpen bit, not null

dbo.vHdSectionSolverTake1

Effective service solvers authorized to "retrieve another request - main".

Column Type Description
liHdSectionSolverTake1HdSectionId int, not null
liHdSectionSolverTake1PersonId int, null
RequesterRoleId int, not null Link to the group of requesters for which the permission for the given person is valid.

dbo.vHdSectionSolverTake2

Effective service solvers authorized to "retrieve another request - secondary".

Column Type Description
liHdSectionSolverTake2HdSectionId int, not null
liHdSectionSolverTake2PersonId int, null
RequesterRoleId int, not null Link to the group of requesters for which the permission for the given person is valid.

dbo.vHdTicket

Values for dynamically calculated request items.

Column Type Description
liHdTicketId int, not null
nOpenTimeHours float, null
nOpenTimeWithoutWaitingHours float, null
nWaitedForUserHours float, not null
nWaitingForUserHours float, null
NextAction nvarchar(max), null
NextActionDeadline datetime, null
IsNextActionInternalTarget int, not null
SlaPause int, not null
IsSlaPaused int, not null

dbo.vHdTicketApprovalItemResultLoc

Column Type Description
iHdTicketApprovalItemResultId int, not null
sHdTicketApprovalItemResult nvarchar(255), null
ApprovalItemResultLocaleId int, not null
LocalizedResult nvarchar(max), null

dbo.vHdTicketCalc

Information whether the request can indeed be reopened.

Column Type Description
iHdTicketId int, not null
bHdTicketUserOpenProtected int, not null

dbo.vHdTicketPersonRead

Effective authorization to display requests.

Column Type Description
liHdTicketId int, null
liPersonId int, null
OnlyRequester int, null
SolverTeam int, null The flag specifying whether the user is a member of the solver team for the given request. Takes into account the mapping of requesters to the solver team.
Operator int, null The flag specifying whether the user has the role of an operator on the given request. Takes into account the mapping of requesters to the solver team.
Solver int, null The flag specifying whether the user has the role of a solver on the given request. Takes into account the mapping of requesters to the solver team.
OnlyReader int, not null The flag specifying whether the user only has the role of a reader on the given request. Takes into account the mapping of requesters to the solver team.

dbo.vInstDetect

Installed software, detected version and activation code.

Column Type Description
intDetectId int, not null
lintComputerNodeId int, not null
lintProductId int, null
txtProductVersion nvarchar(255), null
txtDetCDKey nvarchar(255), null

dbo.vInstTrial

Installations covered by "special installation", including the coverage for package components.

Column Type Description
lintProductId int, not null
lintComputerNodeId int, not null
txtDesc nvarchar(255), null

dbo.vKnowledgeRead

Knowledge that a user can read in services.

Column Type Description
SectionId int, null
ArticleId int, null
PersonId int, null

dbo.vLang

Languages.

Column Type Description
intNameLangId int, null
txtLang nvarchar(255), null

dbo.vLastEvaluatedSwDetect

Last evaluated SW detection on the computer.

Column Type Description
intDetectId int, not null
lintComputerNodeId int, not null
dteCreated datetime, null
dteImported datetime, null
txtDescription nvarchar(255), null
lintDetectKindId int, not null
dteRqCreated datetime, null
txtCollector nvarchar(255), null
txtShareRq nvarchar(255), null
lintDetectStatusId int, not null
liRqCreatedPersonId int, not null
dUpdated datetime, null
DetectSourceMethod int, null
ManualRq bit, not null

dbo.vLicHist_InvoiceAtomLast

Invoice attached to the license.

Column Type Description
lintLicHistId int, null
lintAtomId int, null

dbo.vLicHistItem

License items.

Column Type Description
intLicHistItemId int, not null
lintLicHistId int, not null
NodeId int, null
ActivationKey nvarchar(255), null
lintCancelledByLicHistId int, null
txtMemo nvarchar(max), null
txtInventoryNum nvarchar(255), null
txtDepartment nvarchar(255), null
txtRequest nvarchar(255), null
bolOEM int, not null
dteCancelledDate datetime, null
Object nvarchar(255), null
sCancelledByPerson nvarchar(255), null
UpgradedFromLicHistItemId int, null

dbo.vLicHistLog

Log of changes in registered licenses.

Column Type Description
LicHistId int, null
LogDate datetime, not null
LicHistLogKindId int, not null
LogKind nvarchar(100), not null
Message nvarchar(max), null
Author nvarchar(255), null
PropName nvarchar(255), null
OldVal nvarchar(255), null
NewVal nvarchar(255), null
ObjKind nvarchar(255), null
ObjName nvarchar(255), null

dbo.vLicProductCoveredOnComputer

Which products on the computer have license coverage (per device or per user).

Column Type Description
LicHistId int, not null
ComputerId int, null
UserId int, null
ProductId int, not null
ProductPackId int, null

dbo.vLicTrans

Shared licenses.

Column Type Description
lintProductId int, not null
NodeId int, not null
LicNodeId int, not null
txtDesc nvarchar(255), null
txtLicComputer nvarchar(255), null

dbo.vLog_DetectLast

Last record in the detection log.

Column Type Description
lintDetectId int, null
lintMaxLogId int, null

dbo.vMediaList

List of media.

Column Type Description
lintAtomId int, not null
lintMediaTypeId int, not null
txtTitle nvarchar(255), null
txtId nvarchar(255), null
txtAuthor nvarchar(255), null
txtMediaType nvarchar(255), null
txtLocation nvarchar(255), null

dbo.vMediaType

Types of media.

Column Type Description
intMediaTypeId int, not null
txtMediaType nvarchar(255), null

dbo.vNodeClass

Objects in the object tree. Classification into system objects and discarded assets.

Column Type Description
intNodeId int, not null
lintParentId int, null
lintIconId int, null
intState int, null
txtName nvarchar(255), null
bolHidden bit, not null
lintClassId int, null
bolAutoUpdate bit, not null
txtLDAPGUID nvarchar(255), null
bolComputerStateOn bit, null
txtPath nvarchar(1024), null
bolIgnoreDifferences bit, not null
liSwProfileId int, null
bSwAllAllowed bit, not null
txtClass nvarchar(255), null
bComputer bit, not null
bolScrapped int, not null
LastAgentWSContact datetime, null

dbo.vNodeCostCentre

Cost center of the objects in the tree.

Column Type Description
NodeId int, not null
ClassId int, null
Centre nvarchar(255), null

dbo.vNodeDisposed

Discarded assets.

Column Type Description
NodeId int, not null

dbo.vNodeParentJoin

Objects in the tree - tree.

Column Type Description
lintNodeId int, not null
lintParentNodeId int, not null

dbo.vNodePropertyMix

Objects and properties - Public + Asset + Computer1.

Column Type Description
intNodeId int, not null
lintParentId int, null
lintIconId int, null
intState int, null
txtName nvarchar(255), null
bolHidden bit, null
lintClassId int, null
bolAutoUpdate bit, null
txtLDAPGUID nvarchar(255), null
bolComputerStateOn bit, null
txtPath nvarchar(1024), null
bolIgnoreDifferences bit, null
intNodeId1 int, not null
txtTypeMark nvarchar(255), null
txtSerialNumber nvarchar(255), null
txtManufacturer nvarchar(255), null
txtEvidentiaryNumber nvarchar(255), null
txtProp_Name nvarchar(255), null
intNodeId2 int, not null
txtInventoryNumber nvarchar(255), null
txtPurchased nvarchar(255), null
txtWarranty nvarchar(255), null
txtVendor nvarchar(255), null
txtInvoiceNumber nvarchar(255), null
intNodeId3 int, not null
txtType nvarchar(255), null
txtBIOSSerialNumber nvarchar(255), null

dbo.vNodePropertyMix_Asset

Objects and properties - Assets Number, Purchase Date, Warranty expiration, Manufacturer, Packing Slip Number.

Column Type Description
intNodeId2 int, not null
txtInventoryNumber nvarchar(255), null
txtPurchased nvarchar(255), null
txtWarranty nvarchar(255), null
txtVendor nvarchar(255), null
txtInvoiceNumber nvarchar(255), null

dbo.vNodePropertyMix_Computer1

Objects and properties - Computer - Motherboard (type), BIOS Serial Number.

Column Type Description
intNodeId3 int, not null
txtType nvarchar(255), null
txtBIOSSerialNumber nvarchar(255), null

dbo.vNodePropertyMix_Computer2

Objects and properties - Computer - MAC address.

Column Type Description
intNodeId4 int, not null
txtMACAddress nvarchar(255), null

dbo.vNodePropertyMix_Public

Objects and properties - Type Designation, Serial Number, Manufacturer, Registration Number, Name.

Column Type Description
intNodeId1 int, not null
txtTypeMark nvarchar(255), null
txtSerialNumber nvarchar(255), null
txtManufacturer nvarchar(255), null
txtEvidentiaryNumber nvarchar(255), null
txtProp_Name nvarchar(255), null

dbo.vOnlyReader

Users that only have the right of reader in the services.

Column Type Description
PersonId int, not null
SectionId int, not null
OnlyReader bit, null
RequesterRoleId int, not null Link to the group of requesters for which the permission for the given person is valid.

dbo.vPersonNodeRight

Rights in the object tree - main view.

Column Type Description
liPersonId int, null
liNodeId int, null
bRead int, null
bWrite int, null
bMove int, null
bDelete int, null
CreateObj int, null

dbo.vPersonNodeRight_Create

Rights in the objects tree - the right to "Create any objects".

Column Type Description
liPersonId int, null
liNodeId int, null

dbo.vPersonNodeRight_Delete

Rights in the object tree - the right to "Remove".

Column Type Description
liPersonId int, null
liNodeId int, null

dbo.vPersonNodeRight_Move

Rights in the object tree - the right to "Move".

Column Type Description
liPersonId int, null
liNodeId int, null

dbo.vPersonNodeRight_Read

Rights in the object tree - the right to "Read".

Column Type Description
liPersonId int, null
liNodeId int, null

dbo.vPersonNodeRight_Write

Rights in the object tree - the right to "Change".

Column Type Description
liPersonId int, null
liNodeId int, null

dbo.vPersonRightRead

Effective permission of people and groups have for records on the activities of other people and groups within the ALVAO User Activity Monitoring module.

Column Type Description
liPersonRightReadPersonId int, null
liPersonRightReadSubjectPersonId int, null

dbo.vProduct

Products (software).

Column Type Description
intProductId int, not null
txtProductName nvarchar(1023), null
lintLangId int, null
lintProducerCompanyId int, null
lintProductTypeId int, not null
lintProductCategoryId int, null
txtCertifiedBy nvarchar(255), null
SamTypeId int, not null
dteTimeStamp datetime, not null
intProductUID int, null
txtParam1 nvarchar(255), null
txtParam2 nvarchar(255), null
txtDescription nvarchar(255), null
nPrice float, null
bolValid bit, not null
AlternateApprovedProduct nvarchar(max), null
ProductStateId int, not null
SupportedVersion nvarchar(32), null
ProductStateModifiedPersonId int, null
ProductStateModifiedDate datetime, null
ProductRejectedFrom datetime, null
Request nvarchar(32), null

dbo.vProductCategory

Products categories (OS).

Column Type Description
intProductCategoryId int, not null
txtProductCategory nvarchar(255), null

dbo.vProductType

Products types.

Column Type Description
intProductTypeId int, not null
txtProductType nvarchar(255), null

dbo.vProductUsage

Displays the utilization of the products on the computers (in hours) over the past month and year.

Column Type Description
ComputerId int, not null
ProductId int, not null
iUsageLastMonth float, not null
sUsageLastMonth nvarchar(31), null
iUsageLastYear float, not null
sUsageLastYear nvarchar(31), null

dbo.vProperty

View of the properties of objects, including calculated value ​​for the "User" type property.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
bolInheritable bit, not null
intNameOrder int, null
intState int, null
ParentNodeId int, null
NodeIdValue int, null
KindDataTypeId int, null

dbo.vPropertyFromAD

Properties of objects which are downloaded from AD.

Column Type Description
intNodeId int, not null
intPropertyId int, not null
bFromAD int, not null
bCanModify int, not null

dbo.vPropertyKind

Properties of objects.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
NodeIdValue int, null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null
intKindCode int, null
bDetected bit, null
bFromAD bit, null
bCanModify bit, null

dbo.vPropertyKind_Asset

Object properties - Serial number, Inventory number a Asset number.

Column Type Description
intNodeId int, not null
EvidentiaryNumber nvarchar(255), null
SerialNumber nvarchar(255), null
InventoryNumber nvarchar(255), null

dbo.vPropertyKind_AssetCategory

Properties of objects - Asset category.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_BIOSSerialNumber

Properties of objects - BIOS serial number.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_ChassisType

Properties of objects - Type of rack.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_ComputerKind

Properties of objects - Type of computer.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_ComputerName

Properties of objects - Name in the network.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_Department

Properties of objects - Cost center.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_Domain

Properties of objects - DNS domain.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_EvidentiaryNumber

Properties of objects - registration number.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_Frequency

Properties of objects - Frequency.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_Interface

Properties of objects - Interface.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_InventoryDate

Properties of objects - Stocktaking date.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_InventoryNumber

Properties of objects - Asset number.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_InvoiceNumber

Properties of objects - Packing slip number.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_IPAddress

Properties of objects - IP address.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_MACAddress

Properties of objects - MAC address.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_Manufacturer

Properties of objects - Manufacturer.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_MaxSize

Properties of objects - Maximum size.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_MemoryDevices

Properties of objects - Sockets.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_MemoryDevicesUsed

Properties of objects - Occupied sockets.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_Model

Properties of objects - Model.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_Name

Properties of objects - Name.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_Office

Properties of objects - Office.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_PartOfDomain

Properties of objects -Domain components.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_PersonalId

Properties of objects - Personal number.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_Place

Properties of objects - Location.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_Port

Properties of objects - Port.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_ProcessorId

Properties of objects - Processor ID.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_Purchased

Properties of objects - Purchase date.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_RefreshMax

Properties of objects - Maximum refresh.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_SerialNumber

Properties of objects - Serial number.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_Size

Properties of objects - Size.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_Type

Properties of objects - Type.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_TypeMark

Properties of objects - Type designation.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_Vendor

Properties of objects - Vendor.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_Version

Properties of objects - Version.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_VideoRAM

Properties of objects - RAM size.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_WakeUpType

Properties of objects - Wake-up method.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKind_Warranty

Properties of objects - Warranty.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null

dbo.vPropertyKindInherited

Properties of objects - including inherited properties.

Column Type Description
intPropertyId int, not null
lintNodeId int, not null
lintKindId int, not null
txtValue nvarchar(255), null
NodeIdValue int, null
intState int, null
intNameOrder int, null
bolInheritable bit, not null
txtKind nvarchar(255), not null
intKindCode int, null
lintParentNodeId int, null

dbo.vPropertyLoc

Translations of tProperty settings in all languages ​​used.

Column Type Description
PropertyId int, not null ID of settings from the tProperty table
sPropertyValue nvarchar(2048), null The original text value of the setting from tProperty
LocaleId int, not null LocaleID of the translation in LocalizedStringValue
LocalizedStringValue nvarchar(max), null sPropertyValue translation
sProperty nvarchar(255), not null Name of configuration in tProperty

dbo.vSamAlertLast

SAM notification - last unresolved notifications sent

Column Type Description
id int, not null
ProductId int, not null
ComputerId int, not null
SentDate datetime, not null
SamAlertRuleId int, not null
SequenceNum int, not null
Recipients nvarchar(max), null
ResolvedDate datetime, null

dbo.vSectionLicence

Drawing of licenses by services

Column Type Description
PersonCount int, null
LicenceTypeId int, not null
LicenceType nvarchar(max), null
SectionId int, not null

dbo.vSectionWithTreeOrder

For each service, it returns a string which guarantees queueing being the same as that in the tree.

Column Type Description
iHdSectionId int, null
sHdSection nvarchar(255), null
nHdSectionOrder float, null
TreeSorting nvarchar(255), null

dbo.vSlaAccess

Effective authorization requesters have for SLA and services.

Column Type Description
liSlaAccessSlaId int, not null
liSlaAccessHdSectionId int, not null
liSlaAccessPersonId int, null

dbo.vSlaAlertDeadline

Individual SLA notifications for the expiration of the request deadline.

Column Type Description
iSlaAlertRuleId int, not null
liHdTicketId int, not null
liSectionId int, not null
liSlaId int, not null
fSummarySendHour float, null
dHdTicketDeadline datetime, null

dbo.vSlaAlertDeadlineSummary

Summary SLA notifications for the expiration of the request deadline.

Column Type Description
iSlaAlertRuleId int, not null
iHdTicketId int, not null
sTag nvarchar(255), null
sHdTicket nvarchar(1024), null
dHdTicketDeadline datetime, null
sHdTicketUserEmail nvarchar(255), null
sHdSectionEmail nvarchar(255), null
sSolver nvarchar(255), null
liToPersonId int, null
sPortalURL nvarchar(max), null
sPerson nvarchar(255), null
sPersonEmail nvarchar(255), null
iPersonLocaleId int, null

dbo.vSlaAlertInactiveApprovers

Individual SLA notifications for approver inactivity.

Column Type Description
liSlaAlertRuleId int, not null
liHdTicketId int, not null
liSectionId int, not null
liSlaId int, not null
fSummarySendHour float, null

dbo.vSlaAlertInactiveApproversSummary

Summary SLA alerts for approver inactivity.

Column Type Description
liSlaAlertRuleId int, not null
fSummarySendHour float, null
iHdTicketId int, not null
sTag nvarchar(255), null
sHdTicket nvarchar(1024), null
sHdTicketUserEmail nvarchar(255), null
sHdSectionEmail nvarchar(255), null
sSolver nvarchar(255), null
liToPersonId int, null
sPortalURL nvarchar(max), null
sPerson nvarchar(255), null
sPersonEmail nvarchar(255), null
iPersonLocaleId int, null

dbo.vSlaAlertInactiveOperators

Individual SLA notifications for operator inactivity.

Column Type Description
liSlaAlertRuleId int, not null
liHdTicketId int, not null
liSectionId int, not null
liSlaId int, not null
fSummarySendHour float, null

dbo.vSlaAlertInactiveOperatorsSummary

Summary SLA alerts for operator inactivity.

Column Type Description
liSlaAlertRuleId int, not null
fSummarySendHour float, null
iHdTicketId int, not null
sTag nvarchar(255), null
sHdTicket nvarchar(1024), null
sHdTicketUserEmail nvarchar(255), null
sHdSectionEmail nvarchar(255), null
sSolver nvarchar(255), null
liToPersonId int, null
sPortalURL nvarchar(max), null
sPerson nvarchar(255), null
sPersonEmail nvarchar(255), null
iPersonLocaleId int, null

dbo.vSlaAlertInactiveRequesters

Individual SLA notifications for requester inactivity.

Column Type Description
liSlaAlertRuleId int, not null
liHdTicketId int, not null
liSectionId int, not null
liSlaId int, not null
fSummarySendHour float, null

dbo.vSlaAlertInactiveRequestersSummary

Summary SLA alerts for requester inactivity.

Column Type Description
liSlaAlertRuleId int, not null
fSummarySendHour float, null
iHdTicketId int, not null
sTag nvarchar(255), null
sHdTicket nvarchar(1024), null
sHdTicketUserEmail nvarchar(255), null
sHdSectionEmail nvarchar(255), null
sSolver nvarchar(255), null
liToPersonId int, null
sPortalURL nvarchar(max), null
sPerson nvarchar(255), null
sPersonEmail nvarchar(255), null
iPersonLocaleId int, null

dbo.vSlaAlertInactiveSolvers

Individual SLA notifications for solver inactivity.

Column Type Description
liSlaAlertRuleId int, not null
liHdTicketId int, not null
liSectionId int, not null
liSlaId int, not null
fSummarySendHour float, null

dbo.vSlaAlertInactiveSolversSummary

Summary SLA alerts for solver inactivity.

Column Type Description
liSlaAlertRuleId int, not null
fSummarySendHour float, null
iHdTicketId int, not null
sTag nvarchar(255), null
sHdTicket nvarchar(1024), null
sHdTicketUserEmail nvarchar(255), null
sHdSectionEmail nvarchar(255), null
sSolver nvarchar(255), null
liToPersonId int, null
sPortalURL nvarchar(max), null
sPerson nvarchar(255), null
sPersonEmail nvarchar(255), null
iPersonLocaleId int, null

dbo.vSlaAlertInternalTarget

Individual SLA alerts for the expiration of requests internal target date.

Column Type Description
iSlaAlertRuleId int, not null
liHdTicketId int, not null
liSectionId int, not null
liSlaId int, not null
fSummarySendHour float, null
InternalTarget nvarchar(255), null
InternalTargetDeadline datetime, null

dbo.vSlaAlertInternalTargetSummary

Summary SLA alerts for the expiration of requests internal target date.

Column Type Description
iSlaAlertRuleId int, not null
iHdTicketId int, not null
sTag nvarchar(255), null
sHdTicket nvarchar(1024), null
InternalTarget nvarchar(255), null
InternalTargetDeadline datetime, null
sHdTicketUserEmail nvarchar(255), null
sHdSectionEmail nvarchar(255), null
sSolver nvarchar(255), null
liToPersonId int, null
sPortalURL nvarchar(max), null
sPerson nvarchar(255), null
sPersonEmail nvarchar(255), null
iPersonLocaleId int, null

dbo.vSlaLoc

List of SLAs in all used languages.

Column Type Description
iSlaId int, not null
sSla nvarchar(255), null
mSlaDesc nvarchar(max), null
nSlaDeadlineHours float, null
dSlaRemoved datetime, null
nSlaReactionHours float, null
sSlaContract nvarchar(255), null
mSlaNotes nvarchar(max), null
nSlaQuality float, null
liOpeningHoursId int, null
Pause bit, not null
SlaLocaleId int, not null
LocalizedSla nvarchar(255), null
LocalizedSlaDesc nvarchar(max), null

dbo.vStringLoc

Column Type Description
iStringId int, not null
mString nvarchar(max), null
StringLocaleId int, not null
LocalizedString nvarchar(max), null

dbo.vSwInst

Installed software - valid products and outside system objects.

Column Type Description
intInstHistId int, not null
lintComputerNodeId int, not null
lintProductId int, not null
liInstalledPersonId int, null
liUninstalledPersonId int, null
lintInstallDetectId int, null
lintUnistallDetectId int, null
dteInstallDetected datetime, null
dteUninstallDetected datetime, null
dteInstalled datetime, null
dteUninstalled datetime, null
txtMemo nvarchar(max), null
txtDetProductName nvarchar(255), null
txtDetProductVersion nvarchar(255), null
intDetLanguage int, null
txtDetProductId nvarchar(255), null
txtDetInstallDate nvarchar(255), null
txtDetRecognizedBy nvarchar(255), null
txtDetCDKey nvarchar(255), null

dbo.vSwInst_ProductComputer

Software installed on the computers.

Column Type Description
intInstHistId int, not null
lintProductId int, not null
lintComputerNodeId int, not null
txtDetProductVersion nvarchar(255), null
txtDetCDKey nvarchar(255), null
ProductStateId int, not null

dbo.vSwInst_ProductComputerDetect

SW detected in the computers.

Column Type Description
intDetectId int, not null
intInstHistId int, not null
lintProductId int, not null
lintComputerNodeId int, not null
txtDetProductVersion nvarchar(255), null
txtDetCDKey nvarchar(255), null

dbo.vSwInst_TreeCnt

Number of product installations in the subtree.

Column Type Description
lintProductId int, not null
lintParentNodeId int, not null
intCount int, null

dbo.vSwInstLicProfile_ProductComputer

Installed software vs licenses and software profiles.

Column Type Description
liProductId int, null
lintComputerNodeId int, null
intInstHistId int, null
LicTypeId int, null
lintInstProductId int, null
intLicHistId int, null
intLicHistItemId int, null
lintLicProductId int, null
lintProductDowngradeFromId int, null
lintProductPackFromId int, null
liSwProfProductId int, null
liSwPresenceId int, null
intFrom int, not null
bError int, not null
iLicStatusId int, null
iSwProfStatusId int, null
CoversMoreProds int, not null
ProductStateId int, null

dbo.vSwLic_ProductComputer

Products covered by licenses on the computers.

Column Type Description
intLicHistId int, not null
LicTypeId int, null
lintProductId int, not null
NodeId int, null
lintProductDowngradeFromId int, null
lintProductPackFromId int, null
intLicHistItemId int, not null
bolOEM int, not null
ActivationKey nvarchar(255), null
txtInventoryNum nvarchar(255), null
txtDepartment nvarchar(255), null
txtCertificateNo nvarchar(255), null
txtBuyRequest nvarchar(255), null
txtWebDownloadAddr nvarchar(1024), null
txtMemo nvarchar(255), null
CreatedPersonId int, null
CreatedDate datetime, null

dbo.vSwLic_UserComputer

Users' computers.

Column Type Description
LicHistId int, not null
ProductId int, not null
LicProductId int, not null
UserId int, null
ComputerId int, not null

dbo.vSwProfileProduct_Node

Statuses of the software profile on the products installed on the computers.

Column Type Description
liNodeId int, null
liProductId int, null
liSwPresenceId int, null

dbo.vTicketRelation

Links Between Requests.

Column Type Description
id int, not null
BeginHdTicketId int, not null
EndHdTicketId int, not null
TicketRelationTypeId int, not null

dbo.vTicketRelationTypeLoc

Column Type Description
BeginName nvarchar(30), not null
CustomField1 int, null
Cyclic bit, not null
Directional bit, not null
EndName nvarchar(30), not null
id int, not null
MenuOrder int, not null
OneToMany bit, not null
TicketRelationTypeBehaviorId int, not null
RelationTypeLocaleId int, not null
LocalizedBeginName nvarchar(max), not null
LocalizedEndName nvarchar(max), not null

dbo.vTicketStateLoc

List of statuses in all used languages.

Column Type Description
id int, not null
TicketTypeId int, null
TicketState nvarchar(64), not null
Description nvarchar(max), null
SolverInstructions nvarchar(max), null
Order int, not null
TicketStateBehaviorId int, not null
CustomField1 int, null
TransitToAllStates bit, not null
ApprovalAutoStart bit, not null
IsApprovalState bit, not null
OnRejectedStateId int, null
OnApprovalStateId int, null
OnCanceledStateId int, null
OnExpiredStateId int, null
ApprovalSchemaId int, null
ApprovalPersonId int, null
ApprovalExpirationHours float, null
CloseAfterSolution bit, not null
TicketStateLocaleId int, not null
LocalizedState nvarchar(64), null
LocalizedDescription nvarchar(max), null
LocalizedInstructions nvarchar(max), null
LocalizedMessageForApproverTemplate nvarchar(max), null Localized message template for approvers. If the status does not have a defined custom message template for approvers, the default template is used in the record.

dbo.vTicketStatePerTikcetLoc

List of current statuses regarding all requests in all languages used.

Column Type Description
TicketId int, not null
LocaleId int, null
LocalizedState nvarchar(max), null
id int, null
TicketTypeId int, null
TicketState nvarchar(64), null
Description nvarchar(max), null
SolverInstructions nvarchar(max), null
Order int, null
TicketStateBehaviorId int, null
CustomField1 int, null
TransitToAllStates bit, null
ApprovalAutoStart bit, null
IsApprovalState bit, null
OnRejectedStateId int, null
OnApprovalStateId int, null
OnCanceledStateId int, null
OnExpiredStateId int, null
ApprovalSchemaId int, null
ApprovalPersonId int, null
ApprovalExpirationHours float, null
CloseAfterSolution bit, null

dbo.vTicketTemplateColumnValueLoc

Translations of custom items values specified in request templates.

Column Type Description
ColumnId int, not null
DefaultValue nvarchar(max), not null
id int, not null
TicketTemplateId int, not null
TicketTemplateColumnValueLocaleId int, not null
DataType nvarchar(128), null
LocalizedDefaultValue nvarchar(max), null

dbo.vTicketTypeLoc

List of processes used in all used languages.

Column Type Description
BackResolveDeadlineHours float, null
CustomField1 int, null
Description nvarchar(max), null
id int, not null
TicketType nvarchar(30), not null
TicketTypeBehaviorId int, not null
TicketTypeLocaleId int, not null
LocalizedType nvarchar(255), null

dbo.vTimeZone

Overview of time zones and shifts compared to UTC.

Column Type Description
id int, not null Record ID.
uid nvarchar(128), not null Unique identifier (matches the key in the registry).
DisplayName nvarchar(128), not null Localized name.
FromDate datetime, null From date.
ToDate datetime, null Until.
Bias int, not null Shift compared to UTC in minutes

dbo.vTransferConfirmAlertLast

Last sent alerts of unsigned handover protocols.

Column Type Description
id int, not null
DocumentId int, not null
RuleId int, not null
SentDate datetime, not null

dbo.vUserLicence

Drawing of licenses by users

Column Type Description
PersonId int, not null
LicenceTypeId int, null
LicenceType nvarchar(max), null

dbo.vUserNodeRight

Rights in the object tree - users (including the rights allowed / prohibited by membership in roles).

Column Type Description
liPersonId int, null
lintNodeId int, null
bolRead bit, null
bolWrite bit, null
bolMove bit, null
bolDelete bit, null
CreateObj bit, null
bolRecursive bit, not null
lintClassId int, null

dbo.vWbemObject

Detail of the HW detection - all.

Column Type Description
lintWbemObjectId1 int, not null
lintWbemObjectId2 int, not null
intWbemObjectId int, not null
lintDetectId int, not null
bolVirtualObject bit, null
__CLASS nvarchar(255), null
AdapterRAM int, null
AdapterType nvarchar(255), null
AttachedTo nvarchar(255), null
Availability int, null
BankLabel nvarchar(255), null
BaseBoard nvarchar(255), null
Capacity bigint, null
Caption nvarchar(255), null
ChassisTypes int, null
txtChassisTypesDesc nvarchar(255), null
Compressed bit, null
CSDVersion nvarchar(255), null
CurrentClockSpeed int, null
CurrentRefreshRate int, null
DataWidth int, null
Description nvarchar(255), null
DeviceID nvarchar(255), null
DeviceLocator nvarchar(255), null
DeviceType nvarchar(255), null
DHCPEnabled bit, null
DNSServerSearchOrder nvarchar(255), null
Prop_Domain nvarchar(255), null
Drive nvarchar(255), null
DriveType int, null
EDIDVersion nvarchar(255), null
FileSystem nvarchar(255), null
FormFactor int, null
txtFormFactorDesc nvarchar(255), null
FreeSpace float, null
InstallDate datetime, null
InfraredSupported bit, null
InterfaceType nvarchar(255), null
IPAddress nvarchar(255), null
IPEnabled bit, null
IPSubnet nvarchar(255), null
IRQNumber int, null
MACAddress nvarchar(255), null
ManufactureDate datetime, null
Manufacturer nvarchar(255), null
MaxCapacity int, null
MaxClockSpeed int, null
MaxRefreshRate int, null
MediaType nvarchar(255), null
MemoryDevices int, null
MemoryType int, null
txtMemoryTypeDesc nvarchar(255), null
MinRefreshRate int, null
Model nvarchar(255), null
MonitorManufacturer nvarchar(255), null
Monochrome bit, null
PartOfDomain bit, null
Prop_Name nvarchar(255), null
NetConnectionID nvarchar(255), null
Organization nvarchar(255), null
OSLanguage int, null
PNPDeviceID nvarchar(255), null
PortName nvarchar(255), null
ProcessorId nvarchar(255), null
Prop_Product nvarchar(255), null
RegisteredUser nvarchar(255), null
ScreenHeight int, null
ScreenWidth int, null
SerialNumber nvarchar(255), null
Prop_Size float, null
Service nvarchar(255), null
ServiceName nvarchar(255), null
SMBIOSBIOSVersion nvarchar(255), null
SocketDesignation nvarchar(255), null
Speed nvarchar(255), null
StatusInfo int, null
txtStatusInfoDesc nvarchar(255), null
SystemDirectory nvarchar(255), null
SystemType nvarchar(255), null
TotalPhysicalMemory int, null
TypeDetail int, null
txtTypeDetailDesc nvarchar(255), null
UPSPort nvarchar(255), null
UserName nvarchar(255), null
Version nvarchar(255), null
VideoModeDescription nvarchar(255), null
VolumeSerialNumber nvarchar(255), null
WakeUpType int, null
txtWakeUpTypeDesc nvarchar(255), null

dbo.vWbemObject_BIOS

Detail of the HW detection - BIOS.

Column Type Description
intWbemObjectId int, not null
lintDetectId int, not null
bolVirtualObject bit, null
__CLASS nvarchar(255), null
AdapterRAM int, null
AdapterType nvarchar(255), null
AttachedTo nvarchar(255), null
Availability int, null
BankLabel nvarchar(255), null
BaseBoard nvarchar(255), null
Capacity bigint, null
Caption nvarchar(255), null
ChassisTypes int, null
txtChassisTypesDesc nvarchar(255), null
Compressed bit, null
CSDVersion nvarchar(255), null
CurrentClockSpeed int, null
CurrentRefreshRate int, null
DataWidth int, null
Description nvarchar(255), null
DeviceID nvarchar(255), null
DeviceLocator nvarchar(255), null
DeviceType nvarchar(255), null
DHCPEnabled bit, null
DNSServerSearchOrder nvarchar(255), null
Prop_Domain nvarchar(255), null
Drive nvarchar(255), null
DriveType int, null
EDIDVersion nvarchar(255), null
FileSystem nvarchar(255), null
FormFactor int, null
txtFormFactorDesc nvarchar(255), null
FreeSpace float, null
InstallDate datetime, null
InfraredSupported bit, null
InterfaceType nvarchar(255), null
IPAddress nvarchar(255), null
IPEnabled bit, null
IPSubnet nvarchar(255), null
IRQNumber int, null
MACAddress nvarchar(255), null
ManufactureDate datetime, null
Manufacturer nvarchar(255), null
MaxCapacity int, null
MaxClockSpeed int, null
MaxRefreshRate int, null
MediaType nvarchar(255), null
MemoryDevices int, null
MemoryType int, null
txtMemoryTypeDesc nvarchar(255), null
MinRefreshRate int, null
Model nvarchar(255), null
MonitorManufacturer nvarchar(255), null
Monochrome bit, null
PartOfDomain bit, null
Prop_Name nvarchar(255), null
NetConnectionID nvarchar(255), null
Organization nvarchar(255), null
OSLanguage int, null
PNPDeviceID nvarchar(255), null
PortName nvarchar(255), null
ProcessorId nvarchar(255), null
Prop_Product nvarchar(255), null
RegisteredUser nvarchar(255), null
ScreenHeight int, null
ScreenWidth int, null
SerialNumber nvarchar(255), null
Prop_Size float, null
Service nvarchar(255), null
ServiceName nvarchar(255), null
SMBIOSBIOSVersion nvarchar(255), null
SocketDesignation nvarchar(255), null
Speed nvarchar(255), null
StatusInfo int, null
txtStatusInfoDesc nvarchar(255), null
SystemDirectory nvarchar(255), null
SystemType nvarchar(255), null
TotalPhysicalMemory int, null
TypeDetail int, null
txtTypeDetailDesc nvarchar(255), null
UPSPort nvarchar(255), null
UserName nvarchar(255), null
Version nvarchar(255), null
VideoModeDescription nvarchar(255), null
VolumeSerialNumber nvarchar(255), null
WakeUpType int, null
txtWakeUpTypeDesc nvarchar(255), null

dbo.vWbemObject_SystemEnclosure

Detail of the HW detection - Computer rack.

Column Type Description
intWbemObjectId int, not null
lintDetectId int, not null
bolVirtualObject bit, null
__CLASS nvarchar(255), null
AdapterRAM int, null
AdapterType nvarchar(255), null
AttachedTo nvarchar(255), null
Availability int, null
BankLabel nvarchar(255), null
BaseBoard nvarchar(255), null
Capacity bigint, null
Caption nvarchar(255), null
ChassisTypes int, null
txtChassisTypesDesc nvarchar(255), null
Compressed bit, null
CSDVersion nvarchar(255), null
CurrentClockSpeed int, null
CurrentRefreshRate int, null
DataWidth int, null
Description nvarchar(255), null
DeviceID nvarchar(255), null
DeviceLocator nvarchar(255), null
DeviceType nvarchar(255), null
DHCPEnabled bit, null
DNSServerSearchOrder nvarchar(255), null
Prop_Domain nvarchar(255), null
Drive nvarchar(255), null
DriveType int, null
EDIDVersion nvarchar(255), null
FileSystem nvarchar(255), null
FormFactor int, null
txtFormFactorDesc nvarchar(255), null
FreeSpace float, null
InstallDate datetime, null
InfraredSupported bit, null
InterfaceType nvarchar(255), null
IPAddress nvarchar(255), null
IPEnabled bit, null
IPSubnet nvarchar(255), null
IRQNumber int, null
MACAddress nvarchar(255), null
ManufactureDate datetime, null
Manufacturer nvarchar(255), null
MaxCapacity int, null
MaxClockSpeed int, null
MaxRefreshRate int, null
MediaType nvarchar(255), null
MemoryDevices int, null
MemoryType int, null
txtMemoryTypeDesc nvarchar(255), null
MinRefreshRate int, null
Model nvarchar(255), null
MonitorManufacturer nvarchar(255), null
Monochrome bit, null
PartOfDomain bit, null
Prop_Name nvarchar(255), null
NetConnectionID nvarchar(255), null
Organization nvarchar(255), null
OSLanguage int, null
PNPDeviceID nvarchar(255), null
PortName nvarchar(255), null
ProcessorId nvarchar(255), null
Prop_Product nvarchar(255), null
RegisteredUser nvarchar(255), null
ScreenHeight int, null
ScreenWidth int, null
SerialNumber nvarchar(255), null
Prop_Size float, null
Service nvarchar(255), null
ServiceName nvarchar(255), null
SMBIOSBIOSVersion nvarchar(255), null
SocketDesignation nvarchar(255), null
Speed nvarchar(255), null
StatusInfo int, null
txtStatusInfoDesc nvarchar(255), null
SystemDirectory nvarchar(255), null
SystemType nvarchar(255), null
TotalPhysicalMemory int, null
TypeDetail int, null
txtTypeDetailDesc nvarchar(255), null
UPSPort nvarchar(255), null
UserName nvarchar(255), null
Version nvarchar(255), null
VideoModeDescription nvarchar(255), null
VolumeSerialNumber nvarchar(255), null
WakeUpType int, null
txtWakeUpTypeDesc nvarchar(255), null

dbo.vWbemObjectPhysicalMedia

Detail of the HW detection - Hard disks.

Column Type Description
lintWbemObjectId1 int, not null
lintWbemObjectId2 int, not null
intWbemObjectId int, not null
lintDetectId int, not null
bolVirtualObject bit, null
__CLASS nvarchar(255), null
AdapterRAM int, null
AdapterType nvarchar(255), null
AttachedTo nvarchar(255), null
Availability int, null
BankLabel nvarchar(255), null
BaseBoard nvarchar(255), null
Capacity bigint, null
Caption nvarchar(255), null
ChassisTypes int, null
txtChassisTypesDesc nvarchar(255), null
Compressed bit, null
CSDVersion nvarchar(255), null
CurrentClockSpeed int, null
CurrentRefreshRate int, null
DataWidth int, null
Description nvarchar(255), null
DeviceID nvarchar(255), null
DeviceLocator nvarchar(255), null
DeviceType nvarchar(255), null
DHCPEnabled bit, null
DNSServerSearchOrder nvarchar(255), null
Prop_Domain nvarchar(255), null
Drive nvarchar(255), null
DriveType int, null
EDIDVersion nvarchar(255), null
FileSystem nvarchar(255), null
FormFactor int, null
txtFormFactorDesc nvarchar(255), null
FreeSpace float, null
InstallDate datetime, null
InfraredSupported bit, null
InterfaceType nvarchar(255), null
IPAddress nvarchar(255), null
IPEnabled bit, null
IPSubnet nvarchar(255), null
IRQNumber int, null
MACAddress nvarchar(255), null
ManufactureDate datetime, null
Manufacturer nvarchar(255), null
MaxCapacity int, null
MaxClockSpeed int, null
MaxRefreshRate int, null
MediaType nvarchar(255), null
MemoryDevices int, null
MemoryType int, null
txtMemoryTypeDesc nvarchar(255), null
MinRefreshRate int, null
Model nvarchar(255), null
MonitorManufacturer nvarchar(255), null
Monochrome bit, null
PartOfDomain bit, null
Prop_Name nvarchar(255), null
NetConnectionID nvarchar(255), null
Organization nvarchar(255), null
OSLanguage int, null
PNPDeviceID nvarchar(255), null
PortName nvarchar(255), null
ProcessorId nvarchar(255), null
Prop_Product nvarchar(255), null
RegisteredUser nvarchar(255), null
ScreenHeight int, null
ScreenWidth int, null
SerialNumber nvarchar(255), null
Prop_Size float, null
Service nvarchar(255), null
ServiceName nvarchar(255), null
SMBIOSBIOSVersion nvarchar(255), null
SocketDesignation nvarchar(255), null
Speed nvarchar(255), null
StatusInfo int, null
txtStatusInfoDesc nvarchar(255), null
SystemDirectory nvarchar(255), null
SystemType nvarchar(255), null
TotalPhysicalMemory int, null
TypeDetail int, null
txtTypeDetailDesc nvarchar(255), null
UPSPort nvarchar(255), null
UserName nvarchar(255), null
Version nvarchar(255), null
VideoModeDescription nvarchar(255), null
VolumeSerialNumber nvarchar(255), null
WakeUpType int, null
txtWakeUpTypeDesc nvarchar(255), null

dbo.wDocument

Documents.

Column Type Description
lintAtomId int, not null
lintDocumentKindId int, not null
txtIdNumber2 nvarchar(255), null
txtMemo nvarchar(max), null
dteCreated datetime, null
lintResellerCompanyId int, null
lintSrcNodeId int, null
lintDestNodeId int, null
txtId nvarchar(255), null
txtResellerCompany nvarchar(255), null
liCreatedPersonId int, null
sCreatedPersonName nvarchar(255), null
dteRemoved datetime, null
liRemovedPersonId int, null
sRemovedPersonName nvarchar(255), null
TransferConfirmTypeId int, not null
SignDate datetime, null
SignPersonId int, null
SignedBy nvarchar(128), null
SignComputer nvarchar(255), null
intDocumentKindId int, not null
txtDocumentKind nvarchar(255), null
txtSrcNodeName nvarchar(255), null
txtDestNodeName nvarchar(255), null
txtLink int, null

dbo.wIdSeq

Numeric sequence.

Column Type Description
intIdSeqId int, not null
IdSeqTypeId int, null
IdSeqType nvarchar(32), not null
txtPrefix nvarchar(255), null
NextNumber nvarchar(60), null
txtSuffix nvarchar(255), null
sName nvarchar(255), null
sKindName nvarchar(255), null
liKindId int, null
bUse bit, not null

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.

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.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 request to read/unread by the person.

Parameters

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

dbo.spCloseHdTicket

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

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.spCreateNodeFromTemplate

Creates an object based of the object template definition.

Parameters

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

dbo.spCustomColumn_Add

Add new custom item.

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

dbo.spCustomColumn_Drop

Removing custom items.

Parameters

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

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 detection based on patters 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

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 procedures, create a new procedure named spHdSectionForRequesterSearch_Custom. 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

dbo.spHdSectionUpdateAllQueues

Updates the "Date according to queue" item for all requests within all services.

dbo.spHdSectionUpdateQueue

Updates the "Date according to queue" item for all requests within the @HdSectionId service.

Parameters

Name Type Description
@HdSectionId int

dbo.spHdTicketChangeHdSection

Moves the @iHdTicketId request to the @iHdSectionId service.

Parameters

Name Type Description
@iHdTicketId int
@iHdSectionId int
@iPersonId int

dbo.spHdTicketPassToSolver_ExceptionalSolverList

Returns a list of irregular solvers, used to assign requests listed in table #temp1. The procedure can be overloaded by custom procedure spHdTicketPassToSolver_ExceptionalSolverList_SolverList_Custom. 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 requests listed in table #temp1. The procedure can be overloaded by custom procedure spHdTicketPassToSolver_SolverList_Custom. 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 irregular solvers, used to assign the request when transitioning to the @iHdSectionId service.

Parameters

Name Type Description
@iHdSectionId int

dbo.spHdTicketPassToSolverInHdSection_SolverList

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

Parameters

Name Type Description
@iHdSectionId int

dbo.spHdTicketRecalcFirstReaction

Recomputes the solution of the first reaction for the request.

Parameters

Name Type Description
@ticketId int

dbo.spHdTicketRecalcNextActionDeadline

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

Parameters

Name Type Description
@ticketId int

dbo.spHdTicketResolve

Switches the request to Resolved.

Parameters

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

dbo.spHdTicketSolverAppointment

Returns the name and text of an event, which can be inserted into the solver's calendar via Assign to Solver.

Parameters

Name Type Description
@iHdTicketId int

dbo.spHdTicketSolverOpen

Reopens the request by the solver.

Parameters

Name Type Description
@iHdTicketId int
@iSolverPersonId int

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.spMoveNode

Moves the object in the object tree.

Parameters

Name Type Description
@node int
@target int
@person 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.

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 procedures, create a new procedure named spPersonSearch_Custom2. 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 value of this column is used in prompting persons in SD Console and in ALVAO Admin. 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.

dbo.spReadAllComunication

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

Parameters

Name Type Description
@PersonId int
@TicketId int

dbo.spReadAllDiary

Marks all request 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.

dbo.spRebuildLocalizationCache

Restores all the localization cache.

dbo.spRecomputeStats

Recalculates the statistics for all products in Monitoring. This function must be called by the Mon Server only.

Parameters

Name Type Description
@day datetime
@computer int

dbo.spRecomputeStatsForProduct

Recalculates the statistics for specific products in Monitoring. This function must be called by the Mon Server only.

Parameters

Name Type Description
@day datetime
@computer int
@productId int

dbo.spRefreshLicProductCoverage

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

Parameters

Name Type Description
@LicHistId int

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.

dbo.spRefreshSwProfileProductMembership

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

dbo.spRemoveApp

Deletes own application from Monitoring.

Parameters

Name Type Description
@AppId int

dbo.spRemoveDetectResults

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

Parameters

Name Type Description
@detlist nvarchar(max)

dbo.spRemoveDetects

Removes the specific detection (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.spSavePersonTicketDisplay

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

Parameters

Name Type Description
@ticketId int
@personId int

dbo.spSetDetailedRecordsAzureProperties

Sets the properties for saving detailed data from Monitoring to Azure.

Parameters

Name Type Description
@AccountName nvarchar(2048)
@SecretKey nvarchar(2048)
@Container nvarchar(2048)

dbo.spSetDetailedRecordsFolderProperties

Sets the properties for saving detailed data from Monitoring to a local folder.

Parameters

Name Type Description
@ServerPath nvarchar(2048)
@PortalPath nvarchar(2048)

dbo.spStateReqCol

Returns a table with required items for transitioning the request @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 requests by the specified string.

Parameters

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

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 item.

Parameters

Name Type Description
@ColumnId int

dbo.spUpdateHdSectionRightsCache

Updates the authorization cache on services.

dbo.spUpdateInsertProperty

Updates the value of the object properties in the tree. If the property does not exist, it is created.

Parameters

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

dbo.spUpdatePersonManager

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

dbo.spUpdatePropCache_All

Updates property inheritance for the whole database.

dbo.spUpdatePropCache_ObjMoved

Updates property inheritance after the object move in the tree.

Parameters

Name Type Description
@objId int

dbo.spUpdatePropCache_ObjNew

Updates property inheritance after a new object was created.

Parameters

Name Type Description
@objId int

dbo.spUpdatePropCache_PropDel

Updates property inheritance after the object properties were deleted.

Parameters

Name Type Description
@objId int
@kindId int

dbo.spUpdatePropCache_PropNew

Updates property inheritance after a new object property was added.

Parameters

Name Type Description
@propId int

dbo.spUpdatePropCache_PropValChanged

Updates property inheritance after a change in the property value.

Parameters

Name Type Description
@propId int

dbo.spUpdatePropCache_Subtree

Updates the property inheritance for a specific subtree.

Parameters

Name Type Description
@nodeId int

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
@propertyId int
@value nvarchar(255)
@personId int

dbo.spUpdateTicketDeadline

Updates the Request.Date item for changes made to the requested SLA.

Parameters

Name Type Description
@ticketId int
@slaId int
@newSlaId int

dbo.spUpdateTicketHoursToCurrentTarget

Recomputes the time elapsed from the previous operating hours interval to the due date of the current target, either for all requests with an internal target (when 1 is in @forceALL), for a specific request (when @ticketID is entered), or for all requests 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 requests with an internal goal.
@ticketId int Request number for which a recalculation will be forced.

dbo.spUpdateTicketLastAction

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

Parameters

Name Type Description
@TicketId int

dbo.spUpdateTicketShiftedDeadlines

Adjusts the Due date of resolution on the requests with specific SLA.

Parameters

Name Type Description
@slaId int

dbo.spUpdateUnassignedProcess

Updates the list of unrecognized applications in Monitoring.

dbo.spWebAppLoginDelay

Protection against password-guessing attack.

Parameters

Name Type Description
@loginTry int

dbo.DefaultSlaId

Returns the default SLA for on-duty requesters.

Parameters

Name Type Description
@iHdSectionId int
@iPersonId int

dbo.fAddressString

Formats the address properties from tAddress to one string.

Parameters

Name Type Description
@addressId int

dbo.fDate

Returns date without time only.

Parameters

Name Type Description
@datetime datetime

dbo.fDateHoursMinutes

Cut-off of seconds from date and time records.

Parameters

Name Type Description
@d datetime

dbo.fDeadline

Calculates deadline in the service working hours.

Parameters

Name Type Description
@liOpeningHours int
@dFrom datetime
@nHours float

dbo.fGetServerFromURL

Extracts only the server address from URL. Used in Monitoring.

Parameters

Name Type Description
@Url nvarchar(1024)

dbo.fHtmlString

Encodes a string as valid HTML, including ends of lines.

Parameters

Name Type Description
@s nvarchar(4000)

dbo.fLastLevelDomain

Returns the last level of the domain.

Parameters

Name Type Description
@LoginWithDomain nvarchar(255)

dbo.fnCheckRelCycles

Checks the circular task link between requests.

Parameters

Name Type Description
@trId int
@ticketBegin int
@ticketEnd int
@relTypeId int

dbo.fnCheckRelCyclesLicHist

Function for reviewing a circular task.

Parameters

Name Type Description
@nrId int
@beginLicHistId int
@endLicHistId int
@relTypeId int

dbo.fnCheckRelCyclesNode

Function for reviewing a circular task.

Parameters

Name Type Description
@nrId int
@beginNodeId int
@endNodeId int
@relTypeId int

dbo.fnCheckRelDuplicity

Checks the link between requests for duplicity.

Parameters

Name Type Description
@trId int
@ticketBegin int
@ticketEnd int
@relTypeId int

dbo.fnCheckRelOneToMany

Checks whether the request has maximum one link of the 1:N type.

Parameters

Name Type Description
@trId int
@ticketBegin int
@ticketEnd int
@relTypeId int

dbo.fnFileStringInfoCsvSignature

CSV file signature from FileStringInfo part.

Parameters

Name Type Description
@id int

dbo.fnFindAssetUserFromPerson

According to PersonId of the user in Admin NodeId finds the user in the objects tree in AM.

Parameters

Name Type Description
@personId int

dbo.fnFloatHourToTimeString

Converts the value of hours from a floating point number into a text string in the h:mm format.

Parameters

Name Type Description
@hours float

dbo.fnFloatToCharExactLength

The function returns a number (float) as a string with the set minimum length of the integer part and the maximum length of the fractional part, which is guaranteed by completing with zeroes, or rounding where applicable. The maximum length is 50, which is an appropriately selected constant.

Parameters

Name Type Description
@value float
@intLen int
@decLen int

dbo.fnGetBackupKindName

Suffix of properties with original data in which the conversion to another data type failed.

Parameters

Name Type Description
@intKindId int

dbo.fnGetNextTicketId

Function returns id of newly created request.

dbo.fnGetUnreadCount

Number of unread events of the person on request.

Parameters

Name Type Description
@PersonId int
@TicketId int

dbo.fnHdSectionWithoutLast

The function returns the full service name (path) excluding the name of the service

Parameters

Name Type Description
@SectionId int

dbo.fnLastLocalMidnightUtc

The calculation of the last local midnight according to UTC time and the time zone.

Parameters

Name Type Description
@utc datetime
@tzuid nvarchar(128)

dbo.fnLocalTime

Converts UTC data to the specific time zone.

Parameters

Name Type Description
@utc datetime
@tzuid nvarchar(128)

dbo.fnNextLocalMidnightUtc

The calculation of the following local midnight according to UTC time and the time zone.

Parameters

Name Type Description
@utc datetime
@tzuid nvarchar(128)

dbo.fnPersonLoginWithoutDomain

Username of a person without a domain.

Parameters

Name Type Description
@sPersonLogin nvarchar(255)

dbo.fnReportedTime

The calculation of time reported on the selected day and for the selected employee.

Parameters

Name Type Description
@utc datetime
@tzuid nvarchar(128)
@personId int

dbo.fnStartWorkTime

The calculation of the time at which the selected employee began working on the selected day.

Parameters

Name Type Description
@utc datetime
@tzuid nvarchar(128)
@personId int

dbo.fnTodayHour

Converts a floating point number into the item type date and time where date is today's date and time is transferred from the parameter.

Parameters

Name Type Description
@hour float

dbo.fnUtcTime

UTC time calculated from the local time and time zones.

Parameters

Name Type Description
@local datetime
@tzuid nvarchar(128)

dbo.fnWorkTimeAtDay

The calculation of the worked on the selected day for the selected employee.

Parameters

Name Type Description
@utc datetime
@tzuid nvarchar(128)
@personId int

dbo.fnWorkTimeToday

The calculation of the time at which the selected employee began working on the selected day. The calculation does not consider the end of the day, only up to "now"

Parameters

Name Type Description
@utc datetime
@tzuid nvarchar(128)
@personId int

dbo.fRelatedCompany

Request - "Related Organizations" item

Parameters

Name Type Description
@iHdTicketId int

dbo.fStripDomain

Username of a user without a domain.

Parameters

Name Type Description
@LoginWithDomain nvarchar(255)

dbo.fSuggestResolutionDate

Default due date by SLA.

Parameters

Name Type Description
@Ticketid int

dbo.GetProperty

Returns 1 value from the tProperty table based on the set code.

Parameters

Name Type Description
@key nvarchar(255)

dbo.ftApprovers

Position for determining the approvers of a specific approval step”.

Parameters

Name Type Description
@approvalItemId int

Return table

Column Type Description
iPersonId int
sPerson nvarchar(1024)
sPersonEmail nvarchar(1024)

dbo.ftAttendanceMonthReport

Function that creates the table for the employee's monthly report

Parameters

Name Type Description
@month int
@year int
@personId int
@curPersonId int

Return table

Column Type Description
id int
day datetime
lastMidnight datetime
nextMidnight datetime
isWeekend bit
workTime float
holiday nvarchar(255)
doLink bit
coverWithWorkLoad bit
tolerance int

dbo.ftCanManageKnowledge

List of services and articles that the given user may administer.

Parameters

Name Type Description
@userId int

Return table

Column Type Description
SectionId int
ArticleId int

dbo.ftCommaListToTableIds

Conversion of value list string (ID,ID,...) to value table.

Parameters

Name Type Description
@list nvarchar(max)

Return table

Column Type Description
id int

dbo.ftCompanySearch

Search of organizations across all system items.

Parameters

Name Type Description
@sample nvarchar(100)
@accountId int

Return table

Column Type Description
AccountId int
CompanyInfo nvarchar(300)
Address nvarchar(max)
Address2 nvarchar(max)
ItemOrder int

dbo.ftComputerSwManager

People responsible for software installed on the computer

Parameters

Name Type Description
@ComputerId int

Return table

Column Type Description
ComputerId int
SwManagerNodeId int
SwManagerPersonId int

dbo.ftDeviceSearch

Searching for a device in the tree. Returns a table of devices matching the entered parameters arranged by the path in the tree. The function can be customized. In order to customize the function, create a new function named ftDeviceSearch_Custom2. For a proper functionality of ALVAO applications, the function must receive the same parameters as the original functions and return the same columns.

Parameters

Name Type Description
@sample nvarchar(300) Searched string. The search proceeds in the path of the tree, object name, kind, serial number, inventory number and asset number. If empty or NULL, the function returns only the assets entrusted to the requester. Otherwise, the function returns also objects that the user is authorized to see.
@nodeId int ID of the object currently selected. It will be shown as the first in the result.
@count int Number of items in the return table.
@personId int Signed-in user ID.
@requesterId int ID of the selected request requester.

Return table

Column Type Description
DeviceId int Device ID.
DeviceInfo nvarchar(300) Shown name in the menu in the form: "object kind: device name; inventory number, asset number, serial number".
DeviceIconId int Icon ID.
DevicePath nvarchar(1024) Path to object in tree.
ItemOrder int The value by which the result is sorted.

dbo.ftLicHistBase

List of licenses.

dbo.ftLicHistBase

List of licenses.

Return table

Name Type Description
intLicHistId int
dteDate datetime
txtLicName nvarchar(255)
intCountChange int
txtProductName nvarchar(255)
txtResellerCompany nvarchar(255)
txtLicMode nvarchar(255)
txtLicLang nvarchar(255)
txtLicType nvarchar(255)
txtProductType nvarchar(255)
intCurrentCount int
intAssignedCount int
dteDateExpire datetime
txtActivationKey nvarchar(1024)
txtInventoryNum nvarchar(255)
txtInvoice nvarchar(255)
txtLang nvarchar(255)
bolDowngrade bit
txtMemo nvarchar(max)

dbo.ftLicHistRelations

The function to generate the list of links for the selected license.

Parameters

Name Type Description
@licHistId int

Return table

Column Type Description
id int
LicHistRelationTypeId int
ModifiedDate datetime
ModifiedByPerson nvarchar(255)
Straight bit
BeginLicHistId int
BeginLicHistRelation nvarchar(32)
BeginDteDate datetime
BeginTxtLicName nvarchar(255)
BeginIntCountChange int
BeginTxtProductName nvarchar(255)
BeginTxtResellerCompany nvarchar(255)
BeginTxtLicMode nvarchar(255)
BeginTxtLicLang nvarchar(255)
BeginTxtLicType nvarchar(255)
BeginTxtProductType nvarchar(255)
BeginIntCurrentCount int
BeginIntAssignedCount int
BeginDteDateExpire datetime
BeginTxtActivationKey nvarchar(1024)
BeginTxtInventoryNum nvarchar(255)
BeginTxtInvoice nvarchar(255)
BeginTxtLang nvarchar(255)
BeginBolDowngrade bit
BeginTxtMemo nvarchar(max)
EndLicHistId int
EndLicHistRelation nvarchar(32)
EndDteDate datetime
EndTxtLicName nvarchar(255)
EndIntCountChange int
EndTxtProductName nvarchar(255)
EndTxtResellerCompany nvarchar(255)
EndTxtLicMode nvarchar(255)
EndTxtLicLang nvarchar(255)
EndTxtLicType nvarchar(255)
EndTxtProductType nvarchar(255)
EndIntCurrentCount int
EndIntAssignedCount int
EndDteDateExpire datetime
EndTxtActivationKey nvarchar(1024)
EndTxtInventoryNum nvarchar(255)
EndTxtInvoice nvarchar(255)
EndTxtLang nvarchar(255)
EndBolDowngrade bit
EndTxtMemo nvarchar(max)

dbo.ftLicHistSearch

The function to search for the license.

Parameters

Name Type Description
@sample nvarchar(300)
@licHistId int
@count int

Return table

Column Type Description
LicHistId int
LicHistInfo nvarchar(300)
ItemOrder int

dbo.ftNodeRelations

Function that generates a list of links for the selected object with disabled tree rights.

Parameters

Name Type Description
@nodeId int
@showHidden bit

Return table

Column Type Description
id int
NodeRelationTypeId int
BeginNodeId int
BeginNodeRelation nvarchar(32)
BeginNodeKind nvarchar(255)
BeginNodeName nvarchar(255)
BeginNodePath nvarchar(1024)
EndNodeId int
EndNodeRelation nvarchar(32)
EndNodeKind nvarchar(255)
EndNodeName nvarchar(255)
EndNodePath nvarchar(1024)
ModifiedDate datetime
ModifiedByPerson nvarchar(255)
Straight bit
Level int

dbo.ftPersonFromLogin

Search person according to login name

Parameters

Name Type Description
@login nvarchar(255)

Return table

Column Type Description
id int
Person nvarchar(255)
Login nvarchar(255)
Email nvarchar(255)
Pswd nvarchar(255)
System bit
AccountDisabled bit
Hidden bit
Guest bit
SID nvarchar(255)
AdGuid nvarchar(255)

dbo.ftPersonSearchExtended

Extended search of persons across all system items.

Parameters

Name Type Description
@sample nvarchar(100)
@accountId int
@guest bit
@personId int

Return table

Column Type Description
PersonId int
PersonInfo nvarchar(300)
ItemOrder int

dbo.ftRelation

Linked request. The function is used to populate the fields in the dialog for updating selected links (@trId) on the Request links tab @ticketId.

Parameters

Name Type Description
@trId int
@ticketId int

Return table

Column Type Description
BeginHdTicketId int
EndHdTicketId int
TicketRelationTypeId int

dbo.ftRelations

Linked requests to a specific request (@ticketId), which a specific user has the rights to view (@userId): The function is used to display linked requests on the Links tab.

Parameters

Name Type Description
@ticketId int
@userId int

Return table

Column Type Description
Relation nvarchar(30)
iHdTicketId int
sHdTicket nvarchar(1024)
sHdSection nvarchar(255)
sHdTicketStateNotice nvarchar(255)
sHdTicketCustomWorkflowUrl nvarchar(1024)
sHdTicketMessageTag nvarchar(255)
TrId int
dHdTicketResolved datetime
ItemOrder int

dbo.ftRelationsAll

Linked requests to a specific request.

Parameters

Name Type Description
@ticketId int
@userId int

Return table

Column Type Description
Relation nvarchar(30)
iHdTicketId int
sHdTicket nvarchar(1024)
sHdSection nvarchar(255)
sHdTicketStateNotice nvarchar(255)
sHdTicketCustomWorkflowUrl nvarchar(1024)
sHdTicketMessageTag nvarchar(255)
TrId int
dHdTicketResolved datetime
ItemOrder int

dbo.ftRelationsTypes

Types of links between requests. The function is used to populate the link menu.

Parameters

Name Type Description
@localeId int

Return table

Column Type Description
relIdDir int
BeginName nvarchar(200)
EndName nvarchar(200)
MenuOrderStr nvarchar(200)
LocalizedBeginName nvarchar(200)
LocalizedEndName nvarchar(200)

dbo.ftTicketsStateIntersectList

The intersection of statuses for @TicketIds requests, which you can transition to from request statuses, with the exception to Resolved.

Parameters

Name Type Description
@TicketIds nvarchar(200)

Return table

Column Type Description
id int
TicketState nvarchar(30)
Order int
TicketStateBehaviorId int

dbo.ftTicketStateList

The list of statuses for the @TicketIds request, which you can transition to from the current status, with the exception to Resolved.

Parameters

Name Type Description
@TicketId int

Return table

Column Type Description
id int
TicketState nvarchar(30)
Order int
TicketStateBehaviorId int

dbo.ftTicketStateListIncResolved

The list of statuses for the @TicketIds request, which you can transition to from the current status.

Parameters

Name Type Description
@TicketId int

Return table

Column Type Description
id int
TicketState nvarchar(30)
Order int
TicketStateBehaviorId int

dbo.ftTicketStateMultiList

Function for the return of the intersection of possible states (including Solved/Closed) for multiple requests.

Parameters

Name Type Description
@TicketIds nvarchar(max)

Return table

Column Type Description
id int
TicketState nvarchar(30)
Order int
TicketStateBehaviorId int

dbo.tfDay

Calendar of days starting with @Begin to @End (excluding).

Parameters

Name Type Description
@Begin datetime
@End datetime

Return table

Column Type Description
dDay datetime

dbo.tfHdTicketFulltextSearch

Requests found by full text search of sample @sample.

Parameters

Name Type Description
@search ntext

Return table

Column Type Description
liHdTicketFulltextSearchHdTicketId int
iHdTicketFulltextSearchScore int

dbo.tfPersonManager

Direct managers.

dbo.tfPersonManager

Direct managers.

Return table

Name Type Description
liPersonManagerSubordinatePersonId int
liPersonManagerManagerPersonId int

dbo.tfSplitString

The function divides the value based on a preset separator.

Parameters

Name Type Description
@string nvarchar(1024)
@splitChar nvarchar(1)

Return table

Column Type Description
word nvarchar(1024)

 

Did not find what you were looking for? Ask our technical support team.