Skip to main content

Report views

Query.DiskDriveCsy

HD drives in the ALVAO Asset Management in details of HW detection.
Discarded and removed drives are not displayed.
Only the objects and property values are shown that the user connected to the database is authorized to read.
The view is used to create reports and analyses. If not stated otherwise, the data is shown in the ALVAO system language.

ColumnTypeDescription

Id objektu

int, not null

Object identification number of a Computer type that contains a given drive.

Logický disk

nvarchar(255), null

Logical drive name, e.g. "C:".

Kapacita (GB)

float, null

Drive capacity

Využito (GB)

float, null

Used drive space

Volné místo (GB)

float, null

Free drive space

Volné místo (%)

float, null

The percentage of free space and drive capacity

BitLocker

nvarchar(12), not null

It indicates whether the given drive is encrypted by BitLocker. The column may have the following values "On", "Off" and "Unknown" (in Czech).

Query.DiskDriveDeu

HD drives in the ALVAO Asset Management in details of HW detection.
Discarded and removed drives are not displayed.
Only the objects and property values are shown that the user connected to the database is authorized to read.
The view is used to create reports and analyses. If not stated otherwise, the data is shown in the ALVAO system language.

ColumnTypeDescription

Objekt Id

int, not null

Object identification number of a Computer type that contains a given drive.

Logische Platte

nvarchar(255), null

Logical drive name, e.g. "C:".

Kapazität (GB)

float, null

Drive capacity

Verwendeter Speicherplatz (GB)

float, null

Used drive space

Freier Speicherplatz (GB)

float, null

Free drive space

Freier Speicherplatz (%)

float, null

The percentage of free space and drive capacity

BitLocker

nvarchar(18), not null

It indicates whether the given drive is encrypted by BitLocker. The column may have the following values "On", "Off" and "Unknown" (in Czech).

Query.DiskDriveEnu

HD drives in the ALVAO Asset Management in details of HW detection.
Discarded and removed drives are not displayed.
Only the objects and property values are shown that the user connected to the database is authorized to read.
The view is used to create reports and analyses. If not stated otherwise, the data is shown in the ALVAO system language.

ColumnTypeDescription

Object id

int, not null

Object identification number of a Computer type that contains a given drive.

Logical drive

nvarchar(255), null

Logical drive name, e.g. "C:".

Capacity (GB)

float, null

Drive capacity

Utilized (GB)

float, null

Used drive space

Total free space (GB)

float, null

Free drive space

Free space (%)

float, null

The percentage of free space and drive capacity

BitLocker

nvarchar(14), not null

It indicates whether the given drive is encrypted by BitLocker. The column may have the following values "On", "Off" and "Unknown" (in Czech).

Query.DocumentCsy

Documents in ALVAO Asset Management.
Only the objects and property values are shown that the user connected to the database is authorized to read. The view is used to create reports and analyses.
If not stated otherwise, the data is shown in the ALVAO system language.

ColumnTypeDescription

Datum vystavení

datetime, null

Document issue date (without time)

Datum vystavení - Měsíc od

datetime, null

Date of the first day of month when the document was issued.

Typ dokumentu

nvarchar(255), null

Document type

Identifikační číslo

nvarchar(255), null

Document identification number

Dodavatel

nvarchar(255), null

The vendor name (Document type = Invoice)

Předávající

nvarchar(255), null

The name or title of the person handing over (Document type = Handover protocol)

Přebírající

nvarchar(255), null

The name or title of the accepting person (Document type = Handover protocol)

Identifikační číslo 2

nvarchar(255), null

Document identification number 2

Poznámka

nvarchar(max), null

Note

Zneplatněn (UTC)

datetime, null

Date and time of document record voiding in AM

Vytvořil

nvarchar(255), null

User name of a person who created the document record in AM.

Zneplatnil

nvarchar(255), null

User name of a person who made the document record in AM void.

Url

nvarchar(2086), null

URL of the document page in the web app.

Query.DocumentDeu

Documents in ALVAO Asset Management.
Only the objects and property values are shown that the user connected to the database is authorized to read. The view is used to create reports and analyses.
If not stated otherwise, the data is shown in the ALVAO system language.

ColumnTypeDescription

Ausgabedatum

datetime, null

Document issue date (without time)

Ausgabedatum - Monat beginnt

datetime, null

Date of the first day of month when the document was issued.

Dokumenttyp

nvarchar(255), null

Document type

Identifikationsnummer

nvarchar(255), null

Document identification number

Lieferant

nvarchar(255), null

The vendor name (Document type = Invoice)

Übergebende Person

nvarchar(255), null

The name or title of the person handing over (Document type = Handover protocol)

Annehmende Person

nvarchar(255), null

The name or title of the accepting person (Document type = Handover protocol)

Identifikationsnummer 2

nvarchar(255), null

Document identification number 2

Anmerkung

nvarchar(max), null

Note

Ungültig gemacht (UTC)

datetime, null

Date and time of document record voiding in AM

Erstellt von

nvarchar(255), null

User name of a person who created the document record in AM.

Ungültig gemacht von

nvarchar(255), null

User name of a person who made the document record in AM void.

Url

nvarchar(2086), null

URL of the document page in the web app.

Query.DocumentEnu

Documents in ALVAO Asset Management.
Only the objects and property values are shown that the user connected to the database is authorized to read. The view is used to create reports and analyses.
If not stated otherwise, the data is shown in the ALVAO system language.

ColumnTypeDescription

Issue date

datetime, null

Document issue date (without time)

Issue date - Month starting

datetime, null

Date of the first day of month when the document was issued.

Document type

nvarchar(255), null

Document type

Identification number

nvarchar(255), null

Document identification number

Vendor

nvarchar(255), null

The vendor name (Document type = Invoice)

Person handing over

nvarchar(255), null

The name or title of the person handing over (Document type = Handover protocol)

Person accepting

nvarchar(255), null

The name or title of the accepting person (Document type = Handover protocol)

Identification number 2

nvarchar(255), null

Document identification number 2

Note

nvarchar(max), null

Note

Voided (UTC)

datetime, null

Date and time of document record voiding in AM

Created by

nvarchar(255), null

User name of a person who created the document record in AM.

Voided by

nvarchar(255), null

User name of a person who made the document record in AM void.

Url

nvarchar(2086), null

URL of the document page in the web app.

Query.ExecutedSoftwareEnu

Software run on computers in ALVAO Asset Management. Discarded and removed computers are not displayed. Only the objects are shown that the user connected to the database is authorized to read. The view is used to create reports and analyses. If not stated otherwise, the data is shown in the ALVAO system language.

ColumnTypeDescription

Computer Id

int, not null

Computer identification number (tblNode.intNodeId)

Computer

nvarchar(255), null

Computer name

User

nvarchar(255), null

The name of the user who has the computer in use.

Filename

nvarchar(511), null

The name of the running file, including the extension

Path

nvarchar(255), null

The file location on your computer's file system

Size (B)

int, null

File size in bytes

File version

nvarchar(255), null

File version

File description

nvarchar(255), null

File Description

Product

nvarchar(255), null

Product name

Product version

nvarchar(255), null

Product version

Company

nvarchar(255), null

Product manufacturer

Last run

datetime, null

The date and time of the last start in the time zone of the computer detected

Run count

int, null

Total number of files running

Query.HdSectionRightsLog

View of the list of changes in service permissions.
The meaning of values in permission columns:
1=enable
0=refuse
NULL=not set

ColumnTypeDescription

TimeStamp

datetime, not null

Change performance date and time (UTC)

ModifiedByPerson

nvarchar(518), not null

The name of the user who did the change.

HdSection

nvarchar(1287), null

Service name

HdSectionOld

nvarchar(1287), null

Original service name

Role

nvarchar(518), null

User group name which is the permission holder.

RoleOld

nvarchar(518), null

User group name of a person who was originally a permission holder.

Person

nvarchar(518), null

User name of a person who is the permission holder.

PersonOld

nvarchar(518), null

User name of a person who was originally a permission holder.

Operator

int, null

Main solver permissions

OperatorOld

int, null

Original main solver permissions

Solver

int, null

Solver permissions

SolverOld

int, null

Original solver permissions

SolverTake1

int, null

Solver permissions with the right to take the ticket over (main)

SolverTake1Old

int, null

Original solver permissions with the right to take the ticket over (main)

SolverTake2

int, null

Solver permissions with the right to take the ticket over (secondary)

SolverTake2Old

int, null

Original solver permissions with the right to take the ticket over (secondary)

Manager

int, null

Manager permissions

ManagerOld

int, null

Original manager permissions

Reader

int, null

Reader permissions

ReaderOld

int, null

Original reader permissions

ExceptionalSolver

int, null

Exceptional solver permissions

ExceptionalSolverOld

int, null

Original exceptional solver permissions

IrregularOperator

int, null

Permissions of the ticket reporter (formerly of the irregular operator)

IrregularOperatorOld

int, null

The original permissions of the ticket reporter (formerly of irregular operator)

RequesterRole

nvarchar(518), null

Name of the group of requesters associated with the permissions (mapping of requesters to the solver team).

RequesterRoleOld

nvarchar(518), null

Name of the group of requesters originally associated with the permissions (mapping of requesters to the solver team).

Query.NodeParent

View with all objects in Asset and their child objects (including indirect links - deep immersion).

ColumnTypeDescription

ChildNodeId

int, not null

Node ID of the object in the tree.

ParentNodeId

int, not null

Node ID of the parent object in the tree.

Query.NodeRightLog

View of the list of changes in permissions in the objects tree.

ColumnTypeDescription

TimeStamp

datetime, not null

Date and time of the change execution.

ModifiedBy

nvarchar(255), not null

Logged-in user name.

User

nvarchar(255), null

User name.

Group

nvarchar(255), null

Group name.

Object

nvarchar(255), null

Object name.

ObjectOld

nvarchar(255), null

Object name - the previous value.

Recursive

bit, not null

Check box including of child objects.

RecursiveOld

bit, null

Check box including of child objects - the previous value.

Class

nvarchar(255), null

Object type name.

ClassOld

nvarchar(255), null

Object type name - the previous value.

Read

bit, null

Permission to read.

ReadOld

bit, null

Permission to read - the previous value.

Write

bit, null

Permission to edit.

WriteOld

bit, null

Permission to edit - the previous value.

Move

bit, null

Permission to move.

MoveOld

bit, null

Permission to move - the previous value.

Create

bit, null

Permission to create any objects.

CreateOld

bit, null

Permission to create any objects - the previous value.

Delete

bit, null

Permission to delete.

DeleteOld

bit, null

Permission to delete - the previous value.

Query.ObjectCsy

Objects in ALVAO Asset Management.
Discarded and removed objects are not displayed.
In addition to the described columns, the view contains the values of the 100 most used properties.
If you want to prioritize the display of some properties, on the WA – Administration – Settings – Advanced page
set the "AM.Query.PreferredProperties" property as the comma-separated list of preferred property identifiers
(see table dbo.tblKind and column intKindId).
Only objects and property values that the user connected to the database has the right to read are displayed.
The view is used to create reports and analyses. Unless stated otherwise, the data is shown in the ALVAO system language.

ColumnTypeDescription

Id objektu

int, not null

Object identification number (tblNode.intNodeId)

Název objektu

nvarchar(255), null

Object name

Druh objektu

nvarchar(max), null

Object kind

Cesta ve stromu

nvarchar(1024), null

Path in tree (without the object name). Contains an empty chain for root objects.

Id rodiče

int, null

Id of parent object.

Objekt typu počítač

nvarchar(3), not null

It indicates whether the given object is of Computer type. The column may have the following values "Yes" and "No" (in Czech).

Vytvořeno (UTC)

datetime, null

Object creation date and time

Vytvořeno - Měsíc od (UTC)

datetime, null

Date of the first day of month when the object was created.

Upozornění

nvarchar(max), null

Notification of unfilled mandatory object properties.

LinkDiagramUrl

nvarchar(2083), null

URL of the object diagram page.

Url

nvarchar(2072), null

URL of the object page.

Název v síti

nvarchar(255), null

Inventární číslo

nvarchar(255), null

Sériové číslo

nvarchar(255), null

Výrobce

nvarchar(255), null

Datum nákupu

date, null

Cena

nvarchar(255), null

Model

nvarchar(255), null

Záruka do

date, null

Operační systém

nvarchar(255), null

Poznámka

nvarchar(255), null

Název

nvarchar(255), null

Dodavatel

nvarchar(255), null

Číslo dodacího listu

nvarchar(255), null

IP adresa

nvarchar(255), null

Popis

nvarchar(255), null

Množství

nvarchar(255), null

Naposled importováno z AD

date, null

IP adresy

nvarchar(255), null

Naposled přihlášený uživatel (uživatelské jméno)

nvarchar(255), null

MAC adresy

nvarchar(255), null

Počet pevných disků

float, null

Počet logických jader CPU

nvarchar(255), null

Počet fyzických jader CPU

nvarchar(255), null

Součástí domény

nvarchar(255), null

Za software zodpovídá

nvarchar(255), null

Velikost paměti RAM (GB)

float, null

Total storage capacity (GB)

float, null

Nákladové středisko

nvarchar(255), null

Sériové číslo BIOSu

nvarchar(255), null

Druh skříně

nvarchar(255), null

Číslo smlouvy

nvarchar(255), null

Stav smlouvy

nvarchar(255), null

Procesor

nvarchar(255), null

Úhlopříčka

nvarchar(255), null

Grafická karta

nvarchar(255), null

Typ monitoru

nvarchar(255), null

Upozornit předem na konec platnosti (dny)

float, null

Počet procesorů

float, null

Perioda plateb (měsíce)

float, null

Rozlišení obrazovky

nvarchar(255), null

Velikost

nvarchar(255), null

Platnost od

date, null

Platnost do

date, null

Adresa

nvarchar(255), null

Oddělení

nvarchar(255), null

Hostitelský počítač

nvarchar(255), null

IMEI

nvarchar(255), null

MAC adresa

nvarchar(255), null

Pořadí

nvarchar(255), null

Kód organizace

nvarchar(255), null

Název organizace

nvarchar(255), null

Za majetek zodpovídá

int, null

Skupiny uživatelů

nvarchar(255), null

Účet je zablokován

nvarchar(255), null

Azure SQL Databáze

nvarchar(255), null

Azure SQL Server

nvarchar(255), null

Azure účet úložiště

nvarchar(255), null

Budova

nvarchar(255), null

Město

nvarchar(255), null

Barva

nvarchar(255), null

Společnost

nvarchar(255), null

Země

nvarchar(255), null

Rozhraní disku

nvarchar(255), null

Divize

nvarchar(255), null

E-mail

nvarchar(255), null

Fax

nvarchar(255), null

Poschodí

nvarchar(255), null

Skryté vlastnosti

nvarchar(255), null

Telefon domů

nvarchar(255), null

IP telefon

nvarchar(255), null

Klíč od

nvarchar(255), null

Registrační značka

nvarchar(255), null

Typ paměťové karty

nvarchar(255), null

Mobil

nvarchar(255), null

Kancelář

nvarchar(255), null

Pager

nvarchar(255), null

Osobní číslo

nvarchar(255), null

Telefon

nvarchar(255), null

Telefonní číslo

nvarchar(255), null

Poštovní přihrádka

nvarchar(255), null

Funkce

nvarchar(255), null

Skupina prostředků

nvarchar(255), null

Místnost

nvarchar(255), null

Název serverové farmy

nvarchar(255), null

Pracoviště

nvarchar(255), null

Okres

nvarchar(255), null

Ulice

nvarchar(255), null

Odbor

nvarchar(255), null

Pobočka

nvarchar(255), null

Tarif

nvarchar(255), null

STK platné do

date, null

Uživatel

nvarchar(255), null

Uživatelské jméno

nvarchar(255), null

Pracovní místo

nvarchar(255), null

PSČ

nvarchar(255), null

Query.ObjectDeu

Objects in ALVAO Asset Management.
Discarded and removed objects are not displayed.
In addition to the described columns, the view contains the values of the 100 most used properties.
If you want to prioritize the display of some properties, on the WA – Administration – Settings – Advanced page
set the "AM.Query.PreferredProperties" property as the comma-separated list of preferred property identifiers
(see table dbo.tblKind and column intKindId).
Only objects and property values that the user connected to the database has the right to read are displayed.
The view is used to create reports and analyses. Unless stated otherwise, the data is shown in the ALVAO system language.

ColumnTypeDescription

Objekt Id

int, not null

Object identification number (tblNode.intNodeId)

Objektname

nvarchar(255), null

Object name

Objekttyp

nvarchar(max), null

Object kind

Pfad im Objektbaum

nvarchar(1024), null

Path in tree (without the object name). Contains an empty chain for root objects.

Übergeordnete ID

int, null

Id of parent object.

Objekt des Computertypes

nvarchar(4), not null

It indicates whether the given object is of Computer type. The column may have the following values "Yes" and "No" (in Czech).

Erstellt (UTC)

datetime, null

Object creation date and time

Erstellt - Monat beginnt (UTC)

datetime, null

Date of the first day of month when the object was created.

Hinweis

nvarchar(max), null

Notification of unfilled mandatory object properties.

LinkDiagramUrl

nvarchar(2083), null

URL of the object diagram page.

Url

nvarchar(2072), null

URL of the object page.

Name im Netzwerk

nvarchar(255), null

Inventarnummer

nvarchar(255), null

Seriennummer

nvarchar(255), null

Hersteller

nvarchar(255), null

Kaufdatum

date, null

Preis

nvarchar(255), null

Model

nvarchar(255), null

Garantie bis

date, null

Betriebssystem

nvarchar(255), null

Anmerkung

nvarchar(255), null

Bezeichnung

nvarchar(255), null

Lieferant

nvarchar(255), null

Lieferscheinnummer

nvarchar(255), null

IP-Adresse

nvarchar(255), null

Beschreibung

nvarchar(255), null

Menge

nvarchar(255), null

Zuletzt aus AD importiert

date, null

Adresse-IP

nvarchar(255), null

Letzter angemeldeter Benutzer (Benutzername)

nvarchar(255), null

MAC Adressen

nvarchar(255), null

Anzahl Festplatten

float, null

Anzahl der CPU Logikkerne

nvarchar(255), null

Anzahl der CPU Physickerne

nvarchar(255), null

Domäne-Komponente

nvarchar(255), null

Verantwortlich für die Software

nvarchar(255), null

RAM-Speichergröße (GB)

float, null

Total storage capacity (GB)

float, null

Kostenstelle

nvarchar(255), null

BIOS-Seriennummer

nvarchar(255), null

Gehäusetyp

nvarchar(255), null

Vertragsnummer

nvarchar(255), null

Vertragsstatus

nvarchar(255), null

Prozessor

nvarchar(255), null

Diagonale

nvarchar(255), null

Grafikkarte

nvarchar(255), null

Bildschirmtyp

nvarchar(255), null

Auf das Ende der Gültigkeit im Voraus hinweisen (Tage)

float, null

Anzahl Prozessoren

float, null

Zahlungsperiode (Monate)

float, null

Bildschirm-Auflösung

nvarchar(255), null

Größe

nvarchar(255), null

Gültig ab

date, null

Gültig bis

date, null

Adresse

nvarchar(255), null

Abteilung

nvarchar(255), null

Host-Computer

nvarchar(255), null

IMEI

nvarchar(255), null

MAC-Adresse

nvarchar(255), null

Reihenfolge

nvarchar(255), null

Code der Organisation

nvarchar(255), null

Name der Organisation

nvarchar(255), null

Verantwortlich für Vermögensgegenstand

int, null

Benutzergruppen

nvarchar(255), null

Das Konto ist gesperrt

nvarchar(255), null

Azure SQL-Datenbank

nvarchar(255), null

Azure SQL Server

nvarchar(255), null

Azure Speicherkonto

nvarchar(255), null

Gebäude

nvarchar(255), null

Stadt

nvarchar(255), null

Farbe

nvarchar(255), null

Unternehmen

nvarchar(255), null

Land

nvarchar(255), null

Plattenschnittstelle

nvarchar(255), null

Geschäftsbereich

nvarchar(255), null

E-Mail

nvarchar(255), null

Fax

nvarchar(255), null

Etage

nvarchar(255), null

Versteckte Eigenschaften

nvarchar(255), null

Telefon Privat

nvarchar(255), null

IP-Telefon

nvarchar(255), null

Schlüssel von

nvarchar(255), null

Amtliches Kennzeichen

nvarchar(255), null

Speicherkartentyp

nvarchar(255), null

Mobil

nvarchar(255), null

Büro

nvarchar(255), null

Pager

nvarchar(255), null

Personalnummer

nvarchar(255), null

Telefon

nvarchar(255), null

Telefonnummer

nvarchar(255), null

Postfach

nvarchar(255), null

Position

nvarchar(255), null

Azure Ressourcengruppe

nvarchar(255), null

Raum

nvarchar(255), null

Name der Serverfarm

nvarchar(255), null

Arbeitsstelle

nvarchar(255), null

Bezirk

nvarchar(255), null

Straße

nvarchar(255), null

Sparte

nvarchar(255), null

Niederlassung

nvarchar(255), null

Tarif

nvarchar(255), null

Technische Prüfung gültig bis

date, null

Benutzer

nvarchar(255), null

Benutzername

nvarchar(255), null

Arbeitsstation

nvarchar(255), null

PLZ

nvarchar(255), null

Query.ObjectEnu

Objects in ALVAO Asset Management.
Discarded and removed objects are not displayed.
In addition to the described columns, the view contains the values of the 100 most used properties.
If you want to prioritize the display of some properties, on the WA – Administration – Settings – Advanced page
set the "AM.Query.PreferredProperties" property as the comma-separated list of preferred property identifiers
(see table dbo.tblKind and column intKindId).
Only objects and property values that the user connected to the database has the right to read are displayed.
The view is used to create reports and analyses. Unless stated otherwise, the data is shown in the ALVAO system language.

ColumnTypeDescription

Object id

int, not null

Object identification number (tblNode.intNodeId)

Object name

nvarchar(255), null

Object name

Object kind

nvarchar(max), null

Object kind

Path in tree

nvarchar(1024), null

Path in tree (without the object name). Contains an empty chain for root objects.

Parent id

int, null

Id of parent object.

Object of Computer type

nvarchar(3), not null

It indicates whether the given object is of Computer type. The column may have the following values "Yes" and "No" (in Czech).

Created (UTC)

datetime, null

Object creation date and time

Created - Month starting (UTC)

datetime, null

Date of the first day of month when the object was created.

Warning

nvarchar(max), null

Notification of unfilled mandatory object properties.

LinkDiagramUrl

nvarchar(2083), null

URL of the object diagram page.

Url

nvarchar(2072), null

URL of the object page.

Hostname

nvarchar(255), null

Inventory number

nvarchar(255), null

Serial number

nvarchar(255), null

Manufacturer

nvarchar(255), null

Purchase date

date, null

Price

nvarchar(255), null

Model

nvarchar(255), null

Warranty expiration

date, null

Operating system

nvarchar(255), null

Note

nvarchar(255), null

Name

nvarchar(255), null

Vendor

nvarchar(255), null

Packing slip number

nvarchar(255), null

IP address

nvarchar(255), null

Description

nvarchar(255), null

Quantity

nvarchar(255), null

Last imported from AD

date, null

IP addresses

nvarchar(255), null

Last logged-on user (user name)

nvarchar(255), null

MAC addresses

nvarchar(255), null

Number of hard drives

float, null

Number of logical CPU cores

nvarchar(255), null

Number of physical CPU cores

nvarchar(255), null

Part of the domain

nvarchar(255), null

Person responsible for software

nvarchar(255), null

RAM size (GB)

float, null

Total storage capacity (GB)

float, null

Cost center

nvarchar(255), null

BIOS serial number

nvarchar(255), null

Case kind

nvarchar(255), null

Contract number

