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


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 Seznam důvěryhodných domén.
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.
HdSectionMessageTag dbo Unique service prefix and suffix pair.
IdSeqType dbo Numeric sequence types.
KindDataType dbo Property data types in AM.
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.
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.
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.
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
tAdviceRule dbo Notification sending rule.
tAdviceRuleEventKind dbo Notification sending event.
tAdviceRuleRecipientKind dbo Kinds of the notification recipients.
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 ALVAO Monitoring.
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.
tHdBranch dbo Request.Field item values.
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.
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 Authorization individuals and groups have for records on the activities of other individuals and groups within the ALVAO Monitoring product.
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 ALVAO Monitoring 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 technologies with ALVAO Monitoring.
tWorkLoad dbo Employee labor contracts.
tWorkTime dbo Employee attendance record created in the ALVAO Attendance module.
tWorkTimeSnapshot dbo Employee attendance records used by ALVAO Monitoring 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 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.
Node dbo "Objects" in AM.
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.
Požadavky dbo Requests. The view is designated for creating analyses and reports.
Průtok požadavků - historie dbo Materials for analyzing the number of open requests over time.
Průtok požadavků za 1 měsíc dbo Materials for analyzing the number of open requests over time limited to the last month.
Průtok požadavků za 2 měsíce dbo Materials for analyzing the number of open requests over time limited to the last 2 months.
Request dbo Requests. The view is designated for creating analyses and reports.
Request Week Statistics dbo Materials for the weekly request statistics report.
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.
vHdSectionManager dbo Effective service managers.
vHdSectionOperator dbo Effective service operators.
vHdSectionOperator_Direct dbo Effective service operators without absentee stand-ins.
vHdSectionPerson dbo Effective settings of notifications sent from the services to individual persons.
vHdSectionReader dbo Effective readers in services.
vHdSectionSolver dbo Effective service solvers.
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.
vIdSeqProperty dbo Definitions of automatic codes lists for the generation of the properties values.
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 authorization individuals and groups have for records on the activities of other individuals and groups within the ALVAO Monitoring product.
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.
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.
vSlaAlertInactiveApplicants dbo Individual SLA notifications for requester inactivity.
vSlaAlertInactiveApprobators dbo Individual SLA notifications for approver inactivity.
vSlaAlertInactiveOperators dbo Individual SLA notifications for operator inactivity.
vSlaAlertInactiveSolvers dbo Individual SLA notifications for solver inactivity.
vSlaAlertInactiveSummary dbo Summary SLA notification for inactivity (requesters, approvers, operators and solvers).
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.
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_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_SolverList dbo Returns a list of solvers, used to assign the request when transitioning to the @iHdSectionId service.
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.
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:
<br /><b>PersonId</b> - contains Id of the User found. We do not recommend customizing.
<br /><b>PersonEmail</b> - contains the primary e-mail of the User found. We do not recommend customizing.
<br /><b>PersonEmail2</b> - it contains the secondary e-mail of the User found by default. We do not recommend customizing.
<br /><b>DisplayLine1</b> - 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.
<br /><b>DisplayLine2</b>  - 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.
<br /><b>DisplaySingleLine</b> - 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.
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.
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.
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.
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 table functions

Table function Scheme Description
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.
ftHdSectionForRequesterSearch dbo Searching for the Requester’s services. Returns a table of services matching the entered parameters arrangedby the path in the tree. The function can be customized. In order to customize the function, create a new procedure named ftHdSectionForRequesterSearch_Custom. 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 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 Cutting off seconds from the item type date and time.
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 triggers

