Other views

View	Scheme	Description
Node	dbo	"Objects" in AM.
vAct	dbo	Ticket log. The view collects data from various tables.
vApprovalAuthority	dbo	Current approvers of tickets that are currently in the process of being approved.
vApprovalAuthority_Custom	dbo	Current ticket approvers according to custom approval processes. The customer can define custom contents for this view.
vAssetPersonSystemRole	dbo	User membership in system roles of Asset Management.
vAssetUser	dbo	Users in the object tree.
vAssetUserPerson	dbo	The user's link in the object tree to the user in the Administration service (tPerson. Link based on priority: AD GUID Personal number Login name E-mail
vChildTicketPersonRead	dbo	List of child tickets that person should see.
vClass	dbo	Types of objects.
vClassLoc	dbo	Translations of the object type names in all languages ​​used.
vColumnLoc	dbo	Translations of the names and descriptions of custom fields in all languages ​​used.
vColumnValueLoc	dbo	Translations of custom fields values in all languages ​​used.
vComputer	dbo	Computers.
vComputerDetectLast	dbo	Last detection of the computers.
vComputerSwManager	dbo	People and their superiors responsible for software installed on the computer
vDetectKind	dbo	Types of detections (HW, SW).
vDetectSettings	dbo	Computer detection settings.
vDetFiles	dbo	Detected files.
vDocument	dbo	Documents.
vDocumentKind	dbo	Kinds of documents.
vEmailTemplateLoc	dbo	Translations of custom notifications in all languages ​​used.
vHdSectionAllSolver	dbo	Effective solvers and exceptional solvers from services.
vHdSectionAllSolverGroup	dbo	Effective solvers and exceptional solvers from solver groups of services.
vHdSectionEffectiveShowInServiceCatalog	dbo	View for effective viewing of the "View in the Service catalog" option. Takes into account settings in parent services.
vHdSectionExceptionalSolver	dbo	Effective exceptional solvers in services.
vHdSectionExceptionalSolverGroup	dbo	Effective exceptional solvers from exceptional solver groups of services.
vHdSectionIrregularOperator	dbo	Effective exceptional operators in services.
vHdSectionLoc	dbo	Auxiliary view for the language localization of service names and descriptions.
vHdSectionOperator	dbo	Effective service operators.
vHdSectionOperator_Direct	dbo	Effective main solvers without absentee stand-ins.
vHdSectionPerson	dbo	Effective settings of notifications sent from the services to individual persons.
vHdSectionSolverGroup	dbo	Effective solvers from solver groups of services.
vHdTicket	dbo	Values for dynamically calculated ticket items.
vHdTicketApprovalItemResultLoc	dbo	Results of approval steps in all languages used.
vHdTicketCalc	dbo	Information whether the ticket can indeed be reopened.
vHdTicketPersonRead	dbo	Effective authorization of users to tickets.
vHdTicketPersonRead_Custom	dbo	Custom extension of user permissions to see tickets. You can customize this view to include users and requests that those users should see in the application.
vInstDetect	dbo	Installed software, detected version and activation code.
vInstTrial	dbo	Installations covered by "special installation", including the coverage for package components.
vKindLoc	dbo	Translations of the object properties in all languages ​​used.
vKnowledgeRead	dbo	Knowledge that a user can read in services.
vLang	dbo	Languages.
vLastEvaluatedSwDetect	dbo	Last evaluated SW detection on the computer.
vLicHist_InvoiceDocumentLast	dbo	Invoice attached to the license.
vLicHistBase	dbo	License.
vLicHistItem	dbo	License items.
vLicHistLog	dbo	Log of changes in registered licenses.
vLicProductCoveredOnComputer	dbo	Which products on the computer have license coverage (per device or per user).
vLicRight_Modify	dbo	Users with the permission to change software licenses belonging to the organization.
vLicRight_Read	dbo	Users with the permission to read software licenses belonging to the organization.
vLicTrans	dbo	Shared licenses.
vLog_DetectLast	dbo	Last record in the detection log.
vMediaList	dbo	List of media.
vMediaType	dbo	Types of media.
vNewTicketFormSectionLoc	dbo
vNewTicketFormTextBlockLoc	dbo
vNodeClass	dbo	Objects in the Objects Tree. Differentiation between system objects and discarded assets.
vNodeCostCentre	dbo	Cost center of the objects in the tree.
vNodeHealth	dbo	Current health of objects.
vNodeHealth_Custom	dbo	Custom extension of the object health calculation. You can edit this view. By default, it does not contain any records.
vNodeParentJoin	dbo	Objects in the tree - tree.
vNodeProperty	dbo	Properties of all objects.
vNodePropertyMix	dbo	Objects and properties - Public + Asset + Computer1.
vNodePropertyMix_Asset	dbo	Objects and properties - Assets Number, Purchase Date, Warranty expiration, Manufacturer, Packing Slip Number.
vNodePropertyMix_Computer1	dbo	Objects and properties - Computer - Motherboard (type), BIOS Serial Number.
vNodePropertyMix_Computer2	dbo	Objects and properties - Computer - MAC address.
vNodePropertyMix_Public	dbo	Objects and properties - Type Designation, Serial Number, Manufacturer, Registration Number, Name.
vOnlyReader	dbo	Users that only have the right of reader in the services.
vPersonNodeRight	dbo	Rights in the object tree - main view.
vPersonNodeRight_Create	dbo	Rights in the objects tree - the right to "Create any objects".
vPersonNodeRight_Delete	dbo	Rights in the object tree - the right to "Remove".
vPersonNodeRight_Move	dbo	Rights in the object tree - the right to "Move".
vPersonNodeRight_Read	dbo	Rights in the object tree - the right to "Read".
vPersonNodeRight_Write	dbo	Rights in the object tree - the right to "Change".
vPersonResponsibleForAsset	dbo	Users responsible for assets.
vProduct	dbo	Products (software).
vProductCategory	dbo	Products categories (OS).
vProductType	dbo	Products types.
vPropertyFromAD	dbo	Properties of objects which are downloaded from AD.
vPropertyKind_Asset	dbo	Object properties - Serial number, Inventory number a Asset number.
vPropertyKind_AssetCategory	dbo	Properties of objects - Asset category.
vPropertyKind_BIOSSerialNumber	dbo	Properties of objects - BIOS serial number.
vPropertyKind_ChassisType	dbo	Properties of objects - Type of rack.
vPropertyKind_ComputerKind	dbo	Properties of objects - Type of computer.
vPropertyKind_ComputerName	dbo	Properties of objects - Name in the network.
vPropertyKind_Department	dbo	Properties of objects - Cost center.
vPropertyKind_Domain	dbo	Properties of objects - DNS domain.
vPropertyKind_EvidentiaryNumber	dbo	Properties of objects - registration number.
vPropertyKind_Frequency	dbo	Properties of objects - Frequency.
vPropertyKind_Interface	dbo	Properties of objects - Interface.
vPropertyKind_InventoryDate	dbo	Properties of objects - Stocktaking date.
vPropertyKind_InventoryNumber	dbo	Properties of objects - Asset number.
vPropertyKind_InvoiceNumber	dbo	Properties of objects - Packing slip number.
vPropertyKind_IPAddress	dbo	Properties of objects - IP address.
vPropertyKind_MACAddress	dbo	Properties of objects - MAC address.
vPropertyKind_Manufacturer	dbo	Properties of objects - Manufacturer.
vPropertyKind_MaxSize	dbo	Properties of objects - Maximum size.
vPropertyKind_MemoryDevices	dbo	Properties of objects - Sockets.
vPropertyKind_MemoryDevicesUsed	dbo	Properties of objects - Occupied sockets.
vPropertyKind_Model	dbo	Properties of objects - Model.
vPropertyKind_Name	dbo	Properties of objects - Name.
vPropertyKind_Office	dbo	Properties of objects - Office.
vPropertyKind_PartOfDomain	dbo	Properties of objects -Domain components.
vPropertyKind_PersonalId	dbo	Properties of objects - Personal number.
vPropertyKind_Place	dbo	Properties of objects - Location.
vPropertyKind_Port	dbo	Properties of objects - Port.
vPropertyKind_ProcessorId	dbo	Properties of objects - Processor ID.
vPropertyKind_Purchased	dbo	Properties of objects - Purchase date.
vPropertyKind_RefreshMax	dbo	Properties of objects - Maximum refresh.
vPropertyKind_SerialNumber	dbo	Properties of objects - Serial number.
vPropertyKind_Size	dbo	Properties of objects - Size.
vPropertyKind_Type	dbo	Properties of objects - Type.
vPropertyKind_TypeMark	dbo	Properties of objects - Type designation.
vPropertyKind_Vendor	dbo	Properties of objects - Vendor.
vPropertyKind_Version	dbo	Properties of objects - Version.
vPropertyKind_VideoRAM	dbo	Properties of objects - RAM size.
vPropertyKind_WakeUpType	dbo	Properties of objects - Wake-up method.
vPropertyKind_Warranty	dbo	Properties of objects - Warranty.
vPropertyLoc	dbo	Translations of tProperty settings in all languages ​​used.
vRequestParticipant	dbo	Overview of ticket participants on requirements.
vSamAlertLast	dbo	SAM notification - last unresolved notifications sent
vSectionSolverLicence	dbo	Drawing of solver licenses by services
vSectionUserLicence	dbo	Drawing of user licenses by services
vSectionWithTreeOrder	dbo	For each service, it returns a string which guarantees queueing being the same as that in the tree.
vSlaAccess	dbo	Effective authorization requesters have for SLA and services.
vSlaAlertDeadline	dbo	Individual SLA notifications for the expiration of the ticket deadline.
vSlaAlertFirstReaction	dbo	Individual SLA notifications for the ticket first responses.
vSlaAlertInactiveApprovers	dbo	Individual SLA notifications for approver inactivity.
vSlaAlertInactiveOperators	dbo	Individual SLA notifications for inactivity of the main solvers.
vSlaAlertInactiveRequesters	dbo	Individual SLA notifications for requester inactivity.
vSlaAlertInactiveSolverGroups	dbo	Individual SLA notifications for solver group inactivity.
vSlaAlertInactiveSolvers	dbo	Individual SLA notifications for solver inactivity.
vSlaAlertInternalTarget	dbo	Individual SLA alerts for the expiration of tickets internal target date.
vSlaLoc	dbo	List of SLAs in all used languages.
vStringLoc	dbo	List of strings from ALVAO applications in all used languages.
vSwInst	dbo	Installed software - valid products and outside system objects.
vSwInst_ProductComputer	dbo	Software installed on the computers.
vSwInst_ProductComputerDetect	dbo	SW detected in the computers.
vSwInst_TreeCnt	dbo	Number of product installations in the subtree.
vSwInstLicProfile_ProductComputer	dbo	Installed software vs licenses and software profiles. Note: This view is outdated and should not be used. It will be removed in a future version of ALVAO.
vSwLic_ProductComputer	dbo	Products covered by licenses on the computers.
vSwLic_UserComputer	dbo	Users' computers.
vSwProfileProduct_Node	dbo	Statuses of the software profile on the products installed on the computers.
vTicketRelation	dbo	Links Between Tickets.
vTicketRelationTypeLoc	dbo	List of ticket link types in all used languages.
vTicketStateEntered	dbo	Arrivals to individual ticket statuses.
vTicketStateLoc	dbo	List of statuses in all used languages.
vTicketTemplateColumnValueLoc	dbo	Translations of custom fields values specified in ticket templates.
vTicketTypeLoc	dbo	List of processes used in all used languages.
vTimeZone	dbo	Overview of time zones and shifts compared to UTC.
vTransferConfirmAlertLast	dbo	Last sent alerts of unsigned handover protocols.
vUserLicence	dbo	Drawing of licenses by users
vUserNodeRight	dbo	Rights in the object tree - users (including the rights allowed / prohibited by membership in roles).
vWbemObject	dbo	Detail of the HW detection - all.
vWbemObject_BIOS	dbo	Detail of the HW detection - BIOS.
vWbemObject_SystemEnclosure	dbo	Detail of the HW detection - Computer rack.
vWbemObjectPhysicalMedia	dbo	Detail of the HW detection - Hard disks.
wDocument	dbo	Documents.
wIdSeq	dbo	Numeric sequence.