nvarchar(255), null

Contract status

nvarchar(255), null

CPU

nvarchar(255), null

Diagonal

nvarchar(255), null

Graphic card

nvarchar(255), null

Monitor type

nvarchar(255), null

Notify of the end of validity in advance (days)

float, null

Number of processors

float, null

Payment period (months)

float, null

Screen resolution

nvarchar(255), null

Size

nvarchar(255), null

Valid from

date, null

Valid to

date, null

Address

nvarchar(255), null

Department

nvarchar(255), null

Host computer

nvarchar(255), null

IMEI

nvarchar(255), null

MAC address

nvarchar(255), null

Order

nvarchar(255), null

Organization code

nvarchar(255), null

Organization name

nvarchar(255), null

Person responsible for asset

int, null

User Groups

nvarchar(255), null

Account is disabled

nvarchar(255), null

Azure SQL Database

nvarchar(255), null

Azure SQL Server

nvarchar(255), null

Azure Storage Account

nvarchar(255), null

Building

nvarchar(255), null

City

nvarchar(255), null

Color

nvarchar(255), null

Company

nvarchar(255), null

Country

nvarchar(255), null

Disk interface

nvarchar(255), null

Division

nvarchar(255), null

E-mail

nvarchar(255), null

Fax

nvarchar(255), null

Floor

nvarchar(255), null

Hidden properties

nvarchar(255), null

Home phone

nvarchar(255), null

IP phone

nvarchar(255), null

Key for

nvarchar(255), null

License Plate Number

nvarchar(255), null

Memory card type

nvarchar(255), null

Mobile phone

nvarchar(255), null

Office

nvarchar(255), null

Pager

nvarchar(255), null

Personal number

nvarchar(255), null

Phone

nvarchar(255), null

Phone number

nvarchar(255), null

PO Box

nvarchar(255), null

Position

nvarchar(255), null

Resource group

nvarchar(255), null

Room

nvarchar(255), null

Server farm name

nvarchar(255), null

Site

nvarchar(255), null

State or Province

nvarchar(255), null

Street

nvarchar(255), null

Subdivision

nvarchar(255), null

Subsidiary

nvarchar(255), null

Tariff

nvarchar(255), null

Technical inspection valid until

date, null

User

nvarchar(255), null

User name

nvarchar(255), null

Workstation

nvarchar(255), null

ZIP code

nvarchar(255), null

Query.ObjectLastDetectionCsy

Last detection of a specific computer in ALVAO Asset Management.
Discarded and removed computers are not displayed.
Only those objects and property values are shown that the user connected to the database is authorized to read. The view serves to create reports and analyses.
If not stated otherwise, the data is shown in the ALVAO system language.

ColumnTypeDescription

Id objektu

int, not null

Object identification number

Datum poslední detekce HW (UTC)

datetime, null

Last HW detection date and time

Datum poslední detekce HW - Měsíc od (UTC)

datetime, null

Date of the first day of month when the last HW detection was performed.

Datum poslední detekce SW (UTC)

datetime, null

Last SW detection date and time

Datum poslední detekce SW - Měsíc od (UTC)

datetime, null

Date of the first day of month when the last SW detection was performed.

Stáří poslední detekce HW

nvarchar(16), not null

Last HW detection age. The column may have the following values: "undetected", "1 week", "1 month", "3 months", "1 year" and "older than 1 year" (in Czech).

Stáří poslední detekce SW

nvarchar(16), not null

Last SW detection age. The column may have the following values: "undetected", "1 week", "1 month", "3 months", "1 year" and "older than 1 year" (in Czech).

Metoda poslední detekce HW

nvarchar(64), null

Last HW detection method

Metoda poslední detekce SW

nvarchar(64), null

Last SW detection method

Query.ObjectLastDetectionDeu

Last detection of a specific computer in ALVAO Asset Management.
Discarded and removed computers are not displayed.
Only those objects and property values are shown that the user connected to the database is authorized to read. The view serves to create reports and analyses.
If not stated otherwise, the data is shown in the ALVAO system language.

ColumnTypeDescription

Objekt Id

int, not null

Object identification number

Letztes HW-Detektionsdatum (UTC)

datetime, null

Last HW detection date and time

Letztes HW-Detektionsdatum - Monat beginnt (UTC)

datetime, null

Date of the first day of month when the last HW detection was performed.

Letztes SW-Detektionsdatum (UTC)

datetime, null

Last SW detection date and time

Letztes SW-Detektionsdatum - Monat beginnt (UTC)

datetime, null

Date of the first day of month when the last SW detection was performed.

Alter der letzten HW-Detektion

nvarchar(16), not null

Last HW detection age. The column may have the following values: "undetected", "1 week", "1 month", "3 months", "1 year" and "older than 1 year" (in Czech).

Letztes SW-Erkennungsalter

nvarchar(16), not null

Last SW detection age. The column may have the following values: "undetected", "1 week", "1 month", "3 months", "1 year" and "older than 1 year" (in Czech).

Letzte HW-Erkennungsmethode

nvarchar(64), null

Last HW detection method

Letzte SW-Erkennungsmethode

nvarchar(64), null

Last SW detection method

Query.ObjectLastDetectionEnu

Last detection of a specific computer in ALVAO Asset Management.
Discarded and removed computers are not displayed.
Only those objects and property values are shown that the user connected to the database is authorized to read. The view serves to create reports and analyses.
If not stated otherwise, the data is shown in the ALVAO system language.

ColumnTypeDescription

Object id

int, not null

Object identification number

Last HW detection date (UTC)

datetime, null

Last HW detection date and time

Last HW detection date - Month starting (UTC)

datetime, null

Date of the first day of month when the last HW detection was performed.

Last SW detection date (UTC)

datetime, null

Last SW detection date and time

Last SW detection date - Month starting (UTC)

datetime, null

Date of the first day of month when the last SW detection was performed.

Last HW detection age

nvarchar(17), not null

Last HW detection age. The column may have the following values: "undetected", "1 week", "1 month", "3 months", "1 year" and "older than 1 year" (in Czech).

Last SW detection age

nvarchar(17), not null

Last SW detection age. The column may have the following values: "undetected", "1 week", "1 month", "3 months", "1 year" and "older than 1 year" (in Czech).

Last HW detection method

nvarchar(64), null

Last HW detection method

Last SW detection method

nvarchar(64), null

Last SW detection method

Query.ObjectLogCsy

Object log in ALVAO Asset Management, see WebApp - Object - Log tab.
The records of discarded or deleted objects do not appear.
Only the objects and property values are shown that the user connected to the database is authorized to read.
The view is used to create reports and analyses. If not stated otherwise, the data is shown in the ALVAO system language.

ColumnTypeDescription

Id objektu

int, null

Object identification number associated to the record.

Nadpis

nvarchar(max), null

Record title

Zpráva

nvarchar(max), null

Record text

Datum záznamu (UTC)

datetime, null

Record creation date and time

Datum záznamu - Měsíc od (UTC)

datetime, null

Date of the first day of month when the record was created.

Datum záznamu - Týden od (UTC)

datetime, null

Date of the first day of week when the record was created.

Datum záznamu - Rok

int, null

Year of record creation

Datum záznamu - Měsíc

int, null

Month of record creation.

Uživatel

nvarchar(255), null

User name of a person who created the record.

Druh záznamu

nvarchar(max), null

Record kind

Query.ObjectLogDeu

Object log in ALVAO Asset Management, see WebApp - Object - Log tab.
The records of discarded or deleted objects do not appear.
Only the objects and property values are shown that the user connected to the database is authorized to read.
The view is used to create reports and analyses. If not stated otherwise, the data is shown in the ALVAO system language.

ColumnTypeDescription

Objekt Id

int, null

Object identification number associated to the record.

Titel

nvarchar(max), null

Record title

Nachricht

nvarchar(max), null

Record text

Aufnahmedatum (UTC)

datetime, null

Record creation date and time

Aufnahmedatum - Monat beginnt (UTC)

datetime, null

Date of the first day of month when the record was created.

Datum des Eintrags - Woche seit (UTC)

datetime, null

Date of the first day of week when the record was created.

Datum des Eintrags - Jahr

int, null

Year of record creation

Datum des Eintrags - Monat

int, null

Month of record creation.

Benutzer

nvarchar(255), null

User name of a person who created the record.

Aufzeichnungstyp

nvarchar(max), null

Record kind

Query.ObjectLogEnu

Object log in ALVAO Asset Management, see WebApp - Object - Log tab.
The records of discarded or deleted objects do not appear.
Only the objects and property values are shown that the user connected to the database is authorized to read.
The view is used to create reports and analyses. If not stated otherwise, the data is shown in the ALVAO system language.

ColumnTypeDescription

Object id

int, null

Object identification number associated to the record.

Title

nvarchar(max), null

Record title

Message

nvarchar(max), null

Record text

Record date (UTC)

datetime, null

Record creation date and time

Record date - Month starting (UTC)

datetime, null

Date of the first day of month when the record was created.

Record date - Week starting (UTC)

datetime, null

Date of the first day of week when the record was created.

Record date - Year

int, null

Year of record creation

Record date - Month

int, null

Month of record creation.

User

nvarchar(255), null

User name of a person who created the record.

Record kind

nvarchar(max), null

Record kind

Query.ObjectPersonRead

Permission of users to read objects registered in ALVAO. Each row represents one user who has the read permission for the selected object.
The view is used to create reports and analyses.

ColumnTypeDescription

PersonId

int, null

Identification number of the person, see Query.PersonEnu.id

ObjectId

int, null

The object ID number, see Query.ObjectEnu.[Object id]

Query.OrganizationCsy

Organization in ALVAO Service Desk.
Only the organization of the user who is connected to the database is displayed. Contact administrators or Contact readers group members can see all organizations. No deleted organizations are displayed.
The view is used to create reports and analyses.

ColumnTypeDescription

id

int, not null

The organization ID number from dbo.tAccount table.

Název

nvarchar(255), not null

Organization name

IČO

nvarchar(20), null

Company ID - company identification number

DIČ

nvarchar(20), null

VAT ID - value added tax identification number

Telefon

nvarchar(30), null

Organization telephone

Telefon 2

nvarchar(30), null

Organization telephone 2

E-mail

nvarchar(50), null

Organization e-mail

E-mail 2

nvarchar(50), null

Organization e-mail 2

Fax

nvarchar(30), null

Organization fax

Web

nvarchar(50), null

Organization website

Adresa

nvarchar(max), null

Organization address

Adresa 2

nvarchar(max), null

Organization address 2

Url

nvarchar(2080), null

URL of the organization page

AdminUrl

nvarchar(2082), null

URL of the organization page in the administration

Query.OrganizationDeu

Organization in ALVAO Service Desk.
Only the organization of the user who is connected to the database is displayed. Contact administrators or Contact readers group members can see all organizations. No deleted organizations are displayed.
The view is used to create reports and analyses.

ColumnTypeDescription

id

int, not null

The organization ID number from dbo.tAccount table.

Bezeichnung

nvarchar(255), not null

Organization name

IdNr.

nvarchar(20), null

Company ID - company identification number

UID-Nr.

nvarchar(20), null

VAT ID - value added tax identification number

Telefon

nvarchar(30), null

Organization telephone

Telefon 2

nvarchar(30), null

Organization telephone 2

E-Mail

nvarchar(50), null

Organization e-mail

E-Mail 2

nvarchar(50), null

Organization e-mail 2

Fax

nvarchar(30), null

Organization fax

Web

nvarchar(50), null

Organization website

Adresse

nvarchar(max), null

Organization address

Adresse 2

nvarchar(max), null

Organization address 2

Url

nvarchar(2080), null

URL of the organization page

AdminUrl

nvarchar(2082), null

URL of the organization page in the administration

Query.OrganizationEnu

Organization in ALVAO Service Desk.
Only the organization of the user who is connected to the database is displayed. Contact administrators or Contact readers group members can see all organizations. No deleted organizations are displayed.
The view is used to create reports and analyses.

ColumnTypeDescription

id

int, not null

The organization ID number from dbo.tAccount table.

Name

nvarchar(255), not null

Organization name

Company ID

nvarchar(20), null

Company ID - company identification number

VAT ID

nvarchar(20), null

VAT ID - value added tax identification number

Phone

nvarchar(30), null

Organization telephone

Phone 2

nvarchar(30), null

Organization telephone 2

E-mail

nvarchar(50), null

Organization e-mail

E-mail 2

nvarchar(50), null

Organization e-mail 2

Fax

nvarchar(30), null

Organization fax

Website

nvarchar(50), null

Organization website

Address

nvarchar(max), null

Organization address

Address 2

nvarchar(max), null

Organization address 2

Url

nvarchar(2080), null

URL of the organization page

AdminUrl

nvarchar(2082), null

URL of the organization page in the administration

Query.PersonCsy

People registered in ALVAO.
Only people from the same organization as the user connected to the database are displayed. Contact administrators or Contact readers group members can see all users.
The view is used to create reports and analyses.

ColumnTypeDescription

id

int, not null

Identification number of the person - see dbo.tPerson.iPersonId.

Jméno a příjmení

nvarchar(255), null

Name and Surname

Mobil

nvarchar(255), null

Mobile phone

E-mail

nvarchar(255), null

E-mail

E-mail 2

nvarchar(255), null

E-mail 2

Telefon do zaměstnání

nvarchar(255), null

Work phone

Telefon do zaměstnání 2

nvarchar(255), null

Work phone 2

Další kontakty

nvarchar(max), null

Other contacts

Oddělení

nvarchar(255), null

Department

Funkce

nvarchar(255), null

Position

Kancelář

nvarchar(255), null

Office

Osobní číslo

nvarchar(255), null

Personal number

Preferovaný jazyk

nvarchar(255), null

The name of the preferred language of the person

Časové pásmo

nvarchar(64), null

The name of the time zone

OrganizationId

int, null

The person’s organization ID number - see Query.Organization{locale}.id.

ManagerPersonId

int, null

The manager ID number - see Query.Person{locale}.id.

DeputyPersonId

int, null

The ID number of the person’s substitute - see Query.Person{locale}.id.

Zablokován

bit, not null

Blocked user

Sdílený

bit, not null

Shared account

Skrytý v nabídkách

bit, not null

User hidden in menus

Odstraněný

datetime, null

Deleted user

AdminUrl

nvarchar(2074), null

URL of the user page in the administration

Url

nvarchar(2079), null

URL of the user page

Query.PersonDeu

People registered in ALVAO.
Only people from the same organization as the user connected to the database are displayed. Contact administrators or Contact readers group members can see all users.
The view is used to create reports and analyses.

ColumnTypeDescription

id

int, not null

Identification number of the person - see dbo.tPerson.iPersonId.

Vorname und Name

nvarchar(255), null

Name and Surname

Mobil

nvarchar(255), null

Mobile phone

E-Mail

nvarchar(255), null

E-mail

E-Mail 2

nvarchar(255), null

E-mail 2

Telefon Arbeitsort

nvarchar(255), null

Work phone

Telefon Arbeitsort 2

nvarchar(255), null

Work phone 2

Andere Kontakte

nvarchar(max), null

Other contacts

Abteilung

nvarchar(255), null

Department

Position

nvarchar(255), null

Position

Büro

nvarchar(255), null

Office

Personalnummer

nvarchar(255), null

Personal number

Bevorzugte Sprache

nvarchar(255), null

The name of the preferred language of the person

Zeitzone

nvarchar(64), null

The name of the time zone

OrganizationId

int, null

The person’s organization ID number - see Query.Organization{locale}.id.

ManagerPersonId

int, null

The manager ID number - see Query.Person{locale}.id.

DeputyPersonId

int, null

The ID number of the person’s substitute - see Query.Person{locale}.id.

Blockiert

bit, not null

Blocked user

Mitgeteilt

bit, not null

Shared account

Verdeckt im Angebot

bit, not null

User hidden in menus

Entfernt

datetime, null

Deleted user

AdminUrl

nvarchar(2074), null

URL of the user page in the administration

Url

nvarchar(2079), null

URL of the user page

Query.PersonEnu

People registered in ALVAO.
Only people from the same organization as the user connected to the database are displayed. Contact administrators or Contact readers group members can see all users.
The view is used to create reports and analyses.

ColumnTypeDescription

id

int, not null

Identification number of the person - see dbo.tPerson.iPersonId.

Name and Surname

nvarchar(255), null

Name and Surname

Mobile phone

nvarchar(255), null

Mobile phone

E-mail

nvarchar(255), null

E-mail

E-mail 2

nvarchar(255), null

E-mail 2

Work phone

nvarchar(255), null

Work phone

Work phone 2

nvarchar(255), null

Work phone 2

Other contacts

nvarchar(max), null

Other contacts

Department

nvarchar(255), null

Department

Position

nvarchar(255), null

Position

Office

nvarchar(255), null

Office

Personal number

nvarchar(255), null

Personal number

Preferred language

nvarchar(255), null

The name of the preferred language of the person

Time zone

nvarchar(64), null

The name of the time zone

OrganizationId

int, null

The person’s organization ID number - see Query.Organization{locale}.id.

ManagerPersonId

int, null

The manager ID number - see Query.Person{locale}.id.

DeputyPersonId

int, null

The ID number of the person’s substitute - see Query.Person{locale}.id.

Disabled

bit, not null

Blocked user

Shared

bit, not null

Shared account

Hidden in menus

bit, not null

User hidden in menus

Deleted

datetime, null

Deleted user

AdminUrl

nvarchar(2074), null

URL of the user page in the administration

Url

nvarchar(2079), null

URL of the user page

Query.ProcessCsy

Processes in ALVAO Service Desk.
Only processes used in services where the user has been connected to the database by a member of the solver team or by a reader are displayed. No deleted processed are displayed.
The view is used to create reports and analyses.

ColumnTypeDescription

id

int, not null

Identification number of the process - see dbo.TicketType.id.

Název

nvarchar(255), not null

Process name

Popis

nvarchar(max), null

Description of the process

AdminUrl

nvarchar(2077), null

URL of the process page in the administration

Query.ProcessDeu

Processes in ALVAO Service Desk.
Only processes used in services where the user has been connected to the database by a member of the solver team or by a reader are displayed. No deleted processed are displayed.
The view is used to create reports and analyses.

ColumnTypeDescription

id

int, not null

Identification number of the process - see dbo.TicketType.id.

Bezeichnung

nvarchar(255), not null

Process name

Beschreibung

nvarchar(max), null

Description of the process

AdminUrl

nvarchar(2077), null

URL of the process page in the administration

Query.ProcessEnu

Processes in ALVAO Service Desk.
Only processes used in services where the user has been connected to the database by a member of the solver team or by a reader are displayed. No deleted processed are displayed.
The view is used to create reports and analyses.

ColumnTypeDescription

id

int, not null

Identification number of the process - see dbo.TicketType.id.

Name

nvarchar(255), not null

Process name

Description

nvarchar(max), null

Description of the process

AdminUrl

nvarchar(2077), null

URL of the process page in the administration

Query.Request2Csy

Tickets in ALVAO Service Desk.
Only tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. No deleted tickets are displayed.
The view is used to create reports and analyses.

ColumnTypeDescription

id

int, not null

Identification number of the ticket - see dbo.tHdTicket.iHdTicketId.

Značka požadavku

nvarchar(255), null

Ticket identification mark

Název požadavku

nvarchar(1024), null

Ticket name

Značka a název požadavku

nvarchar(1282), null

Tag and name of the ticket, e.g. "T123456COMPANY Request for a new printer".

Interní cíl

nvarchar(255), null

Name of the internal target

Interní cíl - Termín (UTC)

datetime, null

The internal target due date

Vytvořeno (UTC)

datetime, null

Ticket creation date and time

Způsob podání požadavku

nvarchar(255), null

Ticket submission method, e.g., e-mail, phone, form.

Hrubý stav

nvarchar(10), not null

Name of general status (Open, Resolved, Closed, Deleted).

URL požadavku

nvarchar(2072), null

Ticket URL in ALVAO WebApp

Pozastavení SLA (hodiny v provozní době)

float, null

Number of hours in the operating hours of SLA pause being in progress (due to waiting for requester or ticket status).

Pozastaveno SLA (hodiny v provozní době)

float, null

Total SLA pause time within a specific requirement in hours during the operating hours (including the currently running SLA pause).

Čekáno na žadatele (hodiny v provozní době)

float, null

Total waiting time for requesters during the whole solution of a ticket, in hours, during the operating hours of the service.

Čekání na žadatele (hodiny v provozní době)

float, null

The number of hours in the operating hours of waiting for requester in progress.

První reakce (UTC)

datetime, null

Date and time of the first response

První reakce - Termín (UTC)

datetime, null

Date and time of the first response deadline according to SLA. If SLA is paused or the deadline is not determined, the value is null.

První reakce - Zbývá do termínu (hodiny v provozní době)

float, null

Time in hours representing the time until the first response deadline in the operating hours. In case that the date of the first response is not guaranteed or the first response has already been performed, the value is null.

První reakce

nvarchar(9), null

The "fulfilled" value if the first response deadline was fulfilled according to SLA. The "breached" value if the first response deadline was not fulfilled. The "null" value if the first response deadline is not guaranteed or if the first response has not been performed and the deadline according to SLA is not exceeded yet.

První reakce - Doba do reakce (hodiny v provozní době)

float, null

The number of hours in the operating hours from ticket creation to the first response. If the first response was not met, the value is null.

První reakce - Překročení termínu (hodiny v provozní době)

float, null

By how many hours during the operating hours was the first response deadline guaranteed by SLA exceeded.

První reakce - Splnění termínu (hodiny v provozní době)

float, null

How many hours earlier during the operating hours was the first reaction met than as required by the SLA limit.

FirstReactionRequestLogRecordId

int, null

Event ID that completed the first response see Query.RequestLogRecord{locale}.id.

FirstReactionTriggeredByRequestLogRecordId

int, null

Event ID that triggered the event to complete the first response see Query.RequestLogRecord{locale}.id.

Vyřešeno (UTC)

datetime, null

Date and time of ticket solution.

Vyřešení - Termín (UTC)

datetime, null

Date and time of the solution deadline. If SLA is paused or the deadline is not determined, the value is null.

Vyřešení - Zbývá do termínu (hodiny v provozní době)

float, null

Time in hours representing the time until the ticket resolution deadline in the operating hours. In case that the date for ticket resolution is not guaranteed or the ticket has already been resolved, the value is null.

Vyřešení

nvarchar(9), null

The "fulfilled" value if the tickets resolution deadline was fulfilled according to SLA. The "breached" value if the solution deadline was not fulfilled. The "null" value if the ticket resolution deadline is not guaranteed or if the ticket has not been resolved and the resolution deadline according to SLA is not exceeded yet.

Vyřešení - Doba do vyřešení (hodiny v provozní době)

float, null

Hours from the creation to the resolution of the ticket during the operating hours of the service.

Vyřešení - Překročení termínu podle SLA (hodiny v provozní době)

float, null

By how many hours during the operating hours was the deadline for solving the ticket as per SLA exceeded.

Vyřešení - Splnění termínu podle SLA (hodiny v provozní době)

float, null

How many hours earlier during the operating hours the ticket was resolved than the SLA limit.

Vyřešení - Překročení termínu (hodiny v provozní době)

float, null

By how many hours during the operating hours was the deadline for resolution of the ticket exceeded (Ticket - Due date).

Vyřešení - Splnění termínu (hodiny v provozní době)

float, null

How many hours earlier during the operating hours the ticket was resolved than the value listed in the Ticket - Due date field.

ResolutionRequestLogRecordId

int, null

Last resolved ticket event ID, see Query.requestLogRecord{locale}.id.

Uzavřeno (UTC)

datetime, null

Date and time of ticket closing.

RootRequestId

int, null

The highest parent ticket ID number, see Query.Request2{locale}.id.

RequesterPersonId

int, not null