Trigger Scheme Table Description
T_tAct_Insert dbo tAct
T_tHdTicketCust_Insert dbo tHdTicket
TR_LicDowngrade_LogChanges dbo LicDowngrade
TR_LicHist_LogChanges dbo tblLicHist
TR_LicHistAtom_LogChanges dbo tblLicHistAtom
TR_LicHistCust dbo tblLicHist
TR_LicHistCust_LogChanges dbo LicHistCust
TR_LicHistItem_LogChanges dbo tblLicHistItem
TR_LicHistRelation_LogChanges dbo LicHistRelation
TR_tAccountCust dbo tAccount
TR_tAct_Insert_Update_Delete dbo tAct
TR_tAct_MarkEmbededImagesInActHtml dbo tAct A trigger which indicates the images inserted in the text.
TR_tAct_UpdatePersonTicketDisplay dbo tAct Update the status of the “reading” request
TR_tArticle_MarkEmbededImagesInHtml dbo tArticle A trigger which indicates the images inserted in the text.
TR_tblInstHist_RemoveLicTrans dbo tblInstHist Deletes the coverage of the product by licenses in case the product will be uninstalled or deleted.
TR_tblProperty_SetNodeIdValue dbo tblProperty Trigger that sets the value for the new properties of "User" type.
TR_tColumnValue_UpdateLocCache dbo tColumnValue A trigger which updates the cache localizations.
TR_tEmailSignature_MarkEmbededImagesInHtml dbo tEmailSignature A trigger which indicates the images inserted in the text.
TR_tHdSection_UpdateLocCache dbo tHdSection A trigger which updates the cache localizations.
TR_tHdSectionCust dbo tHdSection
TR_tHdTicket_CalculateTicketStateId dbo tHdTicket
TR_tHdTicketApproval_MarkEmbededImagesInHtml dbo tHdTicketApproval A trigger which indicates the images inserted in the text.
TR_tHdTicketApproval_UpdatePersonTicketDisplay dbo tHdTicketApproval Update the status of the “reading” request
TR_tHdTicketApprovalItem_Insert_Update_Delete dbo tHdTicketApprovalItem
TR_tHdTicketApprovalItem_MarkEmbededImagesInHtml dbo tHdTicketApprovalItem A trigger which indicates the images inserted in the text.
TR_tHdTicketApprovalItem_UpdatePersonTicketDisplay dbo tHdTicketApprovalItem Update the status of the “reading” request
TR_TicketChange_Insert_Update_Delete dbo TicketChange
TR_TicketState_UpdateLocCache dbo TicketState A trigger which updates the cache localizations.
TR_TicketType_UpdateLocCache dbo TicketType A trigger which updates the cache localizations.
TR_tLocale_UpdateLocCache dbo tLocale A trigger which updates the cache localizations.
TR_tLocalization_UpdateLocCache dbo tLocalization A trigger which updates the cache localizations.
TR_tPersonCust dbo tPerson
TR_tSla_UpdateLocCache dbo tSla A trigger which updates the cache localizations.
TR_tSlaCust dbo tSla
TR_tString_UpdateLocCache dbo tString A trigger which updates the cache localizations.

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

AdTrustedDomain

Seznam důvěryhodných domén.

Column Type Description
id int, not null Record ID.
DomainName nvarchar(128), not null Název domény v "tečkované" notaci.
Hostname nvarchar(32), not null Název v síti serveru, na kterém běží doménový řadič.
Order int, not null Pořadí, v jakém bude ImportAD zkoušet servery replikovaného řadiče stejné domény.
Skip bit, not null 1=při importu přeskakovat členy z této domény.

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

ArticleHdSection

Assigning articles from the knowledge base to services.

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

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

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.

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.

EmailSignatureHdSection

Assigning signatures to services.

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

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.

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

IdSeqType

Numeric sequence types.

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

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.

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

LicHistCust

License custom items values.

Column Type Description
LicHistId int, null

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.

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.

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.

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.

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.

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

LicKind

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

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

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

LicType

License types.

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

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

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.
ShowBeginDate datetime, null Date from which the current message shall be displayed.
ShowEndDate datetime, null Date until which the current message shall be displayed.
CreatedByPersonId int, not null User who created the current message.

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.

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.

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.

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.

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.

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.

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

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.

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.

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

Printer

Printers

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

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

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

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

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

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

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

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.

RoleBehavior

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

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

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.

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.

RoleMembershipLogOperation

Executed operation which is logged.

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

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.

SamAlertConfig

SAM configuration of notifications.

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

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

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

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

SlaAlertRuleReceiver

Notice for unresolved requests - other recipients.

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

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.

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.

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.

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.

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

tAccountCust

Organization custom items values.

Column Type Description
liAccountId int, null

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

tActHd

Expanding tAct information for the request log.

Column Type Description
liActHdActId int, not null Link to event.
bActHdUserRead bit, not null If the value is 1, the requester can see this event on the portal

tActKind

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

Column Type Description
iActKindId int, not null Record ID
sActKind nvarchar(255), null Naming the type of event
iActKindOrder int, null Order in which records are displayed.
Removable bit, not null

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

