Tables

Table	Scheme	Description
ActMark	dbo	Marking the record in the ticket log.
ActOperation	dbo	Kind of process in the ticket log
AdTrustedDomain	dbo	List of trustworthy domains.
App	Apps	Application.
AppOperation	Perf	Measured operations in applications
AppOperationRecord	Perf	Operation responses in applications
AppOperationRecordData	Perf	Additional operation data in applications
ArticleHdSection	dbo	Assigning articles from the knowledge base to services.
ArticleLoc	dbo
AzureAdTenant	dbo	The table of Azure Active Directory tenants from which users are imported.
ClassKind	dbo	Definition of properties for object class
ColumnValueLoc	dbo	Cache of value list item localizations.
ConnectionToken	dbo	Valid safety token table.
CustomThemeProperty	dbo	Property of the custom theme.
DataPack	dbo	Data packages inserted by database updates
DataQuery	dbo	Data query defined by an SQL query
DataQueryPermission	dbo	Permission to run a Data query.
DetectEventLog	dbo	Detected events from the Event log of computers
DetectMethod	dbo	Detection method (e.g. without Agent, autonomous Agent, ...)
DetectProfile	dbo	Detection profiles
DetRegUninstall	dbo	Detected registry entries. The table contains records which may differ in various computers.
DocumentFolder	dbo	Document folder
DocumentFolderRight	dbo	Permissions of users and groups for documents stored in a certain document folder
EmailSignatureHdSection	dbo	Assigning signatures to services.
FormScriptExtension	dbo	Definition of custom JavaScript for forms.
HdSectionEwsTokens	dbo	Tokens for logging in to MS Exchange.
HdSectionLoc	dbo	Cache of service localizations.
HdSectionManager	dbo	Effective service managers.
HdSectionMessageTag	dbo	Unique service prefix and suffix pair.
HdSectionNodeClass	dbo	Object types assigned to services.
HdSectionNodeClassMyAssets	dbo	Property entrusted to me - services which should be displayed in the service offer on the pages of objects of a certain type.
HdSectionOperator	dbo	Effective main service solvers.
HdSectionReader	dbo	Effective readers in services.
HdSectionRightsLog	dbo	Logging of changes in user permissions to services. The meaning of values in permission columns: 1=enable 0=not set
HdSectionSolver	dbo	Effective service solvers.
HdSectionSolverGroup	dbo	Effective solvers from solver groups of services.
IdSeqType	dbo	Numeric sequence types.
IntegratedAuthIpRange	dbo	IP address range for Integrated Windows Authentication.
KindDataType	dbo	Property data types in AM.
KindRight	dbo	Security for properties.
LibraryIcon	dbo	Service icon library.
LicDowngrade	dbo	License - downgrade.
LicHistCust	dbo	License custom fields values.
LicHistDocument	dbo	License - links to documents and media.
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.
LicHistMedia	dbo	License - links to documents and media.
LicHistRelation	dbo	A table containing links between licenses in Asset Management
LicHistRelationType	dbo	Types of links between licenses in the AM
LicHistRelationTypeBehavior	dbo	Types of links between licenses 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.
LicRight	dbo	Permissions of persons and groups to software licenses of organizations.
LicType	dbo	License types.
LogLevel	dbo	Enumeration of log levels
MailMessage	dbo	Outgoing email queue.
MediaLend	dbo	Information on items lent and returned in the media library.
News	dbo	News.
NewsHdSection	dbo	Services for which the individual news are intended.
NewsLoc	dbo
NewsRead	dbo	Records of reading the news. In multi-tenant operation, records of reading news displayed to other tenants are saved in the provider's database.
NewTicketFormColumn	dbo	Column order on a New Ticket Form
NewTicketFormSection	dbo	Section order on a New Ticket Form
NewTicketFormTextBlock	dbo	Text block order on a New Ticket Form
NodeColumnInheritance	dbo	Inheritance between objects
NodeCust	dbo	Object property values
NodeDocument	dbo	Objects in the tree - links to documents.
NodeHealthStatus	dbo	Object health status
NodeHealthStatusLoc	dbo	Cache of language localizations of object health statuses, see NodeHealthStatus.
NodeRelation	dbo	Table with links between objects in Asset Management
NodeRelationType	dbo	Types of links between objects in the AM.
NodeRelationTypeBehavior	dbo	Types of links between objects in the AM from the viewpoint of system/custom links.
NodeRightLog	dbo	Logging of changes in permissions of users in Asset Management.
OperatorServiceUsage	dbo	Services to which the given solver created tickets last using the New Ticket Form.
PeriodicAlert	dbo	Periodic alerts not defined by an SQL query. Sent by e-mail, periodically with the selected regularity.
PeriodicAlertPeriod	dbo	Send period of periodic alerts.
PersonBehavior	dbo	People types. Normal users =1, system users >1.
PersonEmailUsage	dbo	Use of an e-mail address for sending the message by a specific user.
PersonEventDisplay	dbo	Events viewed by a person.
PersonGridView	dbo	Cache for the number of unread tickets from the viewpoint of a specific user.
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 tickets of the requester.
PrintReportTemplate	dbo	Templates for print reports
ProductCust	dbo	Product License custom fields values.
ProductState	dbo	Status of the products
ProfileValue	dbo	View settings table
ReceivedMessage	dbo	Table for temporary storage of read messages for custom actions.
ReceivedMessageRule	dbo	Rules for incoming messages to service mailboxes.
RelatedTicketRule	dbo	The rules for automatic creation of linked tickets while transiting the source ticket to a certain status.
RelatedTicketRuleColumn	dbo	Copied items of the source ticket while creating linked tickets.
RelatedTicketRuleRequesterMode	dbo	Method of setting the requester while creating linked tickets, see RelatedTicketRule.
RequiredClassKind	dbo	The table contains properties that must be filled in for the given object types.
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.
Scanner	dbo	Scanners importing data from other systems or physical devices into Alvao.
ScannerPropertyLockout	dbo	Locking of values of object properties (dbo.tblKind) for editing by scanners (dbo.Scanner).
SccmConnection	dbo	Connection to MS SCCM
SccmConnectionKind	dbo	Type of connection to MS SCCM
Script	Apps	Application scripts.
SearchLog	dbo	Log of searched queries
SectionSequence	dbo
Server	dbo	Settings of server applications (Alvao Service, AM Collector).
SharedView	dbo	Table of shared views.
SharedViewRecipient	dbo	Table of users and groups which the view is shared with.
SlaAlertRuleReceiver	dbo	Notice for unresolved tickets - other recipients.
SlaLoc	dbo	Cache of SLA localizations.
SlaRightsLog	dbo	Logging of changes in SLA assignment The meaning of values in permission columns: 1=enable 0=refuse NULL=not set
SnmpDeviceTypeMap	dbo	Map for determining the type of object based on device descriptions in SNMP.
StringLoc	dbo	Cache of text string localizations.
Subscriber	dbo	A table containing information on the customer and on the ticket 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 fields values.
tAct	dbo	The record in communication or ticket log.
tActKind	dbo	Record type tAct, e.g. "e-mail", "phone", "note", "process", …
tAddress	dbo	Address
tApprovalSchema	dbo	Approval schemes.
tApprovalSchemaItem	dbo	Approval scheme step.
tArticle	dbo	Article in Knowledge Base.
tBankHoliday	dbo	National holidays.
tBankHolidayLoaded	dbo	National holiday blocks included in the database. A block is a list of holidays belonging to one region and year.
tBankHolidayRegion	dbo	Local national holiday regions.
tblADMap	dbo	Mapping attributes from AD to AM properties. This configuration is used by ImportAD.
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).
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.
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
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	Numeric sequences - definitions.
tblInstHist	dbo	Records on installation and uninstallation of products on the computers (manual as well as detected)
tblInstTrial	dbo	Special installation.
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.
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.
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).
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.
tColumn	dbo	List of custom fields and certain system items.
tColumnValue	dbo	Value lists for custom fields.
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.
TenantDiagnosticsLog	dbo	Tenant diagnostics log records
TenantSecurityChangeLog	dbo	Tenant security-change log records
TenantSigninLog	dbo	User sign in log records
tHdSection	dbo	ALVAO Service Desk product services.
tHdSectionCust	dbo	Services custom fields values.
tHdSectionPerson	dbo	Setting of notifications from the services to individual persons.
tHdSectionRights	dbo	Permissions individuals and groups have in services (Main solver, Solver, ...).
tHdTicket	dbo	Tickets.
tHdTicketAltMessageTag	dbo	Alternative ticket tags. Upon merging tickets, the final ticket uses tags from original tickets as alternative tags.
tHdTicketApproval	dbo	Ticket approval process instance - main record.
tHdTicketApprovalItem	dbo	Ticket approval step.
tHdTicketApprovalItemResult	dbo	List of approval step statuses.
tHdTicketCust	dbo	Ticket custom fields values.
TicketAlert	dbo	Cache for storing alerts.
TicketAlertSeverity	dbo	Alert severity.
TicketAlertSeverityLoc	dbo	Language localisation cache for alert severity, see TicketAlertSeverity.
TicketAlertType	dbo	SLA alert type
TicketAlertTypeLoc	dbo	Language localization cache of SLA alert type, see TicketAlertType
TicketChange	dbo	Ticket log record for changes to the ticket field value.
TicketNode	dbo	Objects associated to the ticket over the ticket "Objects" item.
TicketRelation	dbo	Links Between Tickets.
TicketRelationType	dbo	Types of links between tickets.
TicketRelationTypeBehavior	dbo	System types of links between tickets.
TicketRequestParticipant	dbo	Ticket participant for the ticket
TicketSequence	dbo	A table containing the next ticket number.
TicketState	dbo	Ticket statuses. Statuses are defined in the process (see dbo.TicketType).
TicketStateBehavior	dbo	System ticket statuses, see dbo.TicketState.
TicketStateCust	dbo	Ticket state custom fields values.
TicketStateLoc	dbo	Cache of the localizations of ticket states.
TicketStateRelation	dbo	Allowed transitions among ticket statuses, see dbo.TicketState.
TicketStateRequiredColumn	dbo	Required items for individual ticket statuses, see dbo.TicketState.
TicketTag	dbo	User tag of the ticket
TicketTagType	dbo	Ticket tag type
TicketTagTypeLoc	dbo	Cache of tag types localizations.
TicketTemplate	dbo	List of ticket templates
TicketTemplateColumnValue	dbo	column values on ticket template.
TicketTemplateNode	dbo	Objects linked to the ticket templates.
TicketType	dbo	Processes. Among others, the process defines possible ticket statuses, solving process, custom ticket items, etc.
TicketTypeBehavior	dbo	System processes.
TicketTypeColumn	dbo	Ticket items used by the process.
TicketTypeLoc	dbo	Cache of process localizations.
TicketTypeNodeHealthImpact	dbo	For the effect on object health requirements, see TicketType.TicketTypeNodeHealthImpactId.
tIdSeqClass	dbo	Numeric sequences - 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.
Token	dbo	For internal use
tOpeningHours	dbo	Service operating hours.
tOpeningHoursCache	dbo	Auxiliary records for optimizing time calculations according to service operating hours.
tOpeningHoursException	dbo	Exceptions in service operating hours.
tPerson	dbo	Persons in the ALVAO system.
tPersonCust	dbo	Persons in the ALVAO system - own items.
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.
tSla	dbo	SLA.
tSlaAlert	dbo	Ticket 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 fields 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.
tWeekOpeningHours	dbo	Item in the definition of service operating hours.
tWorkLoad	dbo	Employee labor contracts.
tWorkTime	dbo	Employee attendance record created in the ALVAO Attendance module.
UserLogonLog	dbo	Logging users in/out to/from Asset Management Console.
UserLogonLogAction	dbo	Executed action which is logged.
UserLogonLogApplication	dbo	Application name.
WebAppActiveSession	dbo	Active session at ALVAO WebApp.
Webhook	dbo	Registered webhooks integrating Alvao with other applications.
WebhookTopic	dbo	Webhook topics
WorkOvertimeDisposal	dbo	Table with list of paid overtime hours

dbo.ActMark

Marking the record in the ticket log.

Column	Type	Description
id	tinyint, not null	Record ID
Name	nvarchar(255), not null	Record marking name

dbo.ActOperation

Kind of process in the ticket log

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

dbo.AdTrustedDomain

List of trustworthy domains.

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

Apps.App

Application.

Column	Type	Description
id	int, not null	Application ID.
Name	nvarchar(255), not null	Application name.
Description	nvarchar(max), null	Application description.
IsEnabled	bit, not null	If the application is enabled. 1 = enabled, 0 = disabled.

Perf.AppOperation

Measured operations in applications

Column	Type	Description
id	int, not null	Operation identifier
AppOperation	nvarchar(255), null	Operation name

Perf.AppOperationRecord

Operation responses in applications

Column	Type	Description
id	int, not null	Record identifier
AppOperationId	int, not null	Measured operation identifier. A foreign key to the AppOperation table.
OperationStart	datetime, not null	Operation start time
ServerDurationSeconds	float, null	Duration of the operation on the server in seconds
ClientDurationSeconds	float, null	Duration of the operation in the client in seconds
UserPersonId	int, not null	User identifier of a person who performed the operation

Perf.AppOperationRecordData

Additional operation data in applications