dbo.Node

"Objects" in AM.

Column	Type	Description
Node Id	int, not null

dbo.vAct

Ticket log. The view collects data from various tables.

Column	Type	Description
iActId	int, null
liActKindId	int, null
dAct	datetime, null
sAct	nvarchar(max), null
mActNotice	nvarchar(max), null
liActFromPersonId	int, null
liActToPersonId	int, null
liActHdTicketId	int, null
sActFrom	nvarchar(1024), null
sActFromEmail	nvarchar(255), null
sActFromPhone	nvarchar(255), null
mActFromContact	nvarchar(max), null
sActFromMobile	nvarchar(255), null
sActFromOffice	nvarchar(255), null
sActFromDepartment	nvarchar(255), null
sActFromWorkPosition	nvarchar(255), null
sActFromCompany	nvarchar(255), null
sActTo	nvarchar(2048), null
sActToEmail	nvarchar(1024), null
nActWorkHours	float, null
dActRemoved	datetime, null
sActCc	nvarchar(2048), null
sActAutoSubmitted	nvarchar(255), null
sActMessageId	nvarchar(255), null
sActXSpamLevel	nvarchar(255), null
sActXSpamStatus	nvarchar(255), null
nActTravelHours	float, null
nActTravelKm	float, null
bNoCharge	bit, not null
liActHdTicketApprovalItemId	int, null
bWaitingForUser	bit, null
CreatedByPersonId	int, null
TicketChangeId	int, null
ActOperationId	int, null
RelationId	int, null
SlaAlertId	int, null	Custom notifications link.
ActLocaleId	int, null
ActMarkId	tinyint, null	Record marking. A foreign key to the ActMark table.
TicketNodeId	int, null
UserRead	bit, not null