tAdviceRule

Notification sending rule.

Column Type Description
iAdviceRuleId int, not null
liAdviceRuleSlaId int, null
liAdviceRuleHdSectionId int, null
liAdviceRuleAdviceRuleEventKindId int, not null
nAdviceRuleHours float, null
liAdviceRuleAdviceRuleRecipientKindId int, not null
liAdviceRuleRecipientPersonId int, null
sAdviceRuleRecipientEmail nvarchar(1024), null
bAdviceRuleUrgent bit, null

tAdviceRuleEventKind

Notification sending event.

Column Type Description
iAdviceRuleEventKindId int, not null
sAdviceRuleEventKind nvarchar(255), null

tAdviceRuleRecipientKind

Kinds of the notification recipients.

Column Type Description
iAdviceRuleRecipientKindId int, not null
sAdviceRuleRecipientKind nvarchar(255), null

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 Automatické schválení kroků se stejným schvalovatelem.

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

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

tBankHoliday

National holidays.

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

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

tBankHolidayRegion

Local national holiday regions.

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

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

tblAsset

Identification numbers of documents and media.

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

tblAtom

Kind of record - document / medium.

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

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

tblClass

ID of the objects types. Texts in tblDict.

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

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

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

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

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

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.

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.

tblDetectKind

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

Column Type Description
intDetectKindId int, not null

tblDetectMethod

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

Column Type Description
intDetectMethodId int, not null

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

tblDetectStatus

ID of the detections statuses. Texts in tblDict.

Column Type Description
intDetectStatusId int, not null

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

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

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.

tblDocumentKind

Kinds of documents. Texts in tblDict

Column Type Description
intDocumentKindId int, not null

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

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.

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

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

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

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

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)

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.

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.

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

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

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

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

tblInventoryAssetPackRel

Stocktaking - assignment of assets to readers.

Column Type Description
lintInventoryAssetPackId int, null
lintInventoryAssetId int, null

tblInventoryAtom

Stocktaking - documents.

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

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
bAccounting bit, not null 1 = "accountant" role can edit the values of this property.
CleanValueByCopying bit, not null 1 = Delete value when copying properties
KindDataTypeId int, not null Property data type ID.

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

tblLang

ID of languages. Text in tblDict

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

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.

tblLicHistAtom

License - links to documents and media.

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

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

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

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

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

tblMediaType

ID of the media types. Texts in tblDict.

Column Type Description
intMediaTypeId int, not null

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

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.

tblNodeAtom

Objects in the tree - links to documents.

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

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

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

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

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

tblProductCategory

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

Column Type Description
intProductCategoryId int, not null

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

tblProductType

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

Column Type Description
intProductTypeId int, not null

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.

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

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

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

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

tblSetting

Mapping properties to system functions.

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

tblSwLibUpdate

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

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

tblSystemSetting

System settings.

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

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

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

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

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

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

tblWbemObjectRel

Links between the detected components of the computers.

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

tBuilding

Buildings, see item Request.Building.

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

tColumn

List of custom items and certain system items.

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

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.

tComputer

Computers for ALVAO Monitoring.

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.

tDay

Calendar of days

Column Type Description
dDay datetime, not null

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

tDetectedClassKind

Detected properties of the computer components.

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

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

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

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.

tHdBranch

Request.Field item values.

Column Type Description
iHdBranchId int, not null Record ID.
sHdBranch nvarchar(255), null Full area name Contains the full path to the tree root, for example "A/B".
sHdBranchShort nvarchar(255), null Shortened area name, for example "B"
nHdBranchOrder float, null Order in which areas are displayed.
liHdBranchHdSectionId int, null Link to service in which the area is found.
liHdBranchParentHdBranchId int, null Link to ancestor in tree of areas. Root area has NULL link.

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, 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

tHdSectionCust

Services custom items values.

Column Type Description
liHdSectionId int, null

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

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

tHdTicket

Requests.

Column Type Description
sHdTicket nvarchar(1024), null Request name
mHdTicketNotice nvarchar(max), null Notes to the request.
liHdTicketUserPersonId int, 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.
sHdTicketHdBranch nvarchar(255), null Area.
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 "Resolution speed“ item on satisfaction survey.
FeedbackProfessionality int, null "Professionalism“ item on satisfaction survey.
FeedbackExpertise int, null "Expertise“ item on satisfaction survey.
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.

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

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

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