Column	Type	Description
id	int, not null	Data record identifier
AppOperationRecordId	int, not null	Identifier of a record to which the data is related. A foreign key to the AppOperationRecord table.
DataName	nvarchar(255), null	Parameter name
TextDataValue	nvarchar(255), null	Parameter text value
IntDataValue	int, null	Integer parameter value
FloatDataValue	float, null	Real parameter value

dbo.ArticleHdSection

Assigning articles from the knowledge base to services.

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

dbo.ArticleLoc

Column	Type	Description
Id	int, not null
ArticleId	int, not null
LocaleId	int, not null
Name	nvarchar(1024), null
Annotation	nvarchar(max), null
Text	nvarchar(max), null
HtmlText	nvarchar(max), null

dbo.AzureAdTenant

The table of Azure Active Directory tenants from which users are imported.

Column	Type	Description
id	int, not null	Record ID
AzureTenantId	nvarchar(40), not null	Folder ID in Azure
Name	nvarchar(max), not null
ScimSecretTokenHash	nvarchar(255), null
ScimSecretTokenHashLastGenerated	datetime, null
UserPortraits	bit, not null
UserPresence	bit, not null
Intune	bit, not null	Devices are imported from Intune.

dbo.ClassKind

Definition of properties for object class

Column	Type	Description
ClassId	int, not null	ID of object class (tblClass.intClassId)
KindId	int, not null	ID of object property (tblKind.intKindId)

dbo.ColumnValueLoc

Cache of value list item localizations.

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

dbo.ConnectionToken

Valid safety token table.

Column	Type	Description
id	int, not null	Record ID.
Token	varchar, not null	Token.
ValidTo	datetime, not null	Valid to.

dbo.CustomThemeProperty

Property of the custom theme.

Column	Type	Description
id	int, not null	Record ID
Name	nvarchar(30), not null	Name of the theme property.
Value	nvarchar(30), not null	Value of the theme property.

dbo.DataPack

Data packages inserted by database updates

Column	Type	Description
id	nvarchar(128), not null	Data package identifier
InsertedDate	datetime, not null	Date of insertion

dbo.DataQuery

Data query defined by an SQL query

Column	Type	Description
id	int, not null	Record ID
Name	nvarchar(255), not null	Query name
Description	nvarchar(max), null	Description
SqlQuery	nvarchar(max), null	SQL query
IsEnabled	bit, not null	1 = the query is enabled, 0 = disabled.
ErrorMessage	nvarchar(max), null	Error message at the last SQL script run.
Hidden	bit, not null

dbo.DataQueryPermission

Permission to run a Data query.

Column	Type	Description
id	int, not null	Record ID
DataQueryId	int, not null	DataQuery (DataQuery.id)
RoleId	int, null	Role (tRole.iRoleId)
PersonId	int, null	Person (tPerson.iPersonId)

dbo.DetectEventLog

Detected events from the Event log of computers

Column	Type	Description
id	int, not null	Record ID
DetectId	int, not null	Detection ID
EventDate	datetime, null	Event date and time (UTC)
EventID	int, null	Event ID in the Event log
Message	nvarchar(max), null	Event text

dbo.DetectMethod

Detection method (e.g. without Agent, autonomous Agent, ...)

Column	Type	Description
id	int, not null	Record ID.
BehaviorId	int, not null	Behavior from the system perspective: 0=Custom detection method, 1=Automatically, 2=Autonomous Agent, 3=Without Agent, 4=Agent over TCP/IP, 6=MS SCCM, 7=Manually
Name	nvarchar(64), null	Name of the detection method.
Custom1	nvarchar(1024), null	Field for user data, usually identifier of the custom detection method.

dbo.DetectProfile

Detection profiles

Column	Type	Description
id	int, not null	Record ID
ProfileName	nvarchar(64), not null	Profile name
DefaultProfile	bit, not null	Default profile
DetectPeriod	int, null	Period of automatic detection planning
HwMethodId	int, null	HW detection method ID
HwTcpIpPort	int, null	HW detection agent port number during detection by Agent over TCP/IP
SwMethodId	int, null	SW detection method ID
SwTcpIpPort	int, null	SW detection agent port number during detection by Agent over TCP/IP
SwIsFull	bit, not null	Full SW detection
SwIncludeFiles	nvarchar(255), null	Full SW detection, include files
SwExcludeFiles	nvarchar(255), null	Full SW detection, skip files

dbo.DetRegUninstall

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

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

dbo.DocumentFolder

Document folder

Column	Type	Description
id	int, not null	Record ID
Name	nvarchar(255), not null	Folder name
Objects	bit, not null	1 = documents in this folder can be linked to objects
SwLicenses	bit, not null	1 = documents in this folder can be linked to software licenses
Stocktakings	bit, not null	1 = documents in this folder can be linked to the asset stocktaking

dbo.DocumentFolderRight

Permissions of users and groups for documents stored in a certain document folder

Column	Type	Description
id	int, not null	Record ID
DocumentFolderId	int, not null	Document folder (DocumentFolder.id)
PersonId	int, null	User (tPerson.iPersonId); Just one of the PersonId and RoleId must have a value filled in.
RoleId	int, null	User group (tRole.iRoleId)
CanRead	bit, null	1 = read permission for documents
CanModify	bit, null	1 = editing permission for documents
CanDelete	bit, null	1 = deletion permission for documents

dbo.EmailSignatureHdSection

Assigning signatures to services.

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

dbo.FormScriptExtension

Definition of custom JavaScript for forms.

Column	Type	Description
id	int, not null	Entity ID.
SectionId	int, not null	Link to service.
Javascript	nvarchar(max), null	JavaScript inserted into the page.

dbo.HdSectionEwsTokens

Tokens for logging in to MS Exchange.

Column	Type	Description
HdSectionId	int, not null	Service ID (see tHdSection.iHdSectionId)
RefreshToken	nvarchar(max), null	Refresh token
AccessToken	nvarchar(max), null	Access token
AccessTokenExpiration	datetime, null	Access token expiration (UTC)
LastErrorMessage	nvarchar(max), null	Error message and from the last login to the mailbox. If it contains NULL, the last login was successful.

dbo.HdSectionLoc

Cache of service localizations.

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

dbo.HdSectionManager

Effective service managers.

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

dbo.HdSectionMessageTag

Unique service prefix and suffix pair.

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

dbo.HdSectionNodeClass

Object types assigned to services.

Column	Type	Description
id	int, not null	Record ID.
HdSectionId	int, not null	A service (tHdSection.iHdSectionId) to which the object type is linked.
NodeClassId	int, not null	The object type (tblClass.intClassId) which is linked to the service.

dbo.HdSectionNodeClassMyAssets

Property entrusted to me - services which should be displayed in the service offer on the pages of objects of a certain type.

Column	Type	Description
id	int, not null	Record ID.
HdSectionId	int, not null	The service (tHdSection.iHdSectionId) which should be displayed on the object pages.
NodeClassId	int, not null	The class of objects (tblClass.intClassId) whose website should display the service.

dbo.HdSectionOperator

Effective main service solvers.

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

dbo.HdSectionReader

Effective readers in services.

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

dbo.HdSectionRightsLog

Logging of changes in user permissions to services.
The meaning of values in permission columns:
1=enable
0=not set

Column	Type	Description
id	int, not null	Record ID
TimeStamp	datetime, not null	Change performance date and time (UTC)
ModifiedByPersonId	int, null	User ID of a person who performed the change.
ModifiedByPerson	nvarchar(255), not null	The name of the user who did the change.
HdSectionId	int, null	Service ID
HdSectionIdOld	int, null	ID of the original service
HdSection	nvarchar(255), null	Service name
HdSectionOld	nvarchar(255), null	Original service name
RoleId	int, null	User group ID which is the permission holder.
RoleIdOld	int, null
Role	nvarchar(255), null	User group name which is the permission holder.
RoleOld	nvarchar(255), null	User group name of a person who was originally a permission holder.
PersonId	int, null	User ID of a person who is the permission holder.
PersonIdOld	int, null	User ID of a person who was originally a permission holder.
Person	nvarchar(255), null	User name of a person who is the permission holder.
PersonOld	nvarchar(255), null	User name of a person who was originally a permission holder.
MainSolver	bit, not null	Main solver permissions
MainSolverOld	bit, not null	Original main solver permissions
Solver	bit, not null	Solver permissions
SolverOld	bit, not null	Original solver permissions
SolverTake1	bit, not null	Solver permissions with the right to take the ticket over (main)
SolverTake1Old	bit, not null	Original solver permissions with the right to take the ticket over (main)
SolverTake2	bit, not null	Solver permissions with the right to take the ticket over (secondary)
SolverTake2Old	bit, not null	Original solver permissions with the right to take the ticket over (secondary)
Manager	bit, not null	Manager permissions
ManagerOld	bit, not null	Original manager permissions
Reader	bit, not null	Reader permissions
ReaderOld	bit, not null	Original reader permissions
ExceptionalSolver	bit, not null	Exceptional solver permissions
ExceptionalSolverOld	bit, not null	Original exceptional solver permissions
TicketReporter	bit, not null	Permissions of the ticket reporter (formerly of the irregular operator)
TicketReporterOld	bit, not null	The original permissions of the ticket reporter (formerly of irregular operator)
SolverGroup	bit, not null
SolverGroupOld	bit, not null
RequesterRoleId	int, null	ID of the group of requesters associated with the permissions (mapping of requesters to the solver team).
RequesterRoleIdOld	int, null	ID of the group of requesters originally associated with the permissions (mapping of requesters to the solver team).
RequesterRole	nvarchar(255), null	Name of the group of requesters associated with the permissions (mapping of requesters to the solver team).
RequesterRoleOld	nvarchar(255), null	Name of the group of requesters originally associated with the permissions (mapping of requesters to the solver team).

dbo.HdSectionSolver

Effective service solvers.

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

dbo.HdSectionSolverGroup

Effective solvers from solver groups of services.

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

dbo.IdSeqType

Numeric sequence types.

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

dbo.IntegratedAuthIpRange

IP address range for Integrated Windows Authentication.

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

dbo.KindDataType

Property data types in AM.

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

dbo.KindRight

Security for properties.

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

dbo.LibraryIcon

Service icon library.

Column	Type	Description
Id	int, not null	Record ID
Name	nvarchar(100), null	Icon name
Content	varbinary, not null	Binary content of file in PNG format
SystemIcon	bit, not null	1 = system icon

dbo.LicDowngrade

License - downgrade.

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

dbo.LicHistCust

License custom fields values.

Column	Type	Description
LicHistId	int, null

dbo.LicHistDocument

License - links to documents and media.

Column	Type	Description
LicHistId	int, not null	License (tblLicHist.intLicHistId)
AMDocumentId	int, not null	Document (tblDocument.id)

dbo.LicHistItemAssign

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

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

dbo.LicHistLog

Change record for a license or a license item.

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

dbo.LicHistLogKind

Kind of change of a license or a license item.

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

dbo.LicHistMedia

License - links to documents and media.

Column	Type	Description
LicHistId	int, not null	License (tblLicHist.intLicHistId)
MediaId	int, not null	Media (tblMedia.id)

dbo.LicHistRelation

A table containing links between licenses in Asset Management

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

dbo.LicHistRelationType

Types of links between licenses in the AM

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

dbo.LicHistRelationTypeBehavior

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

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

dbo.LicKind

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

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

dbo.LicProductCoverage

Which of all products have license coverage.

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

dbo.LicRight

Permissions of persons and groups to software licenses of organizations.

Column	Type	Description
id	int, not null	Record ID
NodeId	int, null	Organization (tblNode.intNodeId) to whose software licenses the permissions apply.
PersonId	int, null	Authorized user (tPerson.iPersonId)
RoleId	int, null	Authorized group of users (tRole.iRoleId)
CanRead	tinyint, null	Permission to read
CanModify	tinyint, null	Permission to modify

dbo.LicType

License types.

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

dbo.LogLevel

Enumeration of log levels

Column	Type	Description
id	int, not null	Record ID
Name	nvarchar(50), not null	Log level name

dbo.MailMessage

Outgoing email queue.

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

dbo.MediaLend

Information on items lent and returned in the media library.

Column	Type	Description
MediaId	int, not null	Media (tblMedia.id)
lintPersonNodeId	int, null	Lended to person in tree - tblNode
txtPerson	nvarchar(255), null	Lended to
dteLended	datetime, null	Date lended
dteReturned	datetime, null	Date returned
txtNote	nvarchar(max), null	Note
liLendingPersonId	int, not null	Lended by - tPerson
liAcceptingPersonId	int, null	Taken over by - tPerson

dbo.News

News.

Column	Type	Description
id	int, not null	Primary table key.
CreatedDate	datetime, not null	Creation date of the news post.
Subject	nvarchar(max), not null	Name of the news post.
Text	nvarchar(max), null	Text of the news post.
Order	int, not null	News post display order.
ShowEndDate	datetime, null	Date until which the news post shall be displayed.
CreatedByPersonId	int, not null	User who created the news post.
HtmlText	nvarchar(max), null	HTML text of the news post.
SentDate	datetime, null	Date and time of the last sending of the news post.
Important	bit, not null	1 = important news post. Alerts for important unread news are displayed on every WA page.
PublishToTenants	bit, not null	1 = news post displayed to users of all tenants. This option can only be enabled in the ALVAO provider's database.
ShowToRequesters	bit, not null	1 = also show to requesters of selected services; 0 = show only to members of service teams
LocaleId	int, null

dbo.NewsHdSection

Services for which the individual news are intended.