The ID number of the ticket requester - see Query.Person{locale}.id.

SolverPersonId

int, null

The current ticket solver ID number - see Query.Person{locale}.id.

Řešitelská skupina

nvarchar(255), null

The name of the solver group to which the ticket is assigned.

RequestedForPersonId

int, not null

ID number of the user for who the ticket was created - see Query.Person{locale}.id.

SectionId

int, not null

The service ID number - see Query.Section{locale}.id.

SlaId

int, not null

The SLA ID number - see Query.Sla{locale}.id.

RelatedOrganizationId

int, null

The related organization of the ticket ID number (related organization item), see Query.Organization{locale}.id.

RequestStateId

int, not null

The current ticket status ID number - see Query.RequestState{locale}.id.

StartRequestLogRecordId

int, null

The ID number of the ticket creating event - see Query.RequestLogRecord{locale}.id.

Priorita

nvarchar(max), null

Priority name

Dopad

nvarchar(max), null

Impact name

Naléhavost

nvarchar(max), null

Urgency name

Náklady (hodiny)

float, null

Total recorded time (Work + Travel time), in hours.

Náklady - Práce (hodiny)

float, null

Number of hours worked in relation to the ticket.

Náklady - Cesta (hodiny)

float, null

Number of hours spent on the way in respect of the ticket.

Náklady - Cesta (km)

float, null

Number of kilometers reported in relation to the ticket.

Poznámka

nvarchar(max), null

Ticket notes

Skupina

nvarchar(255), null

Group

Číslo zařízení

nvarchar(255), null

Device number

Dotazník spokojenosti - Celková spokojenost

nvarchar(max), null

Requester’s overall satisfaction

Dotazník spokojenosti - Rychlost řešení

nvarchar(max), null

The speed of ticket solution from the requester's perspective

Dotazník spokojenosti - Profesionalita

nvarchar(max), null

Professionalism of the solving team from the requester's point of view

Dotazník spokojenosti - Odbornost

nvarchar(max), null

Expertise of the solving team from the requester's point of view

Dotazník spokojenosti - Komentáře a poznámky

nvarchar(max), null

Comments and notes from the requester on the satisfaction survey

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Query.Request2Deu

Tickets in ALVAO Service Desk.
Only tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. No deleted tickets are displayed.
The view is used to create reports and analyses.

ColumnTypeDescription

id

int, not null

Identification number of the ticket - see dbo.tHdTicket.iHdTicketId.

Kennung der Anfrage

nvarchar(255), null

Ticket identification mark

Name der Anfrage

nvarchar(1024), null

Ticket name

Zeichen und Name der Anfrage

nvarchar(1282), null

Tag and name of the ticket, e.g. "T123456COMPANY Request for a new printer".

Internes Ziel

nvarchar(255), null

Name of the internal target

Internes Ziel - Termin (UTC)

datetime, null

The internal target due date

Erstellt (UTC)

datetime, null

Ticket creation date and time

Methode der Anfragestellung

nvarchar(255), null

Ticket submission method, e.g., e-mail, phone, form.

Gesamtstatus

nvarchar(13), not null

Name of general status (Open, Resolved, Closed, Deleted).

URL der Anfrage

nvarchar(2072), null

Ticket URL in ALVAO WebApp

SLA-Aussetzung (Stunden innerhalb der Betriebszeit)

float, null

Number of hours in the operating hours of SLA pause being in progress (due to waiting for requester or ticket status).

SLA ausgesetzt (Stunden innerhalb der Betriebszeit)

float, null

Total SLA pause time within a specific requirement in hours during the operating hours (including the currently running SLA pause).

Gewartet auf den Anfragesteller (Stunden innerhalb der Betriebszeit)

float, null

Total waiting time for requesters during the whole solution of a ticket, in hours, during the operating hours of the service.

Warten auf den Anfragesteller (Stunden innerhalb der Betriebszeit)

float, null

The number of hours in the operating hours of waiting for requester in progress.

Erste Reaktion (UTC)

datetime, null

Date and time of the first response

Erste Reaktion - Termin (UTC)

datetime, null

Date and time of the first response deadline according to SLA. If SLA is paused or the deadline is not determined, the value is null.

Erste Reaktion - Zeit bis zum Termin (Stunden innerhalb der Betriebszeit)

float, null

Time in hours representing the time until the first response deadline in the operating hours. In case that the date of the first response is not guaranteed or the first response has already been performed, the value is null.

Erste Reaktion

nvarchar(13), null

The "fulfilled" value if the first response deadline was fulfilled according to SLA. The "breached" value if the first response deadline was not fulfilled. The "null" value if the first response deadline is not guaranteed or if the first response has not been performed and the deadline according to SLA is not exceeded yet.

Erste Reaktion - Zeit bis zur Reaktion (Stunden innerhalb der Betriebszeit)

float, null

The number of hours in the operating hours from ticket creation to the first response. If the first response was not met, the value is null.

Erste Reaktion - Überschreitung des Termins (Stunden innerhalb der Betriebszeit)

float, null

By how many hours during the operating hours was the first response deadline guaranteed by SLA exceeded.

Erste Reaktion - Einhaltung des Termins (Stunden innerhalb der Betriebszeit)

float, null

How many hours earlier during the operating hours was the first reaction met than as required by the SLA limit.

FirstReactionRequestLogRecordId

int, null

Event ID that completed the first response see Query.RequestLogRecord{locale}.id.

FirstReactionTriggeredByRequestLogRecordId

int, null

Event ID that triggered the event to complete the first response see Query.RequestLogRecord{locale}.id.

Gelöst (UTC)

datetime, null

Date and time of ticket solution.

Erledigung - Termin (UTC)

datetime, null

Date and time of the solution deadline. If SLA is paused or the deadline is not determined, the value is null.

Bearbeitet - Zeit bis zum Termin (Stunden innerhalb der Betriebszeit)

float, null

Time in hours representing the time until the ticket resolution deadline in the operating hours. In case that the date for ticket resolution is not guaranteed or the ticket has already been resolved, the value is null.

Lösung

nvarchar(13), null

The "fulfilled" value if the tickets resolution deadline was fulfilled according to SLA. The "breached" value if the solution deadline was not fulfilled. The "null" value if the ticket resolution deadline is not guaranteed or if the ticket has not been resolved and the resolution deadline according to SLA is not exceeded yet.

Bearbeitet - Zeit bis zur Bearbeitung (Stunden innerhalb der Betriebszeit)

float, null

Hours from the creation to the resolution of the ticket during the operating hours of the service.

Bearbeitet - Überschreitung des Termins gem. SLA (Stunden innerhalb der Betriebszeit)

float, null

By how many hours during the operating hours was the deadline for solving the ticket as per SLA exceeded.

Bearbeitet - Einhaltung des Termins gem. SLA (Stunden innerhalb der Betriebszeit)

float, null

How many hours earlier during the operating hours the ticket was resolved than the SLA limit.

Erledigung - Überschreitung des Termins (Stunden innerhalb der Betriebszeit)

float, null

By how many hours during the operating hours was the deadline for resolution of the ticket exceeded (Ticket - Due date).

Erledigung - Einhaltung des Termins (Stunden innerhalb der Betriebszeit)

float, null

How many hours earlier during the operating hours the ticket was resolved than the value listed in the Ticket - Due date field.

ResolutionRequestLogRecordId

int, null

Last resolved ticket event ID, see Query.requestLogRecord{locale}.id.

Geschlossen (UTC)

datetime, null

Date and time of ticket closing.

RootRequestId

int, null

The highest parent ticket ID number, see Query.Request2{locale}.id.

RequesterPersonId

int, not null

The ID number of the ticket requester - see Query.Person{locale}.id.

SolverPersonId

int, null

The current ticket solver ID number - see Query.Person{locale}.id.

Bearbeitergruppe

nvarchar(255), null

The name of the solver group to which the ticket is assigned.

RequestedForPersonId

int, not null

ID number of the user for who the ticket was created - see Query.Person{locale}.id.

SectionId

int, not null

The service ID number - see Query.Section{locale}.id.

SlaId

int, not null

The SLA ID number - see Query.Sla{locale}.id.

RelatedOrganizationId

int, null

The related organization of the ticket ID number (related organization item), see Query.Organization{locale}.id.

RequestStateId

int, not null

The current ticket status ID number - see Query.RequestState{locale}.id.

StartRequestLogRecordId

int, null

The ID number of the ticket creating event - see Query.RequestLogRecord{locale}.id.

Priorität

nvarchar(max), null

Priority name

Auswirkung

nvarchar(max), null

Impact name

Dringlichkeit

nvarchar(max), null

Urgency name

Aufwand (in Stunden)

float, null

Total recorded time (Work + Travel time), in hours.

Arbeitsaufwand (in Stunden)

float, null

Number of hours worked in relation to the ticket.

Aufwand - Reisezeit (in Stunden)

float, null

Number of hours spent on the way in respect of the ticket.

Aufwand - Reisezeit (in km)

float, null

Number of kilometers reported in relation to the ticket.

Anmerkung

nvarchar(max), null

Ticket notes

Gruppe

nvarchar(255), null

Group

Gerätenummer

nvarchar(255), null

Device number

Zufriedenheitsbefragung - Gesamtzufriedenheit

nvarchar(max), null

Requester’s overall satisfaction

Zufriedenheitsbefragung - Schnelligkeit der Bearbeitung

nvarchar(max), null

The speed of ticket solution from the requester's perspective

Zufriedenheitsbefragung - Professionalität

nvarchar(max), null

Professionalism of the solving team from the requester's point of view

Zufriedenheitsbefragung - Fachkompetenz

nvarchar(max), null

Expertise of the solving team from the requester's point of view

Zufriedenheitsbefragung - Kommentare und Anmerkungen

nvarchar(max), null

Comments and notes from the requester on the satisfaction survey

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Query.Request2Enu

Tickets in ALVAO Service Desk.
Only tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. No deleted tickets are displayed.
The view is used to create reports and analyses.

ColumnTypeDescription

id

int, not null

Identification number of the ticket - see dbo.tHdTicket.iHdTicketId.

Request tag

nvarchar(255), null

Ticket identification mark

Request name

nvarchar(1024), null

Ticket name

Request tag and title

nvarchar(1282), null

Tag and name of the ticket, e.g. "T123456COMPANY Request for a new printer".

Internal target

nvarchar(255), null

Name of the internal target

Internal target - Due date (UTC)

datetime, null

The internal target due date

Created (UTC)

datetime, null

Ticket creation date and time

Request submission method

nvarchar(255), null

Ticket submission method, e.g., e-mail, phone, form.

Overall status

nvarchar(8), not null

Name of general status (Open, Resolved, Closed, Deleted).

Request URL

nvarchar(2072), null

Ticket URL in ALVAO WebApp

SLA pause (hours during the operation hours)

float, null

Number of hours in the operating hours of SLA pause being in progress (due to waiting for requester or ticket status).

SLA paused (hours during the operation hours)

float, null

Total SLA pause time within a specific requirement in hours during the operating hours (including the currently running SLA pause).

Waited for requester (hours during the operation hours)

float, null

Total waiting time for requesters during the whole solution of a ticket, in hours, during the operating hours of the service.

Waiting for requester (hours during the operation hours)

float, null

The number of hours in the operating hours of waiting for requester in progress.

First response (UTC)

datetime, null

Date and time of the first response

First response - Due date (UTC)

datetime, null

Date and time of the first response deadline according to SLA. If SLA is paused or the deadline is not determined, the value is null.

First response - Remaining (hours during the operation hours)

float, null

Time in hours representing the time until the first response deadline in the operating hours. In case that the date of the first response is not guaranteed or the first response has already been performed, the value is null.

First response

nvarchar(13), null

The "fulfilled" value if the first response deadline was fulfilled according to SLA. The "breached" value if the first response deadline was not fulfilled. The "null" value if the first response deadline is not guaranteed or if the first response has not been performed and the deadline according to SLA is not exceeded yet.

First response - Time to response (hours during the operation hours)

float, null

The number of hours in the operating hours from ticket creation to the first response. If the first response was not met, the value is null.

First response - Exceeding of due date (hours during the operation hours)

float, null

By how many hours during the operating hours was the first response deadline guaranteed by SLA exceeded.

First response - Meeting of due date (hours during the operation hours)

float, null

How many hours earlier during the operating hours was the first reaction met than as required by the SLA limit.

FirstReactionRequestLogRecordId

int, null

Event ID that completed the first response see Query.RequestLogRecord{locale}.id.

FirstReactionTriggeredByRequestLogRecordId

int, null

Event ID that triggered the event to complete the first response see Query.RequestLogRecord{locale}.id.

Resolved (UTC)

datetime, null

Date and time of ticket solution.

Resolution - Due date (UTC)

datetime, null

Date and time of the solution deadline. If SLA is paused or the deadline is not determined, the value is null.

Resolution - Remaining (hours during the operation hours)

float, null

Time in hours representing the time until the ticket resolution deadline in the operating hours. In case that the date for ticket resolution is not guaranteed or the ticket has already been resolved, the value is null.

Resolution

nvarchar(13), null

The "fulfilled" value if the tickets resolution deadline was fulfilled according to SLA. The "breached" value if the solution deadline was not fulfilled. The "null" value if the ticket resolution deadline is not guaranteed or if the ticket has not been resolved and the resolution deadline according to SLA is not exceeded yet.

Resolution - Time to resolve (hours during the operation hours)

float, null

Hours from the creation to the resolution of the ticket during the operating hours of the service.

Resolution - SLA breached by (hours during the operation hours)

float, null

By how many hours during the operating hours was the deadline for solving the ticket as per SLA exceeded.

Resolution - SLA met by (hours during the operation hours)

float, null

How many hours earlier during the operating hours the ticket was resolved than the SLA limit.

Resolution - Exceeding of due date (hours during the operation hours)

float, null

By how many hours during the operating hours was the deadline for resolution of the ticket exceeded (Ticket - Due date).

Resolution - Meeting of due date (hours during the operation hours)

float, null

How many hours earlier during the operating hours the ticket was resolved than the value listed in the Ticket - Due date field.

ResolutionRequestLogRecordId

int, null

Last resolved ticket event ID, see Query.requestLogRecord{locale}.id.

Closed (UTC)

datetime, null

Date and time of ticket closing.

RootRequestId

int, null

The highest parent ticket ID number, see Query.Request2{locale}.id.

RequesterPersonId

int, not null

The ID number of the ticket requester - see Query.Person{locale}.id.

SolverPersonId

int, null

The current ticket solver ID number - see Query.Person{locale}.id.

Solver group

nvarchar(255), null

The name of the solver group to which the ticket is assigned.

RequestedForPersonId

int, not null

ID number of the user for who the ticket was created - see Query.Person{locale}.id.

SectionId

int, not null

The service ID number - see Query.Section{locale}.id.

SlaId

int, not null

The SLA ID number - see Query.Sla{locale}.id.

RelatedOrganizationId

int, null

The related organization of the ticket ID number (related organization item), see Query.Organization{locale}.id.

RequestStateId

int, not null

The current ticket status ID number - see Query.RequestState{locale}.id.

StartRequestLogRecordId

int, null

The ID number of the ticket creating event - see Query.RequestLogRecord{locale}.id.

Priority

nvarchar(max), null

Priority name

Impact

nvarchar(max), null

Impact name

Urgency

nvarchar(max), null

Urgency name

Cost (hours)

float, null

Total recorded time (Work + Travel time), in hours.

Cost - Work (hours)

float, null

Number of hours worked in relation to the ticket.

Cost - Time traveled (hours)

float, null

Number of hours spent on the way in respect of the ticket.

Cost - Distance traveled (km)

float, null

Number of kilometers reported in relation to the ticket.

Note

nvarchar(max), null

Ticket notes

Group

nvarchar(255), null

Group

Device number

nvarchar(255), null

Device number

Satisfaction survey - General satisfaction

nvarchar(max), null

Requester’s overall satisfaction

Satisfaction survey - Resolution speed

nvarchar(max), null

The speed of ticket solution from the requester's perspective

Satisfaction survey - Professionalism

nvarchar(max), null

Professionalism of the solving team from the requester's point of view

Satisfaction survey - Expertise

nvarchar(max), null

Expertise of the solving team from the requester's point of view

Satisfaction survey - Comments and remarks

nvarchar(max), null

Comments and notes from the requester on the satisfaction survey

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Query.RequestChangeCsy

Progress of tickets solving in ALVAO Service Desk. Each line corresponds to a change in status, service, SLA, or solver. Only records for tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Číslo požadavku

int, not null

The ticket identification number.

Id služby

int, null

Service ID (tHdSection.iHdSectionId).

Id stavu

int, null

Status ID (TicketState.id).

Id řešitele

int, null

Solver ID (tPerson.iPersonId).

Řešitelská skupina

nvarchar(255), null

The name of the solver group to which the ticket is assigned.

Id SLA

int, null

SLA ID (tSla.iSlaId).

Začátek (UTC)

datetime, null

Date of change performance.

Konec (UTC)

datetime, null

Change end date = the date the next change was made.

Doba trvání (hodiny)

float, null

Number of hours the change took.

Doba trvání v provozní době (hodiny)

float, not null

Number of hours the change took. It is calculated in the operating hours of the SLA that was up to date at that time.

Spuštěno SLA (hodiny)

float, not null

The number of hours in SLA operating hours during which the SLA was running within the change duration.

Pozastaveno SLA (hodiny)

float, not null

The number of hours in SLA operating hours during which the SLA was paused within the change duration.

Požadavek uzavřen (UTC)

datetime, null

Date and time of ticket closing.

Query.RequestChangeDeu

Progress of tickets solving in ALVAO Service Desk. Each line corresponds to a change in status, service, SLA, or solver. Only records for tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Anfrage-Nummer

int, not null

The ticket identification number.

Id des Service

int, null

Service ID (tHdSection.iHdSectionId).

Id des Status

int, null

Status ID (TicketState.id).

ID des Bearbeiters

int, null

Solver ID (tPerson.iPersonId).

Bearbeitergruppe

nvarchar(255), null

The name of the solver group to which the ticket is assigned.

Id der SLA

int, null

SLA ID (tSla.iSlaId).

Beginn (UTC)

datetime, null

Date of change performance.

Ende (UTC)

datetime, null

Change end date = the date the next change was made.

Dauer (Stunden)

float, null

Number of hours the change took.

Betriebszeitdauer (Stunden)

float, not null

Number of hours the change took. It is calculated in the operating hours of the SLA that was up to date at that time.

Laufendes SLA (Stunden)

float, not null

The number of hours in SLA operating hours during which the SLA was running within the change duration.

SLA ausgesetzt (Stunden)

float, not null

The number of hours in SLA operating hours during which the SLA was paused within the change duration.

Ticket geschlossen (UTC)

datetime, null

Date and time of ticket closing.

Query.RequestChangeEnu

Progress of tickets solving in ALVAO Service Desk. Each line corresponds to a change in status, service, SLA, or solver. Only records for tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Request number

int, not null

The ticket identification number.

Service ID

int, null

Service ID (tHdSection.iHdSectionId).

Status ID

int, null

Status ID (TicketState.id).

Solver ID

int, null

Solver ID (tPerson.iPersonId).

Solver group

nvarchar(255), null

The name of the solver group to which the ticket is assigned.

SLA ID

int, null

SLA ID (tSla.iSlaId).

Start (UTC)

datetime, null

Date of change performance.

End (UTC)

datetime, null

Change end date = the date the next change was made.

Duration (hours)

float, null

Number of hours the change took.

Duration in operating hours (hours)

float, not null

Number of hours the change took. It is calculated in the operating hours of the SLA that was up to date at that time.

Running SLA (hours)

float, not null

The number of hours in SLA operating hours during which the SLA was running within the change duration.

SLA paused (hours)

float, not null

The number of hours in SLA operating hours during which the SLA was paused within the change duration.

Ticket closed (UTC)

datetime, null

Date and time of ticket closing.

Query.RequestContinualResponseCsy

Continuous informing of the requester by the solver team in tickets within the ALVAO Service Desk. Continuous notification is a message sent from the vendors to the customer during the solution of their ticket; such messages are not reactions to a previous message from the customer. Only tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Číslo požadavku

int, not null

The ticket identification number.

Název požadavku

nvarchar(1024), null

Ticket name

Služba

nvarchar(1024), null

Name of the service including the path in the tree.

SLA

nvarchar(255), null

SLA name.

Žadatel

nvarchar(255), null

First and last name of the requester.

Organizace (žadatel)

nvarchar(255), null

Name of the requester’s organization.

Řešitel

nvarchar(255), null

Name and surname of the solver.

Termín (UTC)

datetime, null

Ticket due date.

Interní cíl

nvarchar(255), null

Internal target name.

Interní cíl (termín) (UTC)

datetime, null

Internal target date.

Datum (UTC)

datetime, null

Date of message sending.

Týden od (UTC)

datetime, null

Date of the beginning of the week in which the message was sent.

Měsíc od (UTC)

datetime, null

Date of the beginning of the month in which the message was sent.

Rok (UTC)

int, null

year in which the message was sent.

Čtvrtletí (UTC)

int, null

Quarter in which the message was sent (1-4).

Měsíc (UTC)

int, null

Month in which the message was sent (1-12).

Týden (UTC)

int, null

Week in which the message was sent (1-53).

Hodina (UTC)

int, null

Hour in which the message was sent (0-23).

Značka a název požadavku

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

Nejvyšší požadavek

int, null

Identification number of the root parent ticket.

Nejvyšší služba

nvarchar(1024), null

Name of root service in the service tree.

Informoval

nvarchar(255), null

Name and surname of the solver who sent the message.

Doba (hodiny)

float, not null

Time elapsed from the sending of the previous message from the supplier to the sending of this message, in hours.

Související organizace

nvarchar(255), not null

Name of the organization for which the ticket is being implemented.

Proces

nvarchar(255), null

Process name.

Id žadatele

int, not null

The ID number of the ticket requester - see Query.Person{locale}.id.

Id řešitele

int, null

The current ticket solver ID number - see Query.Person{locale}.id.

Id služby

int, not null

The service ID number - see Query.Section{locale}.id.

Id SLA

int, not null

The SLA ID number - see Query.Sla{locale}.id.

Id organizace žadatele

int, null

The requester’s organization ID number - see Query.Organization{locale}.id.

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Request for HW - catalog path (služba)

nvarchar(max), null

Request for HW - categories (služba)

nvarchar(max), null

Request for HW - currency (služba)

nvarchar(256), null

Query.RequestContinualResponseDeu

Continuous informing of the requester by the solver team in tickets within the ALVAO Service Desk. Continuous notification is a message sent from the vendors to the customer during the solution of their ticket; such messages are not reactions to a previous message from the customer. Only tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Anfrage-Nummer

int, not null

The ticket identification number.

Name der Anfrage

nvarchar(1024), null

Ticket name

Service

nvarchar(1024), null

Name of the service including the path in the tree.

SLA

nvarchar(255), null

SLA name.

Anfragesteller

nvarchar(255), null

First and last name of the requester.

Organisation (Anfragesteller)

nvarchar(255), null

Name of the requester’s organization.

Bearbeiter

nvarchar(255), null

Name and surname of the solver.

Termin (UTC)

datetime, null

Ticket due date.

Internes Ziel

nvarchar(255), null

Internal target name.

Internes Ziel (Termin) (UTC)

datetime, null

Internal target date.

Datum (UTC)

datetime, null

Date of message sending.

Woche seit (UTC)

datetime, null

Date of the beginning of the week in which the message was sent.

Monat seit (UTC)

datetime, null

Date of the beginning of the month in which the message was sent.

Jahr (UTC)

int, null

year in which the message was sent.

Quartal (UTC)

int, null

Quarter in which the message was sent (1-4).

Monat (UTC)

int, null

Month in which the message was sent (1-12).

Woche (UTC)

int, null

Week in which the message was sent (1-53).