tHdTicketApprovalItemResult

List of approval step statuses.

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

tHdTicketCategory

Request.Category item values.

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

tHdTicketCust

Request custom items values.

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

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

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

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

TicketRelationTypeBehavior

System types of links between requests.

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

TicketSequence

A table containing the next request number.

Column Type Description
NextTicketId int, not null Next request number

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.

TicketStateBehavior

Workflow system statuses defined within Processes.

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

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.

TicketStateRelation

Permitted transitions between Workflow statuses.

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

TicketStateRequiredColumn

Mandatory items for individual Workflow statuses.

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

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

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.

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

TicketTypeBehavior

System processes.

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

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

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.

tIdSeqClass

Numerical series - definitions for types of objects.

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

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.

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.

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.

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.

tNodeProduct

Software profiles - exceptions for the computer.

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

tOpeningHours

Service working hours.

Column Type Description
iOpeningHoursId int, not null
sOpeningHours nvarchar(255), null
mDescription nvarchar(max), null
mNotes nvarchar(max), null

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

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

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 Počáteční datum a čas nepřítomnosti.
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 Koncové datum a čas nepřítomnosti.
IsOutOfOffice bit, not null Identifikátor, zda je uživatel nepřítomen. Automaticky počítaný sloupec.

tPersonCust

Persons in the ALVAO system - own items.

Column Type Description
liPersonId int, null

tPersonRights

Authorization individuals and groups have for records on the activities of other individuals and groups within the ALVAO Monitoring product.

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

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

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

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.

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.

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.

TransferConfirmType

Method of the assets takeover signing.

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

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

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.

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.

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

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

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.

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.

tSlaCust

SLA custom items values.

Column Type Description
liSlaId int, null

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

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

tString

System code list for texts.

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

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

tSwPresence

Software profiles - product statuses.

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

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

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

tSwProfileSwProfile

Software profiles - sub-profiles.

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

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

tTimeOffKind

Types of employee absence records.

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

tUnassignedProcess

Processes, which ALVAO Monitoring 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

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

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

tWMIDefaultSetting

Default settings for using WMI technologies with ALVAO Monitoring.

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

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.

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

tWorkTimeSnapshot

Employee attendance records used by ALVAO Monitoring 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

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

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.

UserLogonLogAction

Executed action which is logged.

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

UserLogonLogApplication

Application name.

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

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.

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.

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
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
Domain Component 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
Codepage nvarchar(255), null

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

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
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
Domain Component 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
Codepage nvarchar(255), null

Node

"Objects" in AM.

Column Type Description
Node Id int, not null

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.

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.

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.

Požadavky

Requests. The view is designated for creating analyses and reports.

Column Type Description
Číslo požadavku int, not null
Žadatel nvarchar(255), null
Organizace (žadatel) nvarchar(255), null
Sekce nvarchar(255), null
Skupina nvarchar(255), null
Název požadavku nvarchar(1024), null
Řešitel nvarchar(255), null
Oddělení (řešitel) nvarchar(255), null
Funkce (řešitel) nvarchar(255), null
Obor nvarchar(255), null
Kategorie nvarchar(255), null
Priorita nvarchar(max), null
SLA nvarchar(255), null
Status nvarchar(8), not null

Průtok požadavků - historie

Materials for analyzing the number of open requests over time.

Column Type Description
Číslo požadavku int, not null
Žadatel nvarchar(255), null
Organizace (žadatel) nvarchar(255), null
Sekce nvarchar(255), null
Název požadavku nvarchar(1024), null
Řešitel nvarchar(255), null
Oddělení (řešitel) nvarchar(255), null
Funkce (řešitel) nvarchar(255), null
Obor nvarchar(255), null
Kategorie nvarchar(255), null
Skupina nvarchar(255), null
Priorita nvarchar(max), null
SLA nvarchar(255), null
Datum datetime, not null
Operace nvarchar(10), not null
Změna počtu otevřených požadavků int, not null
Týden od datetime, null
Měsíc od datetime, null
Rok int, null
Čtvrtletí int, null
Měsíc int, null
Týden int, null
Hodina int, null

Průtok požadavků za 1 měsíc

Materials for analyzing the number of open requests over time limited to the last month.