Column	Type	Description
id	int, not null	Primary table key.
NewsId	int, not null	id of the news post (News.id).
HdSectionId	int, null	id of the service for which the news post is intended (tHdSection.iHdSectionId). NULL = intended for all services.

dbo.NewsLoc

Column	Type	Description
Id	int, not null
NewsId	int, not null
LocaleId	int, not null
Subject	nvarchar(max), not null
Text	nvarchar(max), null
HtmlText	nvarchar(max), null

dbo.NewsRead

Records of reading the news. In multi-tenant operation, records of reading news displayed to other tenants are saved in the provider's database.

Column	Type	Description
id	int, not null	Record ID
NewsId	int, not null	News post ID (News.id).
PersonId	int, not null	Person ID (tPerson.iPersonId). Person ID in the tenant's database in a multi-tenant operation.
PersonName	nvarchar(255), null	Name of the person
PersonLogin	nvarchar(255), null	Person’s username
TenantId	int, null	Tenant ID in the tenant database. ZERO, if this is a local news post.
Organization	nvarchar(255), null	Organization name in the tenant database. NULL if this is local news post.
FirstDisplayed	datetime, not null	Date and time user first viewed the news post.

dbo.NewTicketFormColumn

Column order on a New Ticket Form

Column	Type	Description
id	int, not null	Entity ID
SectionId	int, not null	Link to service
ColumnId	int, not null	Link to column
Order	int, not null	Row on which the item is displayed
Required	bit, not null	Marking the item obligation.
Column	int, null	Column on which the item is displayed (0 left, 1 right)

dbo.NewTicketFormSection

Section order on a New Ticket Form

Column	Type	Description
id	int, not null	Entity ID
Name	nvarchar(255), not null	Section name
Order	int, not null	Row on which the item is displayed
SectionId	int, not null	Id of the service (tHdSection.iHdSectionId)
Expand	bit, not null	1 = when the form for submitting a new ticket is displayed, the section will be expanded. 0 = the section will be collapsed

dbo.NewTicketFormTextBlock

Text block order on a New Ticket Form

Column	Type	Description
id	int, not null	Entity ID
TextHtml	nvarchar(max), null	Text in HTML
Order	int, not null	Row on which the item is displayed
SectionId	int, not null	Id of the service (tHdSection.iHdSectionId)
Column	int, null	Column on which the item is displayed (0 left, 1 right)
ColSpan	int, null	Number of columns the item occupies. (1 half row, 2 whole row)

dbo.NodeColumnInheritance

Inheritance between objects

Column	Type	Description
NodeId	int, not null	ID of object (tblNode.intNodeId)
KindId	int, not null	ID of object property (tblKind.intKindId)
InheritedFromNodeId	int, null	ID of parent object (tblNode.intNodeId); NULL = this object property is inheritable.

dbo.NodeCust

Object property values

Column	Type	Description
NodeId	int, not null	ID of object (tblNode.intNodeId)
ColumnSet	xml, null	System column with sparse column set information.
Name	nvarchar(255), null
ComputerSetName	nvarchar(255), null
SiteName	nvarchar(255), null
Hostname	nvarchar(255), null
NetworkBranchName	nvarchar(255), null
User	nvarchar(255), null
Note	nvarchar(255), null
Location	nvarchar(255), null
Address	nvarchar(255), null
OrganizationCode	nvarchar(255), null
TypeDesignation	nvarchar(255), null
InventoryNumber	nvarchar(255), null
SerialNumber	nvarchar(255), null
PackingSlipNumber	nvarchar(255), null
Port	nvarchar(255), null
Manufacturer	nvarchar(255), null
Type	nvarchar(255), null
Frequency	nvarchar(255), null
RefreshMaximum	nvarchar(255), null
RefreshMinimum	nvarchar(255), null
HorizontalResolution	nvarchar(255), null
VerticalResolution	nvarchar(255), null
Version	nvarchar(255), null
Codepage	nvarchar(255), null
CountryCode	nvarchar(255), null
FileSystem	nvarchar(255), null
LogicalDevice	nvarchar(255), null
MaximumFrequency	nvarchar(255), null
VideoMode	nvarchar(255), null
PictureWidth	nvarchar(255), null
PictureHeight	nvarchar(255), null
__order	nvarchar(255), null
NumberOfLicenses	nvarchar(255), null
Building	nvarchar(255), null
Floor	nvarchar(255), null
Room	nvarchar(255), null
Vendor	nvarchar(255), null
Department	nvarchar(255), null
PurchaseDate	date, null
Warranty	nvarchar(255), null
Description	nvarchar(255), null
DateOfNextServiceInspection	date, null
Phone	nvarchar(255), null
Fax	nvarchar(255), null
Email	nvarchar(255), null
ContactPerson	nvarchar(255), null
OrganizationName	nvarchar(255), null
Price	nvarchar(255), null
Size	nvarchar(255), null
FreeSpace	nvarchar(255), null
Website	nvarchar(255), null
Password	nvarchar(255), null
UserName	nvarchar(255), null
RamSize	nvarchar(255), null
Freeware	nvarchar(255), null
CostCenter	nvarchar(255), null
Segment	nvarchar(255), null
Unit	nvarchar(255), null
SubnetName	nvarchar(255), null
MacAddress	nvarchar(255), null
IpAddress	nvarchar(255), null
DnsDomain	nvarchar(255), null
DhcpServer	nvarchar(255), null
IpxAddress	nvarchar(255), null
Irq	nvarchar(255), null
DiskInterface	nvarchar(255), null
PersonalNumber	nvarchar(255), null
Office	nvarchar(255), null
Facility	nvarchar(255), null
Diagonal	nvarchar(255), null
ComputerKind	nvarchar(255), null
CdReadSpeed	nvarchar(255), null
DvdReadSpeed	nvarchar(255), null
CdWriteSpeed	nvarchar(255), null
DvdWriteSpeed	nvarchar(255), null
Ethernet10Mbit	nvarchar(255), null
Ethernet100Mbit	nvarchar(255), null
MaximumHorizontalResolution	nvarchar(255), null
MaximumVerticalResolution	nvarchar(255), null
BiosSerialNumber	nvarchar(255), null
Subdivision	nvarchar(255), null
Site	nvarchar(255), null
Division	nvarchar(255), null
Section	nvarchar(255), null
Subsidiary	nvarchar(255), null
Sockets	nvarchar(255), null
OccupiedSockets	nvarchar(255), null
MaximumSize	nvarchar(255), null
Model	nvarchar(255), null
WakeUpMethod	nvarchar(255), null
CaseKind	nvarchar(255), null
PartOfTheDomain	nvarchar(255), null
Quantity	nvarchar(255), null
AssetCategory	nvarchar(255), null
AssetNumber	nvarchar(255), null
AssetCheckDate	date, null
CpuSerialNumber	nvarchar(255), null
LandeskId	nvarchar(255), null
WarrantyExpiration	date, null
MobilePhone	nvarchar(255), null
Position	nvarchar(255), null
City	nvarchar(255), null
Street	nvarchar(255), null
Country	nvarchar(255), null
Company	nvarchar(255), null
PoBox	nvarchar(255), null
StateOrProvince	nvarchar(255), null
ZipCode	nvarchar(255), null
HomePhone	nvarchar(255), null
Pager	nvarchar(255), null
IpPhone	nvarchar(255), null
ScreenResolution	nvarchar(255), null
MonitorType	nvarchar(255), null
Center	nvarchar(255), null
Imei	nvarchar(255), null
DataRecordingMedium	nvarchar(255), null
PhoneNumber	nvarchar(255), null
ModemInterface	nvarchar(255), null
DataService	nvarchar(255), null
ConnectionSpeed	nvarchar(255), null
InstalledMaps	nvarchar(255), null
MemoryCardType	nvarchar(255), null
KeyFor	nvarchar(255), null
Color	nvarchar(255), null
LicensePlateNumber	nvarchar(255), null
TechnicalInspectionValidUntil	date, null
Tariff	nvarchar(255), null
ServerFarmName	nvarchar(255), null
CloudName	nvarchar(255), null
HostComputer	nvarchar(255), null
LastLoggedOnUser	nvarchar(255), null
PersonResponsibleForSoftware	nvarchar(255), null
NumberOfLogicalCpuCores	nvarchar(255), null
DefaultIncidentSla	nvarchar(255), null
DefaultIncidentService	nvarchar(255), null
MonitoringMode	nvarchar(255), null
AccountIsDisabled	nvarchar(255), null
PersonResponsibleForAsset	int, null
LastImportedFromAd	date, null
RamSizeGb	float, null
TotalStorageCapacityGb	float, null
NumberOfHardDrives	float, null
Cpu	nvarchar(255), null
NumberOfProcessors	float, null
OperatingSystem	nvarchar(255), null
MacAddresses	nvarchar(255), null
IpAddresses	nvarchar(255), null
GraphicCard	nvarchar(255), null
NumberOfPhysicalCpuCores	nvarchar(255), null
Order	nvarchar(255), null
UserGroups	nvarchar(255), null
HiddenProperties	nvarchar(255), null
ContractNumber	nvarchar(255), null
PaymentPeriodMonths	float, null
ValidFrom	date, null
ValidTo	date, null
NotifyOfTheEndOfValidityInAdvanceDays	float, null
ContractStatus	nvarchar(255), null
IntuneDeviceId	nvarchar(255), null
UserUpn	nvarchar(255), null
IntuneLastCheckIn	nvarchar(255), null
TonerLevel	nvarchar(255), null
SnmpScan	nvarchar(255), null
SnmpLastScan	nvarchar(255), null
ResourceGroup	nvarchar(255), null
AzureSqlServer	nvarchar(255), null
AzureSqlDatabase	nvarchar(255), null
AzureStorageAccount	nvarchar(255), null
Workstation	nvarchar(255), null
AlvaoAgentDeviceId	nvarchar(255), null
StatusAssetCheck	nvarchar(255), null
ReasonForNotBeingFoundAssetCheck	nvarchar(255), null
NoteForAdministratorAssetCheck	nvarchar(255), null
AdGuid	nvarchar(255), null
JamfDeviceId	nvarchar(255), null
JamfLastCheckIn	nvarchar(255), null
LansweeperDeviceId	nvarchar(255), null
LansweeperLastCheckIn	nvarchar(255), null
LansweeperSiteId	nvarchar(255), null
ZabbixDeviceId	nvarchar(255), null
ZabbixLastCheckIn	nvarchar(255), null

dbo.NodeDocument

Objects in the tree - links to documents.