Stunde (UTC)

int, null

Hour in which the message was sent (0-23).

Zeichen und Name der Anfrage

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

Höchste Anfrage

int, null

Identification number of the root parent ticket.

Höchster Service

nvarchar(1024), null

Name of root service in the service tree.

Informiert durch

nvarchar(255), null

Name and surname of the solver who sent the message.

Zeit (Stunden)

float, not null

Time elapsed from the sending of the previous message from the supplier to the sending of this message, in hours.

Zugehörige Organisationen

nvarchar(255), not null

Name of the organization for which the ticket is being implemented.

Prozess

nvarchar(255), null

Process name.

Id des Anfragestellers

int, not null

The ID number of the ticket requester - see Query.Person{locale}.id.

ID des Bearbeiters

int, null

The current ticket solver ID number - see Query.Person{locale}.id.

Id des Service

int, not null

The service ID number - see Query.Section{locale}.id.

Id der SLA

int, not null

The SLA ID number - see Query.Sla{locale}.id.

Id der Organisation des Anfragestellers

int, null

The requester’s organization ID number - see Query.Organization{locale}.id.

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Request for HW - catalog path (Service)

nvarchar(max), null

Request for HW - categories (Service)

nvarchar(max), null

Request for HW - currency (Service)

nvarchar(256), null

Query.RequestContinualResponseEnu

Continuous informing of the requester by the solver team in tickets within the ALVAO Service Desk. Continuous notification is a message sent from the vendors to the customer during the solution of their ticket; such messages are not reactions to a previous message from the customer. Only tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Request number

int, not null

The ticket identification number.

Request name

nvarchar(1024), null

Ticket name

Service

nvarchar(1024), null

Name of the service including the path in the tree.

SLA

nvarchar(255), null

SLA name.

Requester

nvarchar(255), null

First and last name of the requester.

Organization (requester)

nvarchar(255), null

Name of the requester’s organization.

Solver

nvarchar(255), null

Name and surname of the solver.

Due date (UTC)

datetime, null

Ticket due date.

Internal target

nvarchar(255), null

Internal target name.

Internal target (due date) (UTC)

datetime, null

Internal target date.

Date (UTC)

datetime, null

Date of message sending.

Week starting (UTC)

datetime, null

Date of the beginning of the week in which the message was sent.

Month starting (UTC)

datetime, null

Date of the beginning of the month in which the message was sent.

Year (UTC)

int, null

year in which the message was sent.

Quarter (UTC)

int, null

Quarter in which the message was sent (1-4).

Month (UTC)

int, null

Month in which the message was sent (1-12).

Week (UTC)

int, null

Week in which the message was sent (1-53).

Hour (UTC)

int, null

Hour in which the message was sent (0-23).

Request tag and title

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

Highest request

int, null

Identification number of the root parent ticket.

Highest service

nvarchar(1024), null

Name of root service in the service tree.

Informed by

nvarchar(255), null

Name and surname of the solver who sent the message.

Time (hours)

float, not null

Time elapsed from the sending of the previous message from the supplier to the sending of this message, in hours.

Related organization

nvarchar(255), not null

Name of the organization for which the ticket is being implemented.

Process

nvarchar(255), null

Process name.

Requester ID

int, not null

The ID number of the ticket requester - see Query.Person{locale}.id.

Solver ID

int, null

The current ticket solver ID number - see Query.Person{locale}.id.

Service ID

int, not null

The service ID number - see Query.Section{locale}.id.

SLA ID

int, not null

The SLA ID number - see Query.Sla{locale}.id.

Requesters organization ID

int, null

The requester’s organization ID number - see Query.Organization{locale}.id.

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Request for HW - catalog path (service)

nvarchar(max), null

Request for HW - categories (service)

nvarchar(max), null

Request for HW - currency (service)

nvarchar(256), null

Query.RequestLogRecordCsy

Records in ticket logs in ALVAO Service Desk.
Only ticket log records from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. No deleted records are displayed.
The view is used to create reports and analyses.
Note: Only events from the tAct table are displayed. No events from dbo.tHdTicketApproval and dbo.tHdTicketApprovalItem. tables are displayed.

ColumnTypeDescription

id

int, not null

Identification number of the event - see dbo.tAct.iActId.

Vytvořeno (UTC)

datetime, null

Date and time of the record creation in the ticket log

Předmět

nvarchar(max), null

Subject of the record in the log

Náklady (hodiny)

float, null

Total recorded time (Work + Travel time), in hours

Náklady - Práce (hodiny)

float, null

Reported work in hours

Náklady - Cesta (hodiny)

float, null

Reported time spent on trip in hours

Náklady - Cesta (km)

float, null

Reported distance in kilometers

Druh události

nvarchar(255), null

Name of the type of record (e-mail, note, ...)

Nefakturovat

bit, not null

The "Exclude from invoice to the requester" flag

URL události

nvarchar(2075), null

Event URL in ALVAO WebApp

Operace

nvarchar(255), null

Operation name, see dbo.ActOperation.Name.

Důležitá událost

int, not null

Indication whether this is an important event.

Řešení požadavku

int, not null

Indication whether the event contains a ticket solution.

FromPersonId

int, not null

The current ID number of the ticket event author - see Query.Person{locale}.id.

RequestId

int, null

The ticket ID number - seeQuery.Request2{locale}.id.

Poslední změna (UTC)

datetime, null

Time at which the record was modified.

Požadavek uzavřen (UTC)

datetime, null

Date and time of ticket closing.

Query.RequestLogRecordDeu

Records in ticket logs in ALVAO Service Desk.
Only ticket log records from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. No deleted records are displayed.
The view is used to create reports and analyses.
Note: Only events from the tAct table are displayed. No events from dbo.tHdTicketApproval and dbo.tHdTicketApprovalItem. tables are displayed.

ColumnTypeDescription

id

int, not null

Identification number of the event - see dbo.tAct.iActId.

Erstellt (UTC)

datetime, null

Date and time of the record creation in the ticket log

Betreff

nvarchar(max), null

Subject of the record in the log

Aufwand (in Stunden)

float, null

Total recorded time (Work + Travel time), in hours

Arbeitsaufwand (in Stunden)

float, null

Reported work in hours

Aufwand - Reisezeit (in Stunden)

float, null

Reported time spent on trip in hours

Aufwand - Reisezeit (in km)

float, null

Reported distance in kilometers

Ereignistyp

nvarchar(255), null

Name of the type of record (e-mail, note, ...)

Nicht in Rechnung stellen

bit, not null

The "Exclude from invoice to the requester" flag

URL des Ereignises

nvarchar(2075), null

Event URL in ALVAO WebApp

Operation

nvarchar(255), null

Operation name, see dbo.ActOperation.Name.

Wichtiges Ereignis

int, not null

Indication whether this is an important event.

Lösung der Anfrage

int, not null

Indication whether the event contains a ticket solution.

FromPersonId

int, not null

The current ID number of the ticket event author - see Query.Person{locale}.id.

RequestId

int, null

The ticket ID number - seeQuery.Request2{locale}.id.

Zuletzt geändert (UTC)

datetime, null

Time at which the record was modified.

Ticket geschlossen (UTC)

datetime, null

Date and time of ticket closing.

Query.RequestLogRecordEnu

Records in ticket logs in ALVAO Service Desk.
Only ticket log records from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. No deleted records are displayed.
The view is used to create reports and analyses.
Note: Only events from the tAct table are displayed. No events from dbo.tHdTicketApproval and dbo.tHdTicketApprovalItem. tables are displayed.

ColumnTypeDescription

id

int, not null

Identification number of the event - see dbo.tAct.iActId.

Created (UTC)

datetime, null

Date and time of the record creation in the ticket log

Subject

nvarchar(max), null

Subject of the record in the log

Cost (hours)

float, null

Total recorded time (Work + Travel time), in hours

Cost - Work (hours)

float, null

Reported work in hours

Cost - Time traveled (hours)

float, null

Reported time spent on trip in hours

Cost - Distance traveled (km)

float, null

Reported distance in kilometers

Log record type

nvarchar(255), null

Name of the type of record (e-mail, note, ...)

Exclude from invoice

bit, not null

The "Exclude from invoice to the requester" flag

Log record URL

nvarchar(2075), null

Event URL in ALVAO WebApp

Operation

nvarchar(255), null

Operation name, see dbo.ActOperation.Name.

Marked as important

int, not null

Indication whether this is an important event.

Request solution

int, not null

Indication whether the event contains a ticket solution.

FromPersonId

int, not null

The current ID number of the ticket event author - see Query.Person{locale}.id.

RequestId

int, null

The ticket ID number - seeQuery.Request2{locale}.id.

Last changed (UTC)

datetime, null

Time at which the record was modified.

Ticket closed (UTC)

datetime, null

Date and time of ticket closing.

Query.RequestObjectCsy

Links between tickets in ALVAO Service Desk and objects in ALVAO Asset Management.
Discarded and removed objects are not displayed.
Only tickets from services are displayed where the user is connected to the database by the member of the resolving team, or the reader and only the objects and property values that the user connected to the database has the right to read.
The view is used to create reports and analyses.

ColumnTypeDescription

Číslo požadavku

int, not null

Ticket identification number

Název požadavku

nvarchar(1024), null

Ticket name

Značka a název požadavku

nvarchar(1282), null

Tag and name of the ticket, e.g. "T123456COMPANY Request for a new printer".

Služba

nvarchar(1024), null

Name of the service including the path in the tree

Proces

nvarchar(255), not null

Process name

SLA

nvarchar(255), null

SLA name

Hrubý stav

nvarchar(9), not null

Name of general status (Open, Resolved, Closed, Deleted)

Id objektu

int, not null

Object identification number

Název objektu

nvarchar(255), null

Object name

Druh objektu

nvarchar(max), null

Object kind

Cesta ve stromu

nvarchar(1024), null

Path in tree (without the object name). Contains an empty chain for root objects.

Požadavek uzavřen (UTC)

datetime, null

Date and time of ticket closing.

Query.RequestObjectDeu

Links between tickets in ALVAO Service Desk and objects in ALVAO Asset Management.
Discarded and removed objects are not displayed.
Only tickets from services are displayed where the user is connected to the database by the member of the resolving team, or the reader and only the objects and property values that the user connected to the database has the right to read.
The view is used to create reports and analyses.

ColumnTypeDescription

Anfrage-Nummer

int, not null

Ticket identification number

Name der Anfrage

nvarchar(1024), null

Ticket name

Zeichen und Name der Anfrage

nvarchar(1282), null

Tag and name of the ticket, e.g. "T123456COMPANY Request for a new printer".

Service

nvarchar(1024), null

Name of the service including the path in the tree

Prozess

nvarchar(255), not null

Process name

SLA

nvarchar(255), null

SLA name

Gesamtstatus

nvarchar(11), not null

Name of general status (Open, Resolved, Closed, Deleted)

Objekt Id

int, not null

Object identification number

Objektname

nvarchar(255), null

Object name

Objekttyp

nvarchar(max), null

Object kind

Pfad im Objektbaum

nvarchar(1024), null

Path in tree (without the object name). Contains an empty chain for root objects.

Ticket geschlossen (UTC)

datetime, null

Date and time of ticket closing.

Query.RequestObjectEnu

Links between tickets in ALVAO Service Desk and objects in ALVAO Asset Management.
Discarded and removed objects are not displayed.
Only tickets from services are displayed where the user is connected to the database by the member of the resolving team, or the reader and only the objects and property values that the user connected to the database has the right to read.
The view is used to create reports and analyses.

ColumnTypeDescription

Request number

int, not null

Ticket identification number

Request name

nvarchar(1024), null

Ticket name

Request tag and title

nvarchar(1282), null

Tag and name of the ticket, e.g. "T123456COMPANY Request for a new printer".

Service

nvarchar(1024), null

Name of the service including the path in the tree

Process

nvarchar(255), not null

Process name

SLA

nvarchar(255), null

SLA name

Overall status

nvarchar(8), not null

Name of general status (Open, Resolved, Closed, Deleted)

Object id

int, not null

Object identification number

Object name

nvarchar(255), null

Object name

Object kind

nvarchar(max), null

Object kind

Path in tree

nvarchar(1024), null

Path in tree (without the object name). Contains an empty chain for root objects.

Ticket closed (UTC)

datetime, null

Date and time of ticket closing.

Query.RequestObjectRelation

Links between tickets in ALVAO Service Desk and objects in ALVAO Asset Management.
Only tickets from services are displayed where the user is connected to the database by the member of the resolving team, or the reader and only the objects that the user connected to the database has the right to read. No links to deleted tickets are displayed. No deleted links are displayed.
The view is used to create reports and analyses.

ColumnTypeDescription

RequestId

int, not null

The ticket ID number - seeQuery.Request2{locale}.id.

ObjectId

int, not null

The object ID number - see Query.ObjectCsy{locale}.[Object ID].

Query.RequestOperationCsy

Basic operations (Created, Deleted, Resolved, Closed) with tickets in Alvao Service Desk over time. Only operations for tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Číslo požadavku

int, null

The ticket identification number.

Nejvyšší požadavek

int, null

Identification number of the root linked parent ticket.

Žadatel

nvarchar(255), null

First and last name of the requester.

Organizace (žadatel)

nvarchar(255), null

Name of the requester’s organization.

Služba

nvarchar(1024), null

Name of the service including the path in the tree.

Nejvyšší služba

nvarchar(1024), null

Name of root service in the service tree.

Název požadavku

nvarchar(1024), null

Ticket name

Řešitel

nvarchar(255), null

Name and surname of the solver.

Oddělení (řešitel)

nvarchar(255), null

Name of the solver’s department.

Oddělení (žadatel)

nvarchar(255), null

Name of the requester’s department.

Funkce (řešitel)

nvarchar(255), null

Name of the solver’s job title.

Funkce (žadatel)

nvarchar(255), null

Name of the requester’s job title.

Skupina

nvarchar(255), null

Group

Termín (UTC)

datetime, null

Ticket due date.

Interní cíl

nvarchar(255), null

Internal target name.

Interní cíl (termín) (UTC)

datetime, null

Internal target date.

Priorita

nvarchar(max), null

Priority name.

Značka a název požadavku

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

SLA

nvarchar(255), null

SLA name.

Operace

nvarchar(10), not null

Performed operation (Created, Deleted, Resolved, Closed).

Změna počtu otevřených požadavků

int, not null

Change of the number of open tickets after performing the operation (+1, -1)

Datum (UTC)

datetime, null

Date of operation.

Týden od (UTC)

datetime, null

Date of the beginning of the week of the operation.

Měsíc od (UTC)

datetime, null

Date of the beginning of the month of the operation.

Rok (UTC)

int, null

Year of the operation.

Čtvrtletí (UTC)

int, null

Quarter in which the operation was executed (1-4).

Měsíc (UTC)

int, null

Month in which the operation was executed (1-12).

Týden (UTC)

int, null

Week of the operation (1-53).

Hodina (UTC)

int, null

Hour in which the operation was executed (0-23).

Související organizace

nvarchar(255), not null

Name of the organization for which the ticket is being implemented.

Proces

nvarchar(255), null

Process name.

Id žadatele

int, null

The ID number of the ticket requester - see Query.Person{locale}.id.

Id řešitele

int, null

The current ticket solver ID number - see Query.Person{locale}.id.

Id služby

int, null

The service ID number - see Query.Section{locale}.id.

Id SLA

int, null

The SLA ID number - see Query.Sla{locale}.id.

Id organizace žadatele

int, null

The requester’s organization ID number - see Query.Organization{locale}.id.

Požadavek uzavřen (UTC)

datetime, null

Date and time of ticket closing.

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Request for HW - catalog path (služba)

nvarchar(max), null

Request for HW - categories (služba)

nvarchar(max), null

Request for HW - currency (služba)

nvarchar(256), null

Query.RequestOperationDeu

Basic operations (Created, Deleted, Resolved, Closed) with tickets in Alvao Service Desk over time. Only operations for tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Anfrage-Nummer

int, null

The ticket identification number.

Höchste Anfrage

int, null

Identification number of the root linked parent ticket.

Anfragesteller

nvarchar(255), null

First and last name of the requester.

Organisation (Anfragesteller)

nvarchar(255), null

Name of the requester’s organization.

Service

nvarchar(1024), null

Name of the service including the path in the tree.

Höchster Service

nvarchar(1024), null

Name of root service in the service tree.

Name der Anfrage

nvarchar(1024), null

Ticket name

Bearbeiter

nvarchar(255), null

Name and surname of the solver.

Abteilung (Bearbeiter)

nvarchar(255), null

Name of the solver’s department.

Abteilung (Anfragesteller)

nvarchar(255), null

Name of the requester’s department.

Funktion (Bearbeiter)

nvarchar(255), null

Name of the solver’s job title.

Funktion (Anfragesteller)

nvarchar(255), null

Name of the requester’s job title.

Gruppe

nvarchar(255), null

Group

Termin (UTC)

datetime, null

Ticket due date.

Internes Ziel

nvarchar(255), null

Internal target name.

Internes Ziel (Termin) (UTC)

datetime, null

Internal target date.

Priorität

nvarchar(max), null

Priority name.

Zeichen und Name der Anfrage

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

SLA

nvarchar(255), null

SLA name.

Operation

nvarchar(11), not null

Performed operation (Created, Deleted, Resolved, Closed).

Änderung der Anzahl der offenen Anfragen

int, not null

Change of the number of open tickets after performing the operation (+1, -1)

Datum (UTC)

datetime, null

Date of operation.

Woche seit (UTC)

datetime, null

Date of the beginning of the week of the operation.

Monat seit (UTC)

datetime, null

Date of the beginning of the month of the operation.

Jahr (UTC)

int, null

Year of the operation.

Quartal (UTC)

int, null

Quarter in which the operation was executed (1-4).

Monat (UTC)

int, null

Month in which the operation was executed (1-12).

Woche (UTC)

int, null

Week of the operation (1-53).

Stunde (UTC)

int, null

Hour in which the operation was executed (0-23).

Zugehörige Organisationen

nvarchar(255), not null

Name of the organization for which the ticket is being implemented.

Prozess

nvarchar(255), null

Process name.

Id des Anfragestellers

int, null

The ID number of the ticket requester - see Query.Person{locale}.id.

ID des Bearbeiters

int, null

The current ticket solver ID number - see Query.Person{locale}.id.

Id des Service

int, null

The service ID number - see Query.Section{locale}.id.

Id der SLA

int, null

The SLA ID number - see Query.Sla{locale}.id.

Id der Organisation des Anfragestellers

int, null

The requester’s organization ID number - see Query.Organization{locale}.id.

Ticket geschlossen (UTC)

datetime, null

Date and time of ticket closing.

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Request for HW - catalog path (Service)

nvarchar(max), null

Request for HW - categories (Service)

nvarchar(max), null

Request for HW - currency (Service)

nvarchar(256), null

Query.RequestOperationEnu

Basic operations (Created, Deleted, Resolved, Closed) with tickets in Alvao Service Desk over time. Only operations for tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Request number

int, null

The ticket identification number.

Highest request

int, null

Identification number of the root linked parent ticket.

Requester

nvarchar(255), null

First and last name of the requester.

Organization (requester)

nvarchar(255), null

Name of the requester’s organization.

Service

nvarchar(1024), null

Name of the service including the path in the tree.

Highest service

nvarchar(1024), null

Name of root service in the service tree.

Request name

nvarchar(1024), null

Ticket name

Solver

nvarchar(255), null

Name and surname of the solver.

Department (solver)

nvarchar(255), null

Name of the solver’s department.

Department (requester)

nvarchar(255), null

Name of the requester’s department.

Job title (solver)

nvarchar(255), null

Name of the solver’s job title.

Job title (requester)

nvarchar(255), null

Name of the requester’s job title.

Group

nvarchar(255), null

Group

Due date (UTC)

datetime, null

Ticket due date.

Internal target

nvarchar(255), null

Internal target name.

Internal target (due date) (UTC)

datetime, null

Internal target date.

Priority

nvarchar(max), null

Priority name.

Request tag and title

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

SLA

nvarchar(255), null

SLA name.

Operation

nvarchar(8), not null

Performed operation (Created, Deleted, Resolved, Closed).

Change of the number of open requests

int, not null

Change of the number of open tickets after performing the operation (+1, -1)

Date (UTC)

datetime, null

Date of operation.

Week starting (UTC)

datetime, null

Date of the beginning of the week of the operation.

Month starting (UTC)

datetime, null

Date of the beginning of the month of the operation.

Year (UTC)

int, null

Year of the operation.

Quarter (UTC)

int, null

Quarter in which the operation was executed (1-4).

Month (UTC)

int, null

Month in which the operation was executed (1-12).

Week (UTC)

int, null

Week of the operation (1-53).

Hour (UTC)

int, null

Hour in which the operation was executed (0-23).

Related organization

nvarchar(255), not null

Name of the organization for which the ticket is being implemented.

Process

nvarchar(255), null

Process name.

Requester ID

int, null

The ID number of the ticket requester - see Query.Person{locale}.id.

Solver ID

int, null

The current ticket solver ID number - see Query.Person{locale}.id.

Service ID

int, null

The service ID number - see Query.Section{locale}.id.

SLA ID

int, null

The SLA ID number - see Query.Sla{locale}.id.

Requesters organization ID

int, null

The requester’s organization ID number - see Query.Organization{locale}.id.

Ticket closed (UTC)

datetime, null

Date and time of ticket closing.

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Request for HW - catalog path (service)

nvarchar(max), null

Request for HW - categories (service)

nvarchar(max), null

Request for HW - currency (service)

nvarchar(256), null

Query.RequestPersonRead

Permission of users to see tickets registered in ALVAO. Each row represents one user who may, according to his current permissions, see the given ticket.
The view is used to create reports and analyses.

ColumnTypeDescription

PersonId

int, null

Identification number of the person, see Query.PersonEnu.id

RequestId

int, null

Identification number of the ticket - see Query.Request2Enu.id

Ticket closed (UTC)

datetime, null

Date and time of ticket closing.

Query.RequestRelationCsy

Links between tickets in ALVAO Service Desk.
Only links between tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. No links to deleted tickets are displayed. No deleted links are displayed.
The view is used to create reports and analyses.

ColumnTypeDescription

RequestId

int, not null

The ticket ID number - seeQuery.Request2{locale}.id.

RelatedRequestId

int, not null

The linked ticket ID number - see Query.Request2{locale}.id.

Typ vazby

nvarchar(30), not null

Link type name

Query.RequestRelationDeu

Links between tickets in ALVAO Service Desk.
Only links between tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. No links to deleted tickets are displayed. No deleted links are displayed.
The view is used to create reports and analyses.

ColumnTypeDescription

RequestId

int, not null

The ticket ID number - seeQuery.Request2{locale}.id.

RelatedRequestId

int, not null

The linked ticket ID number - see Query.Request2{locale}.id.

Typ der Verknüpfung

nvarchar(30), not null

Link type name

Query.RequestRelationEnu

Links between tickets in ALVAO Service Desk.
Only links between tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. No links to deleted tickets are displayed. No deleted links are displayed.
The view is used to create reports and analyses.

ColumnTypeDescription

RequestId

int, not null

The ticket ID number - seeQuery.Request2{locale}.id.

RelatedRequestId

int, not null

The linked ticket ID number - see Query.Request2{locale}.id.

Link type

nvarchar(30), not null

Link type name

Query.RequestReopenCsy

Reopening of tickets in ALVAO Service Desk. Only tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Číslo požadavku

int, not null

The ticket identification number.

Název požadavku

nvarchar(1024), null

Ticket name

Služba

nvarchar(1024), null

Name of the service including the path in the tree.

SLA

nvarchar(255), null

SLA name.

Žadatel

nvarchar(255), null

First and last name of the requester.

Organizace (žadatel)

nvarchar(255), null

Name of the requester’s organization.

Řešitel

nvarchar(255), null