Column Type Description
Číslo požadavku int, not null
Žadatel nvarchar(255), null
Organizace (žadatel) nvarchar(255), null
Sekce nvarchar(255), null
Název požadavku nvarchar(1024), null
Řešitel nvarchar(255), null
Oddělení (řešitel) nvarchar(255), null
Funkce (řešitel) nvarchar(255), null
Obor nvarchar(255), null
Kategorie nvarchar(255), null
Skupina nvarchar(255), null
Priorita nvarchar(255), null
SLA nvarchar(255), null
Datum datetime, not null
Operace varchar, not null
Změna počtu otevřených požadavků int, not null
Týden od datetime, null
Měsíc od datetime, null
Rok int, null
Čtvrtletí int, null
Měsíc int, null
Týden int, null
Hodina int, null

Průtok požadavků za 2 měsíce

Materials for analyzing the number of open requests over time limited to the last 2 months.

Column Type Description
Číslo požadavku int, not null
Žadatel nvarchar(255), null
Organizace (žadatel) nvarchar(255), null
Sekce nvarchar(255), null
Název požadavku nvarchar(1024), null
Řešitel nvarchar(255), null
Oddělení (řešitel) nvarchar(255), null
Funkce (řešitel) nvarchar(255), null
Obor nvarchar(255), null
Kategorie nvarchar(255), null
Skupina nvarchar(255), null
Priorita nvarchar(255), null
SLA nvarchar(255), null
Datum datetime, not null
Operace varchar, not null
Změna počtu otevřených požadavků int, not null
Týden od datetime, null
Měsíc od datetime, null
Rok int, null
Čtvrtletí int, null
Měsíc int, null
Týden int, null
Hodina int, null

Request

Requests. The view is designated for creating analyses and reports.

Column Type Description
iHdTicketId int, not null
Ticket Id nvarchar(255), null
Request Name nvarchar(1024), null
Service nvarchar(255), null
SLA nvarchar(255), null
Applicant Name nvarchar(255), null
Applicant Organization nvarchar(255), null
Category nvarchar(255), null
Branch nvarchar(255), null
Group nvarchar(255), null
Solver Name nvarchar(255), null
Request Created datetime, null
Request Resolved datetime, null
Duration Hours float, null
Request Removed datetime, null
Request Deadline datetime, null
Last Activity datetime, null
Applicant Account nvarchar(255), null
Open Time Hours float, null
Waiting For Applicant Hours float, null
Waited For Applicant Hours float, null

Request Week Statistics

Materials for the weekly request statistics report.

Column Type Description
Week From datetime, null
Service nvarchar(255), null
SLA nvarchar(255), null
Applicant Name nvarchar(255), null
Applicant Organization nvarchar(255), null
Category nvarchar(255), null
Branch nvarchar(255), null
Group nvarchar(255), null
Solver Name nvarchar(255), null
Last Activity datetime, null
Requests Created int, not null
Requests Resolved int, not null
Requests Removed int, not null
Left Open int, not null
Deadline Missed int, not null
Average Solution Hours float, not null
Minimal Solution Hours float, null
Maximal Solution Hours float, not null

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.

Software

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

Column Type Description
ComputerNodeId int, 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(255), null License activation number.
LicenseInvoiceNumber nvarchar(255), null License invoice number.
LicenseCertificateNumber nvarchar(255), null License certificate number.
Authorized bit, 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, null Software product type. 1 - commercial 2 - freeware 3 - shareware/trial 4 - not specified
User int, null Author of the product installation.
Comment nvarchar(255), null Installation comment.

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
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
Domain Component 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
Codepage nvarchar(255), null

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.

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

vApprovalAuthority

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

Column Type Description
liApprovalAuthorityHdTicketId int, null
liApprovalAuthorityPersonId int, null

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

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

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

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

vClass

Types of objects.

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

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

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), not null
LocalizedColumnValueShort nvarchar(max), not null

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

vComputerDetectLast

Last detection of the computers.

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

vComputerSwManager

People and their superiors responsible for software installed on the computer

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

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

vDefaultSla

Default SLA for individuals and services.

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

vDetectKind

Types of detections (HW, SW).

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

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

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
SignComputer nvarchar(255), null
sRemovedPersonName nvarchar(255), null
txtId nvarchar(255), null
txtResellerCompany nvarchar(255), null
txtLink int, null