Column	Type	Description
lintNodeId	int, not null	Object (tblNode.intNodeId
AMDocumentId	int, not null	Document (tblDocument.id)
RemovedDate	datetime, null	Date of link deletion.
RemovedByPersonId	int, null	ID of the person who deleted the link.

dbo.NodeHealthStatus

Object health status

Column	Type	Description
id	int, not null	Health status ID.
Description	nvarchar(max), null	Status description

dbo.NodeHealthStatusLoc

Cache of language localizations of object health statuses, see NodeHealthStatus.

Column	Type	Description
NodeHealthStatusId	int, not null	Health status ID (NodeHealthStatus.id).
LocaleId	int, not null	Language ID (tLocale.iLocaleId).
Description	nvarchar(max), null	Localized status description.

dbo.NodeRelation

Table with links between objects in Asset Management

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.
CreatedDate	datetime, not null	Link creation date and time (UTC)
CreatedByPersonId	int, not null	User ID of a person who created the link (tPerson.iPersonId).
RemovedDate	datetime, null	Link removal date and time (UTC)
RemovedByPersonId	int, null	User ID of a person who deleted the link (tPerson.iPersonId).

dbo.NodeRelationType

Types of links between objects 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.
NodeRelationTypeBehaviorId	int, not null	Link behavior. System or custom. Foreign key to NodeRelationTypeBehavior.
LineStyle	varchar, not null
LineColor	varchar, not null
AffectsNodeHealth	bit, not null	1 = health of the final object is influenced by the health of the starting object. 0 = otherwise.

dbo.NodeRelationTypeBehavior

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

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

dbo.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 including of child objects.
RecursiveOld	bit, null	Check box including of child objects - the previous value.
Class	nvarchar(255), null	Object type name.
ClassOld	nvarchar(255), null	Object type name - the previous value.
Read	bit, null	Permission to read.
ReadOld	bit, null	Permission to read - the previous value.
Write	bit, null	Permission to edit.
WriteOld	bit, null	Permission to edit - the previous value.
Move	bit, null	Permission to move.
MoveOld	bit, null	Permission to move - the previous value.
Create	bit, null	Permission to create any objects.
CreateOld	bit, null	Permission to create any objects - the previous value.
Delete	bit, null	Permission to delete.
DeleteOld	bit, null	Permission to delete - the previous value.
ModifiedBy	nvarchar(255), not null	Logged-in user name.

dbo.OperatorServiceUsage

Services to which the given solver created tickets last using the New Ticket Form.

Column	Type	Description
id	int, not null	Record ID.
PersonId	int, not null	The solver who used the given service while registering the ticket.
HdSectionId	int, not null	Used service ID while registering the ticket
LastUsed	datetime, not null	Service last use time

dbo.PeriodicAlert

Periodic alerts not defined by an SQL query. Sent by e-mail, periodically with the selected regularity.

Column	Type	Description
id	int, not null	Record ID
Name	nvarchar(255), not null	Alert name
Description	nvarchar(max), null	Description
IsEnabled	bit, not null	If sending is enabled. 1 = enabled, 0 = disabled.
AttachCSV	bit, not null	If the CSV attachment is be attached to the notification. 1 = enabled, 0 = disabled
PeriodicAlertPeriodId	tinyint, not null	Send period. A foreign key on PeriodicAlertPeriod.
StartDate	datetime, not null	Date and time from which the alert should be sent. At the same time, it is the starting point for calculating the date and time another will be sent according to the selected period.
LastSent	datetime, null	Date and time of last alert sent.
SqlQuery	nvarchar(max), null	SQL query defining alerts.
RunOverAnalyticalDatabase	bit, not null	If starting above the analytical database is enabled. 1 = enabled, 0 = disabled.
LastModified	datetime, not null	Date and time of the last notice modification.
ErrorMessage	nvarchar(max), null	Error message at the last SQL script run.

dbo.PeriodicAlertPeriod

Send period of periodic alerts.

Column	Type	Description
id	tinyint, not null	Record ID
Name	nvarchar(255), not null	Period name

dbo.PersonBehavior

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

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

dbo.PersonEmailUsage

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

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

dbo.PersonEventDisplay

Events viewed by a person.

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

dbo.PersonGridView

Cache for the number of unread tickets from the viewpoint of a specific user.

Column	Type	Description
id	int, not null	Record ID.
PersonId	int, not null	Person (tPerson.iPersonId).
GridName	nvarchar(200), null	Name of table (grid), see the ProfileValue.ValueName table.
ViewName	nvarchar(200), null	View name.
UnreadTicketsCount	int, null	Number of unread tickets in the view.
LastCheck	datetime, null	Time (UTC) of the last update of the UnreadTicketsCount value.

dbo.PersonManager

Pre-counted structure of managers and employees.

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

dbo.PersonPasswordHistory

Used people's passwords.

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

dbo.PersonTicketDisplay

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

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

dbo.PrintReportTemplate

Templates for print reports

Column	Type	Description
id	int, not null	Record ID
Name	nvarchar(255), not null	Template name
Description	nvarchar(max), null	Description of template
LastModified	datetime, not null	Date and time of last change
LastModifiedByPersonId	int, not null	User ID of the person who performed the latest change (tPerson.iPersonId).

dbo.ProductCust

Product License custom fields values.

Column	Type	Description
ProductId	int, not null

dbo.ProductState

Status of the products

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

dbo.ProfileValue

View settings table

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

dbo.ReceivedMessage

Table for temporary storage of read messages for custom actions.

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

dbo.ReceivedMessageRule

Rules for incoming messages to service mailboxes.

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 ticket" (Yes/No).
DeleteRequest	bit, not null	Permit "Remove ticket" option (Yes/no).
ModifiedDate	datetime, null	Date and time of last rule edit.
ModifiedByPersonId	int, null	Person who edited the rules.

dbo.RelatedTicketRule

The rules for automatic creation of linked tickets while transiting the source ticket to a certain status.

Column	Type	Description
id	int, not null	Record ID
TicketStateId	int, not null	Ticket status ID (TicketState.id)
TicketTemplateId	int, not null	Ticket template ID (see TicketTemplate.id)
TicketRelationTypeId	int, not null	ID of the relation type between tickets (see TicketRelationType.id)
InDirection	bit, not null	Relation direction; 1 = the created ticket is at the beginning of the relation, 0 = the created ticket is at the end of the relation.
TicketNameTemplate	nvarchar(1024), null	Ticket name template
RelatedTicketRuleRequesterModeId	tinyint, not null	ID of requester setting method (see RelatedTicketRuleRequesterMode.id). 1 = source ticket requester; 2 = source ticket solver; 3 = RequesterPersonId.
RequesterPersonId	int, null	ID of requester for a new ticket (see tPerson.iPersonId)
RequesterColumnId	int, null	ID of selected custom field of type User. This column is used when RelatedTicketRuleRequesterModeId=4. Otherwise is null.
SqlCondition	nvarchar(max), null	SQL condition for creating a ticket

dbo.RelatedTicketRuleColumn

Copied items of the source ticket while creating linked tickets.

Column	Type	Description
RelatedTicketRuleId	int, not null	Rule ID (see RelatedTicketRule.id)
ColumnId	int, not null	Ticket item ID (see tColumn.iColumnId)

dbo.RelatedTicketRuleRequesterMode

Method of setting the requester while creating linked tickets, see RelatedTicketRule.

Column	Type	Description
id	tinyint, not null	Record ID
Description	nvarchar(1024), null	Record description

dbo.RequiredClassKind

The table contains properties that must be filled in for the given object types.

Column	Type	Description
ClassId	int, not null	Object type ID (tblClass.intClassId)
KindId	int, not null	Property definition ID (tblKind.intKindId)

dbo.RoleBehavior

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

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

dbo.RoleMembershipLog

Logging of changes in membership in groups.

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

dbo.RoleMembershipLogMemberType

Kind of membership in the group.

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

dbo.RoleMembershipLogOperation

Executed operation which is logged.

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

dbo.SamAlert

SAM notifications sent.

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

dbo.SamAlertConfig

SAM configuration of notifications.

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

dbo.SamAlertRule

SAM notification rules.

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

dbo.SamType

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

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

dbo.Scanner

Scanners importing data from other systems or physical devices into Alvao.

Column	Type	Description
id	int, not null	Scanner id (system-defined values)
Name	nvarchar(32), not null	Scanner name

dbo.ScannerPropertyLockout

Locking of values of object properties (dbo.tblKind) for editing by scanners (dbo.Scanner).

Column	Type	Description
id	int, not null
ScannerId	int, not null	Scanner (Scanner.id)
ClassId	int, not null	Object type (tblClass.intClassId)
LockingKindId	int, not null	A property definition (tblKind.intKindId) whose non-empty value locks the property LockedKindId for editing.
LockedKindId	int, not null	A property definition (tblKind.intKindId) which is locked for editing by the non-empty value of the property LockingKindId.

dbo.SccmConnection

Connection to MS SCCM

Column	Type	Description
id	int, not null	Record ID
SccmConnectionKindId	int, not null	Type of connection (SccmConnectionKind.id)
Url	nvarchar(2048), null	Administration Service URL
Username	nvarchar(32), null	Login name for connecting to Administration Service
Password	nvarchar(32), null	User password
ClientId	nvarchar(255), null	GUID of the native client application registered in Azure. Required when connecting via Cloud Management Gateway.
TokenEndpoint	nvarchar(2048), null	URL of the access point for the native client application used to obtain an authorisation token for connecting via the Cloud Management Gateway.
ApplicationUri	nvarchar(2048), null	URL of the web application registered in Azura used to connect via the Cloud Management Gateway.
ConnectionString	nvarchar(2048), null	Connection string for the SCCM database

dbo.SccmConnectionKind

Type of connection to MS SCCM

Column	Type	Description
id	int, not null	Record ID: 1=Administration Service 2=Database
Name	nvarchar(32), not null	Type name

Apps.Script

Application scripts.

Column	Type	Description
id	int, not null	Script ID.
AppId	int, not null	Application ID.
Name	nvarchar(255), not null	Script name.
Code	nvarchar(max), null	Source code of the script.
IsCompilable	bit, not null	Whether the source code can be compiled. 1 = yes, 0 = no.
LastChanged	datetime, null	The date the script was last modified.
IsLibCode	bit, not null	If the code is library. 1 = yes, 0 = no.
Codesign	nvarchar(2048), null	Certified script integrity check value.
Warning	bit, not null	1 = the script contains at least one warning, 0 = no warnings in the script.

dbo.SearchLog

Log of searched queries

Column	Type	Description
id	int, not null	Record ID
TimeStamp	datetime, not null	Date and time of search
Query	nvarchar(max), null	Query
PersonId	int, null	User ID

dbo.SectionSequence

Column	Type	Description
NextSectionId	int, not null

dbo.Server

Settings of server applications (Alvao Service, 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
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
AutoLoadStorageConString	nvarchar(1024), null	Connection string of MS Azure storage account. The Alvao Service will automatically load detection data from this storage.
SwLibDownloadLib	bit, not null	The collector will automatically update the SW product library from the Internet. If the option is enabled, it will take precedence over updating from the folder.
SwlibEvalAllDetAfterDownload	bit, not null
SwlibCheckNewLibDays	int, null
SwLibSearchUnknownSW	bit, not null
SwlibSendAnon	bit, not null
SwLibSendContactEmail	nvarchar(255), null
SwLibLoadFromPath	nvarchar(1024), null	The folder from which the new version of SW products library is uploaded.
IsAlvaoService	bit, not null	1 = this record applies to Alvao Service.

dbo.SharedView

Table of shared views.

Column	Type	Description
id	int, not null	Shared view identifier
OwnerPersonId	int, not null	View owner. A foreign key to the tPerson table.
Settings	nvarchar(max), not null	Shared view setting
GridName	nvarchar(max), not null	Name of a table which the shared view is assigned to. The same as dbo.ProfileValue.ValueName.
Removed	datetime, null	Time of view deletion. If it wasn’t, NULL is present.

dbo.SharedViewRecipient

Table of users and groups which the view is shared with.

Column	Type	Description
RoleId	int, null	The group of persons who the view is shared with.
SharedViewId	int, not null	A foreign key to the SharedView table.
id	int, not null	Record identifier.
PersonId	int, null	A person who the view is shared with.

dbo.SlaAlertRuleReceiver

Notice for unresolved tickets - other recipients.

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

dbo.SlaLoc

Cache of SLA localizations.

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

dbo.SlaRightsLog

Logging of changes in SLA assignment
The meaning of values in permission columns:
1=enable
0=refuse
NULL=not set

Column	Type	Description
id	int, not null	Record ID
TimeStamp	datetime, not null	Change performance date and time (UTC)
ModifiedByPersonId	int, null	User ID of a person who performed the change.
ModifiedByPerson	nvarchar(255), not null	The name of the user who did the change.
HdSectionId	int, null	Service ID
HdSectionIdOld	int, null	ID of the original service
HdSection	nvarchar(255), null	Service name
HdSectionOld	nvarchar(255), null	Original service name
RoleId	int, null	User group ID which is the permission holder.
RoleIdOld	int, null
Role	nvarchar(255), null	User group name of a person who was originally a permission holder.
RoleOld	nvarchar(255), null
PersonId	int, null	User ID of a person who is the permission holder.
PersonIdOld	int, null	User ID of a person who was originally a permission holder.
Person	nvarchar(255), null	User name of a person who is the permission holder.
PersonOld	nvarchar(255), null	User name of a person who was originally a permission holder.
SlaId	int, null	SLA ID
SlaIdOld	int, null	ID of the original SLA
Sla	nvarchar(255), null	SLA name
SlaOld	nvarchar(255), null	Original SLA name
Access	bit, null	Access permissions
AccessOld	bit, null	Original access permissions
Default	bit, null	Marking of the default SLA
DefaultOld	bit, null	Original marking of the default SLA
Inheritance	bit, null	Inheritance.
InheritanceOld	bit, null	Original value of inheritance.

dbo.SnmpDeviceTypeMap

Map for determining the type of object based on device descriptions in SNMP.

Column	Type	Description
id	int, not null	Record id
SysDescrRegex	nvarchar(max), not null	Regex pattern of the "sysDescr" SNMP values (OID 1.3.6.1.2.1.1.1) associated with this record. See Regular Expression Language - Quick Reference.
ClassId	int, null	Object type (see tblClass).

dbo.StringLoc

Cache of text string localizations.

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

dbo.Subscriber

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

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

dbo.SwItemKind

Kinds of records in the views of software.

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

dbo.tAccount

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

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

dbo.tAccountCust

Organization custom fields values.

Column	Type	Description
liAccountId	int, null

dbo.tAct

The record in communication or ticket log.

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	Ticket 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(2048), null	Name of the recipient. At e-mail messages sent to multiple recipients, the column contains all message recipients.
sActToEmail	nvarchar(255), null	Recipient e-mail. The column is empty at e-mail messages sent to multiple recipients.
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(2048), 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 traveled 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 ALVAO Service. 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
ActMarkId	tinyint, null	Record marking. A foreign key to the ActMark table.
UserRead	bit, not null	The flag specifying whether this event can also be seen by requesters or ticket participants without additional permissions for the service
Modified	datetime, null	Time at which the record was modified.

dbo.tActKind

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

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

dbo.tAddress

Address

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

dbo.tApprovalSchema

Approval schemes.

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

dbo.tApprovalSchemaItem

Approval scheme step.

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

dbo.tArticle

Article in Knowledge Base.

Column	Type	Description
iArticleId	int, not null
sArticle	nvarchar(1024), null
mArticleAnnotation	nvarchar(max), null
mArticle	nvarchar(max), null
dArticleCreated	datetime, null
dArticleModified	datetime, null
liArticleAuthorPersonId	int, null
ModifierPersonId	int, null
HtmlArticle	nvarchar(max), null
Published	bit, null
Order	int, null
Removed	datetime, null
HtmlArticleBinary	varbinary, null
HtmlArticleBinaryExt	nvarchar(10), null
SimilarityVector	nvarchar(max), null	Contains embedding vector calculated from the article text.
LocaleId	int, null
ExternalArticleId	int, null	ID of an article from external services

dbo.tBankHoliday

National holidays.

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

dbo.tBankHolidayLoaded

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

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

dbo.tBankHolidayRegion

Local national holiday regions.

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

dbo.tblADMap

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

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

dbo.tblClass

ID of the objects types. Texts in tblDict.

Column	Type	Description
intClassId	int, not null	Class Id
bComputer	bit, not null	If the type is a computer
DefaultObjectTemplateNodeId	int, null	Default object template (tblNode.intNodeId)
ObjectNameTemplate	nvarchar(max), null	Object name template

dbo.tblCommandDef

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

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

dbo.tblCompany

Code list of organizations (software products library).

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

dbo.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 Asset Management. The time of the detection is written to dteRqCreated.
txtCollector	nvarchar(255), null	Name of server on which the AM Collector that reserved the request resolution is running.
txtShareRq	nvarchar(255), null	Name of request sub-folder for detection via shared folder.
lintDetectStatusId	int, not null	1 = "no response so far" 2 = "ok" - carried out without warnings and errors. 3 = "warning" - Warnings were encountered during the detection process, but no errors. 4 = "error" - At least one error was encountered during the detection.
liRqCreatedPersonId	int, not null	The user that created this request, see tPerson.
dUpdated	datetime, null
DetectSourceMethod	int, null
ManualRq	bit, not null	If the value is 1, the request was created manually with the activated Detect and evaluate immediately option.

dbo.tblDetectAction

Scheduled evaluation of HW and SW by detection.

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

dbo.tblDetectKind

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

Column	Type	Description
intDetectKindId	int, not null

dbo.tblDetectOpts

Detections setting.

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

dbo.tblDetectStatus

ID of the detections statuses. Texts in tblDict.

Column	Type	Description
intDetectStatusId	int, not null

dbo.tblDetFile

Detected files on the computers (SW detection).

Column	Type	Description
intDetFileId	int, not null
lintFileId	int, null
lintDetectId	int, null
txtFolderPath	nvarchar(255), null
dteCreated	datetime, null
dteModified	datetime, null
dteAccessed	datetime, null
intAttribs	int, null
LastRun	datetime, null	The date the file was last run.
RunCount	int, null	Total number of files running

dbo.tblDict

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

Column	Type	Description
lintClassId	int, null	object class - tblClass
lintNameLangId	int, null	language name - tblLang
lintDetectKindId	int, null
lintDetectStatusId	int, null
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	Just one of the attributes lintClassId, lintNameLangId, ..., lintDiaryKindId must have a value different from null. The attribute txtText contains the name of the relevant item.
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	Asset check status
lintAllClassObjId	int, null	Text for "all objects" - combo box
lintLendSubjId	int, null	Log - rental
lintLendMsgId	int, null	Log - rental
liSwPresenceId	int, null	SW profiles - profile name
iLicenseStatusId	int, null	SW - license status - text
iLicErrMsgId	int, null	SW - error message for license on SW tab
iSwProfErrMsgId	int, null	SW - error message for profile on SW tab

dbo.tblDocument

Documents.

Column	Type	Description
id	int, not null	Record ID
Name	nvarchar(255), null	Name of the document.
IdNumber	nvarchar(255), null	Identification number 1
lintDocumentKindId	int, not null	Type - tblDict
txtMemo	nvarchar(max), null	Note
CreatedDate	datetime, not null	Date and time the document was created (UTC).
IssuedDate	datetime, null	Date of issue of the document.
lintResellerCompanyId	int, null	Vendor - tblCompany
lintSrcNodeId	int, null	Handover protocol - the User type object representing a person handing over (tblNode.intNodeId).
lintDestNodeId	int, null	Handover protocol - the User type object representing a recipient (tblNode.intNodeId).
txtIdNumber2	nvarchar(255), null	ID number 2
dteRemoved	datetime, null	Voided
liCreatedPersonId	int, null	Author - tPerson
liRemovedPersonId	int, null	Voided by - tPerson
TransferConfirmTypeId	int, not null	Sign method.
SignDate	datetime, null	Date of signing.
SignPersonId	int, null	ID of the person who signed the document.
SignComputer	nvarchar(255), null	Name of the computer from which the document was signed.
SignedBy	nvarchar(128), null	The person who signed the document (if its ID cannot be obtained)
DocumentFolderId	int, not null	Document folder (DocumentFolder.id)
GiverFlags	int, null	The bit array of flags expressing the relation of the person handing over to the handed over asset in the handover protocol. Possible values: NULL = no relation 0x01 = assets entrusted for use 0x02 = other entrusted assets
ReceiverFlags	int, null	The bit array of flags expressing the relation of the recipient to the asset handed over in the handover protocol. Possible values: NULL = no relation 0x01 = assets entrusted for use 0x02 = other entrusted assets
SummaryProtocol	bit, not null	1 = this is a summary internal handover protocol.
HtmlText	nvarchar(max), null	Html text of the document.

dbo.tblDocumentKind

Kinds of documents. Texts in tblDict

Column	Type	Description
intDocumentKindId	int, not null

dbo.tblFile

Detected files on the computer (SW detection).

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

dbo.tblFileImage

Recognition rules for files (software products library).

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

dbo.tblFileStringInfo

Information on detected files - texts.

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

dbo.tblFileVerInfo

Information on detected files - versions.

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

dbo.tblHistory

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

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

dbo.tblIcon

Icons.

Column	Type	Description
intIconId	int, not null	icon Id
txtDesc	nvarchar(255), null	icon name
uid	int, null	Unique identifier UID (only system icons)
Svg	varbinary, null	Icon in SVG format

dbo.tblIdSeq

Numeric sequences - 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	Sequence name
liKindId	int, null	Property
bUse	bit, not null	1=series is active
IdSeqTypeId	int, null	Numeric sequence type.

dbo.tblInstHist

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

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

dbo.tblInstTrial

Special installation.

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

dbo.tblKind

Definitions of the objects properties.

Column	Type	Description
intKindId	int, not null	primary key
txtName	nvarchar(255), not null	property name
intFlags	int, null	bit field: 0x20 = property not inheritable
lintValueKindId	int, null	This attribute contains the tblKind.intKindId definition of the property, from which the list of values shall be used (tblKindValue)
bolGlobalScope	bit, not null	1 = global property for a class of objects. "0" indicates the property is considered local for each class of objects (printers, computers etc.). An automatic list of values is then put together from the values of this property for the given object class,
bolUnique	bit, not null	1 = property value must be unique
intOrder	int, null	The sequence for table filtering can be set
intKindCode	int, null	The unique number determines the property (integrated ones are numbered), user properties do not have this number
bSelectOnly	bit, not null	1 = property value can only be selected from the list of values
CleanValueByCopying	bit, not null	1 = Delete value when copying properties
KindDataTypeId	int, not null	Property data type ID.
RequiredForAllClasses	bit, not null	1 = the property is mandatory in objects of all kinds that use it. In this case, there is no record for it in the RequiredClassKind table.
ColumnName	nvarchar(255), null	NodeCust table column name that stores the property value. NULL = the object property is not used in any object class and has no representation in the NodeCust table.
Category	nvarchar(max), null	Property categories

dbo.tblKindValue

Value lists for the properties of objects.

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

dbo.tblLang

ID of languages. Text in tblDict

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

dbo.tblLicHist

License - list of purchased software licenses.

Column	Type	Description
intLicHistId	int, not null	Record ID
lintProductId	int, not null	Product - tblProduct
LicenseCount	int, null	Number of purchased licenses
dteDate	date, not null	Purchase date
dteDateExpire	date, null	Date of expiration
txtLicName	nvarchar(255), null	License name
txtMemo	nvarchar(max), null	Note
txtDepartment	nvarchar(255), null	Cost center
txtInventoryNum	nvarchar(255), null	Inventory number
dteUpgradeTo	date, null	Date of upgrading to ...
txtActivationKey	nvarchar(1024), null	Activation key
CreatedPersonId	int, null	Author - tPerson
CreatedDate	datetime, null	Created.
LicKindId	int, not null	1 = devices 2 = user 3 = connection 4 = processor
AutoAssign	bit, not null	Assign automatically
MultiAssign	bit, not null	A flag indicating whether multiple license items can be assigned to the same object.
LicTypeId	int, null	License type.
AutoAssignFilter	nvarchar(max), null	Filter for automatic assignment of licenses.
InvalidatedDate	datetime, null	The date on which the license was invalidated.
InvalidatedByPersonId	int, null	The person who has invalidated the license.
AutoAssignNow	bit, not null	A tag indicating whether the license should be automatically and immediately assigned.
OrganizationNodeId	int, null	Organization ID.
IsValid	bit, not null	A flag indicating whether the license is valid.
UId	nvarchar(255), null	Unique license identifier in the external system.
CoverPackPartsWithoutPackageInstalled	bit, not null	Cover package components when package itself is not installed. 0 = the license will cover the components of the package only if the license package itself is installed. 1 = the license covers the components of the package even if the package itself is not installed.
NoProductInstallation	bit, not null	Check whether the assigned license covers any installations on endpoint devices or not (SaaS, CAL).
ProductNotes	nvarchar(255), null

dbo.tblLicHistItem

License - license items.

Column	Type	Description
intLicHistItemId	int, not null	Record ID
lintLicHistId	int, not null	License ID - tblLicHist
NodeId	int, null	Computer ID - tblNode
ActivationKey	nvarchar(255), null	Serial number
txtMemo	nvarchar(max), null	Note
txtInventoryNum	nvarchar(255), null	Inventory number
txtDepartment	nvarchar(255), null	Center
txtRequest	nvarchar(255), null	Ticket
AutoAssigned	bit, not null	Automatically assigned item
LicensesCount	int, not null	Number of assigned licenses

dbo.tblLicTrans

License - shared licenses.

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

dbo.tblLog

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

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

dbo.tblMedia

Media.

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

dbo.tblMediaType

ID of the media types. Texts in tblDict.

Column	Type	Description
intMediaTypeId	int, not null

dbo.tblNetScanRange

Network search setting.

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

dbo.tblNode

Objects in the tree.

Column	Type	Description
intNodeId	int, not null	Object id
lintParentId	int, null	Id of parent object, foreign key to tblNode
lintIconId	int, null	icon - tblIcon
intState	int, null	bit field: 1 = Recycle Bin object 2 = the object is protected against deletion 4 = Object Template object 8 = object cannot obe moved 0x10 = hidden object 0x20 = object template 0x40 = property list tabs 0x80 = history is not kept for the object 0x100 = folder "Computer found in network"
txtName	nvarchar(255), null	object name
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
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	1=all software is allowed 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.
DetectProfileId	int, null	Computer detection profile
RequiredPropertyAlert	bit, not null	The object does not have any of the required properties filled in.
PathLen	int, null
IsDiscarded	bit, not null	1 = the object is discarded.
IsRemoved	bit, not null	1 = Whether the object is in the Recycle bin.
IsTemplate	bit, not null	1 = the object is object template.
IsHidden	bit, null	1 = the object is the Recycle bin, or Object templates, or Property categories, or their child object.
IsActive	bit, null	1 = the object is not the Discarded assets, or the Recycle bin, or Object templates, or Property categories, neither their child object.
Search	nvarchar(max), null	Column for full text search.

dbo.tblNodeParent

Objects in the tree - tree.

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

dbo.tblNotice

Notes.

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

dbo.tblOsVersionInfo

Detection of SW - information on the operating system.

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

dbo.tblProduct

Products / software (software products library).

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

dbo.tblProductCategory

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

Column	Type	Description
intProductCategoryId	int, not null

dbo.tblProductPack

Definition of software products packages (software products library).

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

dbo.tblProductType

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

Column	Type	Description
intProductTypeId	int, not null

dbo.tblPropertyMap

Mapping properties to system functions.

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

dbo.tblRegImage

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

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

dbo.tblRegUninstall

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

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

dbo.tblRegValue

Detection - values of detected records from the register.

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

dbo.tblSetting

Mapping properties to system functions.

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

dbo.tblSwLibUpdate

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

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

dbo.tblSystemSetting

System settings.

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

dbo.tblUserNodeRight

Rights in the object tree to groups / users.

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

dbo.tblVersion

Software products library version.

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

dbo.tblWbemClassDesc

Code list of values for the detected HW properties.

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

dbo.tblWbemObject

HW detected in the computers.

Column	Type	Description
intWbemObjectId	int, not null
lintDetectId	int, not null
bolVirtualObject	bit, not null
__CLASS	nvarchar(255), null
AdapterRAM	float, null
AdapterType	nvarchar(255), null
AttachedTo	nvarchar(255), null
Availability	int, null
BankLabel	nvarchar(255), null
BaseBoard	nvarchar(255), null
Capacity	bigint, null
Caption	nvarchar(255), null
ChassisTypes	int, null
txtChassisTypesDesc	nvarchar(255), null
Compressed	bit, null
CSDVersion	nvarchar(255), null
CurrentClockSpeed	int, null
CurrentRefreshRate	int, null
DataWidth	int, null
Description	nvarchar(255), null
DeviceID	nvarchar(255), null
DeviceLocator	nvarchar(255), null
DeviceType	nvarchar(255), null
DHCPEnabled	bit, null
DNSServerSearchOrder	nvarchar(255), null
Prop_Domain	nvarchar(255), null
Drive	nvarchar(255), null
DriveType	int, null
EDIDVersion	nvarchar(255), null
FileSystem	nvarchar(255), null
FormFactor	int, null
txtFormFactorDesc	nvarchar(255), null
FreeSpace	float, null
InstallDate	datetime, null
InfraredSupported	bit, null
InterfaceType	nvarchar(255), null
IPAddress	nvarchar(255), null
IPEnabled	bit, null
IPSubnet	nvarchar(255), null
IRQNumber	int, null
MACAddress	nvarchar(255), null
ManufactureDate	datetime, null
Manufacturer	nvarchar(255), null
MaxCapacity	int, null
MaxClockSpeed	int, null
MaxRefreshRate	int, null
MediaType	nvarchar(255), null
MemoryDevices	int, null
MemoryType	int, null
txtMemoryTypeDesc	nvarchar(255), null
MinRefreshRate	int, null
Model	nvarchar(255), null
MonitorManufacturer	nvarchar(255), null
Monochrome	bit, null
PartOfDomain	bit, null
Prop_Name	nvarchar(255), null
NetConnectionID	nvarchar(255), null
Organization	nvarchar(255), null
OSLanguage	int, null
PNPDeviceID	nvarchar(255), null
PortName	nvarchar(255), null
ProcessorId	nvarchar(255), null
Prop_Product	nvarchar(255), null
RegisteredUser	nvarchar(255), null
ScreenHeight	int, null
ScreenWidth	int, null
SerialNumber	nvarchar(255), null
Prop_Size	float, null
Service	nvarchar(255), null
ServiceName	nvarchar(255), null
SMBIOSBIOSVersion	nvarchar(255), null
SocketDesignation	nvarchar(255), null
Speed	nvarchar(255), null
StatusInfo	int, null
txtStatusInfoDesc	nvarchar(255), null
SystemDirectory	nvarchar(255), null
SystemType	nvarchar(255), null
TotalPhysicalMemory	bigint, null
TypeDetail	int, null
txtTypeDetailDesc	nvarchar(255), null
UPSPort	nvarchar(255), null
UserName	nvarchar(255), null
Version	nvarchar(255), null
VideoModeDescription	nvarchar(255), null
VolumeSerialNumber	nvarchar(255), null
WakeUpType	int, null
txtWakeUpTypeDesc	nvarchar(255), null
AlvaoVirtualMachineHostname	nvarchar(128), null
NumberOfLogicalProcessors	int, null
Active	bit, null
MaxHorizontalImageSize	int, null
MaxVerticalImageSize	int, null
DriveLetter	nvarchar(16), null	Drive letter.
ProtectionStatus	int, null	The status of drive section encryption by the BitLocker tool. 0 = off, 1 = on, 2 = unknown.
NumberOfCores	int, null	Number of physical CPU cores.
IsActivated	bit, null
IsEnabled	bit, null
IsOwned	bit, null
ManufacturerVersion	nvarchar(128), null
ManufacturerVersionFull20	nvarchar(128), null
ManufacturerVersionInfo	nvarchar(128), null
PhysicalPresenceVersionInfo	nvarchar(128), null
SpecVersion	nvarchar(128), null

dbo.tblWbemObjectProcess

Hardware "Blacklist".

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

dbo.tblWbemObjectRel

Links between the detected components of the computers.

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

dbo.tColumn

List of custom fields and certain system items.

Column	Type	Description
iColumnId	int, not null	Item ID.
sTable	nvarchar(128), null	Name of the table where the values of the item are stored.
sColumn	nvarchar(128), null	Name of the column in the table where the values of the item are stored.
sTitle	nvarchar(255), not null	Displayed item name.
mDescription	nvarchar(max), null	Item description.
nOrder	float, not null	The order of items as they are described on the forms.
bUseColumnValue	bit, not null	Use the value list.
Removed	datetime, null	Date of item removal.
Multiline	bit, not null	Multi-row text.
Localize	bit, not null	The flag specifying whether translation of value lists of a custom field into other languages is enabled / allowed.
Type	nvarchar(128), null	Custom field data type. May contain basic types (i.e. nvarchar, bit, int, datetime, float) or advanced data types: user – int representing foreign key to tPerson (i.e. tPerson.iPersonId)
MaxLength	int, null	The maximum length of a custom field in characters.
RoleId	int, null	Source group of field type User (tRole.iRoleId).

dbo.tColumnValue

Value lists for custom fields.

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

dbo.tDay

Calendar of days

Column	Type	Description
dDay	datetime, not null

dbo.tDb

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

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

dbo.tDetectedClassKind

Detected properties of the computer components.

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

dbo.tDocument

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

Column	Type	Description
iDocumentId	int, not null	Record ID.
sDocument	nvarchar(255), null	File name.
sDocumentContentType	nvarchar(255), null	MIME file type.
oDocument	varbinary, null	Binary data set if a file is attached. This column is NULL for a reference attachment
liDocumentActId	int, null	Event ID in the ticket log (tAct) to which the attachment belongs.
liDocumentArticleId	int, null	Article ID in the Knowledge Base (tArticle) to which the attachment belongs.
Url	nvarchar(max), null	URL address if it is the attachment of the link type. The column is NULL at the attachments of the file type.
AMDocumentId	int, null	Document ID in ALVAO Asset Management (tblDocument), to which the attachment belongs.
AMNoticeId	int, null	Object notice ID (tblNotice) to which the attachment belongs.
TicketTemplateId	int, null	ID of the ticket template (TicketTemplate) to which the attachment belongs.
NewsId	int, null	News post ID (News.id) to which the attachment belongs.
EmailSignatureId	int, null	User signature ID (tEmailSignature) to which the attachment belongs.
HdTicketApprovalItemId	int, null	ID of the approval step (tHdTicketApprovalItem) to which the attachment belongs.
EmbededImage	bit, not null	If the value is 1, it is not an attachment but an image inserted directly into the formatted text.
PrintReportTemplateId	int, null	ID of the print report template (PrintReportTemplate) to which the attachment belongs.
SolverInstructionsTicketStateId	int, null	Ticket status (TicketState.id) to whose instructions for resolvers this file belongs.
NodeId	int, null	Id of the object (tblNode.intNodeId), to which the attachment belongs.
Created	datetime, null	Date and time on which was the document added.
CreatedByPersonId	int, null	Id of the person (tPerson.iPersonId), who added the document.
NewTicketFormTextBlockId	int, null
UniqueGUID	uniqueidentifier, not null
OcrText	nvarchar(max), null	Textual content of the image recognized by OCR
OcrLastError	nvarchar(max), null	Last error message returned by OCR

dbo.tEmailSignature

Signatures for e-mail messages.

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

dbo.tEmailTemplate

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

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

dbo.TenantDiagnosticsLog

Tenant diagnostics log records

Column	Type	Description
id	int, not null	Record ID
LoggedDate	datetime, not null	Time stamp of created log record (UTC by default).
LogLevelId	int, not null	Log level of the record
Message	nvarchar(max), null	Log message
Application	nvarchar(250), null	Name of application that generated the log record.
Callsite	nvarchar(max), null	Context of the logged event (e.g., a source code class name, method name, etc.)
Exception	nvarchar(max), null	Occurred exception information
Parameters	nvarchar(max), null	Additional detailed text parameters of the log record.

dbo.TenantSecurityChangeLog

Tenant security-change log records

Column	Type	Description
id	int, not null	Record ID
LoggedDate	datetime, not null	Time stamp of created log record (UTC by default).
LogLevelId	int, not null	Log level of the record
Message	nvarchar(max), null	Log message
Application	nvarchar(250), null	Name of application that has generated log record.
Parameters	nvarchar(max), null	Additional detailed text parameters of the log record.

dbo.TenantSigninLog

User sign in log records

Column	Type	Description
id	int, not null	Record ID
LoggedDate	datetime, not null	Time stamp of created log record (UTC by default).
LogLevelId	int, not null	Log level of the record
Message	nvarchar(max), null	Log message
Application	nvarchar(250), null	Name of application that has generated log record.
Parameters	nvarchar(max), null	Additional detailed text parameters of the log record.

dbo.tHdSection

ALVAO Service Desk product services.

Column	Type	Description
iHdSectionId	int, not null	Record ID.
sHdSection	nvarchar(1024), 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.
nHdSectionOrder	float, null	Order in which services are displayed.
liHdSectionParentHdSectionId	int, null	Link to ancestor in tree.
sHdSectionEmail	nvarchar(255), null	Service email.
sHdSectionMessageTagPrefix	nvarchar(255), null	Prefix in ticket number.
sHdSectionMessageTagSuffix	nvarchar(255), null	Suffix in ticket number.
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.
sHdSectionUserShowFields	nvarchar(1024), null	List of optional items that shall be displayed on the portal during the process of editing/viewing the ticket.
nHdSectionUserReopenDays	float, null	The number of days when the requester may reopen their ticket until the ticket is resolved.
bHdSectionMessageRemove	bit, not null	If the value is 1, processed messages are removed from the server.
sHdSectionMailboxLogin	nvarchar(255), null	Username for loading messages.
sHdSectionMailboxPassword	nvarchar(255), null	Password for loading messages.
bHdSectionHdTicketUserRead	bit, not null	If this is 1, the user can view the tickets of other users from the same organization in this service.
UserManagerCanReadTickets	bit, not null	Managers can read the tickets of their reports.
bHdSectionFolder	bit, not null	If the service is only a folder containing other services and the user cannot insert tickets, the value is 1. The button for creating a ticket for this service is not displayed in the portal.
sHdSectionNewHdTicketUrl	nvarchar(1024), null	URL of the custom form to create a new ticket.
sHdSectionHdTicketCustomWorkflowUrl	nvarchar(1024), null	Custom workflow URL.
dHdSectionRemoved	datetime, null	Time at which the service was removed. The service is not removed for NULL.
bHdSectionMessageReadOnlyUnread	bit, not null	If the value is 1, only unread messages are read.
bHdSectionMessageMarkRead	bit, not null	If the value is 1, messages are marked as read once the message is loaded.
sHdSectionMessageFolder	nvarchar(255), null	Target folder for moving loaded messages.
bHdSectionImapSsl	bit, not null	If the value is 1, SSL will be used for connecting to the IMAP server.
TicketTypeId	int, not null
ImapPort	int, null
UseFeedback	bit, not null
CustomFeedbackUrl	nvarchar(max), null
TileColor	int, null
TileType	int, not null
AllowSkipCustomForm	bit, not null	If it is 1 and a custom form is set up on the service to submit a new ticket, operators can submit the ticket in the standard way.
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 catalog" option.
ForceUseSolverLicense	bit, not null
Keywords	nvarchar(max), null	Service keywords.
DefaultTicketTemplateId	int, null	Default ticket template.
TargetHdSectionId	int, null	Target service of the service shortcut.
IconName	nvarchar(255), null	If the service icon was not loaded from the disk when upgrading to A10.2, this column displays "Upload failed <icon name>". This value in the service table overloads the display name of the icon from the icon library. Otherwise, this column is NULL.
LibraryIconId	int, not null
TicketNameTemplate	nvarchar(1023), null	Ticket name template.
HomePage	bit, not null	Service flag for setting the tiles on the home page.
KnowledgeSharepointFolders	nvarchar(max), null	List of SharePoint folder URLs relative to root folder.
EwsServerName	nvarchar(255), null	Name of Exchange server.
EwsClientId	nvarchar(255), null	Application ID.
EwsTenantId	nvarchar(255), null	Folder ID.
EwsClientSecret	nvarchar(255), null	Secret client code.
SlaRightsSectionId	int, not null	Id of the service (tHdSection.iHdSectionId) from which this service inherits SLA assignments. If this service doesn’t inherit SLA assignments, this column contains the same value as the iHdSectionId column. If this record represents a service shortcut this column contains the same value as the TargetHdSectionId column or id of the service the target service inherits SLA assignments from.

dbo.tHdSectionCust

Services custom fields values.

Column	Type	Description
liHdSectionId	int, null
RequestForHwCatalogPath	nvarchar(max), null
RequestForHwCategories	nvarchar(max), null
RequestForHwCurrency	nvarchar(256), null

dbo.tHdSectionPerson

Setting of notifications from the services to individual persons.

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

dbo.tHdSectionRights

Permissions individuals and groups have in services (Main solver, Solver, ...).

Column	Type	Description
iHdSectionRightsId	int, not null
liHdSectionRightsHdSectionId	int, not null
liHdSectionRightsRoleId	int, null
liHdSectionRightsPersonId	int, null
MainSolver	bit, not null
Solver	bit, not null
Manager	bit, not null
Reader	bit, not null
ExceptionalSolver	bit, not null
TicketReporter	bit, not null
SolverGroup	bit, not null
RequesterRoleId	int, not null	ID of the group of requesters associated with the permissions (mapping of requesters to the solver team).

dbo.tHdTicket

Tickets.

Column	Type	Description
sHdTicket	nvarchar(1024), null	Ticket name
mHdTicketNotice	nvarchar(max), null	Notes to the ticket.
liHdTicketUserPersonId	int, not null	Link to requester.
dHdTicket	datetime, null	Time at which the ticket was created. When the ticket was created by an e-mail, it is the moment the message was sent.
dHdTicketDeadline	datetime, null	Deadline.
sHdTicketGroup	nvarchar(255), null	Group.
liHdTicketSolverPersonId	int, null	ID of the ticket solver (see tPerson.iPersonId). If this is NULL, the ticket has no solver.
dHdTicketReceived	datetime, null	Time at which the ticket was received. When the ticket was created by an e-mail, it is the moment the message was read from the mailbox.
dHdTicketResolved	datetime, null	Time to solve ticket 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 ticket 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 ticket.
sHdTicketMessageTag	nvarchar(255), null	Ticket number. Contains the prefix and suffix of the service in which the ticket is found as the root of the record ID.
dHdTicketRemoved	datetime, null	Time at which the ticket was deleted.
liHdTicketSlaId	int, not null	Link to SLA, used for this ticket.
liHdTicketResolvedPersonId	int, null
iHdTicketSolverOrder	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 ticket is implemented.
FeedbackLinkId	uniqueidentifier, null	Contains a unique guid ticket identifier.
FeedbackSolveSpeed	int, null	The "Resolution speed" item of the satisfaction survey. This is a foreign key in the tColumnValue table. tColumnValue.nOrder contains a numerical representation of the score.
FeedbackProfessionality	int, null	The "Professionalism" item of the satisfaction survey. This is a foreign key in the tColumnValue table. tColumnValue.nOrder contains a numerical representation of the score.
FeedbackExpertise	int, null	The "Expertise" item of the satisfaction survey. This is a foreign key in the tColumnValue table. tColumnValue.nOrder contains a numerical representation of the score.
FeedbackComment	nvarchar(max), null	"Comments and notes" item on satisfaction survey.
ClosedDate	datetime, null	Ticket close date
ClosedByPersonId	int, null	ID of the person who closed the ticket
FirstReactionDeadline	datetime, null
LastActionDate	datetime, null	Date of the last reaction
WaitingActId	int, null	If the ticket is waiting for requester, the value is tAct.iActId of the event that initiated waiting. Otherwise NULL.
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.
WorkHours	float, null	Number of hours worked in relation to the ticket.
TravelHours	float, null	Number of hours spent on the way in respect of the ticket.
TravelKm	float, null	Number of kms reported in relation to the ticket.
NextActionDeadline	datetime, null	The current target date of the ticket.
iHdTicketId	int, not null
OriginalDeadline	datetime, null	Original deadline for resolving tickets set according to SLA.
ShiftedDeadline	datetime, null	Ticket resolution deadline shifted by the SLA pause period (does not include the interval from the last event in the ticket log to the present).
InternalTarget	nvarchar(255), null	Internal target name.
InternalTargetDeadline	datetime, null	Internal target date.
TicketStateId	int, not null	Ticket status ID.
FeedbackGeneral	int, null	The "Overall satisfaction" item of the satisfaction survey. This is a foreign key in the tColumnValue table. tColumnValue.nOrder contains a numerical representation of the score.
SumOfAllOpeningHoursIntervalsToCurrentTarget	float, null	Time elapsed from the beginning of the next interval of the operating time up to the due date of the current target (in the operating hours).
FullTextSearch	nvarchar(max), null	Column is used for full-text search and contains ticket tag, ticket name, requester name, solver name and service name.
ShiftedFirstReactionDeadline	datetime, null	First response deadline shifted by the SLA pause period (does not include the interval from the last event in the ticket log to the present).
SlaPausedHours	float, null	Total SLA pause time within a specific requirement in hours (does not include an interval from the last event in the ticket log until present).
CurrentSlaPauseStart	datetime, null	Date and time of the running SLA pause.
TopTicketAlertId	int, null	Most important alert of the ticket (TicketAlert.id).
ApprovalId	int, null	ID of the record on the ongoing approval process (tHdTicketApproval.iHdTicketApprovalId).
RequestedForPersonId	int, not null	The person for whom the ticket is created (tPerson.iPersonId).
FirstReactionActId	int, null	The event ID that represents the first response (tAct.iActId).
FirstReactionTriggeredByActId	int, null	The event ID that caused the first response. This is usually the same event as FirstReactionActId. In the case that FirstReactionActId is an automatically created event, such as a requester's notification of a change in the ticket status, this column indicates the event that triggered the submission of the notification, such as a change in the ticket status, a new ticket to the solver, etc. (tAct.iActId).
SolverGroupRoleId	int, null
Keywords	nvarchar(max), null	List of keywords extracted from ticket comunication separated by comma.

dbo.tHdTicketAltMessageTag

Alternative ticket tags. Upon merging tickets, the final ticket uses tags from original tickets as alternative tags.

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

dbo.tHdTicketApproval

Ticket 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
CanceledPersonId	int, null	ID of the person who canceled approving.
TicketStateId	int, null

dbo.tHdTicketApprovalItem

Ticket approval step.

Column	Type	Description
iHdTicketApprovalItemId	int, not null	Record ID
dHdTicketApprovalItem	datetime, null	Date and time of step completion
liHdTicketApprovalItemPersonId	int, null	Approver (see tPerson.iPersonId)
liHdTicketApprovalItemHdTicketApprovalItemResultId	int, not null	Status and/or results of approval (see tHdTicketApprovalItemResult)
mHdTicketApprovalItemNotes	nvarchar(max), null	Approver’s comment
liHdTicketApprovalItemApprovalSchemaItemId	int, null	Step of the approval scheme governing this approval step, see tHdTicketApprovalSchemaItem.
liHdTicketApprovalItemHdTicketApprovalId	int, not null	Record of ongoing approval in a ticket, see tHdTicketApproval.
dExpiration	datetime, null	Date and time after which approval should expire.
ApprovalItemNotesHtml	nvarchar(max), null	Approver’s comment in HTML
Started	datetime, null	Date and time of commencement of step approval.
MessageForApproverActId	int, not null	Report for approvers (see tAct.iActId)
DeputyApproverPersonId	int, null	Identifier of the substitute who actually made the approval in the approver’s absence (see tPerson.iPersonId)

dbo.tHdTicketApprovalItemResult

List of approval step statuses.

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

dbo.tHdTicketCust

Ticket custom fields values.

Column	Type	Description
liHdTicketId	int, not null	Link to ticket to which the values belong.
ProblemCandidate	bit, null
IncidentClosureCode	int, null
mujSloupec	nvarchar(max), null
diagnosis	nvarchar(max), null
rootCause	nvarchar(max), null
workaround	nvarchar(max), null
resolution2	nvarchar(max), null
ProblemClosureCode	int, null
FiveWhys	nvarchar(256), null
Changeend	datetime, null
Changestart	datetime, null
RiskLevel	int, null
changeEndActual	datetime, null
changeStartActual	datetime, null
RiskDescription	nvarchar(256), null
successfulChange	bit, null
overranChangeWindow	bit, null
TripDeparture	datetime, null
TripReturn	datetime, null
TripPurpose	nvarchar(256), null
TripTransport	nvarchar(256), null
UserName	nvarchar(256), null
UserSurname	nvarchar(256), null
Department	int, null
PositionName	int, null
Manager	int, null
Locality	int, null
ContractAgreementOn	int, null
NumberOfMonths	int, null
FirstDay	date, null
Laptop	bit, null
StandardDesktopKit_i	bit, null
MobilePhone	bit, null
Car	bit, null
OtherTraining	nvarchar(256), null
DescribePotentialSpe	nvarchar(max), null
MobilePackage	int, null
Url	nvarchar(256), null

dbo.TicketAlert

Cache for storing alerts.

Column	Type	Description
id	int, not null	Record ID.
TicketAlertTypeId	int, not null	Alert type: 0 = ticket not being resolved, 1 = first reaction due date, 2 = resolution due date, 3 = internal target date.
TicketId	int, not null	Ticket (tHdTicket.Id).
SeverityId	int, not null	Severity (TicketAlertSeverity.id).
Raised	datetime, not null	Alert date and time
Param1	float, null	A parameter which is inserted into the alert text.

dbo.TicketAlertSeverity

Alert severity.

Column	Type	Description
id	int, not null	Record ID.
TicketAlertSeverity	nvarchar(255), not null	Localised name of alert severity.

dbo.TicketAlertSeverityLoc

Language localisation cache for alert severity, see TicketAlertSeverity.

Column	Type	Description
TicketAlertSeverityId	int, not null	Alert ID (TicketAlertSeverity.id).
LocaleId	int, not null	Language ID.
TicketAlertSeverity	nvarchar(255), null	Localised name of alert severity.

dbo.TicketAlertType

SLA alert type

Column	Type	Description
id	int, not null
Name	nvarchar(max), not null	Alert name
MsgTemplateNoParams	nvarchar(max), null	Alert text without parameter
MsgTemplateParam1	nvarchar(max), null	Alert text with parameter

dbo.TicketAlertTypeLoc

Language localization cache of SLA alert type, see TicketAlertType

Column	Type	Description
TicketAlertTypeId	int, not null
LocaleId	int, not null	Language ID
MsgTemplateNoParams	nvarchar(max), null	Localized alert text without parameter
MsgTemplateParam1	nvarchar(max), null	Localized alert text with parameter

dbo.TicketChange

Ticket log record for changes to the ticket field value.

Column	Type	Description
id	int, not null	Record ID
TicketId	int, not null	Ticket ID (tHdTicket.iHdTicketId)
PersonId	int, not null	Author of the change (tPerson.iPersonId)
ChangeDate	datetime, not null	Change date and time (UTC)
ColumnId	int, not null	Changed field (tColumn.iColumnId)
ValueOldNvarchar	nvarchar(max), null	Old string value
ValueNewNvarchar	nvarchar(max), null	New string value
ValueOldBit	bit, null	Old bit value
ValueNewBit	bit, null	New bit value
ValueOldDate	date, null	Old date value
ValueNewDate	date, null	New date value
ValueOldDatetime	datetime, null	Old datetime value
ValueNewDatetime	datetime, null	New datetime value
ValueOldFloat	float, null	Old float value
ValueNewFloat	float, null	New float value
ValueOldInt	int, null	Old int value (could be foreign key to various tables)
ValueNewInt	int, null	New int value (could be foreign key to various tables)

dbo.TicketNode

Objects associated to the ticket over the ticket "Objects" item.

Column	Type	Description
id	int, not null	Record ID
TicketId	int, not null	Ticket ID (tHdTicket.iHdTicketId)
NodeId	int, not null	Object ID (tblNode.intNodeId)
Created	datetime, null	Link creation date and time (UTC)
Removed	datetime, null	Link removal date and time (UTC)
CreatedByPersonId	int, null	User ID of a person who created the link (tPerson.iPersonId).
RemovedByPersonId	int, null	User ID of a person who deleted the link (tPerson.iPersonId).

dbo.TicketRelation

Links Between Tickets.

Column	Type	Description
id	int, not null	Record ID
BeginHdTicketId	int, not null	The ticket ID at the beginning of the link, see tHdTicket.iHdTicket.
EndHdTicketId	int, not null	The ticket ID at the end of the link, see tHdTicket.iHdTicket.
TicketRelationTypeId	int, not null	Link kind ID, see TicketRelationType.id.
Created	datetime, null	Link creation date and time
Removed	datetime, null	Link removal date and time
CreatedByPersonId	int, null	Link author ID, see tPerson.iPersonId.
RemovedByPersonId	int, null	User ID of a person who deleted the link - see tPerson.iPersonId.

dbo.TicketRelationType

Types of links between tickets.

Column	Type	Description
id	int, not null	Record ID
BeginName	nvarchar(30), not null	The name of the link from the ticket view at the beginning of the link
EndName	nvarchar(30), not null	The name of the link from the ticket view at the end of the link
Directional	bit, not null	Permitted values are 0 and 1. If set to 1, the link is directional, i.e. links "Link A to B" and "Link B to B" are two different links.
Cyclic	bit, not null	Permitted values are 0 and 1. If set to 1, the link may not create a cycle. Example of a cycle: A is linked to B, B is linked to C, and C is linked to A.
OneToMany	bit, not null	Permitted values are 0 and 1. If set to 1, the target ticket may not contain more than one link.
MenuOrder	int, not null	The order of link types in menus
TicketRelationTypeBehaviorId	int, not null	System link type. When defining a custom link type, always use the value 1.
CustomField1	int, null	Custom field

dbo.TicketRelationTypeBehavior

System types of links between tickets.

Column	Type	Description
id	int, not null	Record ID
TicketRelationTypeBehavior	nvarchar(50), null	Link name

dbo.TicketRequestParticipant

Ticket participant for the ticket

Column	Type	Description
TicketId	int, not null	Ticket ID (tHdTicket.iHdTicketId).
PersonId	int, not null	User ID of the ticket participant (tPerson.iPersonId).

dbo.TicketSequence

A table containing the next ticket number.

Column	Type	Description
NextTicketId	int, not null	Next ticket number

dbo.TicketState

Ticket statuses. Statuses are defined in the process (see dbo.TicketType).

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 ticket after changing to status - value = 1 is only possible in the Solved status.
CustomMessageForApproverTemplate	nvarchar(max), null	Custom message template for approvers. If the record has a value of NULL, then the default template is used (available in tString).
Removed	datetime, null	Date of status deletion. If the value is NULL here, the status was not deleted.
SendNotificationForRequester	bit, not null	Send a notification to the requester when transitioning to status.
CustomNotificationForRequesterTemplate	nvarchar(max), null	Custom template of notifications to requester about change of the ticket status. If the record has a value of NULL, then the default template is used (saved in tString).
PauseSla	bit, not null	SLA is paused at this status
DisplayCommandMoveToService	bit, not null	Display the command "Transfer To Another Service" at the top of the command panel: 0 - off, 1 - on
DisplayCommandAssignToSolver	bit, not null	In the tickets in this status, display the Assign to solver command first in the Command bar.
SolverGroupRoleId	int, null	Assign ticket to a solver group during transition to this status.

dbo.TicketStateBehavior

System ticket statuses, see dbo.TicketState.

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

dbo.TicketStateCust

Ticket state custom fields values.

Column	Type	Description
TicketStateId	int, not null	Link to ticket state to which the values belong.

dbo.TicketStateLoc

Cache of the localizations of ticket states.

Column	Type	Description
TicketStateId	int, not null	Ticket status ID.
LocaleId	int, not null	Language ID.
TicketState	nvarchar(64), null	Localized ticket status name.
Description	nvarchar(max), null	Localized ticket status description.
SolverInstructions	nvarchar(max), null	Localized instructions for solver.
CustomMessageForApproverTemplate	nvarchar(max), null	Localized customer message template for approvers. If the record has a value of NULL, then the default template is used (available in tString).
CustomNotificationForRequesterTemplate	nvarchar(max), null	Localized custom template of notifications to requester about the change of ticket status. If the record has a value of NULL, then the default template is used (saved in tString).

dbo.TicketStateRelation

Allowed transitions among ticket statuses, see dbo.TicketState.

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

dbo.TicketStateRequiredColumn

Required items for individual ticket statuses, see dbo.TicketState.

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

dbo.TicketTag

User tag of the ticket

Column	Type	Description
id	int, not null	Record ID
PersonId	int, not null	Person (tPerson.iPersonId)
TicketId	int, not null	Ticket (tHdTicket.iHdTicketId)
TicketTagTypeId	int, not null	Tag type (TicketTagType.id)

dbo.TicketTagType

Ticket tag type

Column	Type	Description
id	int, not null	Record ID
Name	nvarchar(70), not null	Tag name
Color	nvarchar(10), not null	Tag color (HEX)

dbo.TicketTagTypeLoc

Cache of tag types localizations.

Column	Type	Description
TicketTagTypeId	int, not null	Id of tag type (see TicketTagType.id)
LocaleId	int, not null	Language ID
Name	nvarchar(70), not null	Localized tag name

dbo.TicketTemplate

List of ticket 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 ticket automatically created based on this template (FK).
LastTicketCreationDate	datetime, null	Creation date of the last ticket automatically created based on this template.
NextDate	datetime, null	Next deadline for the planned ticket - 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 tickets 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).
SolverGroupId	int, null

dbo.TicketTemplateColumnValue

column values on ticket template.

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

dbo.TicketTemplateNode

Objects linked to the ticket templates.

Column	Type	Description
id	int, not null	Record ID
TicketTemplateId	int, not null	ID of the ticket template (TicketTemplate.Id)
NodeId	int, not null	Object ID (tblNode.intNodeId)

dbo.TicketType

Processes. Among others, the process defines possible ticket statuses, solving process, custom ticket items, etc.

Column	Type	Description
id	int, not null	Record ID
TicketType	nvarchar(255), not null	Process name
Description	nvarchar(max), null	Description of the process
TicketTypeBehaviorId	int, not null	Process type ID (TicketTypeBehavior.id)
CustomField1	int, null
BackResolveDeadlineHours	float, null
TicketTypeNodeHealthImpactId	int, not null	ID of the effect of tickets with this process on the health of objects in the given tickets (TicketTypeNodeHealthImpact.id). 1=no effect, 2=incident, 3=change.

dbo.TicketTypeBehavior

System processes.

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

dbo.TicketTypeColumn

Ticket items used by the process.

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

dbo.TicketTypeLoc

Cache of process localizations.

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

dbo.TicketTypeNodeHealthImpact

For the effect on object health requirements, see TicketType.TicketTypeNodeHealthImpactId.

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

dbo.tIdSeqClass

Numeric sequences - definitions for types of objects.

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

dbo.TimeZone

Time zone list.

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

dbo.TimeZoneBias

Time zone shifts compared to UTC for each year

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

dbo.tLocale

Language environments.

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

dbo.tLocalization

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

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

dbo.tNodeProduct

Software profiles - exceptions for the computer.

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

dbo.Token

For internal use

Column	Type	Description
PersonId	int, not null
Scope	nvarchar(2048), not null
AccessToken	nvarchar(max), not null
Expiration	datetime, not null

dbo.tOpeningHours

Service operating hours.

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

dbo.tOpeningHoursCache

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

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

dbo.tOpeningHoursException

Exceptions in service operating hours.

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

dbo.tPerson

Persons in the ALVAO system.

Column	Type	Description
iPersonId	int, not null	Record ID
sPerson	nvarchar(255), null	displayed username
sPersonLogin	nvarchar(255), null	User name
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
sPersonUrgentEmail	nvarchar(255), null	E-mail for urgent messages
bPersonGuest	bit, not null
dPersonRemoved	datetime, null	date on which the user was removed
mPersonNotes	nvarchar(max), null
sPersonCountry	nvarchar(255), null
sPersonCountryAbbr	nvarchar(2), null
iPersonCountryCode	int, null
sPersonPreferredLanguage	nvarchar(2), null
sPersonCity	nvarchar(255), null
oPersonSID	image, null
sPersonAdPath	nvarchar(1024), null
dPersonAdCreated	datetime, null
sPersonSID	nvarchar(255), null
liPersonManagerPersonId	int, null
sPersonPersonalNumber	nvarchar(255), null
liPersonDelegatePersonId	int, null
OutOfOfficeSince	datetime, null	Starting date and time of absence.
iPersonLocaleId	int, null	Language number. This is the Microsoft LocaleID. The list of these, for example, can be found here http://msdn.microsoft.com/en-us/goglobal/bb964664.aspx. The list of similar Locale ID can be found in the tLocale table
sPersonAdName	nvarchar(255), null
liAccountId	int, null
sFirstName	nvarchar(255), null
sLastName	nvarchar(255), null
sImportSystem	nvarchar(255), null
sImportRecordId	nvarchar(255), null
sAdDisplayName	nvarchar(255), null
TimeZone	nvarchar(64), null
Email2	nvarchar(255), null
Phone2	nvarchar(255), null
PersonPortrait	varbinary, null
PersonPortraitHash	varchar, null
PersonBehaviorId	int, not null	For user type, see the PersonBehavior table.
OutOfOfficeUntil	datetime, null	Ending date and time of absence.
IsOutOfOffice	bit, not null	Identifier specifying whether the user is absent. Automatically calculated column.
ImportAdLastFound	datetime, null	Date and time when the user was last found during AD import.
AzureAdObjectId	nvarchar(40), null	User ID in the Azure Active Directory
AzureAdTenantId	int, null	The tenant’s ID Azure Active Directory which the user belongs to.
SamAccountName	nvarchar(255), null	Username for systems older than Windows 2000
AadAppClientId	nvarchar(255), null	Application (client) ID in AAD
AadAppTenantId	nvarchar(255), null	Directory (tenant) ID in AAD
TeamsConversationId	nvarchar(255), null
App	bit, not null	Application account
RefreshToken	nvarchar(3000), null	For internal use
PersonPortraitETag	nvarchar(1024), null	ETag value of portrait in Azure Active Directory

dbo.tPersonCust

Persons in the ALVAO system - own items.

Column	Type	Description
liPersonId	int, null

dbo.tProperty

ALVAO system settings.

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

dbo.TransferConfirmAlert

Sent alerts to sign the handover protocols.

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

dbo.TransferConfirmAlertConfig

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

Column	Type	Description
SendTimeHour	float, not null	Alert send time.
RepeatTeamAlertAfterDays	int, null	Repetition period of the last alert.
RequireUserAuthentication	bit, not null	Require user verification during signature.

dbo.TransferConfirmAlertRule

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

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

dbo.TransferConfirmType

Method of the assets takeover signing.

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

dbo.tRole

Groups of persons for the entire ALVAO.

Column	Type	Description
iRoleId	int, not null	Record ID.
sRole	nvarchar(255), null	Group name.
sRoleAdGuid	nvarchar(255), null	GUID in Active Directory
bRoleEveryone	bit, not null	Only one group "all", which has a value of 1, exists in ALVAO.
dRoleCreated	datetime, null	Time at which the group was created.
sDesc	nvarchar(max), null
RoleBehaviorId	int, not null
AdDistributionGroup	bit, not null	Group type in Active Directory. True means that it is a distribution group. Otherwise it is a security group.
AdPath	nvarchar(1024), null	Path to the group in Active Directory.
DistributionEmail	nvarchar(255), null	Distribution group e-mail (Active Directory - mail attribute).
LastImport	datetime, null	Last import time from Active Directory.
AdCreated	datetime, null	Time of group creation in Active Directory (Active Directory - whenCreated attribute).
AzureAdObjectId	nvarchar(40), null	Group ID in the Azure Active Directory
AzureAdTenantId	int, null	The tenant’s ID Azure Active Directory which the group belongs to.

dbo.tRolePerson

Persons' membership in groups.

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

dbo.tRoleRole

Groups' membership in groups.

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

dbo.tSla

SLA.

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

dbo.tSlaAlert

Ticket 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.
FirstReactionDeadline	datetime, null	The expiration deadline of first response.

dbo.tSlaAlertRule

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

Column	Type	Description
id	int, not null
liSlaId	int, not null
liToRoleStringId	int, 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.
FirstReactionExpireHours	float, null	Number of hours until the expiry of the internal target date.
TicketAlertSeverityId	int, not null	Alert severity (TicketAlertSeverity.id).
SendByEmail	bit, not null	If the value is 1, an alert is sent by e-mail.

dbo.tSlaCust

SLA custom fields values.

Column	Type	Description
liSlaId	int, null

dbo.tSlaRights

Assigning SLA to individuals and groups.

Column	Type	Description
iSlaRightsId	int, not null
liSlaRightsSlaId	int, not null
liSlaRightsRoleId	int, null
liSlaRightsPersonId	int, null
bSlaRightsDefault	bit, not null	1 = SLA is set as the default; 0 = SLA is not default
liHdSectionId	int, not null

dbo.tSmtp

Configuration of the SMTP server for ALVAO.

Column	Type	Description
sSmtpAddress	nvarchar(255), null	SMTP server address.
nSmtpPort	int, null	SMTP Server port.
sSmtpLogin	nvarchar(255), null	Username for SMTP server access.
sSmtpPswd	nvarchar(255), null	Password for SMTP server access.
bSmtpSsl	bit, not null	1, should SSL be used for connecting to the SMTP server.
ClientId	nvarchar(255), null	OAuth - Application (client) ID
TenantId	nvarchar(255), null	OAuth - Directory (tenant) ID
ClientSecret	nvarchar(255), null	OAuth - Client secret
AuthType	int, not null	Authentication type: 0 = OAuth, 1 = Basic, 2 = Integrated

dbo.tString

System code list for texts.

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

dbo.tSwLibAddUnknown

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

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

dbo.tSwPresence

Software profiles - product statuses.

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

dbo.tSwProfile

Software profiles - list.

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

dbo.tSwProfileProduct

Software profiles - membership of products in profiles.

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

dbo.tSwProfileSwProfile

Software profiles - sub-profiles.

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

dbo.tTimeOff

Employee absence records.

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

dbo.tTimeOffKind

Types of employee absence records.

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

dbo.tWeekOpeningHours

Item in the definition of service operating hours.

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

dbo.tWorkLoad

Employee labor contracts.

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

dbo.tWorkTime

Employee attendance record created in the ALVAO Attendance module.

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

dbo.UserLogonLog

Logging users in/out to/from Asset Management Console.

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

dbo.UserLogonLogAction

Executed action which is logged.

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

dbo.UserLogonLogApplication

Application name.

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

dbo.WebAppActiveSession

Active session at ALVAO WebApp.

Column	Type	Description
id	int, not null	Session ID.
PersonId	int, not null	Signed-in user ID.
ExpireDate	datetime, not null	Date and time of session expiration.
TicketGUID	uniqueidentifier, not null	Authentication ticket Id.
ClientAddress	nvarchar(50), null	IP address of the logged in user

dbo.Webhook

Registered webhooks integrating Alvao with other applications.

Column	Type	Description
id	int, not null	Record ID
Name	nvarchar(255), null	Webhook name
Enabled	bit, not null	1 = the webhook is enabled, 0 = disabled.
TopicId	int, not null	Webhook topic ID (WebhookTopic.id)
Url	nvarchar(2048), not null	Webhook callback URL
Created	datetime, not null	Creation date
LastInvoked	datetime, null	Last invocation date
ErrorMessage	nvarchar(max), null	Error message at the last invocation.
TicketStateId	int, null	Ticket status in which the webhook should be invoked (TicketState.id).
SectionId	int, null	Ticket service for which the webhook should be invoked (tHdSection.iHdSectionId).
TicketTypeId	int, null	Ticket process for which the webhook should be invoked (TicketType.id).
ColumnId	int, null	Ticket field ID for wich the webhook should be invoked (tColumn.iColumnId).
NodeClassId	int, null	Object type in which the webhook should be invoked (tblClass.intClassId).
ParentNodeId	int, null	ID of the parent object for whose subtree the webhook should be invoked (tblNode.intNodeId).
NodePropertyKindId	int, null	Object property kind in which the webhook should be invoked (tblKind.intKindId).
NodePropertyNewValue	nvarchar(255), null	New object property value in which the webhook should be invoked.
MovedFromNodeId	int, null	ID of the source object for whose subtree the webhook should be invoked (tblNode.intNodeId).
MovedToNodeId	int, null	ID of the destination object for whose subtree the webhook should be invoked (tblNode.intNodeId).

dbo.WebhookTopic

Webhook topics

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

dbo.WorkOvertimeDisposal

Table with list of paid overtime hours

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