Name and surname of the solver.

Vyřešil

nvarchar(255), null

Name and surname of the solver who resolved the ticket.

Termín (UTC)

datetime, null

Ticket due date.

Interní cíl

nvarchar(255), null

Internal target name.

Interní cíl (termín) (UTC)

datetime, null

Internal target date.

Nejvyšší požadavek

int, null

Identification number of the root parent ticket.

Nejvyšší služba

nvarchar(1024), null

Name of root service in the service tree.

Datum (UTC)

datetime, null

Date of ticket reopening.

Týden od (UTC)

datetime, null

Date of the beginning of the week in which the ticket was reopened.

Měsíc od (UTC)

datetime, null

Date of the beginning of the month in which the ticket was reopened.

Rok (UTC)

int, null

Year of ticket reopening.

Čtvrtletí (UTC)

int, null

Quarter in which the ticket was reopened (1-4).

Měsíc (UTC)

int, null

Month in which the ticket was reopened (1-12).

Týden (UTC)

int, null

Week of ticket reopening (1-53).

Hodina (UTC)

int, null

Hour in which the ticket was reopened (0-23).

Značka a název požadavku

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

Vyřešeno (UTC)

datetime, null

Date and time of ticket solution.

Znovu otevřeno (UTC)

datetime, null

Date and time of ticket reopening.

Doba vyřešení (hodiny)

float, not null

Time elapsed in hours from the solution up to the reopening of the ticket.

Související organizace

nvarchar(255), not null

Name of the organization for which the ticket is being implemented.

Proces

nvarchar(255), null

Process name.

Id žadatele

int, not null

The ID number of the ticket requester - see Query.Person{locale}.id.

Id řešitele

int, null

The current ticket solver ID number - see Query.Person{locale}.id.

Id služby

int, not null

The service ID number - see Query.Section{locale}.id.

Id SLA

int, not null

The SLA ID number - see Query.Sla{locale}.id.

Id organizace žadatele

int, null

The requester’s organization ID number - see Query.Organization{locale}.id.

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Request for HW - catalog path (služba)

nvarchar(max), null

Request for HW - categories (služba)

nvarchar(max), null

Request for HW - currency (služba)

nvarchar(256), null

Query.RequestReopenDeu

Reopening of tickets in ALVAO Service Desk. Only tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Anfrage-Nummer

int, not null

The ticket identification number.

Name der Anfrage

nvarchar(1024), null

Ticket name

Service

nvarchar(1024), null

Name of the service including the path in the tree.

SLA

nvarchar(255), null

SLA name.

Anfragesteller

nvarchar(255), null

First and last name of the requester.

Organisation (Anfragesteller)

nvarchar(255), null

Name of the requester’s organization.

Bearbeiter

nvarchar(255), null

Name and surname of the solver.

Gelöst von

nvarchar(255), null

Name and surname of the solver who resolved the ticket.

Termin (UTC)

datetime, null

Ticket due date.

Internes Ziel

nvarchar(255), null

Internal target name.

Internes Ziel (Termin) (UTC)

datetime, null

Internal target date.

Höchste Anfrage

int, null

Identification number of the root parent ticket.

Höchster Service

nvarchar(1024), null

Name of root service in the service tree.

Datum (UTC)

datetime, null

Date of ticket reopening.

Woche seit (UTC)

datetime, null

Date of the beginning of the week in which the ticket was reopened.

Monat seit (UTC)

datetime, null

Date of the beginning of the month in which the ticket was reopened.

Jahr (UTC)

int, null

Year of ticket reopening.

Quartal (UTC)

int, null

Quarter in which the ticket was reopened (1-4).

Monat (UTC)

int, null

Month in which the ticket was reopened (1-12).

Woche (UTC)

int, null

Week of ticket reopening (1-53).

Stunde (UTC)

int, null

Hour in which the ticket was reopened (0-23).

Zeichen und Name der Anfrage

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

Gelöst (UTC)

datetime, null

Date and time of ticket solution.

Wieder geöffnet (UTC)

datetime, null

Date and time of ticket reopening.

Lösungszeit (Stunden)

float, not null

Time elapsed in hours from the solution up to the reopening of the ticket.

Zugehörige Organisationen

nvarchar(255), not null

Name of the organization for which the ticket is being implemented.

Prozess

nvarchar(255), null

Process name.

Id des Anfragestellers

int, not null

The ID number of the ticket requester - see Query.Person{locale}.id.

ID des Bearbeiters

int, null

The current ticket solver ID number - see Query.Person{locale}.id.

Id des Service

int, not null

The service ID number - see Query.Section{locale}.id.

Id der SLA

int, not null

The SLA ID number - see Query.Sla{locale}.id.

Id der Organisation des Anfragestellers

int, null

The requester’s organization ID number - see Query.Organization{locale}.id.

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Request for HW - catalog path (Service)

nvarchar(max), null

Request for HW - categories (Service)

nvarchar(max), null

Request for HW - currency (Service)

nvarchar(256), null

Query.RequestReopenEnu

Reopening of tickets in ALVAO Service Desk. Only tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Request number

int, not null

The ticket identification number.

Request name

nvarchar(1024), null

Ticket name

Service

nvarchar(1024), null

Name of the service including the path in the tree.

SLA

nvarchar(255), null

SLA name.

Requester

nvarchar(255), null

First and last name of the requester.

Organization (requester)

nvarchar(255), null

Name of the requester’s organization.

Solver

nvarchar(255), null

Name and surname of the solver.

Resolved by

nvarchar(255), null

Name and surname of the solver who resolved the ticket.

Due date (UTC)

datetime, null

Ticket due date.

Internal target

nvarchar(255), null

Internal target name.

Internal target (due date) (UTC)

datetime, null

Internal target date.

Highest request

int, null

Identification number of the root parent ticket.

Highest service

nvarchar(1024), null

Name of root service in the service tree.

Date (UTC)

datetime, null

Date of ticket reopening.

Week starting (UTC)

datetime, null

Date of the beginning of the week in which the ticket was reopened.

Month starting (UTC)

datetime, null

Date of the beginning of the month in which the ticket was reopened.

Year (UTC)

int, null

Year of ticket reopening.

Quarter (UTC)

int, null

Quarter in which the ticket was reopened (1-4).

Month (UTC)

int, null

Month in which the ticket was reopened (1-12).

Week (UTC)

int, null

Week of ticket reopening (1-53).

Hour (UTC)

int, null

Hour in which the ticket was reopened (0-23).

Request tag and title

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

Resolved (UTC)

datetime, null

Date and time of ticket solution.

Reopened (UTC)

datetime, null

Date and time of ticket reopening.

Resolution time (hours)

float, not null

Time elapsed in hours from the solution up to the reopening of the ticket.

Related organization

nvarchar(255), not null

Name of the organization for which the ticket is being implemented.

Process

nvarchar(255), null

Process name.

Requester ID

int, not null

The ID number of the ticket requester - see Query.Person{locale}.id.

Solver ID

int, null

The current ticket solver ID number - see Query.Person{locale}.id.

Service ID

int, not null

The service ID number - see Query.Section{locale}.id.

SLA ID

int, not null

The SLA ID number - see Query.Sla{locale}.id.

Requesters organization ID

int, null

The requester’s organization ID number - see Query.Organization{locale}.id.

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Request for HW - catalog path (service)

nvarchar(max), null

Request for HW - categories (service)

nvarchar(max), null

Request for HW - currency (service)

nvarchar(256), null

Query.RequestStateCsy

Process-based ticket status in ALVAO Service Desk.
Only statuses from processes are assigned to services where the user has been connected to the database by a member of the solver team or by a reader are displayed. No deleted statuses are displayed.
The view is used to create reports and analyses.

ColumnTypeDescription

id

int, not null

Identification number of the ticket status - see dbo.TicketState.id.

Název

nvarchar(64), not null

Ticket status name

Popis pro žadatele

nvarchar(max), null

A description of the status visible to the requester.

Schvalování

bit, not null

Ticket approval is performed at this status.

Pozastaveno SLA

bit, not null

SLA is paused at this status.

Mimořádný stav

int, not null

Emergency status

Pořadí v postupu řešení

int, not null

The order of the status in the process workflow

ProcessId

int, null

The process ID number in which the status is in the solution process - see Query.Process{locale}.id.

AdminUrl

nvarchar(2141), null

URL of the ticket status page in the administration.

Query.RequestStateDeu

Process-based ticket status in ALVAO Service Desk.
Only statuses from processes are assigned to services where the user has been connected to the database by a member of the solver team or by a reader are displayed. No deleted statuses are displayed.
The view is used to create reports and analyses.

ColumnTypeDescription

id

int, not null

Identification number of the ticket status - see dbo.TicketState.id.

Bezeichnung

nvarchar(64), not null

Ticket status name

Beschreigung für den Anfragesteller

nvarchar(max), null

A description of the status visible to the requester.

Freigabe

bit, not null

Ticket approval is performed at this status.

SLA ausgesetzt

bit, not null

SLA is paused at this status.

Außerordentlicher Status

int, not null

Emergency status

Reihenfolge im Lösungsablauf

int, not null

The order of the status in the process workflow

ProcessId

int, null

The process ID number in which the status is in the solution process - see Query.Process{locale}.id.

AdminUrl

nvarchar(2141), null

URL of the ticket status page in the administration.

Query.RequestStateEnu

Process-based ticket status in ALVAO Service Desk.
Only statuses from processes are assigned to services where the user has been connected to the database by a member of the solver team or by a reader are displayed. No deleted statuses are displayed.
The view is used to create reports and analyses.

ColumnTypeDescription

id

int, not null

Identification number of the ticket status - see dbo.TicketState.id.

Name

nvarchar(64), not null

Ticket status name

Description for the requester

nvarchar(max), null

A description of the status visible to the requester.

Approving

bit, not null

Ticket approval is performed at this status.

SLA paused

bit, not null

SLA is paused at this status.

Emergency status

int, not null

Emergency status

Order in solving process

int, not null

The order of the status in the process workflow

ProcessId

int, null

The process ID number in which the status is in the solution process - see Query.Process{locale}.id.

AdminUrl

nvarchar(2141), null

URL of the ticket status page in the administration.

Query.RequestSubsequentResponseCsy

Follow-up reactions of the solver team for tickets within the ALVAO Service Desk. The subsequent reaction is the first message from the vendor sent to the customer from the receipt of any message from the customer in the course of processing their ticket. Responses are only displayed for tickets from services where the user has been connected to the database by a member of the solver team or by a reader. The view is used to create reports and analyses.

ColumnTypeDescription

Číslo požadavku

int, not null

The ticket identification number.

Název požadavku

nvarchar(1024), null

Ticket name

Služba

nvarchar(1024), null

Name of the service including the path in the tree.

SLA

nvarchar(255), null

SLA name.

Žadatel

nvarchar(255), null

First and last name of the requester.

Organizace (žadatel)

nvarchar(255), null

Name of the requester’s organization.

Řešitel

nvarchar(255), null

Name and surname of the solver.

Termín (UTC)

datetime, null

Ticket due date.

Interní cíl

nvarchar(255), null

Internal target name.

Interní cíl (termín) (UTC)

datetime, null

Internal target date.

Datum (UTC)

datetime, null

Date of follow-up reaction.

Týden od (UTC)

datetime, null

Date of the beginning of the week of follow-up reaction.

Měsíc od (UTC)

datetime, null

Date of the beginning of the month of follow-up reaction.

Rok (UTC)

int, null

Year of follow-up reaction.

Čtvrtletí (UTC)

int, null

Quarter of reaction (1-4).

Měsíc (UTC)

int, null

Month of follow-up reaction (1-12).

Týden (UTC)

int, null

Week of follow-up reaction (1-53).

Hodina (UTC)

int, null

Hour of follow-up reaction (0-23).

Reagoval

nvarchar(255), null

Name and surname of the solver who sent the message.

Doba do reakce (hodiny)

float, not null

Hours until follow-up reaction.

Překročení SLA (hodiny)

float, null

By how many hours was the SLA time to first reaction deadline exceeded.

Splnění SLA (hodiny)

float, null

How many hours earlier was the reaction met than as required by the SLA limit.

Značka a název požadavku

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

Související organizace

nvarchar(255), not null

Name of the organization for which the ticket is being implemented.

Nejvyšší požadavek

int, null

Identification number of the root parent ticket.

Nejvyšší služba

nvarchar(1024), null

Name of root service in the tree.

Proces

nvarchar(255), null

Process name.

Id žadatele

int, not null

The ID number of the ticket requester - see Query.Person{locale}.id.

Id řešitele

int, null

The current ticket solver ID number - see Query.Person{locale}.id.

Id služby

int, not null

The service ID number - see Query.Section{locale}.id.

Id SLA

int, not null

The SLA ID number - see Query.Sla{locale}.id.

Id organizace žadatele

int, null

The requester’s organization ID number - see Query.Organization{locale}.id.

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Request for HW - catalog path (služba)

nvarchar(max), null

Request for HW - categories (služba)

nvarchar(max), null

Request for HW - currency (služba)

nvarchar(256), null

Query.RequestSubsequentResponseDeu

Follow-up reactions of the solver team for tickets within the ALVAO Service Desk. The subsequent reaction is the first message from the vendor sent to the customer from the receipt of any message from the customer in the course of processing their ticket. Responses are only displayed for tickets from services where the user has been connected to the database by a member of the solver team or by a reader. The view is used to create reports and analyses.

ColumnTypeDescription

Anfrage-Nummer

int, not null

The ticket identification number.

Name der Anfrage

nvarchar(1024), null

Ticket name

Service

nvarchar(1024), null

Name of the service including the path in the tree.

SLA

nvarchar(255), null

SLA name.

Anfragesteller

nvarchar(255), null

First and last name of the requester.

Organisation (Anfragesteller)

nvarchar(255), null

Name of the requester’s organization.

Bearbeiter

nvarchar(255), null

Name and surname of the solver.

Termin (UTC)

datetime, null

Ticket due date.

Internes Ziel

nvarchar(255), null

Internal target name.

Internes Ziel (Termin) (UTC)

datetime, null

Internal target date.

Datum (UTC)

datetime, null

Date of follow-up reaction.

Woche seit (UTC)

datetime, null

Date of the beginning of the week of follow-up reaction.

Monat seit (UTC)

datetime, null

Date of the beginning of the month of follow-up reaction.

Jahr (UTC)

int, null

Year of follow-up reaction.

Quartal (UTC)

int, null

Quarter of reaction (1-4).

Monat (UTC)

int, null

Month of follow-up reaction (1-12).

Woche (UTC)

int, null

Week of follow-up reaction (1-53).

Stunde (UTC)

int, null

Hour of follow-up reaction (0-23).

Reagiert

nvarchar(255), null

Name and surname of the solver who sent the message.

Zeit bis zur Reaktion (Stunden)

float, not null

Hours until follow-up reaction.

Überschreitung der SLA (Stunden)

float, null

By how many hours was the SLA time to first reaction deadline exceeded.

Erfüllung von SLA (Stunden)

float, null

How many hours earlier was the reaction met than as required by the SLA limit.

Zeichen und Name der Anfrage

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

Zugehörige Organisationen

nvarchar(255), not null

Name of the organization for which the ticket is being implemented.

Höchste Anfrage

int, null

Identification number of the root parent ticket.

Höchster Service

nvarchar(1024), null

Name of root service in the tree.

Prozess

nvarchar(255), null

Process name.

Id des Anfragestellers

int, not null

The ID number of the ticket requester - see Query.Person{locale}.id.

ID des Bearbeiters

int, null

The current ticket solver ID number - see Query.Person{locale}.id.

Id des Service

int, not null

The service ID number - see Query.Section{locale}.id.

Id der SLA

int, not null

The SLA ID number - see Query.Sla{locale}.id.

Id der Organisation des Anfragestellers

int, null

The requester’s organization ID number - see Query.Organization{locale}.id.

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Request for HW - catalog path (Service)

nvarchar(max), null

Request for HW - categories (Service)

nvarchar(max), null

Request for HW - currency (Service)

nvarchar(256), null

Query.RequestSubsequentResponseEnu

Follow-up reactions of the solver team for tickets within the ALVAO Service Desk. The subsequent reaction is the first message from the vendor sent to the customer from the receipt of any message from the customer in the course of processing their ticket. Responses are only displayed for tickets from services where the user has been connected to the database by a member of the solver team or by a reader. The view is used to create reports and analyses.

ColumnTypeDescription

Request number

int, not null

The ticket identification number.

Request name

nvarchar(1024), null

Ticket name

Service

nvarchar(1024), null

Name of the service including the path in the tree.

SLA

nvarchar(255), null

SLA name.

Requester

nvarchar(255), null

First and last name of the requester.

Organization (requester)

nvarchar(255), null

Name of the requester’s organization.

Solver

nvarchar(255), null

Name and surname of the solver.

Due date (UTC)

datetime, null

Ticket due date.

Internal target

nvarchar(255), null

Internal target name.

Internal target (due date) (UTC)

datetime, null

Internal target date.

Date (UTC)

datetime, null

Date of follow-up reaction.

Week starting (UTC)

datetime, null

Date of the beginning of the week of follow-up reaction.

Month starting (UTC)

datetime, null

Date of the beginning of the month of follow-up reaction.

Year (UTC)

int, null

Year of follow-up reaction.

Quarter (UTC)

int, null

Quarter of reaction (1-4).

Month (UTC)

int, null

Month of follow-up reaction (1-12).

Week (UTC)

int, null

Week of follow-up reaction (1-53).

Hour (UTC)

int, null

Hour of follow-up reaction (0-23).

Responded

nvarchar(255), null

Name and surname of the solver who sent the message.

Time until response (hours)

float, not null

Hours until follow-up reaction.

SLA breached by (hours)

float, null

By how many hours was the SLA time to first reaction deadline exceeded.

Time until SLA breach (hours)

float, null

How many hours earlier was the reaction met than as required by the SLA limit.

Request tag and title

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

Related organization

nvarchar(255), not null

Name of the organization for which the ticket is being implemented.

Highest request

int, null

Identification number of the root parent ticket.

Highest service

nvarchar(1024), null

Name of root service in the tree.

Process

nvarchar(255), null

Process name.

Requester ID

int, not null

The ID number of the ticket requester - see Query.Person{locale}.id.

Solver ID

int, null

The current ticket solver ID number - see Query.Person{locale}.id.

Service ID

int, not null

The service ID number - see Query.Section{locale}.id.

SLA ID

int, not null

The SLA ID number - see Query.Sla{locale}.id.

Requesters organization ID

int, null

The requester’s organization ID number - see Query.Organization{locale}.id.

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Request for HW - catalog path (service)

nvarchar(max), null

Request for HW - categories (service)

nvarchar(max), null

Request for HW - currency (service)

nvarchar(256), null

Query.RoleMembershipLog

Provides the list of changes in membership of users and groups in groups.

ColumnTypeDescription

TimeStamp

datetime, not null

Date and time of the change execution.

MemberType

nvarchar(50), null

User or group.

Member

nvarchar(255), not null

User name or group name.

Operation

nvarchar(50), null

Operation - added or removed.

Group

nvarchar(255), not null

Name of the group in which membership changed.

ModifiedBy

nvarchar(255), not null

The name of the user who did the change.

Query.SearchLogCsy

Searched queries

ColumnTypeDescription

Dotaz

nvarchar(max), null

Searched query

Uživatel

nvarchar(255), null

Username of the person who searched the query

Datum vyhledání (UTC)

datetime, not null

Date and time of search

Datum vyhledání - Týden od (UTC)

datetime, null

Date of the first day of the week in which the query was searched.

Datum vyhledání - Měsíc od (UTC)

datetime, null

Date of the first day of the month in which the query was searched

Datum vyhledání - Rok (UTC)

int, null

Year of query search

Query.SearchLogDeu

Searched queries

ColumnTypeDescription

Abfrage

nvarchar(max), null

Searched query

Benutzer

nvarchar(255), null

Username of the person who searched the query

Datum der Suche (UTC)

datetime, not null

Date and time of search

Datum der Suche - Woche von (UTC)

datetime, null

Date of the first day of the week in which the query was searched.

Datum der Suche - Monat von (UTC)

datetime, null

Date of the first day of the month in which the query was searched

Datum der Suche - Jahr (UTC)

int, null

Year of query search

Query.SearchLogEnu

Searched queries

ColumnTypeDescription

Query

nvarchar(max), null

Searched query

User

nvarchar(255), null

Username of the person who searched the query

Search date (UTC)

datetime, not null

Date and time of search

Search date - Week from (UTC)

datetime, null

Date of the first day of the week in which the query was searched.

Search date - Month from (UTC)

datetime, null

Date of the first day of the month in which the query was searched

Search date - Year (UTC)

int, null

Year of query search

Query.SectionCsy

Services in ALVAO Service Desk.
Only services where the user has been connected to the database by a member of the solver team or by a reader are displayed. No deleted services are displayed.
The view is used to create reports and analyses.

ColumnTypeDescription

id

int, not null

Identification number of the service - see dbo.tHdSection.iHdSectionId.

Název

nvarchar(255), null

Service name

Název (včetně cesty ve stromu)

nvarchar(1024), null

Name of the service including the path in the tree

E-mail

nvarchar(255), null

Service e-mail

Telefon

nvarchar(255), null

Service telephone

Předpona značky požadavku

nvarchar(255), null

Ticket tag prefix

Přípona značky požadavku

nvarchar(255), null

Ticket tag suffix

Preferovaný jazyk

nvarchar(max), null

The name of the preferred language of the service

Časové pásmo

nvarchar(max), null

The name of the service time zone

Složka

bit, not null

The service is a folder.

ParentSectionId

int, null

The parent service ID number -see Query.Section{locale}.id.

RootSectionId

int, null

The highest parent service ID number - see Query.Section{locale}.id.

ProcessId

int, not null

The service process ID number - see Query.Process{locale}.id.

TargetSectionId

int, null

If the service is a shortcut of another service, this includes the ID number of the represented service, see Query.Section{locale}.id.

Odkaz na hlavní stránce

int, not null

A service is a link on the home page.

AdminUrl

nvarchar(2091), null

URL of the service page in the administration.

CatalogUrl

nvarchar(2090), null

URL of the service page/form in the service catalog.

Request for HW - catalog path

nvarchar(max), null

Request for HW - categories

nvarchar(max), null

Request for HW - currency

nvarchar(256), null

Query.SectionDeu

Services in ALVAO Service Desk.
Only services where the user has been connected to the database by a member of the solver team or by a reader are displayed. No deleted services are displayed.
The view is used to create reports and analyses.

ColumnTypeDescription

id

int, not null

Identification number of the service - see dbo.tHdSection.iHdSectionId.

Bezeichnung

nvarchar(255), null

Service name

Name (einschließlich des Weges in Baumstruktur)

nvarchar(1024), null

Name of the service including the path in the tree

E-Mail

nvarchar(255), null

Service e-mail

Telefon

nvarchar(255), null

Service telephone

Präfix der Kennung der Anfrage

nvarchar(255), null

Ticket tag prefix

Suffix der Kennung der Anfrage

nvarchar(255), null

Ticket tag suffix

Bevorzugte Sprache

nvarchar(max), null

The name of the preferred language of the service

Zeitzone

nvarchar(max), null

The name of the service time zone

Ordner

bit, not null

The service is a folder.

ParentSectionId

int, null

The parent service ID number -see Query.Section{locale}.id.

RootSectionId

int, null

The highest parent service ID number - see Query.Section{locale}.id.

ProcessId

int, not null

The service process ID number - see Query.Process{locale}.id.

TargetSectionId

int, null

If the service is a shortcut of another service, this includes the ID number of the represented service, see Query.Section{locale}.id.

Referenz auf der Hauptseite

int, not null

A service is a link on the home page.

AdminUrl

nvarchar(2091), null

URL of the service page in the administration.