dbo.vApprovalAuthority

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

Column	Type	Description
liApprovalAuthorityHdTicketId	int, null
liApprovalAuthorityPersonId	int, null

dbo.vApprovalAuthority_Custom

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

Column	Type	Description
liHdTicketId	int, null
liPersonId	int, null

dbo.vAssetPersonSystemRole

User membership in system roles of Asset Management.

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

dbo.vAssetUser

Users in the object tree.

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

dbo.vAssetUserPerson

The user's link in the object tree to the user in the Administration service (tPerson.
Link based on priority:

1. AD GUID
2. Personal number
3. Login name
4. E-mail

Column	Type	Description
NodeId	int, not null
PersonId	int, not null
PersonManagerId	int, null

dbo.vChildTicketPersonRead

List of child tickets that person should see.

Column	Type	Description
ChildTicketId	int, not null	Ticket ID of child ticket (tHdTicket.iHdTicketId).
ParentTicketId	int, not null	Ticket ID of parent ticket (tHdTicket.iHdTicketId).
PersonId	int, null	User ID (tPerson.iPersonId).

dbo.vClass

Types of objects.

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

dbo.vClassLoc

Translations of the object type names in all languages ​​used.

Column	Type	Description
lintClassId	int, null	Object type ID (tblClass.intClassId)
txtText	nvarchar(255), null	Object type name in the ALVAO system language
LocalizedText	nvarchar(max), null	Localized name of the object type
ClassLocaleId	int, not null	LCID of the language into which the localization is performed.