vDocumentKind

Kinds of documents.

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

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

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

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

vHdSectionExceptionalSolver

Effective irregular solvers in services.

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

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
iHdSectionLocaleId int, not null LCID of the language for which the localization is executed
LocalizedSection nvarchar(max), null Localized full service name.
LocalizedSectionShort nvarchar(max), null Localized short service name.
LocalizedSectionDesc nvarchar(max), null Localized service description.

vHdSectionManager

Effective service managers.

Column Type Description
liHdSectionManagerHdSectionId int, not null Link to service in which the user is the manager.
liHdSectionManagerPersonId int, null Link to user.

vHdSectionOperator

Effective service operators.

Column Type Description
liHdSectionOperatorHdSectionId int, not null Link to service in which the user is the operator.
liHdSectionOperatorPersonId int, null Link to user

vHdSectionOperator_Direct

Effective service operators without absentee stand-ins.

Column Type Description
liHdSectionOperatorHdSectionId int, not null
liHdSectionOperatorPersonId int, null

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

vHdSectionReader

Effective readers in services.

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

vHdSectionSolver

Effective service solvers.

Column Type Description
liHdSectionSolverHdSectionId int, not null Link to service in which the user is the solver.
liHdSectionSolverPersonId int, null Link to user.

vHdSectionSolverTake1

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

Column Type Description
liHdSectionSolverTake1HdSectionId int, not null
liHdSectionSolverTake1PersonId int, null

vHdSectionSolverTake2

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

Column Type Description
liHdSectionSolverTake2HdSectionId int, not null
liHdSectionSolverTake2PersonId int, null

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

vHdTicketApprovalItemResultLoc

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

vHdTicketCalc

Information whether the request can indeed be reopened.

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

vHdTicketPersonRead

Effective authorization to display requests.

Column Type Description
liHdTicketId int, null
liPersonId int, null
OnlyRequester int, null

vIdSeqProperty

Definitions of automatic codes lists for the generation of the properties values.

Column Type Description
intIdSeqId int, not null
txtPrefix nvarchar(255), null
NextNumber nvarchar(60), null
txtSuffix nvarchar(255), null
sNextValue nvarchar(765), null
liKindId int, null
liClassId int, null
sComputerKind nvarchar(255), null

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

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

vKnowledgeRead

Knowledge that a user can read in services.

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

vLang

Languages.

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

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

vLicHist_InvoiceAtomLast

Invoice attached to the license.

Column Type Description
lintLicHistId int, null
lintAtomId int, null

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

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

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

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

vLog_DetectLast

Last record in the detection log.

Column Type Description
lintDetectId int, null
lintMaxLogId int, null

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

vMediaType

Types of media.

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

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

vNodeCostCentre

Cost center of the objects in the tree.

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

vNodeDisposed

Discarded assets.

Column Type Description
NodeId int, not null

vNodeParentJoin

Objects in the tree - tree.

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

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

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

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

vNodePropertyMix_Computer2

Objects and properties - Computer - MAC address.

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

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

vOnlyReader

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

Column Type Description
PersonId int, null
SectionId int, not null
OnlyReader bit, null

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

vPersonNodeRight_Create

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

Column Type Description
liPersonId int, null
liNodeId int, null

vPersonNodeRight_Delete

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

Column Type Description
liPersonId int, null
liNodeId int, null

vPersonNodeRight_Move

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

Column Type Description
liPersonId int, null
liNodeId int, null

vPersonNodeRight_Read

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

Column Type Description
liPersonId int, null
liNodeId int, null

vPersonNodeRight_Write

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

Column Type Description
liPersonId int, null
liNodeId int, null

vPersonRightRead

Effective authorization individuals and groups have for records on the activities of other individuals and groups within the ALVAO Monitoring product.

Column Type Description
liPersonRightReadPersonId int, null
liPersonRightReadSubjectPersonId int, null

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

vProductCategory

Products categories (OS).

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

vProductType

Products types.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

vSectionLicence

Drawing of licenses by services

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

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

vSlaAccess

Effective authorization requesters have for SLA and services.

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

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

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

vSlaAlertInactiveApplicants

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

vSlaAlertInactiveApprobators

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

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

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

vSlaAlertInactiveSummary

Summary SLA notification for inactivity (requesters, approvers, operators and solvers).

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

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

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

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(max), null
LocalizedSlaDesc nvarchar(max), null