CatalogUrl

nvarchar(2090), null

URL of the service page/form in the service catalog.

Request for HW - catalog path

nvarchar(max), null

Request for HW - categories

nvarchar(max), null

Request for HW - currency

nvarchar(256), null

Query.SectionEnu

Services in ALVAO Service Desk.
Only services where the user has been connected to the database by a member of the solver team or by a reader are displayed. No deleted services are displayed.
The view is used to create reports and analyses.

ColumnTypeDescription

id

int, not null

Identification number of the service - see dbo.tHdSection.iHdSectionId.

Name

nvarchar(255), null

Service name

Name (including the path in tree)

nvarchar(1024), null

Name of the service including the path in the tree

E-mail

nvarchar(255), null

Service e-mail

Phone

nvarchar(255), null

Service telephone

Request tag prefix

nvarchar(255), null

Ticket tag prefix

Request tag suffix

nvarchar(255), null

Ticket tag suffix

Preferred language

nvarchar(max), null

The name of the preferred language of the service

Time zone

nvarchar(max), null

The name of the service time zone

Folder

bit, not null

The service is a folder.

ParentSectionId

int, null

The parent service ID number -see Query.Section{locale}.id.

RootSectionId

int, null

The highest parent service ID number - see Query.Section{locale}.id.

ProcessId

int, not null

The service process ID number - see Query.Process{locale}.id.

TargetSectionId

int, null

If the service is a shortcut of another service, this includes the ID number of the represented service, see Query.Section{locale}.id.

Link on the homepage

int, not null

A service is a link on the home page.

AdminUrl

nvarchar(2091), null

URL of the service page in the administration.

CatalogUrl

nvarchar(2090), null

URL of the service page/form in the service catalog.

Request for HW - catalog path

nvarchar(max), null

Request for HW - categories

nvarchar(max), null

Request for HW - currency

nvarchar(256), null

Query.SlaCsy

SLA in ALVAO Service Desk.
Only SLAs used in services where the user has been connected to the database by a member of the solver team or by a reader are displayed. No deleted SLAs are displayed.
The view is used to create reports and analyses.

ColumnTypeDescription

id

int, not null

Identification number of SLA - see dbo.tSla.iSlaId.

Název

nvarchar(255), null

SLA name

Popis

nvarchar(max), null

SLA description

Provozní doba

nvarchar(255), null

SLA operating time name

Doba do první reakce (hodiny v provozní době)

float, null

The number of hours until which the first ticket is guaranteed to the requester to meet the ticket with this SLA.

Doba do vyřešení (hodiny v provozní době)

float, null

The number of hours until the ticket first response solution with this SLA is guaranteed.

Smlouva (číslo)

nvarchar(255), null

SLA contract number

Index kvality

float, null

Quality index

Poznámky

nvarchar(max), null

SLA notes

AdminUrl

nvarchar(2076), null

URL of the SLA in the administration

Query.SlaDeu

SLA in ALVAO Service Desk.
Only SLAs used in services where the user has been connected to the database by a member of the solver team or by a reader are displayed. No deleted SLAs are displayed.
The view is used to create reports and analyses.

ColumnTypeDescription

id

int, not null

Identification number of SLA - see dbo.tSla.iSlaId.

Bezeichnung

nvarchar(255), null

SLA name

Beschreibung

nvarchar(max), null

SLA description

Betriebszeit

nvarchar(255), null

SLA operating time name

Zeit bis zur ersten Reaktion (Stunden innerhalb der Betriebszeit)

float, null

The number of hours until which the first ticket is guaranteed to the requester to meet the ticket with this SLA.

Zeit bis zur Bearbeitung (Stunden innerhalb der Betriebszeit)

float, null

The number of hours until the ticket first response solution with this SLA is guaranteed.

Vertrag (Nummer)

nvarchar(255), null

SLA contract number

Qualitätsindex

float, null

Quality index

Anmerkungen

nvarchar(max), null

SLA notes

AdminUrl

nvarchar(2076), null

URL of the SLA in the administration

Query.SlaEnu

SLA in ALVAO Service Desk.
Only SLAs used in services where the user has been connected to the database by a member of the solver team or by a reader are displayed. No deleted SLAs are displayed.
The view is used to create reports and analyses.

ColumnTypeDescription

id

int, not null

Identification number of SLA - see dbo.tSla.iSlaId.

Name

nvarchar(255), null

SLA name

Description

nvarchar(max), null

SLA description

Operating hours

nvarchar(255), null

SLA operating time name

Time until the first response (hours during the operating hours)

float, null

The number of hours until which the first ticket is guaranteed to the requester to meet the ticket with this SLA.

Time to resolve (hours during the operating hours)

float, null

The number of hours until the ticket first response solution with this SLA is guaranteed.

Contract (number)

nvarchar(255), null

SLA contract number

Quality index

float, null

Quality index

Notes

nvarchar(max), null

SLA notes

AdminUrl

nvarchar(2076), null

URL of the SLA in the administration

Query.SlaRightsLog

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

ColumnTypeDescription

TimeStamp

datetime, not null

Change performance date and time (UTC)

ModifiedByPerson

nvarchar(518), not null

The name of the user who did the change.

HdSection

nvarchar(1287), null

Service name

HdSectionOld

nvarchar(1287), null

Original service name

Role

nvarchar(518), null

User group name which is the permission holder.

RoleOld

nvarchar(518), null

User group name of a person who was originally a permission holder.

Person

nvarchar(518), null

User name of a person who is the permission holder.

PersonOld

nvarchar(518), null

User name of a person who was originally a permission holder.

Sla

nvarchar(518), null

SLA name

SlaOld

nvarchar(518), null

Original SLA name

Access

bit, null

Access permissions

AccessOld

bit, null

Original access permissions

Default

bit, null

Marking of the default SLA

DefaultOld

bit, null

Original marking of the default SLA

Inheritance

bit, null

InheritanceOld

bit, null

Query.Software

View with the products (software) installed on computers that have not yet been discarded or deleted.

ColumnTypeDescription

ComputerNodeId

int, null

Node ID of the computer in the tree.

ParentNodeId

int, null

Node ID of the parent's object in the tree.

Product

nvarchar(1023), null

Product name.

Category

int, null

Product category (e.g. 1 - OS).

NeedsLicense

int, not null

1=product requires license.

FirstInstallationDetected

datetime, null

Date of the installation first detection.

Installed

datetime, null

Date of installation.

LastDetectionDateTime

datetime, null

Date of the last detection.

LastDetectedProductVersion

nvarchar(255), null

Last detected version.

LastDetectedProductName

nvarchar(255), null

Last detected product name.

LicenseInventoryNumber

nvarchar(255), null

Inventory number for license.

LicenseActivationKey

nvarchar(255), null

License activation number.

LicenseInvoiceNumber

nvarchar(255), null

License invoice number.

LicenseCertificateNumber

nvarchar(255), null

License certificate number.

Authorized

bit, null

The software installation on the computer is confirmed or a license has been assigned to that computer.

CDKey

nvarchar(255), null

CD key for the software product.

Description

nvarchar(max), null

Last note at an installation history record.

LicenceName

nvarchar(255), null

License name.

Publisher

nvarchar(255), null

Software manufacturer.

SoftwarePack

int, not null

The product is from the SW package.

Type

int, null

Software product type. 1 - commercial 2 - freeware 3 - shareware/trial 4 - not specified

User

int, null

Author of the product installation.

Comment

nvarchar(255), null

Installation comment.

Query.SwInstallationCsy

Software installation in ALVAO Asset Management - Installation Registry.
Installations on discarded and removed computers are not displayed.
Only the objects and property values are shown that the user connected to the database is authorized to read.
The view is used to create reports and analyses. If not stated otherwise, the data is shown in the ALVAO system language.

ColumnTypeDescription

Produkt

nvarchar(1023), null

Product name

Detekovaný název produktu

nvarchar(255), null

Detected product name

Detekovaná verze produktu

nvarchar(255), null

Detected product version

Id objektu

int, not null

Identification number of a computer that contains given installation.

Uživatel

nvarchar(255), null

User name under which the computer with the installed product is located in the objects tree.

Licence

nvarchar(255), null

License name

Počet přidělených licencí

int, not null

Number of assigned licenses

Typ licence

nvarchar(32), null

License type, e.g. "Normal", "Unlimited multilicense", "OEM", "Floating", ...

Stav licence

nvarchar(11), not null

License status. The column may have the following values "Without license" and "With license" (in Czech).

Stav licence - podrobný

nvarchar(255), null

Similar license status, e.g. "Missing", "Not necessary", "Assigned", "Shared".

Stav profilu

nvarchar(255), null

Profile status, e.g. "Disabled", "Optional", ...

Produkt nalezen (UTC)

datetime, null

Date and time when the product installation was detected on a computer.

Zjištěno odinstalování (UTC)

datetime, null

Date and time when the product uninstallation was detected on a computer.

Nainstalováno

datetime, null

Manually registered installation date

Odinstalováno

datetime, null

Manually registered uninstallation date

Produkt nalezen - Měsíc od (UTC)

datetime, null

Date of the first day of month when the installation was detected.

Zjištěno odinstalování - Měsíc od (UTC)

datetime, null

Date of the first day of month when the uninstallation was detected.

Nainstalováno - Měsíc od

datetime, null

Date of the first day of month when the installation was manually registered.

Odinstalováno - Měsíc od

datetime, null

Date of the first day of month when the uninstallation was manually registered.

Typ produktu

nvarchar(255), null

Product type, e.g. "commercial", "freeware", ...

Stav instalace

nvarchar(13), not null

Installation status. The column may have the following values "Installed" and "Uninstalled" (in Czech).

Nákladové středisko

nvarchar(255), null

Computer cost center

Operační systém

nvarchar(3), not null

It indicates whether the product is an operating system. The column may have the following values "Yes" and "No" (in Czech).

Query.SwInstallationDeu

Software installation in ALVAO Asset Management - Installation Registry.
Installations on discarded and removed computers are not displayed.
Only the objects and property values are shown that the user connected to the database is authorized to read.
The view is used to create reports and analyses. If not stated otherwise, the data is shown in the ALVAO system language.

ColumnTypeDescription

Produkt

nvarchar(1023), null

Product name

Detektiertes Produktname

nvarchar(255), null

Detected product name

Detektierte Produktversion

nvarchar(255), null

Detected product version

Objekt Id

int, not null

Identification number of a computer that contains given installation.

Benutzer

nvarchar(255), null

User name under which the computer with the installed product is located in the objects tree.

Lizenz

nvarchar(255), null

License name

Anzahl der zugeteilten Lizenzen

int, not null

Number of assigned licenses

Lizenztyp

nvarchar(32), null

License type, e.g. "Normal", "Unlimited multilicense", "OEM", "Floating", ...

Lizenz-Status

nvarchar(11), not null

License status. The column may have the following values "Without license" and "With license" (in Czech).

Lizenz-Status - detailliert

nvarchar(255), null

Similar license status, e.g. "Missing", "Not necessary", "Assigned", "Shared".

Profil-Status

nvarchar(255), null

Profile status, e.g. "Disabled", "Optional", ...

Produkt gefunden (UTC)

datetime, null

Date and time when the product installation was detected on a computer.

Deinstallation erkannt (UTC)

datetime, null

Date and time when the product uninstallation was detected on a computer.

Installiert

datetime, null

Manually registered installation date

Deinstalliert

datetime, null

Manually registered uninstallation date

Produkt gefunden - Monat beginnt (UTC)

datetime, null

Date of the first day of month when the installation was detected.

Deinstallation erkannt - Monat seit (UTC)

datetime, null

Date of the first day of month when the uninstallation was detected.

Installiert - Monat seit

datetime, null

Date of the first day of month when the installation was manually registered.

Deinstalliert - Monat seit

datetime, null

Date of the first day of month when the uninstallation was manually registered.

Produkttyp

nvarchar(255), null

Product type, e.g. "commercial", "freeware", ...

Installationsstatus

nvarchar(13), not null

Installation status. The column may have the following values "Installed" and "Uninstalled" (in Czech).

Kostenstelle

nvarchar(255), null

Computer cost center

Betriebssystem

nvarchar(4), not null

It indicates whether the product is an operating system. The column may have the following values "Yes" and "No" (in Czech).

Query.SwInstallationEnu

Software installation in ALVAO Asset Management - Installation Registry.
Installations on discarded and removed computers are not displayed.
Only the objects and property values are shown that the user connected to the database is authorized to read.
The view is used to create reports and analyses. If not stated otherwise, the data is shown in the ALVAO system language.

ColumnTypeDescription

Product

nvarchar(1023), null

Product name

Detected product name

nvarchar(255), null

Detected product name

Detected product version

nvarchar(255), null

Detected product version

Object id

int, not null

Identification number of a computer that contains given installation.

User

nvarchar(255), null

User name under which the computer with the installed product is located in the objects tree.

License

nvarchar(255), null

License name

Number of assigned licenses

int, not null

Number of assigned licenses

License type

nvarchar(32), null

License type, e.g. "Normal", "Unlimited multilicense", "OEM", "Floating", ...

License status

nvarchar(15), not null

License status. The column may have the following values "Without license" and "With license" (in Czech).

License status - detailed

nvarchar(255), null

Similar license status, e.g. "Missing", "Not necessary", "Assigned", "Shared".

Profile status

nvarchar(255), null

Profile status, e.g. "Disabled", "Optional", ...

Product found (UTC)

datetime, null

Date and time when the product installation was detected on a computer.

Software uninstallation detected (UTC)

datetime, null

Date and time when the product uninstallation was detected on a computer.

Installed

datetime, null

Manually registered installation date

Uninstalled

datetime, null

Manually registered uninstallation date

Product found date - Month starting (UTC)

datetime, null

Date of the first day of month when the installation was detected.

Uninstallation detected - Month from (UTC)

datetime, null

Date of the first day of month when the uninstallation was detected.

Installed - Month from

datetime, null

Date of the first day of month when the installation was manually registered.

Uninstalled - Month from

datetime, null

Date of the first day of month when the uninstallation was manually registered.

Product type

nvarchar(255), null

Product type, e.g. "commercial", "freeware", ...

Installation status

nvarchar(11), not null

Installation status. The column may have the following values "Installed" and "Uninstalled" (in Czech).

Cost center

nvarchar(255), null

Computer cost center

Operating system

nvarchar(3), not null

It indicates whether the product is an operating system. The column may have the following values "Yes" and "No" (in Czech).

Query.SwLicenseCsy

License in ALVAO Asset Management - License Registry.
Only the licenses, objects and property values are shown that the user connected to the database is authorized to read.
The view is used to create reports and analyses. If not stated otherwise, the data is shown in the ALVAO system language.

ColumnTypeDescription

Název licence

nvarchar(255), null

License name

Produkt

nvarchar(1023), null

Product name

Typ produktu

nvarchar(255), null

Product type, e.g. "commercial", "freeware", ...

Počet

int, null

Number of licenses. 1 for free floating unlimited multilicenses.

Stav přidělení

nvarchar(18), null

Assignment status. The column may have the following values "Assigned without reason", "Assigned" and "Free" (in Czech).

Typ licence

nvarchar(32), not null

License type, e.g. "Normal", "Unlimited multilicense", "OEM", "Floating", ...

Datum vytvoření (UTC)

datetime, null

License creation date and time

Datum vytvoření - Měsíc od (UTC)

datetime, null

Date of the first day of month when the license was created.

Vytvořil

nvarchar(255), null

User name of a person who created the license.

Platnost od

date, not null

Valid from

Platnost do

date, null

Valid to

Upgrade/Podpora do

date, null

End date of upgrade/support

Aktivační klíč licence

nvarchar(1024), null

License activation key

Inventární číslo licence

nvarchar(255), null

License inventory number

Licenční model

nvarchar(32), not null

CAL/Licensing, e.g. "to processor", "to user", "to device", ...

Nákladové středisko

nvarchar(255), not null

License cost center name

Uživatel

nvarchar(255), null

User name of a person whom the license is assigned to. NULL if the license is assigned to a computer.

Počítač

nvarchar(255), null

Name of a computer which the license is assigned to. NULL if the license is assigned to a user.

Id objektu

int, null

Object identification number the license is assigned to.

Query.SwLicenseDeu

License in ALVAO Asset Management - License Registry.
Only the licenses, objects and property values are shown that the user connected to the database is authorized to read.
The view is used to create reports and analyses. If not stated otherwise, the data is shown in the ALVAO system language.

ColumnTypeDescription

Lizenzname

nvarchar(255), null

License name

Produkt

nvarchar(1023), null

Product name

Produkttyp

nvarchar(255), null

Product type, e.g. "commercial", "freeware", ...

Anzahl

int, null

Number of licenses. 1 for free floating unlimited multilicenses.

Zuweisungsstatus

nvarchar(21), null

Assignment status. The column may have the following values "Assigned without reason", "Assigned" and "Free" (in Czech).

Lizenztyp

nvarchar(32), not null

License type, e.g. "Normal", "Unlimited multilicense", "OEM", "Floating", ...

Erstellungsdatum (UTC)

datetime, null

License creation date and time

Erstellungsdatum - Monat beginnt (UTC)

datetime, null

Date of the first day of month when the license was created.

Erstellt von

nvarchar(255), null

User name of a person who created the license.

Gültig ab

date, not null

Valid from

Gültig bis

date, null

Valid to

Upgrade/Support bis

date, null

End date of upgrade/support

Aktivierungsschlüssel der Lizenz

nvarchar(1024), null

License activation key

Inventarnummer der Lizenz

nvarchar(255), null

License inventory number

Lizenzmodell

nvarchar(32), not null

CAL/Licensing, e.g. "to processor", "to user", "to device", ...

Kostenstelle

nvarchar(255), not null

License cost center name

Benutzer

nvarchar(255), null

User name of a person whom the license is assigned to. NULL if the license is assigned to a computer.

Computer

nvarchar(255), null

Name of a computer which the license is assigned to. NULL if the license is assigned to a user.

Objekt Id

int, null

Object identification number the license is assigned to.

Query.SwLicenseEnu

License in ALVAO Asset Management - License Registry.
Only the licenses, objects and property values are shown that the user connected to the database is authorized to read.
The view is used to create reports and analyses. If not stated otherwise, the data is shown in the ALVAO system language.

ColumnTypeDescription

License name

nvarchar(255), null

License name

Product

nvarchar(1023), null

Product name

Product type

nvarchar(255), null

Product type, e.g. "commercial", "freeware", ...

Count

int, null

Number of licenses. 1 for free floating unlimited multilicenses.

Assignment status

nvarchar(23), null

Assignment status. The column may have the following values "Assigned without reason", "Assigned" and "Free" (in Czech).

License type

nvarchar(32), not null

License type, e.g. "Normal", "Unlimited multilicense", "OEM", "Floating", ...

Creation date (UTC)

datetime, null

License creation date and time

Creation date - Month starting (UTC)

datetime, null

Date of the first day of month when the license was created.

Created by

nvarchar(255), null

User name of a person who created the license.

Valid from

date, not null

Valid from

Valid to

date, null

Valid to

Upgrade/Support to

date, null

End date of upgrade/support

License activation key

nvarchar(1024), null

License activation key

License inventory number

nvarchar(255), null

License inventory number

License model

nvarchar(32), not null

CAL/Licensing, e.g. "to processor", "to user", "to device", ...

Cost center

nvarchar(255), not null

License cost center name

User

nvarchar(255), null

User name of a person whom the license is assigned to. NULL if the license is assigned to a computer.

Computer

nvarchar(255), null

Name of a computer which the license is assigned to. NULL if the license is assigned to a user.

Object id

int, null

Object identification number the license is assigned to.

Query.UserLogonLog

Provides the list of individual user log ins/outs to/from console applications.

ColumnTypeDescription

TimeStamp

datetime, not null

Date and time of the change execution.

Username

nvarchar(255), not null

The username of the user.

User

nvarchar(255), null

User name.

Action

nvarchar(50), null

Executed action - logon, logout.

Application

nvarchar(50), null

Name of the application in which he executed the action.

Computer

nvarchar(255), null

Name of the computer to which he logged in.

IsAdmin

bit, not null

Identifier of whether or not the user was logged in with the administrator permission.

Query.NodeDiary

Deprecated (The view will be removed in the following versions of ALVAO). Use the Query view instead.ObjectCsy,
or Query.ObjectEnu or Query.ObjectDeu) View with the log for objects.

ColumnTypeDescription

NodeId

int, null

Node ID of the object in the tree.

Subject

nvarchar(max), null

The text of the object log item title.

Date

datetime, null

Date of the record insert.

Flag

int, null

As far as the object history record is concerned, it contains the value determining the even kind. For more information, please refer to tblHistory.

Text

nvarchar(max), null

The text of the object log item.

Type

int, not null

0=object history, 1=object note.

Query.RequestCsy

Deprecated (The view will be removed in the following versions of ALVAO). Use the Query view instead Query.Request2Csy). Tickets in ALVAO Service Desk. Only tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Číslo požadavku

int, not null

The ticket identification number.

Nejvyšší požadavek

int, null

Identification number of the root parent ticket.

Nejvyšší služba

nvarchar(1024), null

Name of root service in the service tree.

Žadatel

nvarchar(255), null

First and last name of the requester.

Organizace (žadatel)

nvarchar(255), null

Name of the requester’s organization.

Služba

nvarchar(1024), null

Name of the service including the path in the tree.

Skupina

nvarchar(255), null

Název požadavku

nvarchar(1024), null

Řešitel

nvarchar(255), null

Name and surname of the solver.

Oddělení (řešitel)

nvarchar(255), null

Name of the solver’s department.

Oddělení (žadatel)

nvarchar(255), null

Name of the requester’s department

Funkce (řešitel)

nvarchar(255), null

Name of the solver’s job title.

Funkce (žadatel)

nvarchar(255), null

Name of the requester’s job title.

Interní cíl

nvarchar(255), null

Internal target name.

Interní cíl (termín) (UTC)

datetime, null

Priorita

nvarchar(max), null

Priority name.

Proces

nvarchar(255), null

Process name.

SLA

nvarchar(255), null

SLA name.

Stav

nvarchar(64), not null

Ticket status name.

Značka a název požadavku

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

Způsob podání

nvarchar(255), null

Ticket submission method, e.g., e-mail, phone, form.

Datum (UTC)

datetime, null

Date of ticket creation.

Týden od (UTC)

datetime, null

Date of the beginning of the week in which the ticket was created.

Měsíc od (UTC)

datetime, null

Date of the beginning of the month in which the ticket was created.

Rok (UTC)

int, null

Year of ticket creation.

Čtvrtletí (UTC)

int, null

Quarter in which the ticket was created (1-4).

Měsíc (UTC)

int, null

Month in which the ticket was created (1-12).

Týden (UTC)

int, null

Week of ticket creation (1-53).

Den v týdnu (UTC)

int, null

Day of the week of ticket creation (1-7).

Hodina (UTC)

int, null

Hour in which the ticket was created (0-23).

Hrubý stav

nvarchar(10), not null

Name of general status (Open, Resolved, Closed, Deleted)

Související organizace

nvarchar(255), not null

Name of the organization for which the ticket is being implemented.

Doba otevření (hodiny v provozní době)

float, not null

Time in hours from ticket creation until its closing, or until present, if the ticket is not closed.

První reakce (UTC)

datetime, null

Date and time of the first response performance.

První reakce - Měsíc od (UTC)

datetime, null

Date of the first day of month when the first response was performed.

První reakce - Týden od (UTC)

datetime, null

Date of the first day of week when the first response was performed.

Termín první reakce (UTC)

datetime, null

Date and time of the first response deadline according to SLA. If SLA is paused or the deadline is not determined, the value is null.

Doba do první reakce (hodiny v provozní době)

float, null

Time in hours from ticket creation until the first response performance. In case that the ticket does not have the first response completed, the value is null.