dbo.vColumnLoc

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

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

dbo.vColumnValueLoc

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

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

dbo.vComputer

Computers.

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

dbo.vComputerDetectLast

Last detection of the computers.

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

dbo.vComputerSwManager

People and their superiors responsible for software installed on the computer

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

dbo.vDetectKind

Types of detections (HW, SW).

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

dbo.vDetectSettings

Computer detection settings.

Column	Type	Description
NodeId	int, not null	Computer ID.
MethodId	int, null	Detection method ID.
TcpIpPort	int, null	Agent port number during detection by Agent over TCP/IP.
KindId	int, null	Type of detection. 1=HW, 2=SW.
IsSwFull	bit, null	Full SW detection.
SwInclude	nvarchar(255), null	Full SW detection, include files.
SwExclude	nvarchar(255), null	Full SW detection, skip files.
DetectPeriod	int, null	Period of automatic detection planning

dbo.vDetFiles

Detected files.

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

dbo.vDocument

Documents.

Column	Type	Description
id	int, not null
Name	nvarchar(255), null
IdNumber	nvarchar(255), null
lintDocumentKindId	int, not null
txtIdNumber2	nvarchar(255), null
txtMemo	nvarchar(max), null
IssuedDate	datetime, null
CreatedDate	datetime, not null
lintResellerCompanyId	int, null
lintSrcNodeId	int, null
lintDestNodeId	int, null
liCreatedPersonId	int, null
sCreatedPersonName	nvarchar(255), null
dteRemoved	datetime, null
liRemovedPersonId	int, null
TransferConfirmTypeId	int, not null
SignDate	datetime, null
SignPersonId	int, null
SignedBy	nvarchar(128), null
SignComputer	nvarchar(255), null
sRemovedPersonName	nvarchar(255), null
txtResellerCompany	nvarchar(255), null
txtLink	int, null
DocumentFolderId	int, not null
SummaryProtocol	bit, not null
GiverFlags	int, null
ReceiverFlags	int, null

dbo.vDocumentKind

Kinds of documents.

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

dbo.vEmailTemplateLoc

Translations of custom notifications in all languages ​​used.

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

dbo.vHdSectionAllSolver

Effective solvers and exceptional solvers from services.

Column	Type	Description
SectionId	int, not null	ID of the service.
PersonId	int, null	User ID.
RequesterRoleId	int, not null	Link to the group of requesters for which the permission for the given person is valid.
Solver	int, not null	1 = is solver.
ExceptionalSolver	int, not null	1 = is exceptional solver.

dbo.vHdSectionAllSolverGroup

Effective solvers and exceptional solvers from solver groups of services.

Column	Type	Description
SectionId	int, not null	ID of the service.
PersonId	int, null	User ID.
RequesterRoleId	int, not null	Link to the group of requesters for which the permission for the given person is valid.
Solver	int, not null	1 = is solver.
ExceptionalSolver	int, not null	1 = is exceptional solver.

dbo.vHdSectionEffectiveShowInServiceCatalog

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

Column	Type	Description
iHdSectionId	int, null
EffectiveShowInServiceCatalog	bit, null

dbo.vHdSectionExceptionalSolver

Effective exceptional solvers in services.

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

dbo.vHdSectionExceptionalSolverGroup

Effective exceptional solvers from exceptional solver groups of services.

Column	Type	Description
SectionId	int, not null	ID of the service where the user is an exceptional solver group member.
PersonId	int, 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.vHdSectionIrregularOperator

Effective exceptional operators in services.

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

dbo.vHdSectionLoc

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

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

dbo.vHdSectionOperator

Effective service operators.

Column	Type	Description
HdSectionId	int, not null	Service ID.
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.vHdSectionOperator_Direct

Effective main solvers without absentee stand-ins.

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

dbo.vHdSectionPerson

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

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

dbo.vHdSectionSolverGroup

Effective solvers from solver groups of services.

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

dbo.vHdTicket

Values for dynamically calculated ticket items.

Column	Type	Description
liHdTicketId	int, not null
nOpenTimeHours	float, null
nOpenTimeWithoutWaitingHours	float, null
nWaitedForUserHours	float, not null
nWaitingForUserHours	float, null
NextActionStringId	int, null	The ID name of the current target of the ticket (tString.iStringId).
NextActionDeadline	datetime, null
IsNextActionInternalTarget	int, not null
SlaPause	int, not null	1 = SLA may be paused while waiting for the requester or in any ticket status.
IsSlaPaused	int, not null
SlaPausingHours	float, null	Number of hours of SLA pause being in progress (due to waiting for requester or ticket status).
SlaPausedHours	float, null	Total SLA pause time within a specific requirement in hours (including the currently running SLA pause).

dbo.vHdTicketApprovalItemResultLoc

Results of approval steps in all languages used.

Column	Type	Description
iHdTicketApprovalItemResultId	int, not null	Approving result ID
sHdTicketApprovalItemResult	nvarchar(255), null	Approving result
ApprovalItemResultLocaleId	int, not null	Language localization ID
LocalizedResult	nvarchar(max), null	Localized approving result

dbo.vHdTicketCalc

