Other views
View | Scheme | Description |
---|---|---|
dbo | "Objects" in AM. | |
dbo | Ticket log. The view collects data from various tables. | |
dbo | Current approvers of tickets that are currently in the process of being approved. | |
dbo | Current ticket approvers according to custom approval processes. The customer can define custom contents for this view. | |
dbo | User membership in system roles of Asset Management. | |
dbo | Users in the object tree. | |
dbo | The user's link in the object tree to the user in the Administration service (tPerson).
| |
dbo | List of child tickets that person should see. | |
dbo | Types of objects. | |
dbo | Translations of the object type names in all languages used. | |
dbo | Translations of the names and descriptions of custom fields in all languages used. | |
dbo | Translations of custom fields values in all languages used. | |
dbo | Computers. | |
dbo | Last detection of the computers. | |
dbo | People and their superiors responsible for software installed on the computer | |
dbo | Types of detections (HW, SW). | |
dbo | Computer detection settings. | |
dbo | Detected files. | |
dbo | Documents. | |
dbo | Kinds of documents. | |
dbo | Translations of custom notifications in all languages used. | |
dbo | Effective solvers and exceptional solvers from services. | |
dbo | Effective solvers and exceptional solvers from solver groups of services. | |
dbo | View for effective viewing of the "View in the Service catalog" option. Takes into account settings in parent services. | |
dbo | Effective exceptional solvers in services. | |
dbo | Effective exceptional solvers from exceptional solver groups of services. | |
dbo | Effective exceptional operators in services. | |
dbo | Auxiliary view for the language localization of service names and descriptions. | |
dbo | Effective service operators. | |
dbo | Effective main solvers without absentee stand-ins. | |
dbo | Effective settings of notifications sent from the services to individual persons. | |
dbo | Effective solvers from solver groups of services. | |
dbo | Values for dynamically calculated ticket items. | |
dbo | Results of approval steps in all languages used. | |
dbo | Information whether the ticket can indeed be reopened. | |
dbo | Effective authorization of users to tickets. | |
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. | |
dbo | Installed software, detected version and activation code. | |
dbo | Installations covered by "special installation", including the coverage for package components. | |
dbo | Translations of the object properties in all languages used. | |
dbo | Knowledge that a user can read in services. | |
dbo | Languages. | |
dbo | Last evaluated SW detection on the computer. | |
dbo | Invoice attached to the license. | |
dbo | License. | |
dbo | License items. | |
dbo | Log of changes in registered licenses. | |
dbo | Which products on the computer have license coverage (per device or per user). | |
dbo | Users with the permission to change software licenses belonging to the organization. | |
dbo | Users with the permission to read software licenses belonging to the organization. | |
dbo | Shared licenses. | |
dbo | Last record in the detection log. | |
dbo | List of media. | |
dbo | Types of media. | |
dbo | ||
dbo | ||
dbo | Objects in the objects tree. Differentiation between system objects and discarded assets. | |
dbo | Cost center of the objects in the tree. | |
dbo | Current health of objects. | |
dbo | Custom extension of the object health calculation. You can edit this view. By default, it does not contain any records. | |
dbo | Objects in the tree - tree. | |
dbo | Properties of all objects. | |
dbo | Objects and properties - Public + Asset + Computer1. | |
dbo | Objects and properties - Assets number, Purchase date, Warranty expiration, Manufacturer, Packing slip number. | |
dbo | Objects and properties - Computer - Motherboard (type), BIOS Serial number. | |
dbo | Objects and properties - Computer - MAC address. | |
dbo | Objects and properties - Type designation, Serial number, Manufacturer, Registration number, Name. | |
dbo | Users that only have the right of reader in the services. | |
dbo | Rights in the object tree - main view. | |
dbo | Rights in the objects tree - the right to "Create any objects". | |
dbo | Rights in the object tree - the right to "Remove". | |
dbo | Rights in the object tree - the right to "Move". | |
dbo | Rights in the object tree - the right to "Read". | |
dbo | Rights in the object tree - the right to "Change". | |
dbo | Users responsible for assets. | |
dbo | Products (software). | |
dbo | Products categories (OS). | |
dbo | Products types. | |
dbo | Properties of objects which are downloaded from AD. | |
dbo | Object properties - Serial number, Inventory number a Asset number. | |
dbo | Properties of objects - Asset category. | |
dbo | Properties of objects - BIOS serial number. | |
dbo | Properties of objects - Type of rack. | |
dbo | Properties of objects - Type of computer. | |
dbo | Properties of objects - Name in the network. | |
dbo | Properties of objects - Cost center. | |
dbo | Properties of objects - DNS domain. | |
dbo | Properties of objects - registration number. | |
dbo | Properties of objects - Frequency. | |
dbo | Properties of objects - Interface. | |
dbo | Properties of objects - Stocktaking date. | |
dbo | Properties of objects - Asset number. | |
dbo | Properties of objects - Packing slip number. | |
dbo | Properties of objects - IP address. | |
dbo | Properties of objects - MAC address. | |
dbo | Properties of objects - Manufacturer. | |
dbo | Properties of objects - Maximum size. | |
dbo | Properties of objects - Sockets. | |
dbo | Properties of objects - Occupied sockets. | |
dbo | Properties of objects - Model. | |
dbo | Properties of objects - Name. | |
dbo | Properties of objects - Office. | |
dbo | Properties of objects -Domain components. | |
dbo | Properties of objects - Personal number. | |
dbo | Properties of objects - Location. | |
dbo | Properties of objects - Port. | |
dbo | Properties of objects - Processor ID. | |
dbo | Properties of objects - Purchase date. | |
dbo | Properties of objects - Maximum refresh. | |
dbo | Properties of objects - Serial number. | |
dbo | Properties of objects - Size. | |
dbo | Properties of objects - Type. | |
dbo | Properties of objects - Type designation. | |
dbo | Properties of objects - Vendor. | |
dbo | Properties of objects - Version. | |
dbo | Properties of objects - RAM size. | |
dbo | Properties of objects - Wake-up method. | |
dbo | Properties of objects - Warranty. | |
dbo | Translations of tProperty settings in all languages used. | |
dbo | Overview of ticket participants on requirements. | |
dbo | SAM notification - last unresolved notifications sent | |
dbo | Drawing of solver licenses by services | |
dbo | Drawing of user licenses by services | |
dbo | For each service, it returns a string which guarantees queueing being the same as that in the tree. | |
dbo | Effective authorization requesters have for SLA and services. | |
dbo | Individual SLA notifications for the expiration of the ticket deadline. | |
dbo | Individual SLA notifications for the ticket first responses. | |
dbo | Individual SLA notifications for approver inactivity. | |
dbo | Individual SLA notifications for inactivity of the main solvers. | |
dbo | Individual SLA notifications for requester inactivity. | |
dbo | Individual SLA notifications for solver group inactivity. | |
dbo | Individual SLA notifications for solver inactivity. | |
dbo | Individual SLA alerts for the expiration of tickets internal target date. | |
dbo | List of SLAs in all used languages. | |
dbo | List of strings from ALVAO applications in all used languages. | |
dbo | Installed software - valid products and outside system objects. | |
dbo | Software installed on the computers. | |
dbo | SW detected in the computers. | |
dbo | Number of product installations in the subtree. | |
dbo | Installed software vs licenses and software profiles. | |
dbo | Products covered by licenses on the computers. | |
dbo | Users' computers. | |
dbo | Statuses of the software profile on the products installed on the computers. | |
dbo | Links between tickets. | |
dbo | List of ticket link types in all used languages. | |
dbo | Arrivals to individual ticket statuses. | |
dbo | List of statuses in all used languages. | |
dbo | Translations of custom fields values specified in ticket templates. | |
dbo | List of processes used in all used languages. | |
dbo | Overview of time zones and shifts compared to UTC. | |
dbo | Last sent alerts of unsigned handover protocols. | |
dbo | Drawing of licenses by users | |
dbo | Rights in the object tree - users (including the rights allowed / prohibited by membership in roles). | |
dbo | Detail of the HW detection - all. | |
dbo | Detail of the HW detection - BIOS. | |
dbo | Detail of the HW detection - Computer rack. | |
dbo | Detail of the HW detection - Hard disks. | |
dbo | Documents. | |
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 | |
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:
- AD GUID
- Personal number
- Login name
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 | |
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.
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. |
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 |
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.
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 |