Přeskočit na hlavní obsah

Other views

dbo.Node

"Objects" in AM.

ColumnTypeDescription

Node Id

int, not null

dbo.vAct

Ticket log. The view collects data from various tables.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

liHdTicketId

int, null

liPersonId

int, null

dbo.vAssetPersonSystemRole

User membership in system roles of Asset Management.

ColumnTypeDescription

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.

ColumnTypeDescription

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
ColumnTypeDescription

NodeId

int, not null

PersonId

int, not null

PersonManagerId

int, null

dbo.vChildTicketPersonRead

List of child tickets that person should see.

ColumnTypeDescription

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.

ColumnTypeDescription

intClassId

int, not null

txtClass

nvarchar(255), null

bComputer

bit, not null

dbo.vClassLoc

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

ColumnTypeDescription

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.

ColumnTypeDescription

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

Precision

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

lintDetectId

int, null

lintComputerNodeId

int, not null

lintDetectKindId

int, not null

dbo.vComputerSwManager

People and their superiors responsible for software installed on the computer

ColumnTypeDescription

ComputerId

int, null

SwManagerPersonId

int, null

SwManagerSuperiorId

int, null

dbo.vDetectKind

Types of detections (HW, SW).

ColumnTypeDescription

intDetectKindId

int, not null

txtDetectKind

nvarchar(255), null

dbo.vDetectSettings

Computer detection settings.

ColumnTypeDescription

NodeId

int, not null

Computer ID.

MethodId

int, null

Detection method ID.

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

intDocumentKindId

int, not null

txtDocumentKind

nvarchar(255), null

dbo.vEmailTemplateLoc

Translations of custom notifications in all languages ​​used.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

iHdSectionId

int, null

EffectiveShowInServiceCatalog

bit, null

dbo.vHdSectionExceptionalSolver

Effective exceptional solvers in services.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

iHdTicketId

int, not null

bHdTicketUserOpenProtected

int, not null

dbo.vHdTicketPersonRead

Effective authorization of users to tickets.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

lintProductId

int, not null

lintComputerNodeId

int, not null

txtDesc

nvarchar(255), null

dbo.vKindLoc

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

ColumnTypeDescription

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

Precision

int, null

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.

ColumnTypeDescription

SectionId

int, null

ArticleId

int, null

PersonId

int, null

dbo.vLang

Languages.

ColumnTypeDescription

intNameLangId

int, null

txtLang

nvarchar(255), null

dbo.vLastEvaluatedSwDetect

Last evaluated SW detection on the computer.

ColumnTypeDescription

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.

ColumnTypeDescription

LicHistId

int, null

AMDocumentId

int, null

Document (tblDocument.id)

dbo.vLicHistBase

License.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

NodeId

int, null

Organization (tblNode.intNodeId) to whose software licenses the permissions apply.

PersonId

int, null

Authorized user (tPerson.iPersonId)

dbo.vLicTrans

Shared licenses.

ColumnTypeDescription

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.

ColumnTypeDescription

lintDetectId

int, null

lintMaxLogId

int, null

dbo.vMediaList

List of media.

ColumnTypeDescription

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.

ColumnTypeDescription

intMediaTypeId

int, not null

txtMediaType

nvarchar(255), null

dbo.vNewTicketFormSectionLoc

ColumnTypeDescription

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

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

NodeId

int, not null

ClassId

int, null

Centre

nvarchar(255), null

dbo.vNodeHealth

Current health of objects.

ColumnTypeDescription

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.

ColumnTypeDescription

NodeId

int, null

Object ID (tblNode.intNodeId)

NodeHealthStatusId

int, null

Object health status ID (NodeHealthStatus.id).

dbo.vNodeParentJoin

Objects in the tree - tree.

ColumnTypeDescription

lintNodeId

int, not null

lintParentNodeId

int, not null

dbo.vNodeProperty

Properties of all objects.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

intNodeId3

int, not null

txtType

nvarchar(255), null

txtBIOSSerialNumber

nvarchar(255), null

dbo.vNodePropertyMix_Computer2

Objects and properties - Computer - MAC address.

ColumnTypeDescription

intNodeId4

int, not null

txtMACAddress

nvarchar(255), null

dbo.vNodePropertyMix_Public

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

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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

ColumnTypeDescription

liPersonId

int, null

liNodeId

int, null

dbo.vPersonNodeRight_Delete

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

ColumnTypeDescription

liPersonId

int, null

liNodeId

int, null

dbo.vPersonNodeRight_Move

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

ColumnTypeDescription

liPersonId

int, null

liNodeId

int, null

dbo.vPersonNodeRight_Read

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

ColumnTypeDescription

liPersonId

int, null

liNodeId

int, null

dbo.vPersonNodeRight_Write

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

ColumnTypeDescription

liPersonId

int, null

liNodeId

int, null

dbo.vPersonResponsibleForAsset

Users responsible for assets.

ColumnTypeDescription

NodeId

int, not null

Asset ID (tblNode.intNodeId)

PersonResponsibleForAsset

int, null

User ID (tblNode.intNodeId)

dbo.vProduct

Products (software).

ColumnTypeDescription

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

ColumnTypeDescription

intProductCategoryId

int, not null

txtProductCategory

nvarchar(255), null

dbo.vProductType

Products types.

ColumnTypeDescription

intProductTypeId

int, not null

txtProductType

nvarchar(255), null

dbo.vPropertyFromAD

Properties of objects which are downloaded from AD.

ColumnTypeDescription

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.

ColumnTypeDescription

intNodeId

int, not null

EvidentiaryNumber

nvarchar(255), null

SerialNumber

nvarchar(255), null

InventoryNumber

nvarchar(255), null

dbo.vPropertyKind_AssetCategory

Properties of objects - Asset category.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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

ColumnTypeDescription

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

ColumnTypeDescription

PersonCount

int, null

LicenceType

nvarchar(max), null

SectionId

int, not null

dbo.vSectionUserLicence

Drawing of user licenses by services

ColumnTypeDescription

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.

ColumnTypeDescription

iHdSectionId

int, null

sHdSection

nvarchar(1024), null

nHdSectionOrder

float, null

TreeSorting

nvarchar(max), null

dbo.vSlaAccess

Effective authorization requesters have for SLA and services.

ColumnTypeDescription

liSlaAccessSlaId

int, not null

liSlaAccessHdSectionId

int, not null

liSlaAccessPersonId

int, null

dbo.vSlaAlertDeadline

Individual SLA notifications for the expiration of the ticket deadline.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

liNodeId

int, null

liProductId

int, null

liSwPresenceId

int, null

dbo.vTicketRelation

Links Between Tickets.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

id

int, not null

DocumentId

int, not null

RuleId

int, not null

SentDate

datetime, not null

dbo.vUserLicence

Drawing of licenses by users

ColumnTypeDescription

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

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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.

ColumnTypeDescription

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