Information whether the ticket can indeed be reopened.

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

dbo.vHdTicketPersonRead

Effective authorization of users to tickets.

Column	Type	Description
liHdTicketId	int, null	Ticket ID, see tHdTicket.iHdTicketId.
liPersonId	int, null	User ID, see tPerson.iPersonId.
OnlyRequester	int, null	1 = the user is the requester of the ticket and has no other roles. 0 = otherwise.
SolverTeam	int, null	1 = the user is a member of the service team of the given ticket (with regard to groups of requesters). 0 = otherwise.
Operator	int, null	1 = the user is the main service solver of the ticket in question (with regard to groups of requesters). 0 = other.
Solver	int, null	1 = the user is a service solver of the given ticket (with regard to groups of requesters). 0 = otherwise.
OnlyReader	int, not null	1 = the user only has the right to see the ticket (with regard to groups of requesters) and is not a member of the ticket solver team. 0 = otherwise.

dbo.vHdTicketPersonRead_Custom

Custom extension of user permissions to see tickets. You can customize this view to include users and requests that those users should see in the application.

Column	Type	Description
TicketId	int, null	Ticket ID, see tHdTicket.iHdTicketId.
PersonId	int, null	User ID, see tPerson.iPersonId.
Requester	int, null	1 = the user is the requester of the ticket or has the same permissions as the requester. 0 = otherwise.
SolverTeam	int, null	1 = the user is a member of the service team of the given ticket (with regard to groups of requesters). 0 = otherwise.
Operator	int, null	1 = the user is the main service solver of the ticket in question (with regard to groups of requesters). 0 = other.
Solver	int, null	1 = the user is a service solver of the given ticket (with regard to groups of requesters). 0 = otherwise.
Read	int, null	1 = the user has permission to see the ticket. 0 = otherwise.

dbo.vInstDetect

Installed software, detected version and activation code.

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

dbo.vInstTrial

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

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

dbo.vKindLoc

Translations of the object properties in all languages ​​used.

Column	Type	Description
intKindId	int, not null	Property definition ID (tblKind.intKindId)
txtName	nvarchar(255), not null	Property name in the ALVAO system language
intFlags	int, null	bit array: 0x20 = property is not heritable
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
ColumnName	nvarchar(255), null	NodeCust table column name that stores the property value.
LocalizedName	nvarchar(max), not null	Localized property name
KindLocaleId	int, not null	LCID of the language into which the localization is performed.

dbo.vKnowledgeRead

Knowledge that a user can read in services.

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

dbo.vLang

Languages.

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

dbo.vLastEvaluatedSwDetect

Last evaluated SW detection on the computer.

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

dbo.vLicHist_InvoiceDocumentLast

Invoice attached to the license.

Column	Type	Description
LicHistId	int, null
AMDocumentId	int, null	Document (tblDocument.id)

dbo.vLicHistBase

License.

Column	Type	Description
intLicHistId	int, not null	License ID.
dteDate	date, not null	Date of license purchase.
txtLicName	nvarchar(255), null	License name.
LicenseCount	int, null	Number of licenses purchased.
txtProductName	nvarchar(1023), null	Product name.
txtResellerCompany	nvarchar(255), null	Supplier name.
txtLicType	nvarchar(32), not null	License type.
txtProductType	nvarchar(255), null	Product type.
intCurrentCount	int, null	Current number of licenses.
intAssignedCount	int, null	Current number of allocated licenses.
dteDateExpire	date, null	License Expiration Date.
txtActivationKey	nvarchar(1024), null	Activation key.
txtInventoryNum	nvarchar(255), null	Inventory number.
txtInvoice	nvarchar(255), null	The name of the document assigned to the license - vDocument.
txtLang	nvarchar(255), null	Product language - vLang.
bolDowngrade	int, not null	License downgrade.
txtMemo	nvarchar(max), null	Note.

dbo.vLicHistItem

License items.

Column	Type	Description
intLicHistItemId	int, not null
lintLicHistId	int, not null
NodeId	int, null
ActivationKey	nvarchar(255), null
txtMemo	nvarchar(max), null
txtInventoryNum	nvarchar(255), null
txtDepartment	nvarchar(255), null
txtRequest	nvarchar(255), null
LicensesCount	int, not null
bolOEM	int, not null
Object	nvarchar(255), null

dbo.vLicHistLog

Log of changes in registered licenses.

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

dbo.vLicProductCoveredOnComputer

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

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

dbo.vLicRight_Modify

Users with the permission to change software licenses belonging to the organization.

Column	Type	Description
NodeId	int, null	Organization (tblNode.intNodeId) to whose software licenses the permissions apply.
PersonId	int, null	Authorized user (tPerson.iPersonId)

dbo.vLicRight_Read

Users with the permission to read software licenses belonging to the organization.

Column	Type	Description
NodeId	int, null	Organization (tblNode.intNodeId) to whose software licenses the permissions apply.
PersonId	int, null	Authorized user (tPerson.iPersonId)

dbo.vLicTrans

Shared licenses.

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

dbo.vLog_DetectLast

Last record in the detection log.

Column	Type	Description
lintDetectId	int, null
lintMaxLogId	int, null

dbo.vMediaList