vStringLoc

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

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

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

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

vSwInst_TreeCnt

Number of product installations in the subtree.

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

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

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

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

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

vTicketRelation

Links Between Requests.

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

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

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(max), not null
LocalizedDescription nvarchar(max), null
LocalizedInstructions nvarchar(max), null

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

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

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(max), not null

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

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

vUserLicence

Drawing of licenses by users

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

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

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

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

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

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

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
SignComputer nvarchar(255), null
intDocumentKindId int, not null
txtDocumentKind nvarchar(255), null
txtSrcNodeName nvarchar(255), null
txtDestNodeName nvarchar(255), null
txtLink int, null

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

spAssetTreeNodeChilds

Returns the object off-springs in the tree.

Parameters

Name Type Description
@nodeId int

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

spAssignLicenceItemToChildren

Assigns the license item to historical upgrades as well.

Parameters

Name Type Description
@LicHistItemId int

spCalcNodeName

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

Parameters

Name Type Description
@nodeId int

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

spCalcNodeNameSubtree

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

Parameters

Name Type Description
@parentId int

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

spCloseHdTicket

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

Parameters

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

spConvertPropertiesToDate

Converts text properties of the specific kind to date type.

Parameters

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

spConvertPropertiesToFloat

Converts text properties of the specific kind to float type.

Parameters

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

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

spCreateNodeFromTemplate

Creates an object based of the object template definition.

Parameters

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

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

spCustomColumn_Drop

Removing custom items.

Parameters

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

spEvalFileRule

Evaluation of one rule for files recognition.

Parameters

Name Type Description
@FileImageId int

spEvalRegRule

Evaluation of the one rule for the recognition of registries.

Parameters

Name Type Description
@RegImageId int

spEvalSwDetection

Evaluates SW detection based on patters from the software products library.

Parameters

Name Type Description
@DetectId int

spGeneratePropValuesFromSequence

Sets other values ​​for properties by numeric sequences.

Parameters

Name Type Description
@NodeId int
@person int

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

spHdSection_UpdateName

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

Parameters

Name Type Description
@iHdSectionId int

spHdSectionUpdateQueue

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

Parameters

Name Type Description
@HdSectionId int

spHdTicketChangeHdSection

Moves the @iHdTicketId request to the @iHdSectionId service.

Parameters

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

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

spHdTicketPassToSolverInHdSection_SolverList

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

Parameters

Name Type Description
@iHdSectionId int

spHdTicketResolve

Switches the request to Resolved.

Parameters

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

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

spHdTicketSolverOpen

Reopens the request by the solver.

Parameters

Name Type Description
@iHdTicketId int
@iSolverPersonId int

spMoveNode

Moves the object in the object tree.

Parameters

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

spNotifyMacros

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

Parameters

Name Type Description
@iHdTicketId int

spPersonByPhoneNumber

Finds the user based on telephone number.

Parameters

Name Type Description
@caller nvarchar(255)

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.

spReadAllComunication

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

Parameters

Name Type Description
@PersonId int
@TicketId int

spReadAllDiary

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

Parameters

Name Type Description
@PersonId int
@TicketId int

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

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

spRefreshLicProductCoverage

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

Parameters

Name Type Description
@LicHistId int

spRefreshNodePath

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

Parameters

Name Type Description
@node int

spRemoveApp

Deletes own application from Monitoring.

Parameters

Name Type Description
@AppId int

spRemoveDetectResults

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

Parameters

Name Type Description
@detlist nvarchar(max)

spRemoveDetects

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

Parameters

Name Type Description
@detlist nvarchar(max)

spRemoveNodes

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

Parameters

Name Type Description
@nodes nvarchar(max)

spRemoveObjects

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

Parameters

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

spReplaceSectionRights

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

Parameters

Name Type Description
@srcSectionId int
@dstSectionId int

spReplaceSectionSLA

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

Parameters

Name Type Description
@srcSectionId int
@dstSectionId int

spSavePersonTicketDisplay

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

Parameters

Name Type Description
@ticketId int
@personId int

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)

spSetDetailedRecordsFolderProperties

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

Parameters

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

spStateReqCol

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

Parameters

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

spTakeLicence

Withdraws license for the computer software.

Parameters

Name Type Description
@LicHistItemId int

