Tables
Table | Scheme | Description |
---|---|---|
dbo | Marking the record in the ticket log. | |
dbo | Kind of process in the ticket log | |
dbo | List of trustworthy domains. | |
Apps | Application. | |
Perf | Measured operations in applications | |
Perf | Operation responses in applications | |
Perf | Additional operation data in applications | |
dbo | Assigning articles from the knowledge base to services. | |
dbo | ||
dbo | The table of Azure Active Directory tenants from which users are imported. | |
dbo | Definition of properties for object class | |
dbo | Cache of value list item localizations. | |
dbo | Valid safety token table. | |
dbo | Property of the custom theme. | |
dbo | Data packages inserted by database updates | |
dbo | Data query defined by an SQL query | |
dbo | Permission to run a Data query. | |
dbo | Detected events from the Event log of computers | |
dbo | Detection method (e.g. without Agent, autonomous Agent, ...) | |
dbo | Detection profiles | |
dbo | Detected registry entries. The table contains records which may differ in various computers. | |
dbo | Document folder | |
dbo | Permissions of users and groups for documents stored in a certain document folder | |
dbo | Assigning signatures to services. | |
dbo | External services | |
dbo | External services metrics | |
dbo | Values of external service usages | |
dbo | Definition of custom JavaScript for forms. | |
dbo | Tokens for logging in to MS Exchange. | |
dbo | Cache of service localizations. | |
dbo | Effective service managers. | |
dbo | Unique service prefix and suffix pair. | |
dbo | Object types assigned to services. | |
dbo | Property entrusted to me - services which should be displayed in the service offer on the pages of objects of a certain type. | |
dbo | Effective main service solvers. | |
dbo | Effective readers in services. | |
dbo | Logging of changes in user permissions to services. | |
dbo | Effective service solvers. | |
dbo | Effective solvers from solver groups of services. | |
dbo | Numeric sequence types. | |
dbo | IP address range for Integrated Windows Authentication. | |
dbo | Property data types in AM. | |
dbo | Security for properties. | |
dbo | Service icon library. | |
dbo | License - downgrade. | |
dbo | License custom fields values. | |
dbo | License - links to documents and media. | |
dbo | Assigning/removing/moving license to/from/between computers. | |
dbo | Change record for a license or a license item. | |
dbo | Kind of change of a license or a license item. | |
dbo | License - links to documents and media. | |
dbo | A table containing links between licenses in Asset Management | |
dbo | Types of links between licenses in the AM | |
dbo | Types of links between licenses in the AM from the viewpoint of system/custom links. | |
dbo | "CAL/Licensing" list, i.e. per device, per user, etc. | |
dbo | Which of all products have license coverage. | |
dbo | Permissions of persons and groups to software licenses of organizations. | |
dbo | License types. | |
dbo | Enumeration of log levels | |
dbo | Outgoing email queue. | |
dbo | Information on items lent and returned in the media library. | |
dbo | News. | |
dbo | Services for which the individual news are intended. | |
dbo | ||
dbo | Records of reading the news. In multi-tenant operation, records of reading news displayed to other tenants are saved in the provider's database. | |
dbo | Column order on a New Ticket Form | |
dbo | Section order on a New Ticket Form | |
dbo | Text block order on a New Ticket Form | |
dbo | Inheritance between objects | |
dbo | Object property values | |
dbo | Objects in the tree - links to documents. | |
dbo | Object health status | |
dbo | Cache of language localizations of object health statuses, see NodeHealthStatus. | |
dbo | Table with links between objects in Asset Management | |
dbo | Types of links between objects in the AM. | |
dbo | Types of links between objects in the AM from the viewpoint of system/custom links. | |
dbo | Logging of changes in permissions of users in Asset Management. | |
dbo | Services to which the given solver created tickets last using the New Ticket Form. | |
dbo | Periodic alerts not defined by an SQL query. Sent by e-mail, periodically with the selected regularity. | |
dbo | Send period of periodic alerts. | |
dbo | People types. Normal users =1, system users >1. | |
dbo | Use of an e-mail address for sending the message by a specific user. | |
dbo | Events viewed by a person. | |
dbo | Cache for the number of unread tickets from the viewpoint of a specific user. | |
dbo | Pre-counted structure of managers and employees. | |
dbo | Used people's passwords. | |
dbo | A record from the history of the last viewed tickets of the requester. | |
dbo | Templates for print reports | |
dbo | Product License custom fields values. | |
dbo | Status of the products | |
dbo | View settings table | |
dbo | Table for temporary storage of read messages for custom actions. | |
dbo | Rules for incoming messages to service mailboxes. | |
dbo | The rules for automatic creation of linked tickets while transiting the source ticket to a certain status. | |
dbo | Copied items of the source ticket while creating linked tickets. | |
dbo | Method of setting the requester while creating linked tickets, see RelatedTicketRule. | |
dbo | The table contains properties that must be filled in for the given object types. | |
dbo | Types of system rolls, e.g. all users, administrators, ... | |
dbo | Logging of changes in membership in groups. | |
dbo | Kind of membership in the group. | |
dbo | Executed operation which is logged. | |
dbo | SAM notifications sent. | |
dbo | SAM configuration of notifications. | |
dbo | SAM notification rules. | |
dbo | SAM notification type - Audit: yes, no, via e-mail. | |
dbo | Scanners importing data from other systems or physical devices into Alvao. | |
dbo | Locking of values of object properties (dbo.tblKind) for editing by scanners (dbo.Scanner). | |
dbo | Connection to MS SCCM | |
dbo | Type of connection to MS SCCM | |
Apps | Application scripts. | |
dbo | Log of searched queries | |
dbo | ||
dbo | Settings of server applications (Alvao Service, AM Collector). | |
dbo | Table of shared views. | |
dbo | Table of users and groups which the view is shared with. | |
dbo | Notice for unresolved tickets - other recipients. | |
dbo | Cache of SLA localizations. | |
dbo | Logging of changes in SLA assignment | |
dbo | Map for determining the type of object based on device descriptions in SNMP. | |
dbo | Cache of text string localizations. | |
dbo | A table containing information on the customer and on the ticket on which information is taken. | |
dbo | Kinds of records in the views of software. | |
dbo | Organization (in accordance with CRM, i.e. the company). | |
dbo | Organization custom fields values. | |
dbo | The record in communication or ticket log. | |
dbo | Record type tAct, e.g. "e-mail", "phone", "note", "process", … | |
dbo | Address | |
dbo | Approval schemes. | |
dbo | Approval scheme step. | |
dbo | Article in Knowledge Base. | |
dbo | National holidays. | |
dbo | National holiday blocks included in the database. A block is a list of holidays belonging to one region and year. | |
dbo | Local national holiday regions. | |
dbo | Mapping attributes from AD to AM properties. This configuration is used by ImportAD. | |
dbo | ID of the objects types. Texts in tblDict. | |
dbo | Definitions of commands for the "Administrator's Tools" function. | |
dbo | Code list of organizations (software products library). | |
dbo | Information on HW and SW detections in the computers. | |
dbo | Scheduled evaluation of HW and SW by detection. | |
dbo | ID of the types of detection (HW, SW). Texts in tblDict. | |
dbo | Detections setting. | |
dbo | ID of the detections statuses. Texts in tblDict. | |
dbo | Detected files on the computers (SW detection). | |
dbo | Common table for the text code lists of the system tables values. | |
dbo | Documents. | |
dbo | Kinds of documents. Texts in tblDict | |
dbo | Detected files on the computer (SW detection). | |
dbo | Recognition rules for files (software products library). | |
dbo | Information on detected files - texts. | |
dbo | Information on detected files - versions. | |
dbo | Log - history of objects in the tree - move, deletion, insertion, etc. | |
dbo | Icons. | |
dbo | Numeric sequences - definitions. | |
dbo | Records on installation and uninstallation of products on the computers (manual as well as detected) | |
dbo | Special installation. | |
dbo | Definitions of the objects properties. | |
dbo | Value lists for the properties of objects. | |
dbo | ID of languages. Text in tblDict | |
dbo | License - list of purchased software licenses. | |
dbo | License - license items. | |
dbo | License - shared licenses. | |
dbo | Log - changes in the properties values and information on the detection results. | |
dbo | Media. | |
dbo | ID of the media types. Texts in tblDict. | |
dbo | Network search setting. | |
dbo | Objects in the tree. | |
dbo | Objects in the tree - tree. | |
dbo | Notes. | |
dbo | Detection of SW - information on the operating system. | |
dbo | Products / software (software products library). | |
dbo | ID of the products categories (OS). Text in tblDict. | |
dbo | Definition of software products packages (software products library). | |
dbo | ID of the products types (commercial, freeware, ...) (software products library). | |
dbo | Mapping properties to system functions. | |
dbo | Software products library - recognition rules for records from the register. | |
dbo | Detected registry entries. The table contains records which may repeat in various computers. | |
dbo | Detection - values of detected records from the register. | |
dbo | Mapping properties to system functions. | |
dbo | Information on which computer is executing the software products library update. | |
dbo | System settings. | |
dbo | Rights in the object tree to groups / users. | |
dbo | Software products library version. | |
dbo | Code list of values for the detected HW properties. | |
dbo | HW detected in the computers. | |
dbo | Hardware "Blacklist". | |
dbo | Links between the detected components of the computers. | |
dbo | List of custom fields and certain system items. | |
dbo | Value lists for custom fields. | |
dbo | Calendar of days | |
dbo | Database version, database language ID, activation keys for the entire ALVAO. | |
dbo | Detected properties of the computer components. | |
dbo | Attachments (to documents, notes, events, e-mails, ...) concerning the entire ALVAO system. | |
dbo | Signatures for e-mail messages. | |
dbo | Templates of custom notifications and alerts sent by the ALVAO SAM Assistant module. | |
dbo | Tenant diagnostics log records | |
dbo | Tenant security-change log records | |
dbo | User sign in log records | |
dbo | ALVAO Service Desk product services. | |
dbo | Services custom fields values. | |
dbo | Setting of notifications from the services to individual persons. | |
dbo | Permissions individuals and groups have in services (Main solver, Solver, ...). | |
dbo | Tickets. | |
dbo | Alternative ticket tags. Upon merging tickets, the final ticket uses tags from original tickets as alternative tags. | |
dbo | Ticket approval process instance - main record. | |
dbo | Ticket approval step. | |
dbo | List of approval step statuses. | |
dbo | Ticket custom fields values. | |
dbo | Cache for storing alerts. | |
dbo | Alert severity. | |
dbo | Language localisation cache for alert severity, see TicketAlertSeverity. | |
dbo | SLA alert type | |
dbo | Language localization cache of SLA alert type, see TicketAlertType | |
dbo | Ticket log record for changes to the ticket field value. | |
dbo | Objects associated to the ticket over the ticket "Objects" item. | |
dbo | Links Between Tickets. | |
dbo | Types of links between tickets. | |
dbo | System types of links between tickets. | |
dbo | Ticket participant for the ticket | |
dbo | A table containing the next ticket number. | |
dbo | Ticket statuses. Statuses are defined in the process (see dbo.TicketType). | |
dbo | System ticket statuses, see dbo.TicketState. | |
dbo | Ticket state custom fields values. | |
dbo | Cache of the localizations of ticket states. | |
dbo | Allowed transitions among ticket statuses, see dbo.TicketState. | |
dbo | Required fields for individual ticket statuses, see dbo.TicketState. | |
dbo | User tag of the ticket | |
dbo | Ticket tag type | |
dbo | Cache of tag types localizations. | |
dbo | List of ticket templates | |
dbo | column values on ticket template. | |
dbo | Objects linked to the ticket templates. | |
dbo | Processes. Among others, the process defines possible ticket statuses, workflow, custom ticket fields, etc. | |
dbo | System processes. | |
dbo | Ticket items used by the process. | |
dbo | Cache of process localizations. | |
dbo | For the effect on object health requirements, see TicketType.TicketTypeNodeHealthImpactId. | |
dbo | Numeric sequences - definitions for types of objects. | |
dbo | Time zone list. | |
dbo | Time zone shifts compared to UTC for each year | |
dbo | Language environments. | |
dbo | Language localization for selected database values. The following items are supported: tHdSection.sHdSectionShort, tHdSection.mHdSectionDesc. | |
dbo | Software profiles - exceptions for the computer. | |
dbo | For internal use | |
dbo | Service operating hours. | |
dbo | Auxiliary records for optimizing time calculations according to service operating hours. | |
dbo | Exceptions in service operating hours. | |
dbo | Persons in the ALVAO system. | |
dbo | Persons in the ALVAO system - own items. | |
dbo | ALVAO system settings. | |
dbo | Sent alerts to sign the handover protocols. | |
dbo | Setting time of sending an alert and the period of the last alert repetition. | |
dbo | Settings of rules for sending alerts of not yet signed handover protocols. | |
dbo | Method of the assets takeover signing. | |
dbo | Groups of persons for the entire ALVAO. | |
dbo | Persons' membership in groups. | |
dbo | Groups' membership in groups. | |
dbo | SLA. | |
dbo | Ticket log records for notification sent for an unresolved issue or upcoming deadline. | |
dbo | Rule for sending notifications for unresolved issues or an upcoming deadline. | |
dbo | SLA custom fields values. | |
dbo | Assigning SLA to individuals and groups. | |
dbo | Configuration of the SMTP server for ALVAO. | |
dbo | System code list for texts. | |
dbo | Sending unrecognized records, request for adding product to the standard software products library. | |
dbo | Software profiles - product statuses. | |
dbo | Software profiles - list. | |
dbo | Software profiles - membership of products in profiles. | |
dbo | Software profiles - sub-profiles. | |
dbo | Employee absence records. | |
dbo | Types of employee absence records. | |
dbo | Item in the definition of service operating hours. | |
dbo | Employee labor contracts. | |
dbo | Employee attendance record created in the ALVAO Attendance module. | |
dbo | Logging users in/out to/from Asset Management Console. | |
dbo | Executed action which is logged. | |
dbo | Application name. | |
dbo | Active session at ALVAO WebApp. | |
dbo | Registered webhooks integrating Alvao with other applications. | |
dbo | Webhook topics | |
dbo | Table with list of paid overtime hours |
dbo.ActMark
Marking the record in the ticket log.
Column | Type | Description |
---|---|---|
id | tinyint, not null | Record ID |
Name | nvarchar(255), not null | Record marking name |
dbo.ActOperation
Kind of process in the ticket log
Column | Type | Description |
---|---|---|
id | int, not null | Record ID |
Name | nvarchar(255), not null | Process kind name |
dbo.AdTrustedDomain
List of trustworthy domains.
Column | Type | Description |
---|---|---|
id | int, not null | Record ID. |
DomainName | nvarchar(128), not null | Domain name in a "dot" notation. |
Hostname | nvarchar(32), not null | Network name of server where the domain controller is running. |
Order | int, not null | Order in which ImportAD will try the servers of the replicated controller of the same domain. |
Skip | bit, not null | 1=skip elements from this domain during import. |
Apps.App
Application.
Column | Type | Description |
---|---|---|
id | int, not null | Application ID. |
Name | nvarchar(255), not null | Application name. |
Description | nvarchar(max), null | Application description. |
IsEnabled | bit, not null | If the application is enabled. 1 = enabled, 0 = disabled. |
Perf.AppOperation
Measured operations in applications
Column | Type | Description |
---|---|---|
id | int, not null | Operation identifier |
AppOperation | nvarchar(255), null | Operation name |
Perf.AppOperationRecord
Operation responses in applications
Column | Type | Description |
---|---|---|
id | int, not null | Record identifier |
int, not null | Measured operation identifier. A foreign key to the AppOperation table. | |
OperationStart | datetime, not null | Operation start time |
ServerDurationSeconds | float, null | Duration of the operation on the server in seconds |
ClientDurationSeconds | float, null | Duration of the operation in the client in seconds |
int, not null | User identifier of a person who performed the operation |
Perf.AppOperationRecordData
Additional operation data in applications
Column | Type | Description |
---|---|---|
id | int, not null | Data record identifier |
int, not null | Identifier of a record to which the data is related. A foreign key to the AppOperationRecord table. | |
DataName | nvarchar(255), null | Parameter name |
TextDataValue | nvarchar(255), null | Parameter text value |
IntDataValue | int, null | Integer parameter value |
FloatDataValue | float, null | Real parameter value |
dbo.ArticleHdSection
Assigning articles from the knowledge base to services.
Column | Type | Description |
---|---|---|
id | int, not null | |
int, null | ||
int, null |
dbo.ArticleLoc
Column | Type | Description |
---|---|---|
Id | int, not null | |
int, not null | ||
int, not null | ||
Name | nvarchar(1024), null | |
Annotation | nvarchar(max), null | |
Text | nvarchar(max), null | |
HtmlText | nvarchar(max), null |
dbo.AzureAdTenant
The table of Azure Active Directory tenants from which users are imported.
Column | Type | Description |
---|---|---|
id | int, not null | Record ID |
AzureTenantId | nvarchar(40), not null | Folder ID in Azure |
Name | nvarchar(max), not null | |
ScimSecretTokenHash | nvarchar(255), null | |
ScimSecretTokenHashLastGenerated | datetime, null | |
UserPortraits | bit, not null | |
UserPresence | bit, not null | |
Intune | bit, not null | Devices are imported from Intune. |
dbo.ClassKind
Definition of properties for object class
Column | Type | Description |
---|---|---|
int, not null | ID of object class (tblClass.intClassId) | |
int, not null | ID of object property (tblKind.intKindId) |
dbo.ColumnValueLoc
Cache of value list item localizations.
Column | Type | Description |
---|---|---|
ColumnValueId | int, not null | Value list item ID. |
ColumnId | int, not null | Custom field ID. |
LocaleId | int, not null | Language ID. |
ColumnValue | nvarchar(max), not null | Localized item value. |
ColumnValueShort | nvarchar(max), not null | Localized reduced item value. |
dbo.ConnectionToken
Valid safety token table.
Column | Type | Description |
---|---|---|
id | int, not null | Record ID. |
Token | varchar, not null | Token. |
ValidTo | datetime, not null | Valid to. |
dbo.CustomThemeProperty
Property of the custom theme.
Column | Type | Description |
---|---|---|
id | int, not null | Record ID |
Name | nvarchar(30), not null | Name of the theme property. |
Value | nvarchar(30), not null | Value of the theme property. |
dbo.DataPack
Data packages inserted by database updates
Column | Type | Description |
---|---|---|
id | nvarchar(128), not null | Data package identifier |
InsertedDate | datetime, not null | Date of insertion |
dbo.DataQuery
Data query defined by an SQL query
Column | Type | Description |
---|---|---|
id | int, not null | Record ID |
Name | nvarchar(255), not null | Query name |
Description | nvarchar(max), null | Description |
SqlQuery | nvarchar(max), null | SQL query |
IsEnabled | bit, not null | 1 = the query is enabled, 0 = disabled. |
ErrorMessage | nvarchar(max), null | Error message at the last SQL script run. |
Hidden | bit, not null |
dbo.DataQueryPermission
Permission to run a Data query.
Column | Type | Description |
---|---|---|
id | int, not null | Record ID |
int, not null | DataQuery (DataQuery.id) | |
int, null | Role (tRole.iRoleId) | |
int, null | Person (tPerson.iPersonId) |
dbo.DetectEventLog
Detected events from the Event log of computers
Column | Type | Description |
---|---|---|
id | int, not null | Record ID |
int, not null | Detection ID | |
EventDate | datetime, null | Event date and time (UTC) |
EventID | int, null | Event ID in the Event log |
Message | nvarchar(max), null | Event text |
dbo.DetectMethod
Detection method (e.g. without Agent, autonomous Agent, ...)
Column | Type | Description |
---|---|---|
id | int, not null | Record ID. |
BehaviorId | int, not null | Behavior from the system perspective: 0=Custom detection method, 1=Automatically, 2=Autonomous Agent, 3=Without Agent, 4=Agent over TCP/IP, 6=MS SCCM, 7=Manually |
Name | nvarchar(64), null | Name of the detection method. |
Custom1 | nvarchar(1024), null | Field for user data, usually identifier of the custom detection method. |
dbo.DetectProfile
Detection profiles
Column | Type | Description |
---|---|---|
id | int, not null | Record ID |
ProfileName | nvarchar(64), not null | Profile name |
DefaultProfile | bit, not null | Default profile |
DetectPeriod | int, null | Period of automatic detection planning |
int, null | HW detection method ID | |
int, null | SW detection method ID | |
SwIsFull | bit, not null | Full SW detection |
SwIncludeFiles | nvarchar(255), null | Full SW detection, include files |
SwExcludeFiles | nvarchar(255), null | Full SW detection, skip files |
dbo.DetRegUninstall
Detected registry entries. The table contains records which may differ in various computers.
Column | Type | Description |
---|---|---|
id | int, not null | Record ID. |
int, not null | ID detection. | |
int, not null | ID of the unique registry key. | |
EstimatedSize | int, null | |
UninstallString | nvarchar(255), null | |
ProductID | nvarchar(255), null | |
InstallDate | nvarchar(255), null | |
InstallLocation | nvarchar(255), null | |
InstallSource | nvarchar(255), null | |
LogFile | nvarchar(255), null | |
ModifyPath | nvarchar(255), null | |
Readme | nvarchar(255), null | |
NoModify | int, null | |
NoRemove | int, null | |
NoRepair | int, null | |
ALC_ProductPath | nvarchar(255), null | |
PIDKey | nvarchar(255), null | |
CD_KEY | nvarchar(255), null | Detected activation key. |
DigitalProductId | nvarchar(255), null | Detected product key. |
dbo.DocumentFolder
Document folder
Column | Type | Description |
---|---|---|
id | int, not null | Record ID |
Name | nvarchar(255), not null | Folder name |
Objects | bit, not null | 1 = documents in this folder can be linked to objects |
SwLicenses | bit, not null | 1 = documents in this folder can be linked to software licenses |
Stocktakings | bit, not null | 1 = documents in this folder can be linked to the asset stocktaking |
dbo.DocumentFolderRight
Permissions of users and groups for documents stored in a certain document folder
Column | Type | Description |
---|---|---|
id | int, not null | Record ID |
int, not null | Document folder (DocumentFolder.id) | |
int, null | User (tPerson.iPersonId); Just one of the PersonId and RoleId must have a value filled in. | |
int, null | User group (tRole.iRoleId) | |
CanRead | bit, null | 1 = read permission for documents |
CanModify | bit, null | 1 = editing permission for documents |
CanDelete | bit, null | 1 = deletion permission for documents |
dbo.EmailSignatureHdSection
Assigning signatures to services.
Column | Type | Description |
---|---|---|
int, not null | ||
int, null |
dbo.ExternalService
External services
Column | Type | Description |
---|---|---|
Id | int, not null | ID of external service |
Name | nvarchar(255), not null | Name of external service |
dbo.ExternalServiceMetric
External services metrics
Column | Type | Description |
---|---|---|
Id | int, not null | ID of external service metric |
int, not null | ID of external service | |
Feature | nvarchar(255), null | Name of the feature |
GroupName | nvarchar(255), null | Name of the group |
MetricName | nvarchar(255), null | Name of the metric |
dbo.ExternalServiceMetricValue
Values of external service usages
Column | Type | Description |
---|---|---|
Id | int, not null | ID of the usage |
int, not null | ID of external service metric | |
Date | date, not null | Date of usage |
IntValue | int, not null | Value of the usage for the date |
dbo.FormScriptExtension
Definition of custom JavaScript for forms.
Column | Type | Description |
---|---|---|
id | int, not null | Entity ID. |
int, not null | Link to service. | |
Javascript | nvarchar(max), null | JavaScript inserted into the page. |
dbo.HdSectionEwsTokens
Tokens for logging in to MS Exchange.
Column | Type | Description |
---|---|---|
int, not null | Service ID (see tHdSection.iHdSectionId) | |
RefreshToken | nvarchar(max), null | Refresh token |
AccessToken | nvarchar(max), null | Access token |
AccessTokenExpiration | datetime, null | Access token expiration (UTC) |
LastErrorMessage | nvarchar(max), null | Error message and from the last login to the mailbox. If it contains NULL, the last login was successful. |
dbo.HdSectionLoc
Cache of service localizations.
Column | Type | Description |
---|---|---|
HdSectionId | int, not null | Service ID. |
LocaleId | int, not null | Language ID. |
HdSection | nvarchar(1024), null | Localized service name. |
HdSectionShort | nvarchar(255), null | Located short service name. |
HdSectionDesc | nvarchar(max), null | Located short service name. |
HdSectionKeywords | nvarchar(max), null | Localized service keywords. |
HdSectionLocId | int, not null | Record ID. |
dbo.HdSectionManager
Effective service managers.
Column | Type | Description |
---|---|---|
id | int, not null | Record ID. |
int, not null | ID of the service where the user is a manager. | |
int, not null | User ID. | |
int, not null | ID of the group of requesters associated with the permissions (mapping of requesters to the solver team). |
dbo.HdSectionMessageTag
Unique service prefix and suffix pair.
Column | Type | Description |
---|---|---|
id | int, not null | Record ID |
Prefix | nvarchar(255), null | Prefix |
Suffix | nvarchar(255), null | Suffix |
dbo.HdSectionNodeClass
Object types assigned to services.
Column | Type | Description |
---|---|---|
id | int, not null | Record ID. |
int, not null | A service (tHdSection.iHdSectionId) to which the object type is linked. | |
int, not null | The object type (tblClass.intClassId) which is linked to the service. |
dbo.HdSectionNodeClassMyAssets
Property entrusted to me - services which should be displayed in the service offer on the pages of objects of a certain type.
Column | Type | Description |
---|---|---|
id | int, not null | Record ID. |
int, not null | The service (tHdSection.iHdSectionId) which should be displayed on the object pages. | |
int, not null | The class of objects (tblClass.intClassId) whose website should display the service. |
dbo.HdSectionOperator
Effective main service solvers.
Column | Type | Description |
---|---|---|
id | int, not null | Record ID. |
int, not null | ID of the service where the user is a main solver. | |
int, not null | User ID. | |
int, not null | ID of the group of requesters associated with the permissions (mapping of requesters to the solver team). |
dbo.HdSectionReader
Effective readers in services.
Column | Type | Description |
---|---|---|
id | int, not null | Record ID. |
int, not null | ID of the service where the user is a reader. | |
int, not null | User ID. | |
int, not null | ID of the group of requesters associated with the permissions (mapping of requesters to the solver team). |
dbo.HdSectionRightsLog
Logging of changes in user permissions to services.
The meaning of values in permission columns:
1=enable
0=not set
Column | Type | Description |
---|---|---|
id | int, not null | Record ID |
TimeStamp | datetime, not null | Change performance date and time (UTC) |
ModifiedByPersonId | int, null | User ID of a person who performed the change. |
ModifiedByPerson | nvarchar(255), not null | The name of the user who did the change. |
HdSectionId | int, null | Service ID |
HdSectionIdOld | int, null | ID of the original service |
HdSection | nvarchar(255), null | Service name |
HdSectionOld | nvarchar(255), null | Original service name |
RoleId | int, null | User group ID which is the permission holder. |
RoleIdOld | int, null | |
Role | nvarchar(255), null | User group name which is the permission holder. |
RoleOld | nvarchar(255), null | User group name of a person who was originally a permission holder. |
PersonId | int, null | User ID of a person who is the permission holder. |
PersonIdOld | int, null | User ID of a person who was originally a permission holder. |
Person | nvarchar(255), null | User name of a person who is the permission holder. |
PersonOld | nvarchar(255), null | User name of a person who was originally a permission holder. |
MainSolver | bit, not null | Main solver permissions |
MainSolverOld | bit, not null | Original main solver permissions |
Solver | bit, not null | Solver permissions |
SolverOld | bit, not null | Original solver permissions |
SolverTake1 | bit, not null | Solver permissions with the right to take the ticket over (main) |
SolverTake1Old | bit, not null | Original solver permissions with the right to take the ticket over (main) |
SolverTake2 | bit, not null | Solver permissions with the right to take the ticket over (secondary) |
SolverTake2Old | bit, not null | Original solver permissions with the right to take the ticket over (secondary) |
Manager | bit, not null | Manager permissions |
ManagerOld | bit, not null | Original manager permissions |
Reader | bit, not null | Reader permissions |
ReaderOld | bit, not null | Original reader permissions |
ExceptionalSolver | bit, not null | Exceptional solver permissions |
ExceptionalSolverOld | bit, not null | Original exceptional solver permissions |
TicketReporter | bit, not null | Permissions of the ticket reporter (formerly of the irregular operator) |
TicketReporterOld | bit, not null | The original permissions of the ticket reporter (formerly of irregular operator) |
SolverGroup | bit, not null | |
SolverGroupOld | bit, not null | |
RequesterRoleId | int, null | ID of the group of requesters associated with the permissions (mapping of requesters to the solver team). |
RequesterRoleIdOld | int, null | ID of the group of requesters originally associated with the permissions (mapping of requesters to the solver team). |
RequesterRole | nvarchar(255), null | Name of the group of requesters associated with the permissions (mapping of requesters to the solver team). |
RequesterRoleOld | nvarchar(255), null | Name of the group of requesters originally associated with the permissions (mapping of requesters to the solver team). |
dbo.HdSectionSolver
Effective service solvers.
Column | Type | Description |
---|---|---|
id | int, not null | Record ID. |
int, not null | ID of the service where the user is a solver. | |
int, not null | User ID. | |
int, not null | ID of the group of requesters associated with the permissions (mapping of requesters to the solver team). |
dbo.HdSectionSolverGroup
Effective solvers from solver groups of services.
Column | Type | Description |
---|---|---|
id | int, not null | Record ID. |
int, not null | ID of the service where the user is a solver group member. | |
int, not null | User ID. | |
int, not null | ID of the group of requesters associated with the permissions (mapping of requesters to the solver team). |
dbo.IdSeqType
Numeric sequence types.
Column | Type | Description |
---|---|---|
id | int, not null | Record ID. |
IdSeqType | nvarchar(32), not null | Numeric sequence type. |
dbo.IntegratedAuthIpRange
IP address range for Integrated Windows Authentication.
Column | Type | Description |
---|---|---|
id | int, not null | Record ID. |
FromIP | bigint, null | Beginning of the range of IP addresses, including. |
ToIP | bigint, null | End of the range of IP addresses, including endpoint. |
dbo.KindDataType
Property data types in AM.
Column | Type | Description |
---|---|---|
KindDataTypeId | int, not null | Property data type ID. |
DataTypeName | nvarchar(20), null | Property data type name. |
dbo.KindRight
Security for properties.
Column | Type | Description |
---|---|---|
id | int, not null | Record ID. |
int, not null | Property definition ID. | |
int, not null | Group ID. | |
int, null | Object type ID. The value NULL meals that the permission applies to all object types. | |
CanRead | tinyint, null | Permission to read. |
CanModify | tinyint, null | Permission to change value. |
dbo.LibraryIcon
Service icon library.
Column | Type | Description |
---|---|---|
Id | int, not null | Record ID |
Name | nvarchar(100), null | Icon name |
Content | varbinary, not null | Binary content of file in PNG format |
SystemIcon | bit, not null | 1 = system icon |
dbo.LicDowngrade
License - downgrade.
Column | Type | Description |
---|---|---|
int, not null | License ID - tblListHist | |
int, not null | Product ID - tblProduct | |
Desc | nvarchar(255), null | Note |
dbo.LicHistCust
License custom fields values.
Column | Type | Description |
---|---|---|
int, null |
dbo.LicHistDocument
License - links to documents and media.
Column | Type | Description |
---|---|---|
int, not null | License (tblLicHist.intLicHistId) | |
int, not null | Document (tblDocument.id) |
dbo.LicHistItemAssign
Assigning/removing/moving license to/from/between computers.
Column | Type | Description |
---|---|---|
id | int, not null | Record ID |
int, not null | License | |
int, null | License item | |
AssignedDate | datetime, not null | Date assigned/removed |
int, not null | Assigning/Removing author | |
int, null | Source object | |
int, null | Target object | |
LicInfo | nvarchar(1000), null | Information on the assigned/removed license. |
ItemInfo | nvarchar(1000), null | Information on the assigned/removed license item. |
dbo.LicHistLog
Change record for a license or a license item.
Column | Type | Description |
---|---|---|
id | int, not null | Record ID. |
LogDate | datetime, not null | Date and time of the event. |
int, null | The license ID to which the change relates. A foreign key in the LicHist table. | |
int, not null | Change kind ID. The kinds of changes are specified in the LicHistLogKind table. | |
int, not null | Change author ID. A foreign key in the tPerson table. | |
PropName | nvarchar(100), null | Name of the changed license property or license item property. |
OldVal | nvarchar(255), null | The original property value. |
NewVal | nvarchar(255), null | New property value. |
Message | nvarchar(max), null | A message displayed in the license log. |
dbo.LicHistLogKind
Kind of change of a license or a license item.
Column | Type | Description |
---|---|---|
id | int, not null | Record ID. |
LogKind | nvarchar(100), not null | Kind of change. |
MsgTemplate | nvarchar(255), not null | Template of the message for displaying the change in the license log. |
dbo.LicHistMedia
License - links to documents and media.
Column | Type | Description |
---|---|---|
int, not null | License (tblLicHist.intLicHistId) | |
int, not null | Media (tblMedia.id) |
dbo.LicHistRelation
A table containing links between licenses in Asset Management
Column | Type | Description |
---|---|---|
id | int, not null | Record ID. |
int, not null | Initial license link ID. A foreign key on the tblLicHist table. | |
int, not null | End license link ID. A foreign key on the tblLicHist table. | |
int, not null | Link type. A foreign key on the LicHistRelationType table. | |
ModifiedDate | datetime, not null | Date of last link edit. |
int, not null | Person who performed the last link edit. |
dbo.LicHistRelationType
Types of links between licenses in the AM
Column | Type | Description |
---|---|---|
id | int, not null | Record ID |
BeginName | nvarchar(32), not null | Start of link (name). |
EndName | nvarchar(32), not null | End of link (name). |
Directional | bit, not null | If the link is directional or non-directional. 1 = directional, 0 = non-directional. |
Cyclic | bit, not null | if creating circular tasks is permitted. 1 = Yes, 0 = No. |
OneToMany | bit, not null | If the link type is OneToMany. 1 = OneToMany, 0 = ManyToMany. |
int, not null | Link behavior. If system or custom one. A foreign key on LicHistRelationTypeBehavior. |
dbo.LicHistRelationTypeBehavior
Types of links between licenses in the AM from the viewpoint of system/custom links.
Column | Type | Description |
---|---|---|
id | int, not null | Record ID |
Name | nvarchar(70), null | Name |
dbo.LicKind
"CAL/Licensing" list, i.e. per device, per user, etc.
Column | Type | Description |
---|---|---|
id | int, not null | |
LicKind | nvarchar(32), not null |
dbo.LicProductCoverage
Which of all products have license coverage.
Column | Type | Description |
---|---|---|
int, not null | License ID - tblListHist | |
int, not null | Product ID - tblProduct | |
int, null |
dbo.LicRight
Permissions of persons and groups to software licenses of organizations.
Column | Type | Description |
---|---|---|
id | int, not null | Record ID |
int, null | Organization (tblNode.intNodeId) to whose software licenses the permissions apply. | |
int, null | Authorized user (tPerson.iPersonId) | |
int, null | Authorized group of users (tRole.iRoleId) | |
CanRead | tinyint, null | Permission to read |
CanModify | tinyint, null | Permission to modify |
dbo.LicType
License types.
Column | Type | Description |
---|---|---|
id | int, not null | Item ID. |
LicType | nvarchar(32), not null | Type name. |
dbo.LogLevel
Enumeration of log levels
Column | Type | Description |
---|---|---|
id | int, not null | Record ID |
Name | nvarchar(50), not null | Log level name |