List of media.

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

dbo.vMediaType

Types of media.

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

dbo.vNewTicketFormSectionLoc

Column	Type	Description
id	int, not null
Order	int, not null
Expand	bit, not null
SectionId	int, not null
LocaleId	int, not null
Name	nvarchar(max), not null

dbo.vNewTicketFormTextBlockLoc

Column	Type	Description
id	int, not null
TextHtml	nvarchar(max), null
Order	int, not null
SectionId	int, not null
ColSpan	int, null
Column	int, null
LocaleId	int, not null

dbo.vNodeClass

Objects in the Objects Tree. Differentiation between system objects and discarded assets.

Column	Type	Description
intNodeId	int, not null
lintParentId	int, null
lintIconId	int, null
intState	int, null
txtName	nvarchar(255), null
IsHidden	bit, null
lintClassId	int, null
bolAutoUpdate	bit, not null
AdGuid	nvarchar(255), null
bolComputerStateOn	bit, null
txtPath	nvarchar(1024), null
bolIgnoreDifferences	bit, not null
liSwProfileId	int, null
bSwAllAllowed	bit, not null
txtClass	nvarchar(255), null
bComputer	bit, not null
IsDiscarded	bit, not null
LastAgentWSContact	datetime, null
RequiredPropertyAlert	bit, not null
IsActive	bit, null

dbo.vNodeCostCentre

Cost center of the objects in the tree.

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

dbo.vNodeHealth

Current health of objects.

Column	Type	Description
NodeId	int, null	Object ID (tblNode.intNodeId)
NodeHealthStatusId	int, null	Object health status ID (NodeHealthStatus.id).

dbo.vNodeHealth_Custom

Custom extension of the object health calculation. You can edit this view. By default, it does not contain any records.

Column	Type	Description
NodeId	int, null	Object ID (tblNode.intNodeId)
NodeHealthStatusId	int, null	Object health status ID (NodeHealthStatus.id).

dbo.vNodeParentJoin

Objects in the tree - tree.

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

dbo.vNodeProperty

Properties of all objects.

Column	Type	Description
NodeId	int, not null	Object ID (tblNode.intNodeId)
KindId	int, null	Property kind ID (tblKind.intKindId)
InheritedFromNodeId	int, null	Object ID (tblNode.intNodeId) from which the property is inherited.
Inheritable	bit, null	If the property value is inherited to child objects.
KindCode	int, null
KindDataTypeId	int, not null	Property data type ID
ColumnName	nvarchar(255), null	Name of the column in the NodeCust table.
CanModify	bit, null	If the value of the property can be changed.
IsDetected	bit, null
IsFromAD	bit, null

dbo.vNodePropertyMix

Objects and properties - Public + Asset + Computer1.

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

dbo.vNodePropertyMix_Asset

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

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

dbo.vNodePropertyMix_Computer1

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

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

dbo.vNodePropertyMix_Computer2

Objects and properties - Computer - MAC address.

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

dbo.vNodePropertyMix_Public

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

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

dbo.vOnlyReader

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

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

dbo.vPersonNodeRight

Rights in the object tree - main view.

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

dbo.vPersonNodeRight_Create

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

Column	Type	Description
liPersonId	int, null
liNodeId	int, null

dbo.vPersonNodeRight_Delete

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

Column	Type	Description
liPersonId	int, null
liNodeId	int, null

dbo.vPersonNodeRight_Move

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

Column	Type	Description
liPersonId	int, null
liNodeId	int, null

dbo.vPersonNodeRight_Read

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

Column	Type	Description
liPersonId	int, null
liNodeId	int, null

dbo.vPersonNodeRight_Write

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

Column	Type	Description
liPersonId	int, null
liNodeId	int, null

dbo.vPersonResponsibleForAsset

Users responsible for assets.

Column	Type	Description
NodeId	int, not null	Asset ID (tblNode.intNodeId)
PersonResponsibleForAsset	int, null	User ID (tblNode.intNodeId)

dbo.vProduct

Products (software).

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

dbo.vProductCategory

Products categories (OS).

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

dbo.vProductType

Products types.

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

dbo.vPropertyFromAD

Properties of objects which are downloaded from AD.

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

dbo.vPropertyKind_Asset

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

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

dbo.vPropertyKind_AssetCategory

Properties of objects - Asset category.

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

dbo.vPropertyKind_BIOSSerialNumber

Properties of objects - BIOS serial number.

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

dbo.vPropertyKind_ChassisType

Properties of objects - Type of rack.

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

dbo.vPropertyKind_ComputerKind

Properties of objects - Type of computer.

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

dbo.vPropertyKind_ComputerName

Properties of objects - Name in the network.

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

dbo.vPropertyKind_Department

Properties of objects - Cost center.

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

dbo.vPropertyKind_Domain

Properties of objects - DNS domain.

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

dbo.vPropertyKind_EvidentiaryNumber

Properties of objects - registration number.

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

dbo.vPropertyKind_Frequency

Properties of objects - Frequency.

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

dbo.vPropertyKind_Interface

Properties of objects - Interface.

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

dbo.vPropertyKind_InventoryDate

Properties of objects - Stocktaking date.