Plnění SLA - První reakce - Zbývá (hodiny v provozní době)

float, null

Time in hours representing the time until the first response deadline. In case that the date of the first response is not guaranteed or the first response has already been performed, the value is null.

Plnění SLA - První reakce - Měsíc od (UTC)

datetime, null

Date of the first day of month when the first response was or was to be performed (if not performed in time). In case that the date of the first response is not guaranteed, the value is null.

Plnění SLA - První reakce - Týden od (UTC)

datetime, null

Date of the first day of week when the first response was or was to be performed (if not performed in time). In case that the date of the first response is not guaranteed, the value is null.

Plnění SLA - První reakce

nvarchar(9), null

The "fulfilled" value if the first response deadline was fulfilled according to SLA. The "breached" value if the first response deadline was not fulfilled. The "null" value if the first response deadline is not guaranteed or if the first response has not been performed and the deadline according to SLA is not exceeded yet.

Vyřešeno (UTC)

datetime, null

Date and time of ticket solution.

Vyřešeno - Měsíc od (UTC)

datetime, null

Date of the first day of month when the ticket was solved.

Vyřešeno - Týden od (UTC)

datetime, null

Date of the first day of week when the ticket was solved.

Termín vyřešení (UTC)

datetime, null

Date and time of the solution deadline. If SLA is paused or the deadline is not determined, the value is null.

Doba do vyřešení (hodiny v provozní době)

float, null

Time in hours from ticket creation until it is resolved. In case that the ticket is not resolved, the value is null.

Plnění SLA - Vyřešení - Zbývá (hodiny v provozní době)

float, null

Time in hours representing the time until the ticket resolution deadline. In case that the date for ticket resolution is not guaranteed or the ticket has already been resolved, the value is null.

Plnění SLA - Vyřešení - Měsíc od (UTC)

datetime, null

Date of the first day of month when the ticket was or was to be resolved (if not resolved in time). In case that the date for ticket resolution is not guaranteed, the value is null.

Plnění SLA - Vyřešení - Týden od (UTC)

datetime, null

Date of the first day of week when the ticket was or was to be resolved (if not resolved in time). In case that the date for ticket resolution is not guaranteed, the value is null.

Plnění SLA - Vyřešení

nvarchar(9), null

The "fulfilled" value if the tickets resolution deadline was fulfilled according to SLA. The "breached" value if the solution deadline was not fulfilled. The "null" value if the ticket resolution deadline is not guaranteed or if the ticket has not been resolved and the resolution deadline according to SLA is not exceeded yet.

URL požadavku

nvarchar(2072), null

Ticket URL in ALVAO WebApp.

Pozastavení SLA (hodiny)

float, null

Number of hours of SLA pause being in progress (due to waiting for requester or ticket status).

Pozastaveno SLA (hodiny)

float, null

Total SLA pause time within a specific requirement in hours (including the currently running SLA pause).

Čekáno na žadatele (hodiny)

float, null

Total waiting time for requesters during the whole solution of a ticket, in hours, during the operating hours of the service.

Čekání na žadatele (hodiny)

float, null

Number of hours of waiting for requester being in progress.

Id žadatele

int, not null

Id řešitele

int, null

Id služby

int, not null

Id SLA

int, not null

Id organizace žadatele

int, null

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Request for HW - catalog path (služba)

nvarchar(max), null

Request for HW - categories (služba)

nvarchar(max), null

Request for HW - currency (služba)

nvarchar(256), null

Query.RequestDeu

Deprecated (The view will be removed in the following versions of ALVAO). Use the Query view instead Query.Request2Csy). Tickets in ALVAO Service Desk. Only tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Anfrage-Nummer

int, not null

The ticket identification number.

Höchste Anfrage

int, null

Identification number of the root parent ticket.

Höchster Service

nvarchar(1024), null

Name of root service in the service tree.

Anfragesteller

nvarchar(255), null

First and last name of the requester.

Organisation (Anfragesteller)

nvarchar(255), null

Name of the requester’s organization.

Service

nvarchar(1024), null

Name of the service including the path in the tree.

Gruppe

nvarchar(255), null

Name der Anfrage

nvarchar(1024), null

Bearbeiter

nvarchar(255), null

Name and surname of the solver.

Abteilung (Bearbeiter)

nvarchar(255), null

Name of the solver’s department.

Abteilung (Anfragesteller)

nvarchar(255), null

Name of the requester’s department

Funktion (Bearbeiter)

nvarchar(255), null

Name of the solver’s job title.

Funktion (Anfragesteller)

nvarchar(255), null

Name of the requester’s job title.

Internes Ziel

nvarchar(255), null

Internal target name.

Internes Ziel (Termin) (UTC)

datetime, null

Priorität

nvarchar(max), null

Priority name.

Prozess

nvarchar(255), null

Process name.

SLA

nvarchar(255), null

SLA name.

Status

nvarchar(64), not null

Ticket status name.

Zeichen und Name der Anfrage

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

Methode der Einreichung

nvarchar(255), null

Ticket submission method, e.g., e-mail, phone, form.

Datum (UTC)

datetime, null

Date of ticket creation.

Woche seit (UTC)

datetime, null

Date of the beginning of the week in which the ticket was created.

Monat seit (UTC)

datetime, null

Date of the beginning of the month in which the ticket was created.

Jahr (UTC)

int, null

Year of ticket creation.

Quartal (UTC)

int, null

Quarter in which the ticket was created (1-4).

Monat (UTC)

int, null

Month in which the ticket was created (1-12).

Woche (UTC)

int, null

Week of ticket creation (1-53).

Wochentag (UTC)

int, null

Day of the week of ticket creation (1-7).

Stunde (UTC)

int, null

Hour in which the ticket was created (0-23).

Gesamtstatus

nvarchar(13), not null

Name of general status (Open, Resolved, Closed, Deleted)

Zugehörige Organisationen

nvarchar(255), not null

Name of the organization for which the ticket is being implemented.

Öffnungszeit (Stunden innerhalb der Betriebszeit)

float, not null

Time in hours from ticket creation until its closing, or until present, if the ticket is not closed.

Erste Reaktion (UTC)

datetime, null

Date and time of the first response performance.

Erste Reaktion - Monat seit (UTC)

datetime, null

Date of the first day of month when the first response was performed.

Erste Reaktion - Woche seit (UTC)

datetime, null

Date of the first day of week when the first response was performed.

Termin der ersten Reaktion (UTC)

datetime, null

Date and time of the first response deadline according to SLA. If SLA is paused or the deadline is not determined, the value is null.

Zeit bis zur ersten Reaktion (Stunden innerhalb der Betriebszeit)

float, null

Time in hours from ticket creation until the first response performance. In case that the ticket does not have the first response completed, the value is null.

SLA-Einhaltung - Erste Reaktion - Verbleibend (Stunden in der Geschäftszeit)

float, null

Time in hours representing the time until the first response deadline. In case that the date of the first response is not guaranteed or the first response has already been performed, the value is null.

SLA-Einhaltung - Erste Reaktion - Monat beginnt (UTC)

datetime, null

Date of the first day of month when the first response was or was to be performed (if not performed in time). In case that the date of the first response is not guaranteed, the value is null.

SLA-Einhaltung - Erste Reaktion - Woche beginnt (UTC)

datetime, null

Date of the first day of week when the first response was or was to be performed (if not performed in time). In case that the date of the first response is not guaranteed, the value is null.

SLA-Einhaltung - Erste Reaktion

nvarchar(13), null

The "fulfilled" value if the first response deadline was fulfilled according to SLA. The "breached" value if the first response deadline was not fulfilled. The "null" value if the first response deadline is not guaranteed or if the first response has not been performed and the deadline according to SLA is not exceeded yet.

Gelöst (UTC)

datetime, null

Date and time of ticket solution.

Gelöst - Monat seit (UTC)

datetime, null

Date of the first day of month when the ticket was solved.

Gelöst - Woche seit (UTC)

datetime, null

Date of the first day of week when the ticket was solved.

Termin für die Lösung (UTC)

datetime, null

Date and time of the solution deadline. If SLA is paused or the deadline is not determined, the value is null.

Zeit bis zur Bearbeitung (Stunden innerhalb der Betriebszeit)

float, null

Time in hours from ticket creation until it is resolved. In case that the ticket is not resolved, the value is null.

SLA-Einhaltung - Lösung - Verbleibend (Stunden in der Geschäftszeit)

float, null

Time in hours representing the time until the ticket resolution deadline. In case that the date for ticket resolution is not guaranteed or the ticket has already been resolved, the value is null.

SLA-Einhaltung - Lösung - Monat beginnt (UTC)

datetime, null

Date of the first day of month when the ticket was or was to be resolved (if not resolved in time). In case that the date for ticket resolution is not guaranteed, the value is null.

SLA-Einhaltung - Lösung - Woche beginnt (UTC)

datetime, null

Date of the first day of week when the ticket was or was to be resolved (if not resolved in time). In case that the date for ticket resolution is not guaranteed, the value is null.

SLA-Einhaltung - Lösung

nvarchar(13), null

The "fulfilled" value if the tickets resolution deadline was fulfilled according to SLA. The "breached" value if the solution deadline was not fulfilled. The "null" value if the ticket resolution deadline is not guaranteed or if the ticket has not been resolved and the resolution deadline according to SLA is not exceeded yet.

URL der Anfrage

nvarchar(2072), null

Ticket URL in ALVAO WebApp.

SLA-Aussetzung (Stunden)

float, null

Number of hours of SLA pause being in progress (due to waiting for requester or ticket status).

SLA ausgesetzt (Stunden)

float, null

Total SLA pause time within a specific requirement in hours (including the currently running SLA pause).

Gewartet auf den Anfragesteller (Stunden)

float, null

Total waiting time for requesters during the whole solution of a ticket, in hours, during the operating hours of the service.

Warten auf den Anfragesteller (Stunden)

float, null

Number of hours of waiting for requester being in progress.

Id des Anfragestellers

int, not null

ID des Bearbeiters

int, null

Id des Service

int, not null

Id der SLA

int, not null

Id der Organisation des Anfragestellers

int, null

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Request for HW - catalog path (Service)

nvarchar(max), null

Request for HW - categories (Service)

nvarchar(max), null

Request for HW - currency (Service)

nvarchar(256), null

Query.RequestEnu

Deprecated (The view will be removed in the following versions of ALVAO). Use the Query view instead Query.Request2Csy). Tickets in ALVAO Service Desk. Only tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Request number

int, not null

The ticket identification number.

Highest request

int, null

Identification number of the root parent ticket.

Highest service

nvarchar(1024), null

Name of root service in the service tree.

Requester

nvarchar(255), null

First and last name of the requester.

Organization (requester)

nvarchar(255), null

Name of the requester’s organization.

Service

nvarchar(1024), null

Name of the service including the path in the tree.

Group

nvarchar(255), null

Request name

nvarchar(1024), null

Solver

nvarchar(255), null

Name and surname of the solver.

Department (solver)

nvarchar(255), null

Name of the solver’s department.

Department (requester)

nvarchar(255), null

Name of the requester’s department

Job title (solver)

nvarchar(255), null

Name of the solver’s job title.

Job title (requester)

nvarchar(255), null

Name of the requester’s job title.

Internal target

nvarchar(255), null

Internal target name.

Internal target (due date) (UTC)

datetime, null

Priority

nvarchar(max), null

Priority name.

Process

nvarchar(255), null

Process name.

SLA

nvarchar(255), null

SLA name.

Status

nvarchar(64), not null

Ticket status name.

Request tag and title

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

Submission method

nvarchar(255), null

Ticket submission method, e.g., e-mail, phone, form.

Date (UTC)

datetime, null

Date of ticket creation.

Week starting (UTC)

datetime, null

Date of the beginning of the week in which the ticket was created.

Month starting (UTC)

datetime, null

Date of the beginning of the month in which the ticket was created.

Year (UTC)

int, null

Year of ticket creation.

Quarter (UTC)

int, null

Quarter in which the ticket was created (1-4).

Month (UTC)

int, null

Month in which the ticket was created (1-12).

Week (UTC)

int, null

Week of ticket creation (1-53).

Weekday (UTC)

int, null

Day of the week of ticket creation (1-7).

Hour (UTC)

int, null

Hour in which the ticket was created (0-23).

Overall status

nvarchar(8), not null

Name of general status (Open, Resolved, Closed, Deleted)

Related organization

nvarchar(255), not null

Name of the organization for which the ticket is being implemented.

Opening time (hours during the operating hours)

float, not null

Time in hours from ticket creation until its closing, or until present, if the ticket is not closed.

First response (UTC)

datetime, null

Date and time of the first response performance.

First response - Month from (UTC)

datetime, null

Date of the first day of month when the first response was performed.

First response - Week from (UTC)

datetime, null

Date of the first day of week when the first response was performed.

First response deadline (UTC)

datetime, null

Date and time of the first response deadline according to SLA. If SLA is paused or the deadline is not determined, the value is null.

Time until the first response (hours during the operating hours)

float, null

Time in hours from ticket creation until the first response performance. In case that the ticket does not have the first response completed, the value is null.

SLA fulfilling - First response - Remaining (hours during the operating hours)

float, null

Time in hours representing the time until the first response deadline. In case that the date of the first response is not guaranteed or the first response has already been performed, the value is null.

SLA fulfilling - First response - Month from (UTC)

datetime, null

Date of the first day of month when the first response was or was to be performed (if not performed in time). In case that the date of the first response is not guaranteed, the value is null.

SLA fulfilling - First response - Week from (UTC)

datetime, null

Date of the first day of week when the first response was or was to be performed (if not performed in time). In case that the date of the first response is not guaranteed, the value is null.

SLA fulfilling - First response

nvarchar(13), null

The "fulfilled" value if the first response deadline was fulfilled according to SLA. The "breached" value if the first response deadline was not fulfilled. The "null" value if the first response deadline is not guaranteed or if the first response has not been performed and the deadline according to SLA is not exceeded yet.

Resolved (UTC)

datetime, null

Date and time of ticket solution.

Solved - Month from (UTC)

datetime, null

Date of the first day of month when the ticket was solved.

Solved - Week from (UTC)

datetime, null

Date of the first day of week when the ticket was solved.

Deadline for resolution (UTC)

datetime, null

Date and time of the solution deadline. If SLA is paused or the deadline is not determined, the value is null.

Time to resolve (hours during the operating hours)

float, null

Time in hours from ticket creation until it is resolved. In case that the ticket is not resolved, the value is null.

SLA fulfilling - Resolution - Remaining (hours during the operating hours)

float, null

Time in hours representing the time until the ticket resolution deadline. In case that the date for ticket resolution is not guaranteed or the ticket has already been resolved, the value is null.

SLA fulfilling - Resolution - Month from (UTC)

datetime, null

Date of the first day of month when the ticket was or was to be resolved (if not resolved in time). In case that the date for ticket resolution is not guaranteed, the value is null.

SLA fulfilling - Resolution - Week from (UTC)

datetime, null

Date of the first day of week when the ticket was or was to be resolved (if not resolved in time). In case that the date for ticket resolution is not guaranteed, the value is null.

SLA fulfilling - Resolution

nvarchar(13), null

The "fulfilled" value if the tickets resolution deadline was fulfilled according to SLA. The "breached" value if the solution deadline was not fulfilled. The "null" value if the ticket resolution deadline is not guaranteed or if the ticket has not been resolved and the resolution deadline according to SLA is not exceeded yet.

Request URL

nvarchar(2072), null

Ticket URL in ALVAO WebApp.

SLA pause (hours)

float, null

Number of hours of SLA pause being in progress (due to waiting for requester or ticket status).

SLA paused (hours)

float, null

Total SLA pause time within a specific requirement in hours (including the currently running SLA pause).

Waited for requester (hours)

float, null

Total waiting time for requesters during the whole solution of a ticket, in hours, during the operating hours of the service.

Waiting for requester (hours)

float, null

Number of hours of waiting for requester being in progress.

Requester ID

int, not null

Solver ID

int, null

Service ID

int, not null

SLA ID

int, not null

Requesters organization ID

int, null

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Request for HW - catalog path (service)

nvarchar(max), null

Request for HW - categories (service)

nvarchar(max), null

Request for HW - currency (service)

nvarchar(256), null

Query.RequestFirstReactionCsy

Deprecated (The view will be removed in the following versions of ALVAO). Use the Query view instead Query.Request2Csy). First response of the solver team in tickets within the ALVAO Service Desk. The first response is the first message which the service vendor gave to the customer on receipt of their ticket. Only tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Číslo požadavku

int, not null

The ticket identification number.

Nejvyšší požadavek

int, null

Identification number of the root linked parent ticket.

Název požadavku

nvarchar(1024), null

Značka a název požadavku

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

Služba

nvarchar(1024), null

Name of the service including the path in the tree.

Nejvyšší služba

nvarchar(1024), null

Name of root service in the service tree.

SLA

nvarchar(255), null

SLA name.

Žadatel

nvarchar(255), null

First and last name of the requester.

Organizace (žadatel)

nvarchar(255), null

Name of the requester’s organization.

Datum (UTC)

datetime, null

Date of first reaction.

Týden od (UTC)

datetime, null

Date of the beginning of the week of the first reaction.

Měsíc od (UTC)

datetime, null

Date of the beginning of the month of the first reaction.

Rok (UTC)

int, null

Year of the first reaction.

Čtvrtletí (UTC)

int, null

Quarter of the first reaction.

Měsíc (UTC)

int, null

Month of the first reaction.

Týden (UTC)

int, null

Week of the first reaction.

Hodina (UTC)

int, null

Hour of the first reaction.

Termín (UTC)

datetime, null

Interní cíl

nvarchar(255), null

Internal target name.

Interní cíl (termín) (UTC)

datetime, null

Doba do reakce (hodiny)

float, null

Hours until first reaction.

Překročení SLA (hodiny)

float, null

By how many hours was the SLA first reaction deadline exceeded.

Splnění SLA (hodiny)

float, null

How many hours earlier was the first reaction met than as required by the SLA limit.

Řešitel

nvarchar(255), null

Name and surname of the current solver.

Reagoval

nvarchar(255), null

Name and surname of the solver who completed the first reaction.

Reagoval (oddělení)

nvarchar(255), null

Name of the department of the solver who completed the first reaction.

Reagoval (funkce)

nvarchar(255), null

Name of the job title of the solver who completed the first reaction.

Reagoval (organizace)

nvarchar(255), null

Name of the organization of the solver who completed the first reaction.

Související organizace

nvarchar(255), not null

Name of the organization for which the ticket is being implemented.

Proces

nvarchar(255), null

Process name.

Id žadatele

int, not null

Id řešitele

int, null

Id služby

int, not null

Id SLA

int, not null

Id organizace žadatele

int, null

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Request for HW - catalog path (služba)

nvarchar(max), null

Request for HW - categories (služba)

nvarchar(max), null

Request for HW - currency (služba)

nvarchar(256), null

Query.RequestFirstReactionDeu

Deprecated (The view will be removed in the following versions of ALVAO). Use the Query view instead Query.Request2Csy). First response of the solver team in tickets within the ALVAO Service Desk. The first response is the first message which the service vendor gave to the customer on receipt of their ticket. Only tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Anfrage-Nummer

int, not null

The ticket identification number.

Höchste Anfrage

int, null

Identification number of the root linked parent ticket.

Name der Anfrage

nvarchar(1024), null

Zeichen und Name der Anfrage

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

Service

nvarchar(1024), null

Name of the service including the path in the tree.

Höchster Service

nvarchar(1024), null

Name of root service in the service tree.

SLA

nvarchar(255), null

SLA name.

Anfragesteller

nvarchar(255), null

First and last name of the requester.

Organisation (Anfragesteller)

nvarchar(255), null

Name of the requester’s organization.

Datum (UTC)

datetime, null

Date of first reaction.

Woche seit (UTC)

datetime, null

Date of the beginning of the week of the first reaction.

Monat seit (UTC)

datetime, null

Date of the beginning of the month of the first reaction.

Jahr (UTC)

int, null

Year of the first reaction.

Quartal (UTC)

int, null

Quarter of the first reaction.

Monat (UTC)

int, null

Month of the first reaction.

Woche (UTC)

int, null

Week of the first reaction.

Stunde (UTC)

int, null

Hour of the first reaction.

Termin (UTC)

datetime, null

Internes Ziel

nvarchar(255), null

Internal target name.

Internes Ziel (Termin) (UTC)

datetime, null

Zeit bis zur Reaktion (Stunden)

float, null

Hours until first reaction.

Überschreitung der SLA (Stunden)

float, null

By how many hours was the SLA first reaction deadline exceeded.

Erfüllung von SLA (Stunden)

float, null

How many hours earlier was the first reaction met than as required by the SLA limit.

Bearbeiter

nvarchar(255), null

Name and surname of the current solver.

Reagiert

nvarchar(255), null

Name and surname of the solver who completed the first reaction.

Reagiert (Abteilung)

nvarchar(255), null

Name of the department of the solver who completed the first reaction.

Reagiert (Funktion)

nvarchar(255), null

Name of the job title of the solver who completed the first reaction.

Reagiert (Organisation)

nvarchar(255), null

Name of the organization of the solver who completed the first reaction.

Zugehörige Organisationen

nvarchar(255), not null

Name of the organization for which the ticket is being implemented.

Prozess

nvarchar(255), null

Process name.

Id des Anfragestellers

int, not null

ID des Bearbeiters

int, null

Id des Service

int, not null

Id der SLA

int, not null

Id der Organisation des Anfragestellers

int, null

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Request for HW - catalog path (Service)

nvarchar(max), null

Request for HW - categories (Service)

nvarchar(max), null

Request for HW - currency (Service)

nvarchar(256), null

Query.RequestFirstReactionEnu

Deprecated (The view will be removed in the following versions of ALVAO). Use the Query view instead Query.Request2Csy). First response of the solver team in tickets within the ALVAO Service Desk. The first response is the first message which the service vendor gave to the customer on receipt of their ticket. Only tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Request number

int, not null

The ticket identification number.

Highest request

int, null

Identification number of the root linked parent ticket.

Request name

nvarchar(1024), null

Request tag and title

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

Service

nvarchar(1024), null

Name of the service including the path in the tree.

Highest service

nvarchar(1024), null

Name of root service in the service tree.

SLA

nvarchar(255), null

SLA name.

Requester

nvarchar(255), null

First and last name of the requester.

Organization (requester)

nvarchar(255), null

Name of the requester’s organization.

Date (UTC)

datetime, null

Date of first reaction.

Week starting (UTC)

datetime, null

Date of the beginning of the week of the first reaction.

Month starting (UTC)

datetime, null

Date of the beginning of the month of the first reaction.

Year (UTC)

int, null

Year of the first reaction.

Quarter (UTC)

int, null

Quarter of the first reaction.

Month (UTC)

int, null

Month of the first reaction.

Week (UTC)

int, null

Week of the first reaction.

Hour (UTC)

int, null

Hour of the first reaction.

Due date (UTC)

datetime, null

Internal target

nvarchar(255), null

Internal target name.

Internal target (due date) (UTC)

datetime, null

Time until response (hours)

float, null

Hours until first reaction.

SLA breached by (hours)

float, null

By how many hours was the SLA first reaction deadline exceeded.

Time until SLA breach (hours)

float, null

How many hours earlier was the first reaction met than as required by the SLA limit.

Solver

nvarchar(255), null

Name and surname of the current solver.

Responded

nvarchar(255), null

Name and surname of the solver who completed the first reaction.

Responded (department)

nvarchar(255), null

Name of the department of the solver who completed the first reaction.

Responded (position)

nvarchar(255), null

Name of the job title of the solver who completed the first reaction.

Responded (organization)

nvarchar(255), null

Name of the organization of the solver who completed the first reaction.

Related organization

nvarchar(255), not null

Name of the organization for which the ticket is being implemented.

Process

nvarchar(255), null