spTicketSearch

Returns a list of requests by the specified string.

Parameters

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

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)

spUpdateColumnValuePath

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

Parameters

Name Type Description
@ColumnId int

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

spUpdatePropCache_ObjMoved

Updates property inheritance after the object move in the tree.

Parameters

Name Type Description
@objId int

spUpdatePropCache_ObjNew

Updates property inheritance after a new object was created.

Parameters

Name Type Description
@objId int

spUpdatePropCache_PropDel

Updates property inheritance after the object properties were deleted.

Parameters

Name Type Description
@objId int
@kindId int

spUpdatePropCache_PropNew

Updates property inheritance after a new object property was added.

Parameters

Name Type Description
@propId int

spUpdatePropCache_PropValChanged

Updates property inheritance after a change in the property value.

Parameters

Name Type Description
@propId int

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

spUpdateTicketDeadline

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

Parameters

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

spUpdateTicketLastAction

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

Parameters

Name Type Description
@TicketId int

spUpdateTicketShiftedDeadlines

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

Parameters

Name Type Description
@slaId int

spWebAppLoginDelay

Protection against password-guessing attack.

Parameters

Name Type Description
@loginTry int

DefaultSlaId

Returns the default SLA for on-duty requesters.

Parameters

Name Type Description
@iHdSectionId int
@iPersonId int

fAddressString

Formats the address properties from tAddress to one string.

Parameters

Name Type Description
@addressId int

fDate

Returns date without time only.

Parameters

Name Type Description
@datetime datetime

fDateHoursMinutes

Cutting off seconds from the item type date and time.

Parameters

Name Type Description
@d datetime

fDeadline

Calculates deadline in the service working hours.

Parameters

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

fGetServerFromURL

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

Parameters

Name Type Description
@Url nvarchar(1024)

fHtmlString

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

Parameters

Name Type Description
@s nvarchar(4000)

fLastLevelDomain

Returns the last level of the domain.

Parameters

Name Type Description
@LoginWithDomain nvarchar(255)

fnCheckRelCycles

Checks the circular task link between requests.

Parameters

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

fnCheckRelCyclesLicHist

Function for reviewing a circular task.

Parameters

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

fnCheckRelCyclesNode

Function for reviewing a circular task.

Parameters

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

fnCheckRelDuplicity

Checks the link between requests for duplicity.

Parameters

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

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

fnFileStringInfoCsvSignature

CSV file signature from FileStringInfo part.

Parameters

Name Type Description
@id int

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

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

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

fnGetBackupKindName

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

Parameters

Name Type Description
@intKindId int

fnGetUnreadCount

Number of unread events of the person on request.

Parameters

Name Type Description
@PersonId int
@TicketId int

fnHdSectionWithoutLast

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

Parameters

Name Type Description
@SectionId int

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)

fnLocalTime

Converts UTC data to the specific time zone.

Parameters

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

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)

fnPersonLoginWithoutDomain

Username of a person without a domain.

Parameters

Name Type Description
@sPersonLogin nvarchar(255)

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

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

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

fnUtcTime

UTC time calculated from the local time and time zones.

Parameters

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

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

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

fRelatedCompany

Request - "Related Organizations" item

Parameters

Name Type Description
@iHdTicketId int

fStripDomain

Username of a user without a domain.

Parameters

Name Type Description
@LoginWithDomain nvarchar(255)

fSuggestResolutionDate

Default due date by SLA.

Parameters

Name Type Description
@Ticketid int

GetProperty

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

Parameters

Name Type Description
@key nvarchar(255)

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

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

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

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

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

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.

ftHdSectionForRequesterSearch

Searching for the Requester’s services. Returns a table of services matching the entered parameters arrangedby the path in the tree. The function can be customized. In order to customize the function, create a new procedure named ftHdSectionForRequesterSearch_Custom. 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 chain. Searching in the name of the service, including the path in the tree. If empty or NULL, the function returns only the service where the user is the operator. Only the Requester’s SLA is checked if it is the other way.
@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
iHdSectionId int Service ID.
ItemOrder int A column for sorting in the Menu.

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)

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)

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

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

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)

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

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

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

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

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)

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

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

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

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

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

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

tfPersonManager

Direct managers.

Return table

Name Type Description
liPersonManagerSubordinatePersonId int
liPersonManagerManagerPersonId int

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.