Column	Type	Description
lintNodeId	int, not null
lintKindId	int, not null
txtValue	date, null
bolInheritable	int, not null
txtKind	nvarchar(255), not null

dbo.vPropertyKind_InventoryNumber

Properties of objects - Asset number.

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

dbo.vPropertyKind_InvoiceNumber

Properties of objects - Packing slip number.

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

dbo.vPropertyKind_IPAddress

Properties of objects - IP address.

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

dbo.vPropertyKind_MACAddress

Properties of objects - MAC address.

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

dbo.vPropertyKind_Manufacturer

Properties of objects - Manufacturer.

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

dbo.vPropertyKind_MaxSize

Properties of objects - Maximum size.

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

dbo.vPropertyKind_MemoryDevices

Properties of objects - Sockets.

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

dbo.vPropertyKind_MemoryDevicesUsed

Properties of objects - Occupied sockets.

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

dbo.vPropertyKind_Model

Properties of objects - Model.

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

dbo.vPropertyKind_Name

Properties of objects - Name.

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

dbo.vPropertyKind_Office

Properties of objects - Office.

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

dbo.vPropertyKind_PartOfDomain

Properties of objects -Domain components.

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

dbo.vPropertyKind_PersonalId

Properties of objects - Personal number.

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

dbo.vPropertyKind_Place

Properties of objects - Location.

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

dbo.vPropertyKind_Port

Properties of objects - Port.

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

dbo.vPropertyKind_ProcessorId

Properties of objects - Processor ID.

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

dbo.vPropertyKind_Purchased

Properties of objects - Purchase date.

Column	Type	Description
lintNodeId	int, not null
lintKindId	int, not null
txtValue	date, null
bolInheritable	int, not null
txtKind	nvarchar(255), not null

dbo.vPropertyKind_RefreshMax

Properties of objects - Maximum refresh.

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

dbo.vPropertyKind_SerialNumber

Properties of objects - Serial number.

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

dbo.vPropertyKind_Size

Properties of objects - Size.

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

dbo.vPropertyKind_Type

Properties of objects - Type.

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

dbo.vPropertyKind_TypeMark

Properties of objects - Type designation.

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

dbo.vPropertyKind_Vendor

Properties of objects - Vendor.

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

dbo.vPropertyKind_Version

Properties of objects - Version.

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

dbo.vPropertyKind_VideoRAM

Properties of objects - RAM size.

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

dbo.vPropertyKind_WakeUpType

Properties of objects - Wake-up method.

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

dbo.vPropertyKind_Warranty

Properties of objects - Warranty.

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

dbo.vPropertyLoc

Translations of tProperty settings in all languages ​​used.

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

dbo.vRequestParticipant

Overview of ticket participants on requirements.

Column	Type	Description
TicketId	int, not null	Ticket ID (tHdTicket.iHdTicketId)
ParticipantCount	int, null	Number ticket participants
FirstParticipantPersonId	int, null	Ticket participant ID with the lowest ID (tPerson.iPersonId)

dbo.vSamAlertLast

SAM notification - last unresolved notifications sent

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

dbo.vSectionSolverLicence

Drawing of solver licenses by services

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

dbo.vSectionUserLicence

Drawing of user licenses by services

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

dbo.vSectionWithTreeOrder

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

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

dbo.vSlaAccess

Effective authorization requesters have for SLA and services.

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

dbo.vSlaAlertDeadline

Individual SLA notifications for the expiration of the ticket deadline.

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

dbo.vSlaAlertFirstReaction

Individual SLA notifications for the ticket first responses.

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

dbo.vSlaAlertInactiveApprovers

Individual SLA notifications for approver inactivity.

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

dbo.vSlaAlertInactiveOperators

Individual SLA notifications for inactivity of the main solvers.

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

dbo.vSlaAlertInactiveRequesters

Individual SLA notifications for requester inactivity.

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

dbo.vSlaAlertInactiveSolverGroups

Individual SLA notifications for solver group inactivity.

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

dbo.vSlaAlertInactiveSolvers

Individual SLA notifications for solver inactivity.

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

dbo.vSlaAlertInternalTarget

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

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

dbo.vSlaLoc

List of SLAs in all used languages.

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

dbo.vStringLoc

List of strings from ALVAO applications in all used languages.

Column	Type	Description
iStringId	int, not null	String ID.
mString	nvarchar(max), null	String.
StringLocaleId	int, not null	Language localization ID.
LocalizedString	nvarchar(max), null	Localized string.

dbo.vSwInst

Installed software - valid products and outside system objects.

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

dbo.vSwInst_ProductComputer

Software installed on the computers.

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

dbo.vSwInst_ProductComputerDetect

SW detected in the computers.

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

dbo.vSwInst_TreeCnt

Number of product installations in the subtree.

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

dbo.vSwInstLicProfile_ProductComputer

Installed software vs licenses and software profiles.
Note: This view is outdated and should not be used. It will be removed in a future version of ALVAO.

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

dbo.vSwLic_ProductComputer

Products covered by licenses on the computers.

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

dbo.vSwLic_UserComputer

Users' computers.

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

dbo.vSwProfileProduct_Node

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

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

dbo.vTicketRelation

Links Between Tickets.

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

dbo.vTicketRelationTypeLoc