Process name.

Requester ID

int, not null

Solver ID

int, null

Service ID

int, not null

SLA ID

int, not null

Requesters organization ID

int, null

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Request for HW - catalog path (service)

nvarchar(max), null

Request for HW - categories (service)

nvarchar(max), null

Request for HW - currency (service)

nvarchar(256), null

Query.RequestLogCsy

Deprecated (The view will be removed in the following versions of ALVAO). Use the Query view instead Query.RequestLogRecordCsy). Records in ticket logs in ALVAO Service Desk. Only records for tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Číslo požadavku

int, not null

The ticket identification number.

Název požadavku

nvarchar(1024), null

Služba

nvarchar(1024), null

Name of the service including the path in the tree.

SLA

nvarchar(255), null

SLA name.

Řešitel

nvarchar(255), null

Name and surname of the solver.

Datum (UTC)

datetime, null

Date of record creation.

Datum účinnosti (UTC)

datetime, null

In case of records of retrospective resolution of tickets, this column specifies the date of retrospective resolution. For other records, the same value is listed as in the Date (UTC) column.

Týden od (UTC)

datetime, null

Date of the beginning of the week in which the record was created.

Měsíc od (UTC)

datetime, null

Date of the beginning of the month in which the record was created.

Rok (UTC)

int, null

Year of record creation.

Čtvrtletí (UTC)

int, null

The quarter in which the record was created (1-4).

Měsíc (UTC)

int, null

Month in which the record was created (1-12).

Týden (UTC)

int, null

Week of record creation (1-53).

Hodina (UTC)

int, null

Hour in which the record was created (0-23).

Od

nvarchar(255), null

Name and surname of the person who created the record.

Čas celkem (hodiny)

float, not null

Total recorded time (Work + Travel time), in hours.

Značka a název požadavku

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

Žadatel

nvarchar(255), null

First and last name of the requester.

Oddělení (žadatel)

nvarchar(255), null

Name of the requester’s department.

Organizace (žadatel)

nvarchar(255), null

Name of the requester’s organization.

Pracovní pozice (žadatel)

nvarchar(255), null

Name of the requester’s job title.

Práce (hodiny)

float, null

Reported work in hours.

Čas na cestě (hodiny)

float, null

Reported time spent on trip in hours.

Vzdálenost (km)

float, null

Reported distance in km.

Druh

nvarchar(255), null

Type of record (e-mail, note, ...).

Nejvyšší požadavek

int, null

Identification number of the root parent ticket.

Nejvyšší služba

nvarchar(1024), null

Name of root service in the service tree.

Nefakturovat

bit, not null

The "Exclude from invoice to the requester" flag.

Předmět

nvarchar(max), null

Subject of the record in the log.

Stav

nvarchar(64), not null

Ticket status name.

Termín (UTC)

datetime, null

Interní cíl

nvarchar(255), null

Internal target name.

Interní cíl (termín) (UTC)

datetime, null

Související organizace

nvarchar(255), not null

Name of the organization for which the ticket is being implemented.

Proces

nvarchar(255), null

Process name.

Id žadatele

int, not null

Id řešitele

int, null

Id služby

int, not null

Id SLA

int, not null

Id organizace žadatele

int, null

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Request for HW - catalog path (služba)

nvarchar(max), null

Request for HW - categories (služba)

nvarchar(max), null

Request for HW - currency (služba)

nvarchar(256), null

Query.RequestLogDeu

Deprecated (The view will be removed in the following versions of ALVAO). Use the Query view instead Query.RequestLogRecordCsy). Records in ticket logs in ALVAO Service Desk. Only records for tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Anfrage-Nummer

int, not null

The ticket identification number.

Name der Anfrage

nvarchar(1024), null

Service

nvarchar(1024), null

Name of the service including the path in the tree.

SLA

nvarchar(255), null

SLA name.

Bearbeiter

nvarchar(255), null

Name and surname of the solver.

Datum (UTC)

datetime, null

Date of record creation.

Datum der Wirksamkeit (UTC)

datetime, null

In case of records of retrospective resolution of tickets, this column specifies the date of retrospective resolution. For other records, the same value is listed as in the Date (UTC) column.

Woche seit (UTC)

datetime, null

Date of the beginning of the week in which the record was created.

Monat seit (UTC)

datetime, null

Date of the beginning of the month in which the record was created.

Jahr (UTC)

int, null

Year of record creation.

Quartal (UTC)

int, null

The quarter in which the record was created (1-4).

Monat (UTC)

int, null

Month in which the record was created (1-12).

Woche (UTC)

int, null

Week of record creation (1-53).

Stunde (UTC)

int, null

Hour in which the record was created (0-23).

Von

nvarchar(255), null

Name and surname of the person who created the record.

Zeit gesamt (Stunden)

float, not null

Total recorded time (Work + Travel time), in hours.

Zeichen und Name der Anfrage

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

Anfragesteller

nvarchar(255), null

First and last name of the requester.

Abteilung (Anfragesteller)

nvarchar(255), null

Name of the requester’s department.

Organisation (Anfragesteller)

nvarchar(255), null

Name of the requester’s organization.

Arbeitsposition (Anfragesteller)

nvarchar(255), null

Name of the requester’s job title.

Arbeit (Stunden)

float, null

Reported work in hours.

Fahrzeit (Stunden)

float, null

Reported time spent on trip in hours.

Entfernung (km)

float, null

Reported distance in km.

Typ

nvarchar(255), null

Type of record (e-mail, note, ...).

Höchste Anfrage

int, null

Identification number of the root parent ticket.

Höchster Service

nvarchar(1024), null

Name of root service in the service tree.

Nicht in Rechnung stellen

bit, not null

The "Exclude from invoice to the requester" flag.

Betreff

nvarchar(max), null

Subject of the record in the log.

Status

nvarchar(64), not null

Ticket status name.

Termin (UTC)

datetime, null

Internes Ziel

nvarchar(255), null

Internal target name.

Internes Ziel (Termin) (UTC)

datetime, null

Zugehörige Organisationen

nvarchar(255), not null

Name of the organization for which the ticket is being implemented.

Prozess

nvarchar(255), null

Process name.

Id des Anfragestellers

int, not null

ID des Bearbeiters

int, null

Id des Service

int, not null

Id der SLA

int, not null

Id der Organisation des Anfragestellers

int, null

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Request for HW - catalog path (Service)

nvarchar(max), null

Request for HW - categories (Service)

nvarchar(max), null

Request for HW - currency (Service)

nvarchar(256), null

Query.RequestLogEnu

Deprecated (The view will be removed in the following versions of ALVAO). Use the Query view instead Query.RequestLogRecordCsy). Records in ticket logs in ALVAO Service Desk. Only records for tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Request number

int, not null

The ticket identification number.

Request name

nvarchar(1024), null

Service

nvarchar(1024), null

Name of the service including the path in the tree.

SLA

nvarchar(255), null

SLA name.

Solver

nvarchar(255), null

Name and surname of the solver.

Date (UTC)

datetime, null

Date of record creation.

Efective date (UTC)

datetime, null

In case of records of retrospective resolution of tickets, this column specifies the date of retrospective resolution. For other records, the same value is listed as in the Date (UTC) column.

Week starting (UTC)

datetime, null

Date of the beginning of the week in which the record was created.

Month starting (UTC)

datetime, null

Date of the beginning of the month in which the record was created.

Year (UTC)

int, null

Year of record creation.

Quarter (UTC)

int, null

The quarter in which the record was created (1-4).

Month (UTC)

int, null

Month in which the record was created (1-12).

Week (UTC)

int, null

Week of record creation (1-53).

Hour (UTC)

int, null

Hour in which the record was created (0-23).

From

nvarchar(255), null

Name and surname of the person who created the record.

Total time (hours)

float, not null

Total recorded time (Work + Travel time), in hours.

Request tag and title

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

Requester

nvarchar(255), null

First and last name of the requester.

Department (requester)

nvarchar(255), null

Name of the requester’s department.

Organization (requester)

nvarchar(255), null

Name of the requester’s organization.

Job title (requestor)

nvarchar(255), null

Name of the requester’s job title.

Work (hours)

float, null

Reported work in hours.

Time traveled (hours)

float, null

Reported time spent on trip in hours.

Distance (km)

float, null

Reported distance in km.

Kind

nvarchar(255), null

Type of record (e-mail, note, ...).

Highest request

int, null

Identification number of the root parent ticket.

Highest service

nvarchar(1024), null

Name of root service in the service tree.

Exclude from invoice

bit, not null

The "Exclude from invoice to the requester" flag.

Subject

nvarchar(max), null

Subject of the record in the log.

Status

nvarchar(64), not null

Ticket status name.

Due date (UTC)

datetime, null

Internal target

nvarchar(255), null

Internal target name.

Internal target (due date) (UTC)

datetime, null

Related organization

nvarchar(255), not null

Name of the organization for which the ticket is being implemented.

Process

nvarchar(255), null

Process name.

Requester ID

int, not null

Solver ID

int, null

Service ID

int, not null

SLA ID

int, not null

Requesters organization ID

int, null

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Request for HW - catalog path (service)

nvarchar(max), null

Request for HW - categories (service)

nvarchar(max), null

Request for HW - currency (service)

nvarchar(256), null

Query.RequestResolutionCsy

Deprecated (The view will be removed in the following versions of ALVAO). Use the Query view instead Query.Request2Csy). Solution of tickets in ALVAO Service Desk. Only tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Číslo požadavku

int, not null

The ticket identification number.

Název požadavku

nvarchar(1024), null

Služba

nvarchar(1024), null

Name of the service including the path in the tree.

SLA

nvarchar(255), null

SLA name.

Žadatel

nvarchar(255), null

First and last name of the requester.

Organizace (žadatel)

nvarchar(255), null

Name of the requester’s organization.

Řešitel

nvarchar(255), null

Name and surname of the solver.

Datum (UTC)

datetime, null

Date for ticket resolution.

Týden od (UTC)

datetime, null

Date of the beginning of the week in which the ticket was solved.

Měsíc od (UTC)

datetime, null

Date of the beginning of the month in which the ticket was solved.

Rok (UTC)

int, null

Year of ticket resolution.

Čtvrtletí (UTC)

int, null

Quarter in which the ticket was resolved (1-4).

Měsíc (UTC)

int, null

Month in which the ticket was resolved (1-12).

Týden (UTC)

int, null

Week of ticket resolution (1-53).

Den v týdnu (UTC)

int, null

Day of the week of ticket solution (1-7).

Hodina (UTC)

int, null

Hour in which the ticket was resolved(0-23).

Značka a název požadavku

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

Nejvyšší požadavek

int, null

Identification number of the root parent ticket.

Nejvyšší služba

nvarchar(1024), null

Name of root service in the service tree.

Čekáno na žadatele (hodiny)

float, null

Total waiting time for requesters during the whole solution of a ticket, in hours, during the operating hours of the service.

Pozastaveno SLA (hodiny)

float, null

Total SLA pause time within a specific requirement in hours (including the currently running SLA pause).

Doba do vyřešení (hodiny)

float, not null

Hours from the creation to the resolution of the ticket during the operating hours of the service.

Termín (UTC)

datetime, null

Interní cíl

nvarchar(255), null

Internal target name.

Interní cíl (termín) (UTC)

datetime, null

Překročení SLA (hodiny)

float, null

By how many hours was the deadline for solving the ticket as per SLA exceeded.

Splnění SLA (hodiny)

float, null

How many hours earlier the ticket was resolved than the SLA limit.

Překročení termínu (hodiny)

float, null

By how many hours was the deadline for resolution of the ticket exceeded (Ticket - Due date).

Splnění termínu (hodiny)

float, null

How many hours earlier the ticket was resolved than the value listed in the Ticket - Due date field.

Související organizace

nvarchar(255), not null

Name of the organization for which the ticket is being implemented.

Proces

nvarchar(255), null

Process name.

Rychlost řešení

float, null

Satisfaction survey - Resolution speed field.

Profesionalita

float, null

Satisfaction survey - Professionalism field.

Odbornost

float, null

Satisfaction survey - Expertise field.

Komentáře a poznámky

nvarchar(max), null

Satisfaction survey - Comments and remarks field.

Celková spokojenost

float, null

Satisfaction survey - General satisfaction field.

Id žadatele

int, not null

Id řešitele

int, null

Id služby

int, not null

Id SLA

int, not null

Id organizace žadatele

int, null

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Request for HW - catalog path (služba)

nvarchar(max), null

Request for HW - categories (služba)

nvarchar(max), null

Request for HW - currency (služba)

nvarchar(256), null

Query.RequestResolutionDeu

Deprecated (The view will be removed in the following versions of ALVAO). Use the Query view instead Query.Request2Csy). Solution of tickets in ALVAO Service Desk. Only tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Anfrage-Nummer

int, not null

The ticket identification number.

Name der Anfrage

nvarchar(1024), null

Service

nvarchar(1024), null

Name of the service including the path in the tree.

SLA

nvarchar(255), null

SLA name.

Anfragesteller

nvarchar(255), null

First and last name of the requester.

Organisation (Anfragesteller)

nvarchar(255), null

Name of the requester’s organization.

Bearbeiter

nvarchar(255), null

Name and surname of the solver.

Datum (UTC)

datetime, null

Date for ticket resolution.

Woche seit (UTC)

datetime, null

Date of the beginning of the week in which the ticket was solved.

Monat seit (UTC)

datetime, null

Date of the beginning of the month in which the ticket was solved.

Jahr (UTC)

int, null

Year of ticket resolution.

Quartal (UTC)

int, null

Quarter in which the ticket was resolved (1-4).

Monat (UTC)

int, null

Month in which the ticket was resolved (1-12).

Woche (UTC)

int, null

Week of ticket resolution (1-53).

Wochentag (UTC)

int, null

Day of the week of ticket solution (1-7).

Stunde (UTC)

int, null

Hour in which the ticket was resolved(0-23).

Zeichen und Name der Anfrage

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

Höchste Anfrage

int, null

Identification number of the root parent ticket.

Höchster Service

nvarchar(1024), null

Name of root service in the service tree.

Gewartet auf den Anfragesteller (Stunden)

float, null

Total waiting time for requesters during the whole solution of a ticket, in hours, during the operating hours of the service.

SLA ausgesetzt (Stunden)

float, null

Total SLA pause time within a specific requirement in hours (including the currently running SLA pause).

Zeit bis zur Lösung (Stunden)

float, not null

Hours from the creation to the resolution of the ticket during the operating hours of the service.

Termin (UTC)

datetime, null

Internes Ziel

nvarchar(255), null

Internal target name.

Internes Ziel (Termin) (UTC)

datetime, null

Überschreitung der SLA (Stunden)

float, null

By how many hours was the deadline for solving the ticket as per SLA exceeded.

Erfüllung von SLA (Stunden)

float, null

How many hours earlier the ticket was resolved than the SLA limit.

Überschreitung des Termins (Stunden)

float, null

By how many hours was the deadline for resolution of the ticket exceeded (Ticket - Due date).

Erfüllung des Termins (Stunden)

float, null

How many hours earlier the ticket was resolved than the value listed in the Ticket - Due date field.

Zugehörige Organisationen

nvarchar(255), not null

Name of the organization for which the ticket is being implemented.

Prozess

nvarchar(255), null

Process name.

Schnelligkeit der Bearbeitung

float, null

Satisfaction survey - Resolution speed field.

Professionalität

float, null

Satisfaction survey - Professionalism field.

Fachkompetenz

float, null

Satisfaction survey - Expertise field.

Kommentare und Anmerkungen

nvarchar(max), null

Satisfaction survey - Comments and remarks field.

Gesamtzufriedenheit

float, null

Satisfaction survey - General satisfaction field.

Id des Anfragestellers

int, not null

ID des Bearbeiters

int, null

Id des Service

int, not null

Id der SLA

int, not null

Id der Organisation des Anfragestellers

int, null

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Request for HW - catalog path (Service)

nvarchar(max), null

Request for HW - categories (Service)

nvarchar(max), null

Request for HW - currency (Service)

nvarchar(256), null

Query.RequestResolutionEnu

Deprecated (The view will be removed in the following versions of ALVAO). Use the Query view instead Query.Request2Csy). Solution of tickets in ALVAO Service Desk. Only tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Request number

int, not null

The ticket identification number.

Request name

nvarchar(1024), null

Service

nvarchar(1024), null

Name of the service including the path in the tree.

SLA

nvarchar(255), null

SLA name.

Requester

nvarchar(255), null

First and last name of the requester.

Organization (requester)

nvarchar(255), null

Name of the requester’s organization.

Solver

nvarchar(255), null

Name and surname of the solver.

Date (UTC)

datetime, null

Date for ticket resolution.

Week starting (UTC)

datetime, null

Date of the beginning of the week in which the ticket was solved.

Month starting (UTC)

datetime, null

Date of the beginning of the month in which the ticket was solved.

Year (UTC)

int, null

Year of ticket resolution.

Quarter (UTC)

int, null

Quarter in which the ticket was resolved (1-4).

Month (UTC)

int, null

Month in which the ticket was resolved (1-12).

Week (UTC)

int, null

Week of ticket resolution (1-53).

Weekday (UTC)

int, null

Day of the week of ticket solution (1-7).

Hour (UTC)

int, null

Hour in which the ticket was resolved(0-23).

Request tag and title

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

Highest request

int, null

Identification number of the root parent ticket.

Highest service

nvarchar(1024), null

Name of root service in the service tree.

Waited for requester (hours)

float, null

Total waiting time for requesters during the whole solution of a ticket, in hours, during the operating hours of the service.

SLA paused (hours)

float, null

Total SLA pause time within a specific requirement in hours (including the currently running SLA pause).

Time to resolve (hours)

float, not null

Hours from the creation to the resolution of the ticket during the operating hours of the service.

Due date (UTC)

datetime, null

Internal target

nvarchar(255), null

Internal target name.

Internal target (due date) (UTC)

datetime, null

SLA breached by (hours)

float, null

By how many hours was the deadline for solving the ticket as per SLA exceeded.

Time until SLA breach (hours)

float, null

How many hours earlier the ticket was resolved than the SLA limit.

Exceeding of due date (hours)

float, null

By how many hours was the deadline for resolution of the ticket exceeded (Ticket - Due date).

Meeting of due date (hours)

float, null

How many hours earlier the ticket was resolved than the value listed in the Ticket - Due date field.

Related organization

nvarchar(255), not null

Name of the organization for which the ticket is being implemented.

Process

nvarchar(255), null

Process name.

Resolution speed

float, null

Satisfaction survey - Resolution speed field.

Professionalism

float, null

Satisfaction survey - Professionalism field.

Expertise

float, null

Satisfaction survey - Expertise field.

Comments and notes

nvarchar(max), null

Satisfaction survey - Comments and remarks field.

Overall satisfaction

float, null

Satisfaction survey - General satisfaction field.

Requester ID

int, not null

Solver ID

int, null

Service ID

int, not null

SLA ID

int, not null

Requesters organization ID

int, null

Problem candidate

bit, null

Incident closure code

nvarchar(max), null

Symptoms

nvarchar(max), null

Diagnostic Activities

nvarchar(max), null

Root cause

nvarchar(max), null

Workaround

nvarchar(max), null

Method of resolution

nvarchar(max), null

Problem closure code

nvarchar(max), null

Five Whys

nvarchar(256), null

Change end (scheduled)

datetime, null

Change start (scheduled)

datetime, null

Level of risks

nvarchar(max), null

Change end (actual)

datetime, null

Change start (actual)

datetime, null

Risk description

nvarchar(256), null

Successful change

bit, null

Overran change window

bit, null

Departure

datetime, null

Return

datetime, null

Purpose of trip

nvarchar(256), null

Means of transport

nvarchar(256), null

Name

nvarchar(256), null

Surname

nvarchar(256), null

Department

nvarchar(max), null

Position name

nvarchar(max), null

Manager

int, null

Site

nvarchar(max), null

Period

nvarchar(max), null

Number of months

nvarchar(max), null

First Day

date, null

Standard laptop kit (includes docking station, display, headphones, ergomouse)

bit, null

Standard desktop kit (includes display, headphones, ergomouse)

bit, null

Standard mobile phone kit (includes SIM card)

bit, null

Company car

bit, null

Other training

nvarchar(256), null

Describe potential specific requirements

nvarchar(max), null

Mobile package

nvarchar(max), null

URL

nvarchar(256), null

Request for HW - catalog path (service)

nvarchar(max), null

Request for HW - categories (service)

nvarchar(max), null

Request for HW - currency (service)

nvarchar(256), null

Query.RequestStatusCsy

Deprecated (The view will be removed in the following versions of ALVAO). Use the Query view instead Query.RequestChangeCsy). Arrivals to individual ticket statuses. Only status changes of tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Číslo požadavku

int, not null

The ticket identification number.

Značka a název požadavku

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

Služba

nvarchar(1024), null

Name of the service including the path in the tree.

Proces

nvarchar(255), null

Process name.

Stav

nvarchar(64), not null

Ticket status name.

Přechod do stavu (UTC)

datetime, null

Date when the ticket was transited to the status.

Přechod ze stavu (UTC)

datetime, null

Date when the ticket transited from the status.

Týden od (UTC)

datetime, null

Date of the beginning of the week in which the ticket was created.

Měsíc od (UTC)

datetime, null

Date of the beginning of the month in which the ticket was created.

Rok (UTC)

int, null

Year of ticket creation.

Doba ve stavu (hodiny)

float, null

Time in hours for which the ticket was in status.

Doba ve stavu (hodiny v provozní době)

float, not null

Time in hours for which the ticket was in status in the operating hours.

Query.RequestStatusDeu

Deprecated (The view will be removed in the following versions of ALVAO). Use the Query view instead Query.RequestChangeCsy). Arrivals to individual ticket statuses. Only status changes of tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Anfrage-Nummer

int, not null

The ticket identification number.

Zeichen und Name der Anfrage

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

Service

nvarchar(1024), null

Name of the service including the path in the tree.

Prozess

nvarchar(255), null

Process name.

Status

nvarchar(64), not null

Ticket status name.

Übergang in den Status (UTC)

datetime, null

Date when the ticket was transited to the status.

Übergang aus dem Status (UTC)

datetime, null

Date when the ticket transited from the status.

Woche seit (UTC)

datetime, null

Date of the beginning of the week in which the ticket was created.

Monat seit (UTC)

datetime, null

Date of the beginning of the month in which the ticket was created.

Jahr (UTC)

int, null

Year of ticket creation.

Zeit in dem Status (Stunden)

float, null

Time in hours for which the ticket was in status.

Zeit in dem Status (Stunden innerhalb der Betriebszeit)

float, not null

Time in hours for which the ticket was in status in the operating hours.

Query.RequestStatusEnu

Deprecated (The view will be removed in the following versions of ALVAO). Use the Query view instead Query.RequestChangeCsy). Arrivals to individual ticket statuses. Only status changes of tickets from services where the user has been connected to the database by a member of the solver team or by a reader are displayed. The view is used to create reports and analyses.

ColumnTypeDescription

Request number

int, not null

The ticket identification number.

Request tag and title

nvarchar(1282), null

Tag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".

Service

nvarchar(1024), null

Name of the service including the path in the tree.

Process

nvarchar(255), null

Process name.

Status

nvarchar(64), not null

Ticket status name.

Transition to status (UTC)

datetime, null

Date when the ticket was transited to the status.

Transition from status (UTC)

datetime, null

Date when the ticket transited from the status.

Week starting (UTC)

datetime, null

Date of the beginning of the week in which the ticket was created.

Month starting (UTC)

datetime, null

Date of the beginning of the month in which the ticket was created.

Year (UTC)

int, null

Year of ticket creation.

Time in status (hours)

float, null

Time in hours for which the ticket was in status.

Time in status (hours during the operating hours)

float, not null

Time in hours for which the ticket was in status in the operating hours.