List of ticket link types in all used languages.

Column	Type	Description
BeginName	nvarchar(30), not null	Start of link (name).
CustomField1	int, null	Custom field
Cyclic	bit, not null	If creating circular tasks is permitted. 1 = Yes, 0 = No.
Directional	bit, not null	If the link is directional or non-directional. 1 = directional, 0 = non-directional.
EndName	nvarchar(30), not null	End of link (name).
id	int, not null	Record ID
MenuOrder	int, not null	The order of link types in menus
OneToMany	bit, not null	If the link type is OneToMany. 1 = OneToMany, 0 = ManyToMany.
TicketRelationTypeBehaviorId	int, not null	System link type. When defining a custom link type, always use the value 1.
RelationTypeLocaleId	int, not null	Language localization ID
LocalizedBeginName	nvarchar(max), not null	Localized name of the beginning of the link
LocalizedEndName	nvarchar(max), not null	Localized name of the end of the link

dbo.vTicketStateEntered

Arrivals to individual ticket statuses.

Column	Type	Description
TicketId	int, not null	The ticket identification number.
TicketStateId	int, not null	Identification number of the ticket status.
TicketState	nvarchar(64), not null	Status name.
StateEntered	datetime, null	Time of transition to status

dbo.vTicketStateLoc

List of statuses in all used languages.

Column	Type	Description
id	int, not null
TicketTypeId	int, null
TicketState	nvarchar(64), not null
Description	nvarchar(max), null
SolverInstructions	nvarchar(max), null
Order	int, not null
TicketStateBehaviorId	int, not null
CustomField1	int, null
TransitToAllStates	bit, not null
ApprovalAutoStart	bit, not null
IsApprovalState	bit, not null
OnRejectedStateId	int, null
OnApprovalStateId	int, null
OnCanceledStateId	int, null
OnExpiredStateId	int, null
ApprovalSchemaId	int, null
ApprovalPersonId	int, null
ApprovalExpirationHours	float, null
CloseAfterSolution	bit, not null
TicketStateLocaleId	int, not null
LocalizedState	nvarchar(64), null
LocalizedDescription	nvarchar(max), null
LocalizedInstructions	nvarchar(max), null
LocalizedMessageForApproverTemplate	nvarchar(max), null	Localized message template for approvers. If the status does not have a defined custom message template for approvers, the default template is used in the record.
Removed	datetime, null	Date of status deletion. If the value is NULL here, the status was not deleted.
LocalizedNotificationForRequesterTemplate	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).
SendNotificationForRequester	bit, not null	Send a notification to the requester when transitioning to status.
DisplayCommandMoveToService	bit, not null
DisplayCommandAssignToSolver	bit, not null
PauseSla	bit, not null
SolverGroupRoleId	int, null

dbo.vTicketTemplateColumnValueLoc

Translations of custom fields values specified in ticket templates.

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

dbo.vTicketTypeLoc

List of processes used in all used languages.

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

dbo.vTimeZone

Overview of time zones and shifts compared to UTC.

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

dbo.vTransferConfirmAlertLast

Last sent alerts of unsigned handover protocols.

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

dbo.vUserLicence

Drawing of licenses by users

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

dbo.vUserNodeRight

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

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

dbo.vWbemObject

Detail of the HW detection - all.

Column	Type	Description
lintWbemObjectId1	int, not null
lintWbemObjectId2	int, not null
intWbemObjectId	int, not null
lintDetectId	int, not null
bolVirtualObject	bit, 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

dbo.vWbemObject_BIOS

Detail of the HW detection - BIOS.

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

dbo.vWbemObject_SystemEnclosure

Detail of the HW detection - Computer rack.

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

dbo.vWbemObjectPhysicalMedia

Detail of the HW detection - Hard disks.

Column	Type	Description
lintWbemObjectId1	int, not null
lintWbemObjectId2	int, not null
intWbemObjectId	int, not null
lintDetectId	int, not null
bolVirtualObject	bit, 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

dbo.wDocument

Documents.

Column	Type	Description
id	int, not null
Name	nvarchar(255), null
IdNumber	nvarchar(255), null
lintDocumentKindId	int, not null
txtIdNumber2	nvarchar(255), null
txtMemo	nvarchar(max), null
IssuedDate	datetime, null
CreatedDate	datetime, not null
lintResellerCompanyId	int, null
lintSrcNodeId	int, null
lintDestNodeId	int, null
txtResellerCompany	nvarchar(255), null
liCreatedPersonId	int, null
sCreatedPersonName	nvarchar(255), null
dteRemoved	datetime, null
liRemovedPersonId	int, null
sRemovedPersonName	nvarchar(255), null
TransferConfirmTypeId	int, not null
SignDate	datetime, null
SignPersonId	int, null
SignedBy	nvarchar(128), null
SignComputer	nvarchar(255), null
intDocumentKindId	int, not null
txtDocumentKind	nvarchar(255), null
txtSrcNodeName	nvarchar(255), null
txtDestNodeName	nvarchar(255), null
txtLink	int, null
DocumentFolderId	int, not null
SummaryProtocol	bit, not null
GiverFlags	int, null
ReceiverFlags	int, null

dbo.wIdSeq

Numeric sequence.

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