Skip to main content

Report views

Query.DiskDriveCsy​

HD drives in the ALVAO Asset Management in details of HW detection.
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 objektuint, not nullObject identification number of a Computer type that contains a given drive.
Logický disknvarchar(255), nullLogical drive name, e.g. "C:".
Kapacita (GB)float, nullDrive capacity
Využito (GB)float, nullUsed drive space
Volné místo (GB)float, nullFree drive space
Volné místo (%)float, nullThe percentage of free space and drive capacity
BitLockernvarchar(12), not nullIt 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.
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 Idint, not nullObject identification number of a Computer type that contains a given drive.
Logische Plattenvarchar(255), nullLogical drive name, e.g. "C:".
Kapazität (GB)float, nullDrive capacity
Verwendeter Speicherplatz (GB)float, nullUsed drive space
Freier Speicherplatz (GB)float, nullFree drive space
Freier Speicherplatz (%)float, nullThe percentage of free space and drive capacity
BitLockernvarchar(18), not nullIt 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.
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 idint, not nullObject identification number of a Computer type that contains a given drive.
Logical drivenvarchar(255), nullLogical drive name, e.g. "C:".
Capacity (GB)float, nullDrive capacity
Utilized (GB)float, nullUsed drive space
Total free space (GB)float, nullFree drive space
Free space (%)float, nullThe percentage of free space and drive capacity
BitLockernvarchar(14), not nullIt 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, nullDocument issue date (without time)
Datum vystavení - Měsíc oddatetime, nullDate of the first day of month when the document was issued.
Typ dokumentunvarchar(255), nullDocument type
Identifikační číslonvarchar(255), nullDocument identification number
Dodavatelnvarchar(255), nullThe vendor name (Document type = Invoice)
Předávajícínvarchar(255), nullThe name or title of the person handing over (Document type = Handover protocol)
Přebírajícínvarchar(255), nullThe name or title of the accepting person (Document type = Handover protocol)
Identifikační číslo 2nvarchar(255), nullDocument identification number 2
Poznámkanvarchar(max), nullNote
Zneplatněn (UTC)datetime, nullDate and time of document record voiding in AM
Vytvořilnvarchar(255), nullUser name of a person who created the document record in AM.
Zneplatnilnvarchar(255), nullUser name of a person who made the document record in AM void.
Urlnvarchar(2086), nullURL 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
Ausgabedatumdatetime, nullDocument issue date (without time)
Ausgabedatum - Monat beginntdatetime, nullDate of the first day of month when the document was issued.
Dokumenttypnvarchar(255), nullDocument type
Identifikationsnummernvarchar(255), nullDocument identification number
Lieferantnvarchar(255), nullThe vendor name (Document type = Invoice)
Übergebende Personnvarchar(255), nullThe name or title of the person handing over (Document type = Handover protocol)
Annehmende Personnvarchar(255), nullThe name or title of the accepting person (Document type = Handover protocol)
Identifikationsnummer 2nvarchar(255), nullDocument identification number 2
Anmerkungnvarchar(max), nullNote
Ungültig gemacht (UTC)datetime, nullDate and time of document record voiding in AM
Erstellt vonnvarchar(255), nullUser name of a person who created the document record in AM.
Ungültig gemacht vonnvarchar(255), nullUser name of a person who made the document record in AM void.
Urlnvarchar(2086), nullURL 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 datedatetime, nullDocument issue date (without time)
Issue date - Month startingdatetime, nullDate of the first day of month when the document was issued.
Document typenvarchar(255), nullDocument type
Identification numbernvarchar(255), nullDocument identification number
Vendornvarchar(255), nullThe vendor name (Document type = Invoice)
Person handing overnvarchar(255), nullThe name or title of the person handing over (Document type = Handover protocol)
Person acceptingnvarchar(255), nullThe name or title of the accepting person (Document type = Handover protocol)
Identification number 2nvarchar(255), nullDocument identification number 2
Notenvarchar(max), nullNote
Voided (UTC)datetime, nullDate and time of document record voiding in AM
Created bynvarchar(255), nullUser name of a person who created the document record in AM.
Voided bynvarchar(255), nullUser name of a person who made the document record in AM void.
Urlnvarchar(2086), nullURL of the document page in the web app.

Query.ExecutedSoftwareEnu​

Software run on computers in ALVAO Asset Management. Hidden 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 Idint, not nullComputer identification number (tblNode.intNodeId)
Computernvarchar(255), nullComputer name
Usernvarchar(255), nullThe name of the user who has the computer in use.
Filenamenvarchar(511), nullThe name of the running file, including the extension
Pathnvarchar(255), nullThe file location on your computer's file system
Size (B)int, nullFile size in bytes
File versionnvarchar(255), nullFile version
File descriptionnvarchar(255), nullFile Description
Productnvarchar(255), nullProduct name
Product versionnvarchar(255), nullProduct version
Companynvarchar(255), nullProduct manufacturer
Last rundatetime, nullThe date and time of the last start in the time zone of the computer detected
Run countint, nullTotal 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
TimeStampdatetime, not nullChange performance date and time (UTC)
ModifiedByPersonnvarchar(518), not nullThe name of the user who did the change.
HdSectionnvarchar(1287), nullService name
HdSectionOldnvarchar(1287), nullOriginal service name
Rolenvarchar(518), nullUser group name which is the permission holder.
RoleOldnvarchar(518), nullUser group name of a person who was originally a permission holder.
Personnvarchar(518), nullUser name of a person who is the permission holder.
PersonOldnvarchar(518), nullUser name of a person who was originally a permission holder.
Operatorint, nullMain solver permissions
OperatorOldint, nullOriginal main solver permissions
Solverint, nullSolver permissions
SolverOldint, nullOriginal solver permissions
SolverTake1int, nullSolver permissions with the right to take the ticket over (main)
SolverTake1Oldint, nullOriginal solver permissions with the right to take the ticket over (main)
SolverTake2int, nullSolver permissions with the right to take the ticket over (secondary)
SolverTake2Oldint, nullOriginal solver permissions with the right to take the ticket over (secondary)
Managerint, nullManager permissions
ManagerOldint, nullOriginal manager permissions
Readerint, nullReader permissions
ReaderOldint, nullOriginal reader permissions
ExceptionalSolverint, nullExceptional solver permissions
ExceptionalSolverOldint, nullOriginal exceptional solver permissions
IrregularOperatorint, nullPermissions of the ticket reporter (formerly of the irregular operator)
IrregularOperatorOldint, nullThe original permissions of the ticket reporter (formerly of irregular operator)
RequesterRolenvarchar(518), nullName of the group of requesters associated with the permissions (mapping of requesters to the solver team).
RequesterRoleOldnvarchar(518), nullName 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
ChildNodeIdint, not nullNode ID of the object in the tree.
ParentNodeIdint, not nullNode ID of the parent object in the tree.

Query.NodeRightLog​

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

ColumnTypeDescription
TimeStampdatetime, not nullDate and time of the change execution.
ModifiedBynvarchar(255), not nullLogged-in user name.
Usernvarchar(255), nullUser name.
Groupnvarchar(255), nullGroup name.
Objectnvarchar(255), nullObject name.
ObjectOldnvarchar(255), nullObject name - the previous value.
Recursivebit, not nullCheck box including of child objects.
RecursiveOldbit, nullCheck box including of child objects - the previous value.
Classnvarchar(255), nullObject type name.
ClassOldnvarchar(255), nullObject type name - the previous value.
Readbit, nullPermission to read.
ReadOldbit, nullPermission to read - the previous value.
Writebit, nullPermission to edit.
WriteOldbit, nullPermission to edit - the previous value.
Movebit, nullPermission to move.
MoveOldbit, nullPermission to move - the previous value.
Createbit, nullPermission to create any objects.
CreateOldbit, nullPermission to create any objects - the previous value.
Deletebit, nullPermission to delete.
DeleteOldbit, nullPermission to delete - the previous value.

Query.ObjectCsy​

Objects in ALVAO Asset Management. Hidden 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 objektuint, not nullObject identification number (tblNode.intNodeId)
Název objektunvarchar(255), nullObject name
Druh objektunvarchar(max), nullObject kind
Cesta ve stromunvarchar(1024), nullPath in tree (without the object name). Contains an empty chain for root objects.
Id rodičeint, nullId of parent object.
Objekt typu počítačnvarchar(3), not nullIt 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, nullObject creation date and time
Vytvořeno - Měsíc od (UTC)datetime, nullDate of the first day of month when the object was created.
Upozorněnínvarchar(max), nullNotification of unfilled mandatory object properties.
LinkDiagramUrlnvarchar(2083), nullURL of the object diagram page.
Urlnvarchar(2072), nullURL of the object page.
Název v sítinvarchar(255), null
Inventární číslonvarchar(255), null
Sériové číslonvarchar(255), null
Výrobcenvarchar(255), null
Datum nákupudate, null
Cenanvarchar(255), null
Modelnvarchar(255), null
Záruka dodate, null
Operační systémnvarchar(255), null
Poznámkanvarchar(255), null
Názevnvarchar(255), null
Dodavatelnvarchar(255), null
Číslo dodacího listunvarchar(255), null
IP adresanvarchar(255), null
Popisnvarchar(255), null
Množstvínvarchar(255), null
Naposled importováno z ADdate, null
IP adresynvarchar(255), null
Naposled přihlášený uživatel (uživatelské jméno)nvarchar(255), null
MAC adresynvarchar(255), null
Počet pevných diskůfloat, null
Počet logických jader CPUnvarchar(255), null
Počet fyzických jader CPUnvarchar(255), null
Součástí doménynvarchar(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řediskonvarchar(255), null
Sériové číslo BIOSunvarchar(255), null
Druh skříněnvarchar(255), null
Číslo smlouvynvarchar(255), null
Stav smlouvynvarchar(255), null
Procesornvarchar(255), null
Úhlopříčkanvarchar(255), null
Grafická kartanvarchar(255), null
Typ monitorunvarchar(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í obrazovkynvarchar(255), null
Velikostnvarchar(255), null
Platnost oddate, null
Platnost dodate, null
Adresanvarchar(255), null
Oddělenínvarchar(255), null
Hostitelský počítačnvarchar(255), null
IMEInvarchar(255), null
MAC adresanvarchar(255), null
Pořadínvarchar(255), null
Kód organizacenvarchar(255), null
Název organizacenvarchar(255), null
Za majetek zodpovídáint, null
Skupiny uživatelůnvarchar(255), null
Účet je zablokovánnvarchar(255), null
Azure SQL Databázenvarchar(255), null
Azure SQL Servernvarchar(255), null
Azure účet úložištěnvarchar(255), null
Budovanvarchar(255), null
Městonvarchar(255), null
Barvanvarchar(255), null
Společnostnvarchar(255), null
Zeměnvarchar(255), null
Rozhraní diskunvarchar(255), null
Divizenvarchar(255), null
E-mailnvarchar(255), null
Faxnvarchar(255), null
Poschodínvarchar(255), null
Skryté vlastnostinvarchar(255), null
Telefon domůnvarchar(255), null
IP telefonnvarchar(255), null
Klíč odnvarchar(255), null
Registrační značkanvarchar(255), null
Typ paměťové kartynvarchar(255), null
Mobilnvarchar(255), null
Kancelářnvarchar(255), null
Pagernvarchar(255), null
Osobní číslonvarchar(255), null
Telefonnvarchar(255), null
Telefonní číslonvarchar(255), null
Poštovní přihrádkanvarchar(255), null
Funkcenvarchar(255), null
Skupina prostředkůnvarchar(255), null
Místnostnvarchar(255), null
Název serverové farmynvarchar(255), null
Pracovištěnvarchar(255), null
Okresnvarchar(255), null
Ulicenvarchar(255), null
Odbornvarchar(255), null
Pobočkanvarchar(255), null
Tarifnvarchar(255), null
STK platné dodate, null
Uživatelnvarchar(255), null
Uživatelské jménonvarchar(255), null
Pracovní místonvarchar(255), null
PSČnvarchar(255), null

Query.ObjectDeu​

Objects in ALVAO Asset Management. Hidden 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 Idint, not nullObject identification number (tblNode.intNodeId)
Objektnamenvarchar(255), nullObject name
Objekttypnvarchar(max), nullObject kind
Pfad im Objektbaumnvarchar(1024), nullPath in tree (without the object name). Contains an empty chain for root objects.
Übergeordnete IDint, nullId of parent object.
Objekt des Computertypesnvarchar(4), not nullIt indicates whether the given object is of Computer type. The column may have the following values "Yes" and "No" (in Czech).
Erstellt (UTC)datetime, nullObject creation date and time
Erstellt - Monat beginnt (UTC)datetime, nullDate of the first day of month when the object was created.
Hinweisnvarchar(max), nullNotification of unfilled mandatory object properties.
LinkDiagramUrlnvarchar(2083), nullURL of the object diagram page.
Urlnvarchar(2072), nullURL of the object page.
Name im Netzwerknvarchar(255), null
Inventarnummernvarchar(255), null
Seriennummernvarchar(255), null
Herstellernvarchar(255), null
Kaufdatumdate, null
Preisnvarchar(255), null
Modelnvarchar(255), null
Garantie bisdate, null
Betriebssystemnvarchar(255), null
Anmerkungnvarchar(255), null
Bezeichnungnvarchar(255), null
Lieferantnvarchar(255), null
Lieferscheinnummernvarchar(255), null
IP-Adressenvarchar(255), null
Beschreibungnvarchar(255), null
Mengenvarchar(255), null
Zuletzt aus AD importiertdate, null
Adresse-IPnvarchar(255), null
Letzter angemeldeter Benutzer (Benutzername)nvarchar(255), null
MAC Adressennvarchar(255), null
Anzahl Festplattenfloat, null
Anzahl der CPU Logikkernenvarchar(255), null
Anzahl der CPU Physickernenvarchar(255), null
Domäne-Komponentenvarchar(255), null
Verantwortlich für die Softwarenvarchar(255), null
RAM-Speichergröße (GB)float, null
Total storage capacity (GB)float, null
Kostenstellenvarchar(255), null
BIOS-Seriennummernvarchar(255), null
Gehäusetypnvarchar(255), null
Vertragsnummernvarchar(255), null
Vertragsstatusnvarchar(255), null
Prozessornvarchar(255), null
Diagonalenvarchar(255), null
Grafikkartenvarchar(255), null
Bildschirmtypnvarchar(255), null
Auf das Ende der Gültigkeit im Voraus hinweisen (Tage)float, null
Anzahl Prozessorenfloat, null
Zahlungsperiode (Monate)float, null
Bildschirm-Auflösungnvarchar(255), null
Größenvarchar(255), null
Gültig abdate, null
Gültig bisdate, null
Adressenvarchar(255), null
Abteilungnvarchar(255), null
Host-Computernvarchar(255), null
IMEInvarchar(255), null
MAC-Adressenvarchar(255), null
Reihenfolgenvarchar(255), null
Code der Organisationnvarchar(255), null
Name der Organisationnvarchar(255), null
Verantwortlich für Vermögensgegenstandint, null
Benutzergruppennvarchar(255), null
Das Konto ist gesperrtnvarchar(255), null
Azure SQL-Datenbanknvarchar(255), null
Azure SQL Servernvarchar(255), null
Azure Speicherkontonvarchar(255), null
Gebäudenvarchar(255), null
Stadtnvarchar(255), null
Farbenvarchar(255), null
Unternehmennvarchar(255), null
Landnvarchar(255), null
Plattenschnittstellenvarchar(255), null
Geschäftsbereichnvarchar(255), null
E-Mailnvarchar(255), null
Faxnvarchar(255), null
Etagenvarchar(255), null
Versteckte Eigenschaftennvarchar(255), null
Telefon Privatnvarchar(255), null
IP-Telefonnvarchar(255), null
Schlüssel vonnvarchar(255), null
Amtliches Kennzeichennvarchar(255), null
Speicherkartentypnvarchar(255), null
Mobilnvarchar(255), null
Büronvarchar(255), null
Pagernvarchar(255), null
Personalnummernvarchar(255), null
Telefonnvarchar(255), null
Telefonnummernvarchar(255), null
Postfachnvarchar(255), null
Positionnvarchar(255), null
Azure Ressourcengruppenvarchar(255), null
Raumnvarchar(255), null
Name der Serverfarmnvarchar(255), null
Arbeitsstellenvarchar(255), null
Bezirknvarchar(255), null
Straßenvarchar(255), null
Spartenvarchar(255), null
Niederlassungnvarchar(255), null
Tarifnvarchar(255), null
Technische Prüfung gültig bisdate, null
Benutzernvarchar(255), null
Benutzernamenvarchar(255), null
Arbeitsstationnvarchar(255), null
PLZnvarchar(255), null

Query.ObjectEnu​

Objects in ALVAO Asset Management. Hidden 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 idint, not nullObject identification number (tblNode.intNodeId)
Object namenvarchar(255), nullObject name
Object kindnvarchar(max), nullObject kind
Path in treenvarchar(1024), nullPath in tree (without the object name). Contains an empty chain for root objects.
Parent idint, nullId of parent object.
Object of Computer typenvarchar(3), not nullIt indicates whether the given object is of Computer type. The column may have the following values "Yes" and "No" (in Czech).
Created (UTC)datetime, nullObject creation date and time
Created - Month starting (UTC)datetime, nullDate of the first day of month when the object was created.
Warningnvarchar(max), nullNotification of unfilled mandatory object properties.
LinkDiagramUrlnvarchar(2083), nullURL of the object diagram page.
Urlnvarchar(2072), nullURL of the object page.
Hostnamenvarchar(255), null
Inventory numbernvarchar(255), null
Serial numbernvarchar(255), null
Manufacturernvarchar(255), null
Purchase datedate, null
Pricenvarchar(255), null
Modelnvarchar(255), null
Warranty expirationdate, null
Operating systemnvarchar(255), null
Notenvarchar(255), null
Namenvarchar(255), null
Vendornvarchar(255), null
Packing slip numbernvarchar(255), null
IP addressnvarchar(255), null
Descriptionnvarchar(255), null
Quantitynvarchar(255), null
Last imported from ADdate, null
IP addressesnvarchar(255), null
Last logged-on user (user name)nvarchar(255), null
MAC addressesnvarchar(255), null
Number of hard drivesfloat, null
Number of logical CPU coresnvarchar(255), null
Number of physical CPU coresnvarchar(255), null
Part of the domainnvarchar(255), null
Person responsible for softwarenvarchar(255), null
RAM size (GB)float, null
Total storage capacity (GB)float, null
Cost centernvarchar(255), null
BIOS serial numbernvarchar(255), null
Case kindnvarchar(255), null
Contract numbernvarchar(255), null
Contract statusnvarchar(255), null
CPUnvarchar(255), null
Diagonalnvarchar(255), null
Graphic cardnvarchar(255), null
Monitor typenvarchar(255), null
Notify of the end of validity in advance (days)float, null
Number of processorsfloat, null
Payment period (months)float, null
Screen resolutionnvarchar(255), null
Sizenvarchar(255), null
Valid fromdate, null
Valid todate, null
Addressnvarchar(255), null
Departmentnvarchar(255), null
Host computernvarchar(255), null
IMEInvarchar(255), null
MAC addressnvarchar(255), null
Ordernvarchar(255), null
Organization codenvarchar(255), null
Organization namenvarchar(255), null
Person responsible for assetint, null
User Groupsnvarchar(255), null
Account is disablednvarchar(255), null
Azure SQL Databasenvarchar(255), null
Azure SQL Servernvarchar(255), null
Azure Storage Accountnvarchar(255), null
Buildingnvarchar(255), null
Citynvarchar(255), null
Colornvarchar(255), null
Companynvarchar(255), null
Countrynvarchar(255), null
Disk interfacenvarchar(255), null
Divisionnvarchar(255), null
E-mailnvarchar(255), null
Faxnvarchar(255), null
Floornvarchar(255), null
Hidden propertiesnvarchar(255), null
Home phonenvarchar(255), null
IP phonenvarchar(255), null
Key fornvarchar(255), null
License Plate Numbernvarchar(255), null
Memory card typenvarchar(255), null
Mobile phonenvarchar(255), null
Officenvarchar(255), null
Pagernvarchar(255), null
Personal numbernvarchar(255), null
Phonenvarchar(255), null
Phone numbernvarchar(255), null
PO Boxnvarchar(255), null
Positionnvarchar(255), null
Resource groupnvarchar(255), null
Roomnvarchar(255), null
Server farm namenvarchar(255), null
Sitenvarchar(255), null
State or Provincenvarchar(255), null
Streetnvarchar(255), null
Subdivisionnvarchar(255), null
Subsidiarynvarchar(255), null
Tariffnvarchar(255), null
Technical inspection valid untildate, null
Usernvarchar(255), null
User namenvarchar(255), null
Workstationnvarchar(255), null
ZIP codenvarchar(255), null

Query.ObjectLastDetectionCsy​

Last detection of a specific computer in ALVAO Asset Management.
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 objektuint, not nullObject identification number
Datum poslední detekce HW (UTC)datetime, nullLast HW detection date and time
Datum poslední detekce HW - Měsíc od (UTC)datetime, nullDate of the first day of month when the last HW detection was performed.
Datum poslední detekce SW (UTC)datetime, nullLast SW detection date and time
Datum poslední detekce SW - Měsíc od (UTC)datetime, nullDate of the first day of month when the last SW detection was performed.
Stáří poslední detekce HWnvarchar(16), not nullLast 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 SWnvarchar(16), not nullLast 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 HWnvarchar(64), nullLast HW detection method
Metoda poslední detekce SWnvarchar(64), nullLast SW detection method

Query.ObjectLastDetectionDeu​

Last detection of a specific computer in ALVAO Asset Management.
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 Idint, not nullObject identification number
Letztes HW-Detektionsdatum (UTC)datetime, nullLast HW detection date and time
Letztes HW-Detektionsdatum - Monat beginnt (UTC)datetime, nullDate of the first day of month when the last HW detection was performed.
Letztes SW-Detektionsdatum (UTC)datetime, nullLast SW detection date and time
Letztes SW-Detektionsdatum - Monat beginnt (UTC)datetime, nullDate of the first day of month when the last SW detection was performed.
Alter der letzten HW-Detektionnvarchar(16), not nullLast 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-Erkennungsalternvarchar(16), not nullLast 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-Erkennungsmethodenvarchar(64), nullLast HW detection method
Letzte SW-Erkennungsmethodenvarchar(64), nullLast SW detection method

Query.ObjectLastDetectionEnu​

Last detection of a specific computer in ALVAO Asset Management.
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 idint, not nullObject identification number
Last HW detection date (UTC)datetime, nullLast HW detection date and time
Last HW detection date - Month starting (UTC)datetime, nullDate of the first day of month when the last HW detection was performed.
Last SW detection date (UTC)datetime, nullLast SW detection date and time
Last SW detection date - Month starting (UTC)datetime, nullDate of the first day of month when the last SW detection was performed.
Last HW detection agenvarchar(17), not nullLast 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 agenvarchar(17), not nullLast 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 methodnvarchar(64), nullLast HW detection method
Last SW detection methodnvarchar(64), nullLast SW detection method

Query.ObjectLogCsy​

Object log in ALVAO Asset Management, see WebApp - Object - Log tab.
The records of hidden 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 objektuint, nullObject identification number associated to the record.
Nadpisnvarchar(max), nullRecord title
Zprávanvarchar(max), nullRecord text
Datum záznamu (UTC)datetime, nullRecord creation date and time
Datum záznamu - Měsíc od (UTC)datetime, nullDate of the first day of month when the record was created.
Datum záznamu - Týden od (UTC)datetime, nullDate of the first day of week when the record was created.
Datum záznamu - Rokint, nullYear of record creation
Datum záznamu - Měsícint, nullMonth of record creation.
Uživatelnvarchar(255), nullUser name of a person who created the record.
Druh záznamunvarchar(max), nullRecord kind

Query.ObjectLogDeu​

Object log in ALVAO Asset Management, see WebApp - Object - Log tab.
The records of hidden 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 Idint, nullObject identification number associated to the record.
Titelnvarchar(max), nullRecord title
Nachrichtnvarchar(max), nullRecord text
Aufnahmedatum (UTC)datetime, nullRecord creation date and time
Aufnahmedatum - Monat beginnt (UTC)datetime, nullDate of the first day of month when the record was created.
Datum des Eintrags - Woche seit (UTC)datetime, nullDate of the first day of week when the record was created.
Datum des Eintrags - Jahrint, nullYear of record creation
Datum des Eintrags - Monatint, nullMonth of record creation.
Benutzernvarchar(255), nullUser name of a person who created the record.
Aufzeichnungstypnvarchar(max), nullRecord kind

Query.ObjectLogEnu​

Object log in ALVAO Asset Management, see WebApp - Object - Log tab.
The records of hidden 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 idint, nullObject identification number associated to the record.
Titlenvarchar(max), nullRecord title
Messagenvarchar(max), nullRecord text
Record date (UTC)datetime, nullRecord creation date and time
Record date - Month starting (UTC)datetime, nullDate of the first day of month when the record was created.
Record date - Week starting (UTC)datetime, nullDate of the first day of week when the record was created.
Record date - Yearint, nullYear of record creation
Record date - Monthint, nullMonth of record creation.
Usernvarchar(255), nullUser name of a person who created the record.
Record kindnvarchar(max), nullRecord 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
PersonIdint, nullIdentification number of the person, see Query.PersonEnu.id
ObjectIdint, nullThe 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
idint, not nullThe organization ID number from dbo.tAccount table.
Názevnvarchar(255), not nullOrganization name
IČOnvarchar(20), nullCompany ID - company identification number
DIČnvarchar(20), nullVAT ID - value added tax identification number
Telefonnvarchar(30), nullOrganization telephone
Telefon 2nvarchar(30), nullOrganization telephone 2
E-mailnvarchar(50), nullOrganization e-mail
E-mail 2nvarchar(50), nullOrganization e-mail 2
Faxnvarchar(30), nullOrganization fax
Webnvarchar(50), nullOrganization website
Adresanvarchar(max), nullOrganization address
Adresa 2nvarchar(max), nullOrganization address 2
Urlnvarchar(2080), nullURL of the organization page
AdminUrlnvarchar(2082), nullURL 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
idint, not nullThe organization ID number from dbo.tAccount table.
Bezeichnungnvarchar(255), not nullOrganization name
IdNr.nvarchar(20), nullCompany ID - company identification number
UID-Nr.nvarchar(20), nullVAT ID - value added tax identification number
Telefonnvarchar(30), nullOrganization telephone
Telefon 2nvarchar(30), nullOrganization telephone 2
E-Mailnvarchar(50), nullOrganization e-mail
E-Mail 2nvarchar(50), nullOrganization e-mail 2
Faxnvarchar(30), nullOrganization fax
Webnvarchar(50), nullOrganization website
Adressenvarchar(max), nullOrganization address
Adresse 2nvarchar(max), nullOrganization address 2
Urlnvarchar(2080), nullURL of the organization page
AdminUrlnvarchar(2082), nullURL 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
idint, not nullThe organization ID number from dbo.tAccount table.
Namenvarchar(255), not nullOrganization name
Company IDnvarchar(20), nullCompany ID - company identification number
VAT IDnvarchar(20), nullVAT ID - value added tax identification number
Phonenvarchar(30), nullOrganization telephone
Phone 2nvarchar(30), nullOrganization telephone 2
E-mailnvarchar(50), nullOrganization e-mail
E-mail 2nvarchar(50), nullOrganization e-mail 2
Faxnvarchar(30), nullOrganization fax
Websitenvarchar(50), nullOrganization website
Addressnvarchar(max), nullOrganization address
Address 2nvarchar(max), nullOrganization address 2
Urlnvarchar(2080), nullURL of the organization page
AdminUrlnvarchar(2082), nullURL 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
idint, not nullIdentification number of the person - see dbo.tPerson.iPersonId.
Jméno a příjmenínvarchar(255), nullName and Surname
Mobilnvarchar(255), nullMobile phone
E-mailnvarchar(255), nullE-mail
E-mail 2nvarchar(255), nullE-mail 2
Telefon do zaměstnánínvarchar(255), nullWork phone
Telefon do zaměstnání 2nvarchar(255), nullWork phone 2
Další kontaktynvarchar(max), nullOther contacts
Oddělenínvarchar(255), nullDepartment
Funkcenvarchar(255), nullPosition
Kancelářnvarchar(255), nullOffice
Osobní číslonvarchar(255), nullPersonal number
Preferovaný jazyknvarchar(255), nullThe name of the preferred language of the person
Časové pásmonvarchar(64), nullThe name of the time zone
OrganizationIdint, nullThe person’s organization ID number - see Query.Organization{locale}.id.
ManagerPersonIdint, nullThe manager ID number - see Query.Person{locale}.id.
DeputyPersonIdint, nullThe ID number of the person’s substitute - see Query.Person{locale}.id.
Zablokovánbit, not nullBlocked user
Sdílenýbit, not nullShared account
Skrytý v nabídkáchbit, not nullUser hidden in menus
Odstraněnýdatetime, nullDeleted user
AdminUrlnvarchar(2074), nullURL of the user page in the administration
Urlnvarchar(2079), nullURL 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
idint, not nullIdentification number of the person - see dbo.tPerson.iPersonId.
Vorname und Namenvarchar(255), nullName and Surname
Mobilnvarchar(255), nullMobile phone
E-Mailnvarchar(255), nullE-mail
E-Mail 2nvarchar(255), nullE-mail 2
Telefon Arbeitsortnvarchar(255), nullWork phone
Telefon Arbeitsort 2nvarchar(255), nullWork phone 2
Andere Kontaktenvarchar(max), nullOther contacts
Abteilungnvarchar(255), nullDepartment
Positionnvarchar(255), nullPosition
Büronvarchar(255), nullOffice
Personalnummernvarchar(255), nullPersonal number
Bevorzugte Sprachenvarchar(255), nullThe name of the preferred language of the person
Zeitzonenvarchar(64), nullThe name of the time zone
OrganizationIdint, nullThe person’s organization ID number - see Query.Organization{locale}.id.
ManagerPersonIdint, nullThe manager ID number - see Query.Person{locale}.id.
DeputyPersonIdint, nullThe ID number of the person’s substitute - see Query.Person{locale}.id.
Blockiertbit, not nullBlocked user
Mitgeteiltbit, not nullShared account
Verdeckt im Angebotbit, not nullUser hidden in menus
Entferntdatetime, nullDeleted user
AdminUrlnvarchar(2074), nullURL of the user page in the administration
Urlnvarchar(2079), nullURL 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
idint, not nullIdentification number of the person - see dbo.tPerson.iPersonId.
Name and Surnamenvarchar(255), nullName and Surname
Mobile phonenvarchar(255), nullMobile phone
E-mailnvarchar(255), nullE-mail
E-mail 2nvarchar(255), nullE-mail 2
Work phonenvarchar(255), nullWork phone
Work phone 2nvarchar(255), nullWork phone 2
Other contactsnvarchar(max), nullOther contacts
Departmentnvarchar(255), nullDepartment
Positionnvarchar(255), nullPosition
Officenvarchar(255), nullOffice
Personal numbernvarchar(255), nullPersonal number
Preferred languagenvarchar(255), nullThe name of the preferred language of the person
Time zonenvarchar(64), nullThe name of the time zone
OrganizationIdint, nullThe person’s organization ID number - see Query.Organization{locale}.id.
ManagerPersonIdint, nullThe manager ID number - see Query.Person{locale}.id.
DeputyPersonIdint, nullThe ID number of the person’s substitute - see Query.Person{locale}.id.
Disabledbit, not nullBlocked user
Sharedbit, not nullShared account
Hidden in menusbit, not nullUser hidden in menus
Deleteddatetime, nullDeleted user
AdminUrlnvarchar(2074), nullURL of the user page in the administration
Urlnvarchar(2079), nullURL 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
idint, not nullIdentification number of the process - see dbo.TicketType.id.
Názevnvarchar(255), not nullProcess name
Popisnvarchar(max), nullDescription of the process
AdminUrlnvarchar(2077), nullURL 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
idint, not nullIdentification number of the process - see dbo.TicketType.id.
Bezeichnungnvarchar(255), not nullProcess name
Beschreibungnvarchar(max), nullDescription of the process
AdminUrlnvarchar(2077), nullURL 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
idint, not nullIdentification number of the process - see dbo.TicketType.id.
Namenvarchar(255), not nullProcess name
Descriptionnvarchar(max), nullDescription of the process
AdminUrlnvarchar(2077), nullURL 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
idint, not nullIdentification number of the ticket - see dbo.tHdTicket.iHdTicketId.
Značka požadavkunvarchar(255), nullTicket identification mark
Název požadavkunvarchar(1024), nullTicket name
Značka a název požadavkunvarchar(1282), nullTag and name of the ticket, e.g. "T123456COMPANY Request for a new printer".
Interní cílnvarchar(255), nullName of the internal target
Interní cíl - Termín (UTC)datetime, nullThe internal target due date
Vytvořeno (UTC)datetime, nullTicket creation date and time
Způsob podání požadavkunvarchar(255), nullTicket submission method, e.g., e-mail, phone, form.
Hrubý stavnvarchar(10), not nullName of general status (Open, Resolved, Closed, Deleted).
URL požadavkunvarchar(2072), nullTicket URL in ALVAO WebApp
Pozastavení SLA (hodiny v provozní době)float, nullNumber 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, nullTotal 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, nullTotal 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, nullThe number of hours in the operating hours of waiting for requester in progress.
První reakce (UTC)datetime, nullDate and time of the first response
První reakce - Termín (UTC)datetime, nullDate 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, nullTime 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í reakcenvarchar(9), nullThe "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, nullThe 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, nullBy 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, nullHow many hours earlier during the operating hours was the first reaction met than as required by the SLA limit.
FirstReactionRequestLogRecordIdint, nullEvent ID that completed the first response see Query.RequestLogRecord{locale}.id.
FirstReactionTriggeredByRequestLogRecordIdint, nullEvent ID that triggered the event to complete the first response see Query.RequestLogRecord{locale}.id.
Vyřešeno (UTC)datetime, nullDate and time of ticket solution.
Vyřešení - Termín (UTC)datetime, nullDate 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, nullTime 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), nullThe "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, nullHours 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, nullBy 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, nullHow 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, nullBy how many hours during the operating hours was the deadline for resolution of the ticket exceeded (Ticket time/Due date item).
Vyřešení - Splnění termínu (hodiny v provozní době)float, nullHow many hours earlier during the operating hours the ticket was resolved than the value listed in the Ticket time/Due date item.
ResolutionRequestLogRecordIdint, nullLast resolved ticket event ID, see Query.requestLogRecord{locale}.id.
Uzavřeno (UTC)datetime, nullDate and time of ticket closing.
RootRequestIdint, nullThe highest parent ticket ID number, see Query.Request2{locale}.id.
RequesterPersonIdint, not nullThe ID number of the ticket requester - see Query.Person{locale}.id.
SolverPersonIdint, nullThe current ticket solver ID number - see Query.Person{locale}.id.
Řešitelská skupinanvarchar(255), nullThe name of the solver group to which the ticket is assigned.
RequestedForPersonIdint, not nullID number of the user for who the ticket was created - see Query.Person{locale}.id.
SectionIdint, not nullThe service ID number - see Query.Section{locale}.id.
SlaIdint, not nullThe SLA ID number - see Query.Sla{locale}.id.
RelatedOrganizationIdint, nullThe related organization of the ticket ID number (related organization item), see Query.Organization{locale}.id.
RequestStateIdint, not nullThe current ticket status ID number - see Query.RequestState{locale}.id.
StartRequestLogRecordIdint, nullThe ID number of the ticket creating event - see Query.RequestLogRecord{locale}.id.
Prioritanvarchar(max), nullPriority name
Dopadnvarchar(max), nullImpact name
Naléhavostnvarchar(max), nullUrgency name
Náklady (hodiny)float, nullTotal recorded time (Work + Travel time), in hours.
Náklady - Práce (hodiny)float, nullNumber of hours worked in relation to the ticket.
Náklady - Cesta (hodiny)float, nullNumber of hours spent on the way in respect of the ticket.
Náklady - Cesta (km)float, nullNumber of kilometers reported in relation to the ticket.
Poznámkanvarchar(max), nullTicket notes
Skupinanvarchar(255), nullGroup
Číslo zařízenínvarchar(255), nullDevice number
Dotazník spokojenosti - Celková spokojenostnvarchar(max), nullRequester’s overall satisfaction
Dotazník spokojenosti - Rychlost řešenínvarchar(max), nullThe speed of ticket solution from the requester's perspective
Dotazník spokojenosti - Profesionalitanvarchar(max), nullProfessionalism of the solving team from the requester's point of view
Dotazník spokojenosti - Odbornostnvarchar(max), nullExpertise of the solving team from the requester's point of view
Dotazník spokojenosti - Komentáře a poznámkynvarchar(max), nullComments and notes from the requester on the satisfaction survey
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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
idint, not nullIdentification number of the ticket - see dbo.tHdTicket.iHdTicketId.
Kennung der Anfragenvarchar(255), nullTicket identification mark
Name der Anfragenvarchar(1024), nullTicket name
Zeichen und Name der Anfragenvarchar(1282), nullTag and name of the ticket, e.g. "T123456COMPANY Request for a new printer".
Internes Zielnvarchar(255), nullName of the internal target
Internes Ziel - Termin (UTC)datetime, nullThe internal target due date
Erstellt (UTC)datetime, nullTicket creation date and time
Methode der Anfragestellungnvarchar(255), nullTicket submission method, e.g., e-mail, phone, form.
Gesamtstatusnvarchar(13), not nullName of general status (Open, Resolved, Closed, Deleted).
URL der Anfragenvarchar(2072), nullTicket URL in ALVAO WebApp
SLA-Aussetzung (Stunden innerhalb der Betriebszeit)float, nullNumber 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, nullTotal 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, nullTotal 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, nullThe number of hours in the operating hours of waiting for requester in progress.
Erste Reaktion (UTC)datetime, nullDate and time of the first response
Erste Reaktion - Termin (UTC)datetime, nullDate 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, nullTime 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 Reaktionnvarchar(13), nullThe "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, nullThe 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, nullBy 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, nullHow many hours earlier during the operating hours was the first reaction met than as required by the SLA limit.
FirstReactionRequestLogRecordIdint, nullEvent ID that completed the first response see Query.RequestLogRecord{locale}.id.
FirstReactionTriggeredByRequestLogRecordIdint, nullEvent ID that triggered the event to complete the first response see Query.RequestLogRecord{locale}.id.
Gelöst (UTC)datetime, nullDate and time of ticket solution.
Erledigung - Termin (UTC)datetime, nullDate 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, nullTime 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ösungnvarchar(13), nullThe "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, nullHours 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, nullBy 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, nullHow many hours earlier during the operating hours the ticket was resolved than the SLA limit.
Erledigung - Überschreitung des Termins (Stunden innerhalb der Betriebszeit)float, nullBy how many hours during the operating hours was the deadline for resolution of the ticket exceeded (Ticket time/Due date item).
Erledigung - Einhaltung des Termins (Stunden innerhalb der Betriebszeit)float, nullHow many hours earlier during the operating hours the ticket was resolved than the value listed in the Ticket time/Due date item.
ResolutionRequestLogRecordIdint, nullLast resolved ticket event ID, see Query.requestLogRecord{locale}.id.
Geschlossen (UTC)datetime, nullDate and time of ticket closing.
RootRequestIdint, nullThe highest parent ticket ID number, see Query.Request2{locale}.id.
RequesterPersonIdint, not nullThe ID number of the ticket requester - see Query.Person{locale}.id.
SolverPersonIdint, nullThe current ticket solver ID number - see Query.Person{locale}.id.
Bearbeitergruppenvarchar(255), nullThe name of the solver group to which the ticket is assigned.
RequestedForPersonIdint, not nullID number of the user for who the ticket was created - see Query.Person{locale}.id.
SectionIdint, not nullThe service ID number - see Query.Section{locale}.id.
SlaIdint, not nullThe SLA ID number - see Query.Sla{locale}.id.
RelatedOrganizationIdint, nullThe related organization of the ticket ID number (related organization item), see Query.Organization{locale}.id.
RequestStateIdint, not nullThe current ticket status ID number - see Query.RequestState{locale}.id.
StartRequestLogRecordIdint, nullThe ID number of the ticket creating event - see Query.RequestLogRecord{locale}.id.
Prioritätnvarchar(max), nullPriority name
Auswirkungnvarchar(max), nullImpact name
Dringlichkeitnvarchar(max), nullUrgency name
Aufwand (in Stunden)float, nullTotal recorded time (Work + Travel time), in hours.
Arbeitsaufwand (in Stunden)float, nullNumber of hours worked in relation to the ticket.
Aufwand - Reisezeit (in Stunden)float, nullNumber of hours spent on the way in respect of the ticket.
Aufwand - Reisezeit (in km)float, nullNumber of kilometers reported in relation to the ticket.
Anmerkungnvarchar(max), nullTicket notes
Gruppenvarchar(255), nullGroup
Gerätenummernvarchar(255), nullDevice number
Zufriedenheitsbefragung - Gesamtzufriedenheitnvarchar(max), nullRequester’s overall satisfaction
Zufriedenheitsbefragung - Schnelligkeit der Bearbeitungnvarchar(max), nullThe speed of ticket solution from the requester's perspective
Zufriedenheitsbefragung - Professionalitätnvarchar(max), nullProfessionalism of the solving team from the requester's point of view
Zufriedenheitsbefragung - Fachkompetenznvarchar(max), nullExpertise of the solving team from the requester's point of view
Zufriedenheitsbefragung - Kommentare und Anmerkungennvarchar(max), nullComments and notes from the requester on the satisfaction survey
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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
idint, not nullIdentification number of the ticket - see dbo.tHdTicket.iHdTicketId.
Request tagnvarchar(255), nullTicket identification mark
Request namenvarchar(1024), nullTicket name
Request tag and titlenvarchar(1282), nullTag and name of the ticket, e.g. "T123456COMPANY Request for a new printer".
Internal targetnvarchar(255), nullName of the internal target
Internal target - Due date (UTC)datetime, nullThe internal target due date
Created (UTC)datetime, nullTicket creation date and time
Request submission methodnvarchar(255), nullTicket submission method, e.g., e-mail, phone, form.
Overall statusnvarchar(8), not nullName of general status (Open, Resolved, Closed, Deleted).
Request URLnvarchar(2072), nullTicket URL in ALVAO WebApp
SLA pause (hours during the operation hours)float, nullNumber 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, nullTotal 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, nullTotal 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, nullThe number of hours in the operating hours of waiting for requester in progress.
First response (UTC)datetime, nullDate and time of the first response
First response - Due date (UTC)datetime, nullDate 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, nullTime 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 responsenvarchar(13), nullThe "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, nullThe 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, nullBy 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, nullHow many hours earlier during the operating hours was the first reaction met than as required by the SLA limit.
FirstReactionRequestLogRecordIdint, nullEvent ID that completed the first response see Query.RequestLogRecord{locale}.id.
FirstReactionTriggeredByRequestLogRecordIdint, nullEvent ID that triggered the event to complete the first response see Query.RequestLogRecord{locale}.id.
Resolved (UTC)datetime, nullDate and time of ticket solution.
Resolution - Due date (UTC)datetime, nullDate 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, nullTime 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.
Resolutionnvarchar(13), nullThe "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, nullHours 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, nullBy 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, nullHow 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, nullBy how many hours during the operating hours was the deadline for resolution of the ticket exceeded (Ticket time/Due date item).
Resolution - Meeting of due date (hours during the operation hours)float, nullHow many hours earlier during the operating hours the ticket was resolved than the value listed in the Ticket time/Due date item.
ResolutionRequestLogRecordIdint, nullLast resolved ticket event ID, see Query.requestLogRecord{locale}.id.
Closed (UTC)datetime, nullDate and time of ticket closing.
RootRequestIdint, nullThe highest parent ticket ID number, see Query.Request2{locale}.id.
RequesterPersonIdint, not nullThe ID number of the ticket requester - see Query.Person{locale}.id.
SolverPersonIdint, nullThe current ticket solver ID number - see Query.Person{locale}.id.
Solver groupnvarchar(255), nullThe name of the solver group to which the ticket is assigned.
RequestedForPersonIdint, not nullID number of the user for who the ticket was created - see Query.Person{locale}.id.
SectionIdint, not nullThe service ID number - see Query.Section{locale}.id.
SlaIdint, not nullThe SLA ID number - see Query.Sla{locale}.id.
RelatedOrganizationIdint, nullThe related organization of the ticket ID number (related organization item), see Query.Organization{locale}.id.
RequestStateIdint, not nullThe current ticket status ID number - see Query.RequestState{locale}.id.
StartRequestLogRecordIdint, nullThe ID number of the ticket creating event - see Query.RequestLogRecord{locale}.id.
Prioritynvarchar(max), nullPriority name
Impactnvarchar(max), nullImpact name
Urgencynvarchar(max), nullUrgency name
Cost (hours)float, nullTotal recorded time (Work + Travel time), in hours.
Cost - Work (hours)float, nullNumber of hours worked in relation to the ticket.
Cost - Time traveled (hours)float, nullNumber of hours spent on the way in respect of the ticket.
Cost - Distance traveled (km)float, nullNumber of kilometers reported in relation to the ticket.
Notenvarchar(max), nullTicket notes
Groupnvarchar(255), nullGroup
Device numbernvarchar(255), nullDevice number
Satisfaction survey - General satisfactionnvarchar(max), nullRequester’s overall satisfaction
Satisfaction survey - Resolution speednvarchar(max), nullThe speed of ticket solution from the requester's perspective
Satisfaction survey - Professionalismnvarchar(max), nullProfessionalism of the solving team from the requester's point of view
Satisfaction survey - Expertisenvarchar(max), nullExpertise of the solving team from the requester's point of view
Satisfaction survey - Comments and remarksnvarchar(max), nullComments and notes from the requester on the satisfaction survey
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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žadavkuint, not nullThe ticket identification number.
Id službyint, nullService ID (tHdSection.iHdSectionId).
Id stavuint, nullStatus ID (TicketState.id).
Id řešiteleint, nullSolver ID (tPerson.iPersonId).
Řešitelská skupinanvarchar(255), nullThe name of the solver group to which the ticket is assigned.
Id SLAint, nullSLA ID (tSla.iSlaId).
Začátek (UTC)datetime, nullDate of change performance.
Konec (UTC)datetime, nullChange end date = the date the next change was made.
Doba trvání (hodiny)float, nullNumber of hours the change took.
Doba trvání v provozní době (hodiny)float, not nullNumber 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 nullThe number of hours in SLA operating hours during which the SLA was running within the change duration.
Požadavek uzavřen (UTC)datetime, nullDate and time of ticket closing.
Pozastaveno SLA (hodiny)float, not nullThe number of hours in SLA operating hours during which the SLA was paused within the change duration.

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-Nummerint, not nullThe ticket identification number.
Id des Serviceint, nullService ID (tHdSection.iHdSectionId).
Id des Statusint, nullStatus ID (TicketState.id).
ID des Bearbeitersint, nullSolver ID (tPerson.iPersonId).
Bearbeitergruppenvarchar(255), nullThe name of the solver group to which the ticket is assigned.
Id der SLAint, nullSLA ID (tSla.iSlaId).
Beginn (UTC)datetime, nullDate of change performance.
Ende (UTC)datetime, nullChange end date = the date the next change was made.
Dauer (Stunden)float, nullNumber of hours the change took.
Betriebszeitdauer (Stunden)float, not nullNumber 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 nullThe number of hours in SLA operating hours during which the SLA was running within the change duration.
Ticket closed (UTC)datetime, nullDate and time of ticket closing.
SLA ausgesetzt (Stunden)float, not nullThe number of hours in SLA operating hours during which the SLA was paused within the change duration.

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 numberint, not nullThe ticket identification number.
Service IDint, nullService ID (tHdSection.iHdSectionId).
Status IDint, nullStatus ID (TicketState.id).
Solver IDint, nullSolver ID (tPerson.iPersonId).
Solver groupnvarchar(255), nullThe name of the solver group to which the ticket is assigned.
SLA IDint, nullSLA ID (tSla.iSlaId).
Start (UTC)datetime, nullDate of change performance.
End (UTC)datetime, nullChange end date = the date the next change was made.
Duration (hours)float, nullNumber of hours the change took.
Duration in operating hours (hours)float, not nullNumber 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 nullThe number of hours in SLA operating hours during which the SLA was running within the change duration.
Ticket closed (UTC)datetime, nullDate and time of ticket closing.
SLA paused (hours)float, not nullThe number of hours in SLA operating hours during which the SLA was paused within the change duration.

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žadavkuint, not nullThe ticket identification number.
Název požadavkunvarchar(1024), nullTicket name
Službanvarchar(1024), nullName of the service including the path in the tree.
SLAnvarchar(255), nullSLA name.
Žadatelnvarchar(255), nullFirst and last name of the requester.
Organizace (žadatel)nvarchar(255), nullName of the requester’s organization.
Řešitelnvarchar(255), nullName and surname of the solver.
Termín (UTC)datetime, nullTicket due date.
Interní cílnvarchar(255), nullInternal target name.
Interní cíl (termín) (UTC)datetime, nullInternal target date.
Datum (UTC)datetime, nullDate of message sending.
Týden od (UTC)datetime, nullDate of the beginning of the week in which the message was sent.
Měsíc od (UTC)datetime, nullDate of the beginning of the month in which the message was sent.
Rok (UTC)int, nullyear in which the message was sent.
Čtvrtletí (UTC)int, nullQuarter in which the message was sent (1-4).
Měsíc (UTC)int, nullMonth in which the message was sent (1-12).
Týden (UTC)int, nullWeek in which the message was sent (1-53).
Hodina (UTC)int, nullHour in which the message was sent (0-23).
Značka a název požadavkunvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
Nejvyšší požadavekint, nullIdentification number of the root parent ticket.
Nejvyšší službanvarchar(1024), nullName of root service in the service tree.
Informovalnvarchar(255), nullName and surname of the solver who sent the message.
Doba (hodiny)float, not nullTime elapsed from the sending of the previous message from the supplier to the sending of this message, in hours.
Související organizacenvarchar(255), not nullName of the organization for which the ticket is being implemented.
Procesnvarchar(255), nullProcess name.
Id žadateleint, not nullThe ID number of the ticket requester - see Query.Person{locale}.id.
Id řešiteleint, nullThe current ticket solver ID number - see Query.Person{locale}.id.
Id službyint, not nullThe service ID number - see Query.Section{locale}.id.
Id SLAint, not nullThe SLA ID number - see Query.Sla{locale}.id.
Id organizace žadateleint, nullThe requester’s organization ID number - see Query.Organization{locale}.id.
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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-Nummerint, not nullThe ticket identification number.
Name der Anfragenvarchar(1024), nullTicket name
Servicenvarchar(1024), nullName of the service including the path in the tree.
SLAnvarchar(255), nullSLA name.
Anfragestellernvarchar(255), nullFirst and last name of the requester.
Organisation (Anfragesteller)nvarchar(255), nullName of the requester’s organization.
Bearbeiternvarchar(255), nullName and surname of the solver.
Termin (UTC)datetime, nullTicket due date.
Internes Zielnvarchar(255), nullInternal target name.
Internes Ziel (Termin) (UTC)datetime, nullInternal target date.
Datum (UTC)datetime, nullDate of message sending.
Woche seit (UTC)datetime, nullDate of the beginning of the week in which the message was sent.
Monat seit (UTC)datetime, nullDate of the beginning of the month in which the message was sent.
Jahr (UTC)int, nullyear in which the message was sent.
Quartal (UTC)int, nullQuarter in which the message was sent (1-4).
Monat (UTC)int, nullMonth in which the message was sent (1-12).
Woche (UTC)int, nullWeek in which the message was sent (1-53).
Stunde (UTC)int, nullHour in which the message was sent (0-23).
Zeichen und Name der Anfragenvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
Höchste Anfrageint, nullIdentification number of the root parent ticket.
Höchster Servicenvarchar(1024), nullName of root service in the service tree.
Informiert durchnvarchar(255), nullName and surname of the solver who sent the message.
Zeit (Stunden)float, not nullTime elapsed from the sending of the previous message from the supplier to the sending of this message, in hours.
Zugehörige Organisationennvarchar(255), not nullName of the organization for which the ticket is being implemented.
Prozessnvarchar(255), nullProcess name.
Id des Anfragestellersint, not nullThe ID number of the ticket requester - see Query.Person{locale}.id.
ID des Bearbeitersint, nullThe current ticket solver ID number - see Query.Person{locale}.id.
Id des Serviceint, not nullThe service ID number - see Query.Section{locale}.id.
Id der SLAint, not nullThe SLA ID number - see Query.Sla{locale}.id.
Id der Organisation des Anfragestellersint, nullThe requester’s organization ID number - see Query.Organization{locale}.id.
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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 numberint, not nullThe ticket identification number.
Request namenvarchar(1024), nullTicket name
Servicenvarchar(1024), nullName of the service including the path in the tree.
SLAnvarchar(255), nullSLA name.
Requesternvarchar(255), nullFirst and last name of the requester.
Organization (requester)nvarchar(255), nullName of the requester’s organization.
Solvernvarchar(255), nullName and surname of the solver.
Due date (UTC)datetime, nullTicket due date.
Internal targetnvarchar(255), nullInternal target name.
Internal target (due date) (UTC)datetime, nullInternal target date.
Date (UTC)datetime, nullDate of message sending.
Week starting (UTC)datetime, nullDate of the beginning of the week in which the message was sent.
Month starting (UTC)datetime, nullDate of the beginning of the month in which the message was sent.
Year (UTC)int, nullyear in which the message was sent.
Quarter (UTC)int, nullQuarter in which the message was sent (1-4).
Month (UTC)int, nullMonth in which the message was sent (1-12).
Week (UTC)int, nullWeek in which the message was sent (1-53).
Hour (UTC)int, nullHour in which the message was sent (0-23).
Request tag and titlenvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
Highest requestint, nullIdentification number of the root parent ticket.
Highest servicenvarchar(1024), nullName of root service in the service tree.
Informed bynvarchar(255), nullName and surname of the solver who sent the message.
Time (hours)float, not nullTime elapsed from the sending of the previous message from the supplier to the sending of this message, in hours.
Related organizationnvarchar(255), not nullName of the organization for which the ticket is being implemented.
Processnvarchar(255), nullProcess name.
Requester IDint, not nullThe ID number of the ticket requester - see Query.Person{locale}.id.
Solver IDint, nullThe current ticket solver ID number - see Query.Person{locale}.id.
Service IDint, not nullThe service ID number - see Query.Section{locale}.id.
SLA IDint, not nullThe SLA ID number - see Query.Sla{locale}.id.
Requesters organization IDint, nullThe requester’s organization ID number - see Query.Organization{locale}.id.
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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
idint, not nullIdentification number of the event - see dbo.tAct.iActId.
Vytvořeno (UTC)datetime, nullDate and time of the record creation in the ticket log
Předmětnvarchar(max), nullSubject of the record in the log
Náklady (hodiny)float, nullTotal recorded time (Work + Travel time), in hours
Náklady - Práce (hodiny)float, nullReported work in hours
Náklady - Cesta (hodiny)float, nullReported time spent on trip in hours
Náklady - Cesta (km)float, nullReported distance in kilometers
Druh událostinvarchar(255), nullName of the type of record (e-mail, note, ...)
Nefakturovatbit, not nullThe "Exclude from invoice to the requester" flag
URL událostinvarchar(2075), nullEvent URL in ALVAO WebApp
Operacenvarchar(255), nullOperation name, see dbo.ActOperation.Name.
Důležitá událostint, not nullIndication whether this is an important event.
Řešení požadavkuint, not nullIndication whether the event contains a ticket solution.
FromPersonIdint, not nullThe current ID number of the ticket event author - see Query.Person{locale}.id.
RequestIdint, nullThe ticket ID number - seeQuery.Request2{locale}.id.
Poslední změna (UTC)datetime, nullTime at which the record was modified.
Požadavek uzavřen (UTC)datetime, nullDate 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
idint, not nullIdentification number of the event - see dbo.tAct.iActId.
Erstellt (UTC)datetime, nullDate and time of the record creation in the ticket log
Betreffnvarchar(max), nullSubject of the record in the log
Aufwand (in Stunden)float, nullTotal recorded time (Work + Travel time), in hours
Arbeitsaufwand (in Stunden)float, nullReported work in hours
Aufwand - Reisezeit (in Stunden)float, nullReported time spent on trip in hours
Aufwand - Reisezeit (in km)float, nullReported distance in kilometers
Ereignistypnvarchar(255), nullName of the type of record (e-mail, note, ...)
Nicht in Rechnung stellenbit, not nullThe "Exclude from invoice to the requester" flag
URL des Ereignisesnvarchar(2075), nullEvent URL in ALVAO WebApp
Operationnvarchar(255), nullOperation name, see dbo.ActOperation.Name.
Wichtiges Ereignisint, not nullIndication whether this is an important event.
Lösung der Anfrageint, not nullIndication whether the event contains a ticket solution.
FromPersonIdint, not nullThe current ID number of the ticket event author - see Query.Person{locale}.id.
RequestIdint, nullThe ticket ID number - seeQuery.Request2{locale}.id.
Last changed (UTC)datetime, nullTime at which the record was modified.
Ticket closed (UTC)datetime, nullDate 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
idint, not nullIdentification number of the event - see dbo.tAct.iActId.
Created (UTC)datetime, nullDate and time of the record creation in the ticket log
Subjectnvarchar(max), nullSubject of the record in the log
Cost (hours)float, nullTotal recorded time (Work + Travel time), in hours
Cost - Work (hours)float, nullReported work in hours
Cost - Time traveled (hours)float, nullReported time spent on trip in hours
Cost - Distance traveled (km)float, nullReported distance in kilometers
Log record typenvarchar(255), nullName of the type of record (e-mail, note, ...)
Exclude from invoicebit, not nullThe "Exclude from invoice to the requester" flag
Log record URLnvarchar(2075), nullEvent URL in ALVAO WebApp
Operationnvarchar(255), nullOperation name, see dbo.ActOperation.Name.
Marked as importantint, not nullIndication whether this is an important event.
Request solutionint, not nullIndication whether the event contains a ticket solution.
FromPersonIdint, not nullThe current ID number of the ticket event author - see Query.Person{locale}.id.
RequestIdint, nullThe ticket ID number - seeQuery.Request2{locale}.id.
Last changed (UTC)datetime, nullTime at which the record was modified.
Ticket closed (UTC)datetime, nullDate and time of ticket closing.

Query.RequestObjectCsy​

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 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žadavkuint, not nullTicket identification number
Název požadavkunvarchar(1024), nullTicket name
Značka a název požadavkunvarchar(1282), nullTag and name of the ticket, e.g. "T123456COMPANY Request for a new printer".
Službanvarchar(1024), nullName of the service including the path in the tree
Procesnvarchar(255), not nullProcess name
SLAnvarchar(255), nullSLA name
Hrubý stavnvarchar(9), not nullName of general status (Open, Resolved, Closed, Deleted)
Id objektuint, not nullObject identification number
Název objektunvarchar(255), nullObject name
Druh objektunvarchar(max), nullObject kind
Cesta ve stromunvarchar(1024), nullPath in tree (without the object name). Contains an empty chain for root objects.
Požadavek uzavřen (UTC)datetime, nullDate and time of ticket closing.

Query.RequestObjectDeu​

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 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-Nummerint, not nullTicket identification number
Name der Anfragenvarchar(1024), nullTicket name
Zeichen und Name der Anfragenvarchar(1282), nullTag and name of the ticket, e.g. "T123456COMPANY Request for a new printer".
Servicenvarchar(1024), nullName of the service including the path in the tree
Prozessnvarchar(255), not nullProcess name
SLAnvarchar(255), nullSLA name
Gesamtstatusnvarchar(11), not nullName of general status (Open, Resolved, Closed, Deleted)
Objekt Idint, not nullObject identification number
Objektnamenvarchar(255), nullObject name
Objekttypnvarchar(max), nullObject kind
Pfad im Objektbaumnvarchar(1024), nullPath in tree (without the object name). Contains an empty chain for root objects.
Ticket closed (UTC)datetime, nullDate and time of ticket closing.

Query.RequestObjectEnu​

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 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 numberint, not nullTicket identification number
Request namenvarchar(1024), nullTicket name
Request tag and titlenvarchar(1282), nullTag and name of the ticket, e.g. "T123456COMPANY Request for a new printer".
Servicenvarchar(1024), nullName of the service including the path in the tree
Processnvarchar(255), not nullProcess name
SLAnvarchar(255), nullSLA name
Overall statusnvarchar(8), not nullName of general status (Open, Resolved, Closed, Deleted)
Object idint, not nullObject identification number
Object namenvarchar(255), nullObject name
Object kindnvarchar(max), nullObject kind
Path in treenvarchar(1024), nullPath in tree (without the object name). Contains an empty chain for root objects.
Ticket closed (UTC)datetime, nullDate 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
RequestIdint, not nullThe ticket ID number - seeQuery.Request2{locale}.id.
ObjectIdint, not nullThe 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žadavkuint, nullThe ticket identification number.
Nejvyšší požadavekint, nullIdentification number of the root linked parent ticket.
Žadatelnvarchar(255), nullFirst and last name of the requester.
Organizace (žadatel)nvarchar(255), nullName of the requester’s organization.
Službanvarchar(1024), nullName of the service including the path in the tree.
Nejvyšší službanvarchar(1024), nullName of root service in the service tree.
Název požadavkunvarchar(1024), nullTicket name
Řešitelnvarchar(255), nullName and surname of the solver.
Oddělení (řešitel)nvarchar(255), nullName of the solver’s department.
Oddělení (žadatel)nvarchar(255), nullName of the requester’s department.
Funkce (řešitel)nvarchar(255), nullName of the solver’s job title.
Funkce (žadatel)nvarchar(255), nullName of the requester’s job title.
Skupinanvarchar(255), nullGroup
Termín (UTC)datetime, nullTicket due date.
Interní cílnvarchar(255), nullInternal target name.
Interní cíl (termín) (UTC)datetime, nullInternal target date.
Prioritanvarchar(max), nullPriority name.
Značka a název požadavkunvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
SLAnvarchar(255), nullSLA name.
Operacenvarchar(10), not nullPerformed operation (Created, Deleted, Resolved, Closed).
Změna počtu otevřených požadavkůint, not nullChange of the number of open tickets after performing the operation (+1, -1)
Datum (UTC)datetime, nullDate of operation.
Týden od (UTC)datetime, nullDate of the beginning of the week of the operation.
Měsíc od (UTC)datetime, nullDate of the beginning of the month of the operation.
Rok (UTC)int, nullYear of the operation.
Čtvrtletí (UTC)int, nullQuarter in which the operation was executed (1-4).
Měsíc (UTC)int, nullMonth in which the operation was executed (1-12).
Týden (UTC)int, nullWeek of the operation (1-53).
Hodina (UTC)int, nullHour in which the operation was executed (0-23).
Související organizacenvarchar(255), not nullName of the organization for which the ticket is being implemented.
Procesnvarchar(255), nullProcess name.
Id žadateleint, nullThe ID number of the ticket requester - see Query.Person{locale}.id.
Id řešiteleint, nullThe current ticket solver ID number - see Query.Person{locale}.id.
Id službyint, nullThe service ID number - see Query.Section{locale}.id.
Id SLAint, nullThe SLA ID number - see Query.Sla{locale}.id.
Id organizace žadateleint, nullThe requester’s organization ID number - see Query.Organization{locale}.id.
Požadavek uzavřen (UTC)datetime, nullDate and time of ticket closing.
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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-Nummerint, nullThe ticket identification number.
Höchste Anfrageint, nullIdentification number of the root linked parent ticket.
Anfragestellernvarchar(255), nullFirst and last name of the requester.
Organisation (Anfragesteller)nvarchar(255), nullName of the requester’s organization.
Servicenvarchar(1024), nullName of the service including the path in the tree.
Höchster Servicenvarchar(1024), nullName of root service in the service tree.
Name der Anfragenvarchar(1024), nullTicket name
Bearbeiternvarchar(255), nullName and surname of the solver.
Abteilung (Bearbeiter)nvarchar(255), nullName of the solver’s department.
Abteilung (Anfragesteller)nvarchar(255), nullName of the requester’s department.
Funktion (Bearbeiter)nvarchar(255), nullName of the solver’s job title.
Funktion (Anfragesteller)nvarchar(255), nullName of the requester’s job title.
Gruppenvarchar(255), nullGroup
Termin (UTC)datetime, nullTicket due date.
Internes Zielnvarchar(255), nullInternal target name.
Internes Ziel (Termin) (UTC)datetime, nullInternal target date.
Prioritätnvarchar(max), nullPriority name.
Zeichen und Name der Anfragenvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
SLAnvarchar(255), nullSLA name.
Operationnvarchar(11), not nullPerformed operation (Created, Deleted, Resolved, Closed).
Änderung der Anzahl der offenen Anfragenint, not nullChange of the number of open tickets after performing the operation (+1, -1)
Datum (UTC)datetime, nullDate of operation.
Woche seit (UTC)datetime, nullDate of the beginning of the week of the operation.
Monat seit (UTC)datetime, nullDate of the beginning of the month of the operation.
Jahr (UTC)int, nullYear of the operation.
Quartal (UTC)int, nullQuarter in which the operation was executed (1-4).
Monat (UTC)int, nullMonth in which the operation was executed (1-12).
Woche (UTC)int, nullWeek of the operation (1-53).
Stunde (UTC)int, nullHour in which the operation was executed (0-23).
Zugehörige Organisationennvarchar(255), not nullName of the organization for which the ticket is being implemented.
Prozessnvarchar(255), nullProcess name.
Id des Anfragestellersint, nullThe ID number of the ticket requester - see Query.Person{locale}.id.
ID des Bearbeitersint, nullThe current ticket solver ID number - see Query.Person{locale}.id.
Id des Serviceint, nullThe service ID number - see Query.Section{locale}.id.
Id der SLAint, nullThe SLA ID number - see Query.Sla{locale}.id.
Id der Organisation des Anfragestellersint, nullThe requester’s organization ID number - see Query.Organization{locale}.id.
Ticket closed (UTC)datetime, nullDate and time of ticket closing.
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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 numberint, nullThe ticket identification number.
Highest requestint, nullIdentification number of the root linked parent ticket.
Requesternvarchar(255), nullFirst and last name of the requester.
Organization (requester)nvarchar(255), nullName of the requester’s organization.
Servicenvarchar(1024), nullName of the service including the path in the tree.
Highest servicenvarchar(1024), nullName of root service in the service tree.
Request namenvarchar(1024), nullTicket name
Solvernvarchar(255), nullName and surname of the solver.
Department (solver)nvarchar(255), nullName of the solver’s department.
Department (requester)nvarchar(255), nullName of the requester’s department.
Job title (solver)nvarchar(255), nullName of the solver’s job title.
Job title (requester)nvarchar(255), nullName of the requester’s job title.
Groupnvarchar(255), nullGroup
Due date (UTC)datetime, nullTicket due date.
Internal targetnvarchar(255), nullInternal target name.
Internal target (due date) (UTC)datetime, nullInternal target date.
Prioritynvarchar(max), nullPriority name.
Request tag and titlenvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
SLAnvarchar(255), nullSLA name.
Operationnvarchar(8), not nullPerformed operation (Created, Deleted, Resolved, Closed).
Change of the number of open requestsint, not nullChange of the number of open tickets after performing the operation (+1, -1)
Date (UTC)datetime, nullDate of operation.
Week starting (UTC)datetime, nullDate of the beginning of the week of the operation.
Month starting (UTC)datetime, nullDate of the beginning of the month of the operation.
Year (UTC)int, nullYear of the operation.
Quarter (UTC)int, nullQuarter in which the operation was executed (1-4).
Month (UTC)int, nullMonth in which the operation was executed (1-12).
Week (UTC)int, nullWeek of the operation (1-53).
Hour (UTC)int, nullHour in which the operation was executed (0-23).
Related organizationnvarchar(255), not nullName of the organization for which the ticket is being implemented.
Processnvarchar(255), nullProcess name.
Requester IDint, nullThe ID number of the ticket requester - see Query.Person{locale}.id.
Solver IDint, nullThe current ticket solver ID number - see Query.Person{locale}.id.
Service IDint, nullThe service ID number - see Query.Section{locale}.id.
SLA IDint, nullThe SLA ID number - see Query.Sla{locale}.id.
Requesters organization IDint, nullThe requester’s organization ID number - see Query.Organization{locale}.id.
Ticket closed (UTC)datetime, nullDate and time of ticket closing.
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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
PersonIdint, nullIdentification number of the person, see Query.PersonEnu.id
RequestIdint, nullIdentification number of the ticket - see Query.Request2Enu.id
Ticket closed (UTC)datetime, nullDate 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
RequestIdint, not nullThe ticket ID number - seeQuery.Request2{locale}.id.
RelatedRequestIdint, not nullThe linked ticket ID number - see Query.Request2{locale}.id.
Typ vazbynvarchar(30), not nullLink 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
RequestIdint, not nullThe ticket ID number - seeQuery.Request2{locale}.id.
RelatedRequestIdint, not nullThe linked ticket ID number - see Query.Request2{locale}.id.
Typ der Verknüpfungnvarchar(30), not nullLink 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
RequestIdint, not nullThe ticket ID number - seeQuery.Request2{locale}.id.
RelatedRequestIdint, not nullThe linked ticket ID number - see Query.Request2{locale}.id.
Link typenvarchar(30), not nullLink 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žadavkuint, not nullThe ticket identification number.
Název požadavkunvarchar(1024), nullTicket name
Službanvarchar(1024), nullName of the service including the path in the tree.
SLAnvarchar(255), nullSLA name.
Žadatelnvarchar(255), nullFirst and last name of the requester.
Organizace (žadatel)nvarchar(255), nullName of the requester’s organization.
Řešitelnvarchar(255), nullName and surname of the solver.
Vyřešilnvarchar(255), nullName and surname of the solver who resolved the ticket.
Termín (UTC)datetime, nullTicket due date.
Interní cílnvarchar(255), nullInternal target name.
Interní cíl (termín) (UTC)datetime, nullInternal target date.
Nejvyšší požadavekint, nullIdentification number of the root parent ticket.
Nejvyšší službanvarchar(1024), nullName of root service in the service tree.
Datum (UTC)datetime, nullDate of ticket reopening.
Týden od (UTC)datetime, nullDate of the beginning of the week in which the ticket was reopened.
Měsíc od (UTC)datetime, nullDate of the beginning of the month in which the ticket was reopened.
Rok (UTC)int, nullYear of ticket reopening.
Čtvrtletí (UTC)int, nullQuarter in which the ticket was reopened (1-4).
Měsíc (UTC)int, nullMonth in which the ticket was reopened (1-12).
Týden (UTC)int, nullWeek of ticket reopening (1-53).
Hodina (UTC)int, nullHour in which the ticket was reopened (0-23).
Značka a název požadavkunvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
Vyřešeno (UTC)datetime, nullDate and time of ticket solution.
Znovu otevřeno (UTC)datetime, nullDate and time of ticket reopening.
Doba vyřešení (hodiny)float, not nullTime elapsed in hours from the solution up to the reopening of the ticket.
Související organizacenvarchar(255), not nullName of the organization for which the ticket is being implemented.
Procesnvarchar(255), nullProcess name.
Id žadateleint, not nullThe ID number of the ticket requester - see Query.Person{locale}.id.
Id řešiteleint, nullThe current ticket solver ID number - see Query.Person{locale}.id.
Id službyint, not nullThe service ID number - see Query.Section{locale}.id.
Id SLAint, not nullThe SLA ID number - see Query.Sla{locale}.id.
Id organizace žadateleint, nullThe requester’s organization ID number - see Query.Organization{locale}.id.
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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-Nummerint, not nullThe ticket identification number.
Name der Anfragenvarchar(1024), nullTicket name
Servicenvarchar(1024), nullName of the service including the path in the tree.
SLAnvarchar(255), nullSLA name.
Anfragestellernvarchar(255), nullFirst and last name of the requester.
Organisation (Anfragesteller)nvarchar(255), nullName of the requester’s organization.
Bearbeiternvarchar(255), nullName and surname of the solver.
Gelöst vonnvarchar(255), nullName and surname of the solver who resolved the ticket.
Termin (UTC)datetime, nullTicket due date.
Internes Zielnvarchar(255), nullInternal target name.
Internes Ziel (Termin) (UTC)datetime, nullInternal target date.
Höchste Anfrageint, nullIdentification number of the root parent ticket.
Höchster Servicenvarchar(1024), nullName of root service in the service tree.
Datum (UTC)datetime, nullDate of ticket reopening.
Woche seit (UTC)datetime, nullDate of the beginning of the week in which the ticket was reopened.
Monat seit (UTC)datetime, nullDate of the beginning of the month in which the ticket was reopened.
Jahr (UTC)int, nullYear of ticket reopening.
Quartal (UTC)int, nullQuarter in which the ticket was reopened (1-4).
Monat (UTC)int, nullMonth in which the ticket was reopened (1-12).
Woche (UTC)int, nullWeek of ticket reopening (1-53).
Stunde (UTC)int, nullHour in which the ticket was reopened (0-23).
Zeichen und Name der Anfragenvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
Gelöst (UTC)datetime, nullDate and time of ticket solution.
Wieder geöffnet (UTC)datetime, nullDate and time of ticket reopening.
Lösungszeit (Stunden)float, not nullTime elapsed in hours from the solution up to the reopening of the ticket.
Zugehörige Organisationennvarchar(255), not nullName of the organization for which the ticket is being implemented.
Prozessnvarchar(255), nullProcess name.
Id des Anfragestellersint, not nullThe ID number of the ticket requester - see Query.Person{locale}.id.
ID des Bearbeitersint, nullThe current ticket solver ID number - see Query.Person{locale}.id.
Id des Serviceint, not nullThe service ID number - see Query.Section{locale}.id.
Id der SLAint, not nullThe SLA ID number - see Query.Sla{locale}.id.
Id der Organisation des Anfragestellersint, nullThe requester’s organization ID number - see Query.Organization{locale}.id.
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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 numberint, not nullThe ticket identification number.
Request namenvarchar(1024), nullTicket name
Servicenvarchar(1024), nullName of the service including the path in the tree.
SLAnvarchar(255), nullSLA name.
Requesternvarchar(255), nullFirst and last name of the requester.
Organization (requester)nvarchar(255), nullName of the requester’s organization.
Solvernvarchar(255), nullName and surname of the solver.
Resolved bynvarchar(255), nullName and surname of the solver who resolved the ticket.
Due date (UTC)datetime, nullTicket due date.
Internal targetnvarchar(255), nullInternal target name.
Internal target (due date) (UTC)datetime, nullInternal target date.
Highest requestint, nullIdentification number of the root parent ticket.
Highest servicenvarchar(1024), nullName of root service in the service tree.
Date (UTC)datetime, nullDate of ticket reopening.
Week starting (UTC)datetime, nullDate of the beginning of the week in which the ticket was reopened.
Month starting (UTC)datetime, nullDate of the beginning of the month in which the ticket was reopened.
Year (UTC)int, nullYear of ticket reopening.
Quarter (UTC)int, nullQuarter in which the ticket was reopened (1-4).
Month (UTC)int, nullMonth in which the ticket was reopened (1-12).
Week (UTC)int, nullWeek of ticket reopening (1-53).
Hour (UTC)int, nullHour in which the ticket was reopened (0-23).
Request tag and titlenvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
Resolved (UTC)datetime, nullDate and time of ticket solution.
Reopened (UTC)datetime, nullDate and time of ticket reopening.
Resolution time (hours)float, not nullTime elapsed in hours from the solution up to the reopening of the ticket.
Related organizationnvarchar(255), not nullName of the organization for which the ticket is being implemented.
Processnvarchar(255), nullProcess name.
Requester IDint, not nullThe ID number of the ticket requester - see Query.Person{locale}.id.
Solver IDint, nullThe current ticket solver ID number - see Query.Person{locale}.id.
Service IDint, not nullThe service ID number - see Query.Section{locale}.id.
SLA IDint, not nullThe SLA ID number - see Query.Sla{locale}.id.
Requesters organization IDint, nullThe requester’s organization ID number - see Query.Organization{locale}.id.
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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
idint, not nullIdentification number of the ticket status - see dbo.TicketState.id.
Názevnvarchar(64), not nullTicket status name
Popis pro žadatelenvarchar(max), nullA description of the status visible to the requester.
Schvalováníbit, not nullTicket approval is performed at this status.
Pozastaveno SLAbit, not nullSLA is paused at this status.
Mimořádný stavint, not nullEmergency status
Pořadí v postupu řešeníint, not nullThe order of the status in the process resolution procedure
ProcessIdint, nullThe process ID number in which the status is in the solution process - see Query.Process{locale}.id.
AdminUrlnvarchar(2141), nullURL 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
idint, not nullIdentification number of the ticket status - see dbo.TicketState.id.
Bezeichnungnvarchar(64), not nullTicket status name
Beschreigung für den Anfragestellernvarchar(max), nullA description of the status visible to the requester.
Freigabebit, not nullTicket approval is performed at this status.
SLA ausgesetztbit, not nullSLA is paused at this status.
Außerordentlicher Statusint, not nullEmergency status
Reihenfolge im Lösungsablaufint, not nullThe order of the status in the process resolution procedure
ProcessIdint, nullThe process ID number in which the status is in the solution process - see Query.Process{locale}.id.
AdminUrlnvarchar(2141), nullURL 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
idint, not nullIdentification number of the ticket status - see dbo.TicketState.id.
Namenvarchar(64), not nullTicket status name
Description for the requesternvarchar(max), nullA description of the status visible to the requester.
Approvingbit, not nullTicket approval is performed at this status.
SLA pausedbit, not nullSLA is paused at this status.
Emergency statusint, not nullEmergency status
Order in solving processint, not nullThe order of the status in the process resolution procedure
ProcessIdint, nullThe process ID number in which the status is in the solution process - see Query.Process{locale}.id.
AdminUrlnvarchar(2141), nullURL 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žadavkuint, not nullThe ticket identification number.
Název požadavkunvarchar(1024), nullTicket name
Službanvarchar(1024), nullName of the service including the path in the tree.
SLAnvarchar(255), nullSLA name.
Žadatelnvarchar(255), nullFirst and last name of the requester.
Organizace (žadatel)nvarchar(255), nullName of the requester’s organization.
Řešitelnvarchar(255), nullName and surname of the solver.
Termín (UTC)datetime, nullTicket due date.
Interní cílnvarchar(255), nullInternal target name.
Interní cíl (termín) (UTC)datetime, nullInternal target date.
Datum (UTC)datetime, nullDate of follow-up reaction.
Týden od (UTC)datetime, nullDate of the beginning of the week of follow-up reaction.
Měsíc od (UTC)datetime, nullDate of the beginning of the month of follow-up reaction.
Rok (UTC)int, nullYear of follow-up reaction.
Čtvrtletí (UTC)int, nullQuarter of reaction (1-4).
Měsíc (UTC)int, nullMonth of follow-up reaction (1-12).
Týden (UTC)int, nullWeek of follow-up reaction (1-53).
Hodina (UTC)int, nullHour of follow-up reaction (0-23).
Reagovalnvarchar(255), nullName and surname of the solver who sent the message.
Doba do reakce (hodiny)float, not nullHours until follow-up reaction.
Překročení SLA (hodiny)float, nullBy how many hours was the SLA time to first reaction deadline exceeded.
Splnění SLA (hodiny)float, nullHow many hours earlier was the reaction met than as required by the SLA limit.
Značka a název požadavkunvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
Související organizacenvarchar(255), not nullName of the organization for which the ticket is being implemented.
Nejvyšší požadavekint, nullIdentification number of the root parent ticket.
Nejvyšší službanvarchar(1024), nullName of root service in the tree.
Procesnvarchar(255), nullProcess name.
Id žadateleint, not nullThe ID number of the ticket requester - see Query.Person{locale}.id.
Id řešiteleint, nullThe current ticket solver ID number - see Query.Person{locale}.id.
Id službyint, not nullThe service ID number - see Query.Section{locale}.id.
Id SLAint, not nullThe SLA ID number - see Query.Sla{locale}.id.
Id organizace žadateleint, nullThe requester’s organization ID number - see Query.Organization{locale}.id.
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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-Nummerint, not nullThe ticket identification number.
Name der Anfragenvarchar(1024), nullTicket name
Servicenvarchar(1024), nullName of the service including the path in the tree.
SLAnvarchar(255), nullSLA name.
Anfragestellernvarchar(255), nullFirst and last name of the requester.
Organisation (Anfragesteller)nvarchar(255), nullName of the requester’s organization.
Bearbeiternvarchar(255), nullName and surname of the solver.
Termin (UTC)datetime, nullTicket due date.
Internes Zielnvarchar(255), nullInternal target name.
Internes Ziel (Termin) (UTC)datetime, nullInternal target date.
Datum (UTC)datetime, nullDate of follow-up reaction.
Woche seit (UTC)datetime, nullDate of the beginning of the week of follow-up reaction.
Monat seit (UTC)datetime, nullDate of the beginning of the month of follow-up reaction.
Jahr (UTC)int, nullYear of follow-up reaction.
Quartal (UTC)int, nullQuarter of reaction (1-4).
Monat (UTC)int, nullMonth of follow-up reaction (1-12).
Woche (UTC)int, nullWeek of follow-up reaction (1-53).
Stunde (UTC)int, nullHour of follow-up reaction (0-23).
Reagiertnvarchar(255), nullName and surname of the solver who sent the message.
Zeit bis zur Reaktion (Stunden)float, not nullHours until follow-up reaction.
Überschreitung der SLA (Stunden)float, nullBy how many hours was the SLA time to first reaction deadline exceeded.
Erfüllung von SLA (Stunden)float, nullHow many hours earlier was the reaction met than as required by the SLA limit.
Zeichen und Name der Anfragenvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
Zugehörige Organisationennvarchar(255), not nullName of the organization for which the ticket is being implemented.
Höchste Anfrageint, nullIdentification number of the root parent ticket.
Höchster Servicenvarchar(1024), nullName of root service in the tree.
Prozessnvarchar(255), nullProcess name.
Id des Anfragestellersint, not nullThe ID number of the ticket requester - see Query.Person{locale}.id.
ID des Bearbeitersint, nullThe current ticket solver ID number - see Query.Person{locale}.id.
Id des Serviceint, not nullThe service ID number - see Query.Section{locale}.id.
Id der SLAint, not nullThe SLA ID number - see Query.Sla{locale}.id.
Id der Organisation des Anfragestellersint, nullThe requester’s organization ID number - see Query.Organization{locale}.id.
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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 numberint, not nullThe ticket identification number.
Request namenvarchar(1024), nullTicket name
Servicenvarchar(1024), nullName of the service including the path in the tree.
SLAnvarchar(255), nullSLA name.
Requesternvarchar(255), nullFirst and last name of the requester.
Organization (requester)nvarchar(255), nullName of the requester’s organization.
Solvernvarchar(255), nullName and surname of the solver.
Due date (UTC)datetime, nullTicket due date.
Internal targetnvarchar(255), nullInternal target name.
Internal target (due date) (UTC)datetime, nullInternal target date.
Date (UTC)datetime, nullDate of follow-up reaction.
Week starting (UTC)datetime, nullDate of the beginning of the week of follow-up reaction.
Month starting (UTC)datetime, nullDate of the beginning of the month of follow-up reaction.
Year (UTC)int, nullYear of follow-up reaction.
Quarter (UTC)int, nullQuarter of reaction (1-4).
Month (UTC)int, nullMonth of follow-up reaction (1-12).
Week (UTC)int, nullWeek of follow-up reaction (1-53).
Hour (UTC)int, nullHour of follow-up reaction (0-23).
Respondednvarchar(255), nullName and surname of the solver who sent the message.
Time until response (hours)float, not nullHours until follow-up reaction.
SLA breached by (hours)float, nullBy how many hours was the SLA time to first reaction deadline exceeded.
Time until SLA breach (hours)float, nullHow many hours earlier was the reaction met than as required by the SLA limit.
Request tag and titlenvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
Related organizationnvarchar(255), not nullName of the organization for which the ticket is being implemented.
Highest requestint, nullIdentification number of the root parent ticket.
Highest servicenvarchar(1024), nullName of root service in the tree.
Processnvarchar(255), nullProcess name.
Requester IDint, not nullThe ID number of the ticket requester - see Query.Person{locale}.id.
Solver IDint, nullThe current ticket solver ID number - see Query.Person{locale}.id.
Service IDint, not nullThe service ID number - see Query.Section{locale}.id.
SLA IDint, not nullThe SLA ID number - see Query.Sla{locale}.id.
Requesters organization IDint, nullThe requester’s organization ID number - see Query.Organization{locale}.id.
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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
TimeStampdatetime, not nullDate and time of the change execution.
MemberTypenvarchar(50), nullUser or group.
Membernvarchar(255), not nullUser name or group name.
Operationnvarchar(50), nullOperation - added or removed.
Groupnvarchar(255), not nullName of the group in which membership changed.
ModifiedBynvarchar(255), not nullThe name of the user who did the change.

Query.SearchLogCsy​

Searched queries

ColumnTypeDescription
Dotaznvarchar(max), nullSearched query
Uživatelnvarchar(255), nullUsername of the person who searched the query
Datum vyhledání (UTC)datetime, not nullDate and time of search
Datum vyhledání - Týden od (UTC)datetime, nullDate of the first day of the week in which the query was searched.
Datum vyhledání - Měsíc od (UTC)datetime, nullDate of the first day of the month in which the query was searched
Datum vyhledání - Rok (UTC)int, nullYear of query search

Query.SearchLogDeu​

Searched queries

ColumnTypeDescription
Abfragenvarchar(max), nullSearched query
Benutzernvarchar(255), nullUsername of the person who searched the query
Datum der Suche (UTC)datetime, not nullDate and time of search
Datum der Suche - Woche von (UTC)datetime, nullDate of the first day of the week in which the query was searched.
Datum der Suche - Monat von (UTC)datetime, nullDate of the first day of the month in which the query was searched
Datum der Suche - Jahr (UTC)int, nullYear of query search

Query.SearchLogEnu​

Searched queries

ColumnTypeDescription
Querynvarchar(max), nullSearched query
Usernvarchar(255), nullUsername of the person who searched the query
Search date (UTC)datetime, not nullDate and time of search
Search date - Week from (UTC)datetime, nullDate of the first day of the week in which the query was searched.
Search date - Month from (UTC)datetime, nullDate of the first day of the month in which the query was searched
Search date - Year (UTC)int, nullYear 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
idint, not nullIdentification number of the service - see dbo.tHdSection.iHdSectionId.
Názevnvarchar(255), nullService name
Název (včetně cesty ve stromu)nvarchar(1024), nullName of the service including the path in the tree
E-mailnvarchar(255), nullService e-mail
Telefonnvarchar(255), nullService telephone
Předpona značky požadavkunvarchar(255), nullTicket tag prefix
Přípona značky požadavkunvarchar(255), nullTicket tag suffix
Preferovaný jazyknvarchar(max), nullThe name of the preferred language of the service
Časové pásmonvarchar(max), nullThe name of the service time zone
Složkabit, not nullThe service is a folder.
ParentSectionIdint, nullThe parent service ID number -see Query.Section{locale}.id.
RootSectionIdint, nullThe highest parent service ID number - see Query.Section{locale}.id.
ProcessIdint, not nullThe service process ID number - see Query.Process{locale}.id.
TargetSectionIdint, nullIf 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ánceint, not nullA service is a link on the home page.
AdminUrlnvarchar(2091), nullURL of the service page in the administration.
CatalogUrlnvarchar(2090), nullURL of the service page/form in the service catalog.
Request for HW - catalog pathnvarchar(max), null
Request for HW - categoriesnvarchar(max), null
Request for HW - currencynvarchar(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
idint, not nullIdentification number of the service - see dbo.tHdSection.iHdSectionId.
Bezeichnungnvarchar(255), nullService name
Name (einschließlich des Weges in Baumstruktur)nvarchar(1024), nullName of the service including the path in the tree
E-Mailnvarchar(255), nullService e-mail
Telefonnvarchar(255), nullService telephone
Präfix der Kennung der Anfragenvarchar(255), nullTicket tag prefix
Suffix der Kennung der Anfragenvarchar(255), nullTicket tag suffix
Bevorzugte Sprachenvarchar(max), nullThe name of the preferred language of the service
Zeitzonenvarchar(max), nullThe name of the service time zone
Ordnerbit, not nullThe service is a folder.
ParentSectionIdint, nullThe parent service ID number -see Query.Section{locale}.id.
RootSectionIdint, nullThe highest parent service ID number - see Query.Section{locale}.id.
ProcessIdint, not nullThe service process ID number - see Query.Process{locale}.id.
TargetSectionIdint, nullIf 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 Hauptseiteint, not nullA service is a link on the home page.
AdminUrlnvarchar(2091), nullURL of the service page in the administration.
CatalogUrlnvarchar(2090), nullURL of the service page/form in the service catalog.
Request for HW - catalog pathnvarchar(max), null
Request for HW - categoriesnvarchar(max), null
Request for HW - currencynvarchar(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
idint, not nullIdentification number of the service - see dbo.tHdSection.iHdSectionId.
Namenvarchar(255), nullService name
Name (including the path in tree)nvarchar(1024), nullName of the service including the path in the tree
E-mailnvarchar(255), nullService e-mail
Phonenvarchar(255), nullService telephone
Request tag prefixnvarchar(255), nullTicket tag prefix
Request tag suffixnvarchar(255), nullTicket tag suffix
Preferred languagenvarchar(max), nullThe name of the preferred language of the service
Time zonenvarchar(max), nullThe name of the service time zone
Folderbit, not nullThe service is a folder.
ParentSectionIdint, nullThe parent service ID number -see Query.Section{locale}.id.
RootSectionIdint, nullThe highest parent service ID number - see Query.Section{locale}.id.
ProcessIdint, not nullThe service process ID number - see Query.Process{locale}.id.
TargetSectionIdint, nullIf 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 homepageint, not nullA service is a link on the home page.
AdminUrlnvarchar(2091), nullURL of the service page in the administration.
CatalogUrlnvarchar(2090), nullURL of the service page/form in the service catalog.
Request for HW - catalog pathnvarchar(max), null
Request for HW - categoriesnvarchar(max), null
Request for HW - currencynvarchar(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
idint, not nullIdentification number of SLA - see dbo.tSla.iSlaId.
Názevnvarchar(255), nullSLA name
Popisnvarchar(max), nullSLA description
Provozní dobanvarchar(255), nullSLA operating time name
Doba do první reakce (hodiny v provozní době)float, nullThe 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, nullThe number of hours until the ticket first response solution with this SLA is guaranteed.
Smlouva (číslo)nvarchar(255), nullSLA contract number
Index kvalityfloat, nullQuality index
Poznámkynvarchar(max), nullSLA notes
AdminUrlnvarchar(2076), nullURL 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
idint, not nullIdentification number of SLA - see dbo.tSla.iSlaId.
Bezeichnungnvarchar(255), nullSLA name
Beschreibungnvarchar(max), nullSLA description
Betriebszeitnvarchar(255), nullSLA operating time name
Zeit bis zur ersten Reaktion (Stunden innerhalb der Betriebszeit)float, nullThe 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, nullThe number of hours until the ticket first response solution with this SLA is guaranteed.
Vertrag (Nummer)nvarchar(255), nullSLA contract number
Qualitätsindexfloat, nullQuality index
Anmerkungennvarchar(max), nullSLA notes
AdminUrlnvarchar(2076), nullURL 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
idint, not nullIdentification number of SLA - see dbo.tSla.iSlaId.
Namenvarchar(255), nullSLA name
Descriptionnvarchar(max), nullSLA description
Operating hoursnvarchar(255), nullSLA operating time name
Time until the first response (hours during the operating hours)float, nullThe 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, nullThe number of hours until the ticket first response solution with this SLA is guaranteed.
Contract (number)nvarchar(255), nullSLA contract number
Quality indexfloat, nullQuality index
Notesnvarchar(max), nullSLA notes
AdminUrlnvarchar(2076), nullURL 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
TimeStampdatetime, not nullChange performance date and time (UTC)
ModifiedByPersonnvarchar(518), not nullThe name of the user who did the change.
HdSectionnvarchar(1287), nullService name
HdSectionOldnvarchar(1287), nullOriginal service name
Rolenvarchar(518), nullUser group name which is the permission holder.
RoleOldnvarchar(518), nullUser group name of a person who was originally a permission holder.
Personnvarchar(518), nullUser name of a person who is the permission holder.
PersonOldnvarchar(518), nullUser name of a person who was originally a permission holder.
Slanvarchar(518), nullSLA name
SlaOldnvarchar(518), nullOriginal SLA name
Accessbit, nullAccess permissions
AccessOldbit, nullOriginal access permissions
Defaultbit, nullMarking of the default SLA
DefaultOldbit, nullOriginal marking of the default SLA
Inheritancebit, null
InheritanceOldbit, null

Query.Software​

View with installed products (software) on not yet deleted computers.

ColumnTypeDescription
ComputerNodeIdint, nullNode ID of the computer in the tree.
ParentNodeIdint, nullNode ID of the parent's object in the tree.
Productnvarchar(1023), nullProduct name.
Categoryint, nullProduct category (e.g. 1 - OS).
NeedsLicenseint, not null1=product requires license.
FirstInstallationDetecteddatetime, nullDate of the installation first detection.
Installeddatetime, nullDate of installation.
LastDetectionDateTimedatetime, nullDate of the last detection.
LastDetectedProductVersionnvarchar(255), nullLast detected version.
LastDetectedProductNamenvarchar(255), nullLast detected product name.
LicenseInventoryNumbernvarchar(255), nullInventory number for license.
LicenseActivationKeynvarchar(255), nullLicense activation number.
LicenseInvoiceNumbernvarchar(255), nullLicense invoice number.
LicenseCertificateNumbernvarchar(255), nullLicense certificate number.
Authorizedbit, nullThe software installation on the computer is confirmed or a license has been assigned to that computer.
CDKeynvarchar(255), nullCD key for the software product.
Descriptionnvarchar(max), nullLast note at an installation history record.
LicenceNamenvarchar(255), nullLicense name.
Publishernvarchar(255), nullSoftware manufacturer.
SoftwarePackint, not nullThe product is from the SW package.
Typeint, nullSoftware product type. 1 - commercial 2 - freeware 3 - shareware/trial 4 - not specified
Userint, nullAuthor of the product installation.
Commentnvarchar(255), nullInstallation comment.

Query.SwInstallationCsy​

Software installation in ALVAO Asset Management - Installation Registry.
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
Produktnvarchar(1023), nullProduct name
Detekovaný název produktunvarchar(255), nullDetected product name
Detekovaná verze produktunvarchar(255), nullDetected product version
Id objektuint, not nullIdentification number of a computer that contains given installation.
Uživatelnvarchar(255), nullUser name under which the computer with the installed product is located in the objects tree.
Licencenvarchar(255), nullLicense name
Počet přidělených licencíint, not nullNumber of assigned licenses
Typ licencenvarchar(32), nullLicense type, e.g. "Normal", "Unlimited multilicense", "OEM", "Floating", ...
Stav licencenvarchar(11), not nullLicense status. The column may have the following values "Without license" and "With license" (in Czech).
Stav licence - podrobnýnvarchar(255), nullSimilar license status, e.g. "Missing", "Not necessary", "Assigned", "Shared".
Stav profilunvarchar(255), nullProfile status, e.g. "Disabled", "Optional", ...
Produkt nalezen (UTC)datetime, nullDate and time when the product installation was detected on a computer.
Zjištěno odinstalování (UTC)datetime, nullDate and time when the product uninstallation was detected on a computer.
Nainstalovánodatetime, nullManually registered installation date
Odinstalovánodatetime, nullManually registered uninstallation date
Produkt nalezen - Měsíc od (UTC)datetime, nullDate of the first day of month when the installation was detected.
Zjištěno odinstalování - Měsíc od (UTC)datetime, nullDate of the first day of month when the uninstallation was detected.
Nainstalováno - Měsíc oddatetime, nullDate of the first day of month when the installation was manually registered.
Odinstalováno - Měsíc oddatetime, nullDate of the first day of month when the uninstallation was manually registered.
Typ produktunvarchar(255), nullProduct type, e.g. "commercial", "freeware", ...
Stav instalacenvarchar(13), not nullInstallation status. The column may have the following values "Installed" and "Uninstalled" (in Czech).
Nákladové střediskonvarchar(255), nullComputer cost center
Operační systémnvarchar(3), not nullIt 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.
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
Produktnvarchar(1023), nullProduct name
Detektiertes Produktnamenvarchar(255), nullDetected product name
Detektierte Produktversionnvarchar(255), nullDetected product version
Objekt Idint, not nullIdentification number of a computer that contains given installation.
Benutzernvarchar(255), nullUser name under which the computer with the installed product is located in the objects tree.
Lizenznvarchar(255), nullLicense name
Anzahl der zugeteilten Lizenzenint, not nullNumber of assigned licenses
Lizenztypnvarchar(32), nullLicense type, e.g. "Normal", "Unlimited multilicense", "OEM", "Floating", ...
Lizenz-Statusnvarchar(11), not nullLicense status. The column may have the following values "Without license" and "With license" (in Czech).
Lizenz-Status - detailliertnvarchar(255), nullSimilar license status, e.g. "Missing", "Not necessary", "Assigned", "Shared".
Profil-Statusnvarchar(255), nullProfile status, e.g. "Disabled", "Optional", ...
Produkt gefunden (UTC)datetime, nullDate and time when the product installation was detected on a computer.
Deinstallation erkannt (UTC)datetime, nullDate and time when the product uninstallation was detected on a computer.
Installiertdatetime, nullManually registered installation date
Deinstalliertdatetime, nullManually registered uninstallation date
Produkt gefunden - Monat beginnt (UTC)datetime, nullDate of the first day of month when the installation was detected.
Deinstallation erkannt - Monat seit (UTC)datetime, nullDate of the first day of month when the uninstallation was detected.
Installiert - Monat seitdatetime, nullDate of the first day of month when the installation was manually registered.
Deinstalliert - Monat seitdatetime, nullDate of the first day of month when the uninstallation was manually registered.
Produkttypnvarchar(255), nullProduct type, e.g. "commercial", "freeware", ...
Installationsstatusnvarchar(13), not nullInstallation status. The column may have the following values "Installed" and "Uninstalled" (in Czech).
Kostenstellenvarchar(255), nullComputer cost center
Betriebssystemnvarchar(4), not nullIt 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.
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
Productnvarchar(1023), nullProduct name
Detected product namenvarchar(255), nullDetected product name
Detected product versionnvarchar(255), nullDetected product version
Object idint, not nullIdentification number of a computer that contains given installation.
Usernvarchar(255), nullUser name under which the computer with the installed product is located in the objects tree.
Licensenvarchar(255), nullLicense name
Number of assigned licensesint, not nullNumber of assigned licenses
License typenvarchar(32), nullLicense type, e.g. "Normal", "Unlimited multilicense", "OEM", "Floating", ...
License statusnvarchar(15), not nullLicense status. The column may have the following values "Without license" and "With license" (in Czech).
License status - detailednvarchar(255), nullSimilar license status, e.g. "Missing", "Not necessary", "Assigned", "Shared".
Profile statusnvarchar(255), nullProfile status, e.g. "Disabled", "Optional", ...
Product found (UTC)datetime, nullDate and time when the product installation was detected on a computer.
Software uninstallation detected (UTC)datetime, nullDate and time when the product uninstallation was detected on a computer.
Installeddatetime, nullManually registered installation date
Uninstalleddatetime, nullManually registered uninstallation date
Product found date - Month starting (UTC)datetime, nullDate of the first day of month when the installation was detected.
Uninstallation detected - Month from (UTC)datetime, nullDate of the first day of month when the uninstallation was detected.
Installed - Month fromdatetime, nullDate of the first day of month when the installation was manually registered.
Uninstalled - Month fromdatetime, nullDate of the first day of month when the uninstallation was manually registered.
Product typenvarchar(255), nullProduct type, e.g. "commercial", "freeware", ...
Installation statusnvarchar(11), not nullInstallation status. The column may have the following values "Installed" and "Uninstalled" (in Czech).
Cost centernvarchar(255), nullComputer cost center
Operating systemnvarchar(3), not nullIt 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 licencenvarchar(255), nullLicense name
Produktnvarchar(1023), nullProduct name
Typ produktunvarchar(255), nullProduct type, e.g. "commercial", "freeware", ...
Početint, nullNumber of licenses. 1 for free floating unlimited multilicenses.
Stav přidělenínvarchar(18), nullAssignment status. The column may have the following values "Assigned without reason", "Assigned" and "Free" (in Czech).
Typ licencenvarchar(32), not nullLicense type, e.g. "Normal", "Unlimited multilicense", "OEM", "Floating", ...
Datum vytvoření (UTC)datetime, nullLicense creation date and time
Datum vytvoření - Měsíc od (UTC)datetime, nullDate of the first day of month when the license was created.
Vytvořilnvarchar(255), nullUser name of a person who created the license.
Platnost oddate, not nullValid from
Platnost dodate, nullValid to
Upgrade/Podpora dodate, nullEnd date of upgrade/support
Aktivační klíč licencenvarchar(1024), nullLicense activation key
Inventární číslo licencenvarchar(255), nullLicense inventory number
Licenční modelnvarchar(32), not nullCAL/Licensing, e.g. "to processor", "to user", "to device", ...
Nákladové střediskonvarchar(255), not nullLicense cost center name
Uživatelnvarchar(255), nullUser name of a person whom the license is assigned to. NULL if the license is assigned to a computer.
Počítačnvarchar(255), nullName of a computer which the license is assigned to. NULL if the license is assigned to a user.
Id objektuint, nullObject 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
Lizenznamenvarchar(255), nullLicense name
Produktnvarchar(1023), nullProduct name
Produkttypnvarchar(255), nullProduct type, e.g. "commercial", "freeware", ...
Anzahlint, nullNumber of licenses. 1 for free floating unlimited multilicenses.
Zuweisungsstatusnvarchar(21), nullAssignment status. The column may have the following values "Assigned without reason", "Assigned" and "Free" (in Czech).
Lizenztypnvarchar(32), not nullLicense type, e.g. "Normal", "Unlimited multilicense", "OEM", "Floating", ...
Erstellungsdatum (UTC)datetime, nullLicense creation date and time
Erstellungsdatum - Monat beginnt (UTC)datetime, nullDate of the first day of month when the license was created.
Erstellt vonnvarchar(255), nullUser name of a person who created the license.
Gültig abdate, not nullValid from
Gültig bisdate, nullValid to
Upgrade/Support bisdate, nullEnd date of upgrade/support
Aktivierungsschlüssel der Lizenznvarchar(1024), nullLicense activation key
Inventarnummer der Lizenznvarchar(255), nullLicense inventory number
Lizenzmodellnvarchar(32), not nullCAL/Licensing, e.g. "to processor", "to user", "to device", ...
Kostenstellenvarchar(255), not nullLicense cost center name
Benutzernvarchar(255), nullUser name of a person whom the license is assigned to. NULL if the license is assigned to a computer.
Computernvarchar(255), nullName of a computer which the license is assigned to. NULL if the license is assigned to a user.
Objekt Idint, nullObject 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 namenvarchar(255), nullLicense name
Productnvarchar(1023), nullProduct name
Product typenvarchar(255), nullProduct type, e.g. "commercial", "freeware", ...
Countint, nullNumber of licenses. 1 for free floating unlimited multilicenses.
Assignment statusnvarchar(23), nullAssignment status. The column may have the following values "Assigned without reason", "Assigned" and "Free" (in Czech).
License typenvarchar(32), not nullLicense type, e.g. "Normal", "Unlimited multilicense", "OEM", "Floating", ...
Creation date (UTC)datetime, nullLicense creation date and time
Creation date - Month starting (UTC)datetime, nullDate of the first day of month when the license was created.
Created bynvarchar(255), nullUser name of a person who created the license.
Valid fromdate, not nullValid from
Valid todate, nullValid to
Upgrade/Support todate, nullEnd date of upgrade/support
License activation keynvarchar(1024), nullLicense activation key
License inventory numbernvarchar(255), nullLicense inventory number
License modelnvarchar(32), not nullCAL/Licensing, e.g. "to processor", "to user", "to device", ...
Cost centernvarchar(255), not nullLicense cost center name
Usernvarchar(255), nullUser name of a person whom the license is assigned to. NULL if the license is assigned to a computer.
Computernvarchar(255), nullName of a computer which the license is assigned to. NULL if the license is assigned to a user.
Object idint, nullObject identification number the license is assigned to.

Query.UserLogonLog​

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

ColumnTypeDescription
TimeStampdatetime, not nullDate and time of the change execution.
Usernamenvarchar(255), not nullThe username of the user.
Usernvarchar(255), nullUser name.
Actionnvarchar(50), nullExecuted action - logon, logout.
Applicationnvarchar(50), nullName of the application in which he executed the action.
Computernvarchar(255), nullName of the computer to which he logged in.
IsAdminbit, not nullIdentifier 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
NodeIdint, nullNode ID of the object in the tree.
Subjectnvarchar(max), nullThe text of the object log item title.
Datedatetime, nullDate of the record insert.
Flagint, nullAs far as the object history record is concerned, it contains the value determining the even kind. For more information, please refer to tblHistory.
Textnvarchar(max), nullThe text of the object log item.
Typeint, not null0=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žadavkuint, not nullThe ticket identification number.
Nejvyšší požadavekint, nullIdentification number of the root parent ticket.
Nejvyšší službanvarchar(1024), nullName of root service in the service tree.
Žadatelnvarchar(255), nullFirst and last name of the requester.
Organizace (žadatel)nvarchar(255), nullName of the requester’s organization.
Službanvarchar(1024), nullName of the service including the path in the tree.
Skupinanvarchar(255), null
Název požadavkunvarchar(1024), null
Řešitelnvarchar(255), nullName and surname of the solver.
Oddělení (řešitel)nvarchar(255), nullName of the solver’s department.
Oddělení (žadatel)nvarchar(255), nullName of the requester’s department
Funkce (řešitel)nvarchar(255), nullName of the solver’s job title.
Funkce (žadatel)nvarchar(255), nullName of the requester’s job title.
Interní cílnvarchar(255), nullInternal target name.
Interní cíl (termín) (UTC)datetime, null
Prioritanvarchar(max), nullPriority name.
Procesnvarchar(255), nullProcess name.
SLAnvarchar(255), nullSLA name.
Stavnvarchar(64), not nullTicket status name.
Značka a název požadavkunvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
Způsob podánínvarchar(255), nullTicket submission method, e.g., e-mail, phone, form.
Datum (UTC)datetime, nullDate of ticket creation.
Týden od (UTC)datetime, nullDate of the beginning of the week in which the ticket was created.
Měsíc od (UTC)datetime, nullDate of the beginning of the month in which the ticket was created.
Rok (UTC)int, nullYear of ticket creation.
Čtvrtletí (UTC)int, nullQuarter in which the ticket was created (1-4).
Měsíc (UTC)int, nullMonth in which the ticket was created (1-12).
Týden (UTC)int, nullWeek of ticket creation (1-53).
Den v týdnu (UTC)int, nullDay of the week of ticket creation (1-7).
Hodina (UTC)int, nullHour in which the ticket was created (0-23).
Hrubý stavnvarchar(10), not nullName of general status (Open, Resolved, Closed, Deleted)
Související organizacenvarchar(255), not nullName of the organization for which the ticket is being implemented.
Doba otevření (hodiny v provozní době)float, not nullTime in hours from ticket creation until its closing, or until present, if the ticket is not closed.
První reakce (UTC)datetime, nullDate and time of the first response performance.
První reakce - Měsíc od (UTC)datetime, nullDate of the first day of month when the first response was performed.
První reakce - Týden od (UTC)datetime, nullDate of the first day of week when the first response was performed.
Termín první reakce (UTC)datetime, nullDate 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, nullTime 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, nullTime 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, nullDate 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, nullDate 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í reakcenvarchar(9), nullThe "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, nullDate and time of ticket solution.
Vyřešeno - Měsíc od (UTC)datetime, nullDate of the first day of month when the ticket was solved.
Vyřešeno - Týden od (UTC)datetime, nullDate of the first day of week when the ticket was solved.
Termín vyřešení (UTC)datetime, nullDate 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, nullTime 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, nullTime 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, nullDate 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, nullDate 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), nullThe "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žadavkunvarchar(2072), nullTicket URL in ALVAO WebApp.
Pozastavení SLA (hodiny)float, nullNumber of hours of SLA pause being in progress (due to waiting for requester or ticket status).
Pozastaveno SLA (hodiny)float, nullTotal SLA pause time within a specific requirement in hours (including the currently running SLA pause).
Čekáno na žadatele (hodiny)float, nullTotal 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, nullNumber of hours of waiting for requester being in progress.
Id žadateleint, not null
Id řešiteleint, null
Id službyint, not null
Id SLAint, not null
Id organizace žadateleint, null
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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-Nummerint, not nullThe ticket identification number.
Höchste Anfrageint, nullIdentification number of the root parent ticket.
Höchster Servicenvarchar(1024), nullName of root service in the service tree.
Anfragestellernvarchar(255), nullFirst and last name of the requester.
Organisation (Anfragesteller)nvarchar(255), nullName of the requester’s organization.
Servicenvarchar(1024), nullName of the service including the path in the tree.
Gruppenvarchar(255), null
Name der Anfragenvarchar(1024), null
Bearbeiternvarchar(255), nullName and surname of the solver.
Abteilung (Bearbeiter)nvarchar(255), nullName of the solver’s department.
Abteilung (Anfragesteller)nvarchar(255), nullName of the requester’s department
Funktion (Bearbeiter)nvarchar(255), nullName of the solver’s job title.
Funktion (Anfragesteller)nvarchar(255), nullName of the requester’s job title.
Internes Zielnvarchar(255), nullInternal target name.
Internes Ziel (Termin) (UTC)datetime, null
Prioritätnvarchar(max), nullPriority name.
Prozessnvarchar(255), nullProcess name.
SLAnvarchar(255), nullSLA name.
Statusnvarchar(64), not nullTicket status name.
Zeichen und Name der Anfragenvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
Methode der Einreichungnvarchar(255), nullTicket submission method, e.g., e-mail, phone, form.
Datum (UTC)datetime, nullDate of ticket creation.
Woche seit (UTC)datetime, nullDate of the beginning of the week in which the ticket was created.
Monat seit (UTC)datetime, nullDate of the beginning of the month in which the ticket was created.
Jahr (UTC)int, nullYear of ticket creation.
Quartal (UTC)int, nullQuarter in which the ticket was created (1-4).
Monat (UTC)int, nullMonth in which the ticket was created (1-12).
Woche (UTC)int, nullWeek of ticket creation (1-53).
Wochentag (UTC)int, nullDay of the week of ticket creation (1-7).
Stunde (UTC)int, nullHour in which the ticket was created (0-23).
Gesamtstatusnvarchar(13), not nullName of general status (Open, Resolved, Closed, Deleted)
Zugehörige Organisationennvarchar(255), not nullName of the organization for which the ticket is being implemented.
Öffnungszeit (Stunden innerhalb der Betriebszeit)float, not nullTime in hours from ticket creation until its closing, or until present, if the ticket is not closed.
Erste Reaktion (UTC)datetime, nullDate and time of the first response performance.
Erste Reaktion - Monat seit (UTC)datetime, nullDate of the first day of month when the first response was performed.
Erste Reaktion - Woche seit (UTC)datetime, nullDate of the first day of week when the first response was performed.
Termin der ersten Reaktion (UTC)datetime, nullDate 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, nullTime 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, nullTime 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, nullDate 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, nullDate 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 Reaktionnvarchar(13), nullThe "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, nullDate and time of ticket solution.
Gelöst - Monat seit (UTC)datetime, nullDate of the first day of month when the ticket was solved.
Gelöst - Woche seit (UTC)datetime, nullDate of the first day of week when the ticket was solved.
Termin für die Lösung (UTC)datetime, nullDate 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, nullTime 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, nullTime 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, nullDate 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, nullDate 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ösungnvarchar(13), nullThe "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 Anfragenvarchar(2072), nullTicket URL in ALVAO WebApp.
SLA-Aussetzung (Stunden)float, nullNumber of hours of SLA pause being in progress (due to waiting for requester or ticket status).
SLA ausgesetzt (Stunden)float, nullTotal SLA pause time within a specific requirement in hours (including the currently running SLA pause).
Gewartet auf den Anfragesteller (Stunden)float, nullTotal 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, nullNumber of hours of waiting for requester being in progress.
Id des Anfragestellersint, not null
ID des Bearbeitersint, null
Id des Serviceint, not null
Id der SLAint, not null
Id der Organisation des Anfragestellersint, null
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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 numberint, not nullThe ticket identification number.
Highest requestint, nullIdentification number of the root parent ticket.
Highest servicenvarchar(1024), nullName of root service in the service tree.
Requesternvarchar(255), nullFirst and last name of the requester.
Organization (requester)nvarchar(255), nullName of the requester’s organization.
Servicenvarchar(1024), nullName of the service including the path in the tree.
Groupnvarchar(255), null
Request namenvarchar(1024), null
Solvernvarchar(255), nullName and surname of the solver.
Department (solver)nvarchar(255), nullName of the solver’s department.
Department (requester)nvarchar(255), nullName of the requester’s department
Job title (solver)nvarchar(255), nullName of the solver’s job title.
Job title (requester)nvarchar(255), nullName of the requester’s job title.
Internal targetnvarchar(255), nullInternal target name.
Internal target (due date) (UTC)datetime, null
Prioritynvarchar(max), nullPriority name.
Processnvarchar(255), nullProcess name.
SLAnvarchar(255), nullSLA name.
Statusnvarchar(64), not nullTicket status name.
Request tag and titlenvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
Submission methodnvarchar(255), nullTicket submission method, e.g., e-mail, phone, form.
Date (UTC)datetime, nullDate of ticket creation.
Week starting (UTC)datetime, nullDate of the beginning of the week in which the ticket was created.
Month starting (UTC)datetime, nullDate of the beginning of the month in which the ticket was created.
Year (UTC)int, nullYear of ticket creation.
Quarter (UTC)int, nullQuarter in which the ticket was created (1-4).
Month (UTC)int, nullMonth in which the ticket was created (1-12).
Week (UTC)int, nullWeek of ticket creation (1-53).
Weekday (UTC)int, nullDay of the week of ticket creation (1-7).
Hour (UTC)int, nullHour in which the ticket was created (0-23).
Overall statusnvarchar(8), not nullName of general status (Open, Resolved, Closed, Deleted)
Related organizationnvarchar(255), not nullName of the organization for which the ticket is being implemented.
Opening time (hours during the operating hours)float, not nullTime in hours from ticket creation until its closing, or until present, if the ticket is not closed.
First response (UTC)datetime, nullDate and time of the first response performance.
First response - Month from (UTC)datetime, nullDate of the first day of month when the first response was performed.
First response - Week from (UTC)datetime, nullDate of the first day of week when the first response was performed.
First response deadline (UTC)datetime, nullDate 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, nullTime 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, nullTime 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, nullDate 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, nullDate 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 responsenvarchar(13), nullThe "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, nullDate and time of ticket solution.
Solved - Month from (UTC)datetime, nullDate of the first day of month when the ticket was solved.
Solved - Week from (UTC)datetime, nullDate of the first day of week when the ticket was solved.
Deadline for resolution (UTC)datetime, nullDate 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, nullTime 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, nullTime 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, nullDate 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, nullDate 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 - Resolutionnvarchar(13), nullThe "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 URLnvarchar(2072), nullTicket URL in ALVAO WebApp.
SLA pause (hours)float, nullNumber of hours of SLA pause being in progress (due to waiting for requester or ticket status).
SLA paused (hours)float, nullTotal SLA pause time within a specific requirement in hours (including the currently running SLA pause).
Waited for requester (hours)float, nullTotal 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, nullNumber of hours of waiting for requester being in progress.
Requester IDint, not null
Solver IDint, null
Service IDint, not null
SLA IDint, not null
Requesters organization IDint, null
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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žadavkuint, not nullThe ticket identification number.
Nejvyšší požadavekint, nullIdentification number of the root linked parent ticket.
Název požadavkunvarchar(1024), null
Značka a název požadavkunvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
Službanvarchar(1024), nullName of the service including the path in the tree.
Nejvyšší službanvarchar(1024), nullName of root service in the service tree.
SLAnvarchar(255), nullSLA name.
Žadatelnvarchar(255), nullFirst and last name of the requester.
Organizace (žadatel)nvarchar(255), nullName of the requester’s organization.
Datum (UTC)datetime, nullDate of first reaction.
Týden od (UTC)datetime, nullDate of the beginning of the week of the first reaction.
Měsíc od (UTC)datetime, nullDate of the beginning of the month of the first reaction.
Rok (UTC)int, nullYear of the first reaction.
Čtvrtletí (UTC)int, nullQuarter of the first reaction.
Měsíc (UTC)int, nullMonth of the first reaction.
Týden (UTC)int, nullWeek of the first reaction.
Hodina (UTC)int, nullHour of the first reaction.
Termín (UTC)datetime, null
Interní cílnvarchar(255), nullInternal target name.
Interní cíl (termín) (UTC)datetime, null
Doba do reakce (hodiny)float, nullHours until first reaction.
Překročení SLA (hodiny)float, nullBy how many hours was the SLA first reaction deadline exceeded.
Splnění SLA (hodiny)float, nullHow many hours earlier was the first reaction met than as required by the SLA limit.
Řešitelnvarchar(255), nullName and surname of the current solver.
Reagovalnvarchar(255), nullName and surname of the solver who completed the first reaction.
Reagoval (oddělení)nvarchar(255), nullName of the department of the solver who completed the first reaction.
Reagoval (funkce)nvarchar(255), nullName of the job title of the solver who completed the first reaction.
Reagoval (organizace)nvarchar(255), nullName of the organization of the solver who completed the first reaction.
Související organizacenvarchar(255), not nullName of the organization for which the ticket is being implemented.
Procesnvarchar(255), nullProcess name.
Id žadateleint, not null
Id řešiteleint, null
Id službyint, not null
Id SLAint, not null
Id organizace žadateleint, null
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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-Nummerint, not nullThe ticket identification number.
Höchste Anfrageint, nullIdentification number of the root linked parent ticket.
Name der Anfragenvarchar(1024), null
Zeichen und Name der Anfragenvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
Servicenvarchar(1024), nullName of the service including the path in the tree.
Höchster Servicenvarchar(1024), nullName of root service in the service tree.
SLAnvarchar(255), nullSLA name.
Anfragestellernvarchar(255), nullFirst and last name of the requester.
Organisation (Anfragesteller)nvarchar(255), nullName of the requester’s organization.
Datum (UTC)datetime, nullDate of first reaction.
Woche seit (UTC)datetime, nullDate of the beginning of the week of the first reaction.
Monat seit (UTC)datetime, nullDate of the beginning of the month of the first reaction.
Jahr (UTC)int, nullYear of the first reaction.
Quartal (UTC)int, nullQuarter of the first reaction.
Monat (UTC)int, nullMonth of the first reaction.
Woche (UTC)int, nullWeek of the first reaction.
Stunde (UTC)int, nullHour of the first reaction.
Termin (UTC)datetime, null
Internes Zielnvarchar(255), nullInternal target name.
Internes Ziel (Termin) (UTC)datetime, null
Zeit bis zur Reaktion (Stunden)float, nullHours until first reaction.
Überschreitung der SLA (Stunden)float, nullBy how many hours was the SLA first reaction deadline exceeded.
Erfüllung von SLA (Stunden)float, nullHow many hours earlier was the first reaction met than as required by the SLA limit.
Bearbeiternvarchar(255), nullName and surname of the current solver.
Reagiertnvarchar(255), nullName and surname of the solver who completed the first reaction.
Reagiert (Abteilung)nvarchar(255), nullName of the department of the solver who completed the first reaction.
Reagiert (Funktion)nvarchar(255), nullName of the job title of the solver who completed the first reaction.
Reagiert (Organisation)nvarchar(255), nullName of the organization of the solver who completed the first reaction.
Zugehörige Organisationennvarchar(255), not nullName of the organization for which the ticket is being implemented.
Prozessnvarchar(255), nullProcess name.
Id des Anfragestellersint, not null
ID des Bearbeitersint, null
Id des Serviceint, not null
Id der SLAint, not null
Id der Organisation des Anfragestellersint, null
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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 numberint, not nullThe ticket identification number.
Highest requestint, nullIdentification number of the root linked parent ticket.
Request namenvarchar(1024), null
Request tag and titlenvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
Servicenvarchar(1024), nullName of the service including the path in the tree.
Highest servicenvarchar(1024), nullName of root service in the service tree.
SLAnvarchar(255), nullSLA name.
Requesternvarchar(255), nullFirst and last name of the requester.
Organization (requester)nvarchar(255), nullName of the requester’s organization.
Date (UTC)datetime, nullDate of first reaction.
Week starting (UTC)datetime, nullDate of the beginning of the week of the first reaction.
Month starting (UTC)datetime, nullDate of the beginning of the month of the first reaction.
Year (UTC)int, nullYear of the first reaction.
Quarter (UTC)int, nullQuarter of the first reaction.
Month (UTC)int, nullMonth of the first reaction.
Week (UTC)int, nullWeek of the first reaction.
Hour (UTC)int, nullHour of the first reaction.
Due date (UTC)datetime, null
Internal targetnvarchar(255), nullInternal target name.
Internal target (due date) (UTC)datetime, null
Time until response (hours)float, nullHours until first reaction.
SLA breached by (hours)float, nullBy how many hours was the SLA first reaction deadline exceeded.
Time until SLA breach (hours)float, nullHow many hours earlier was the first reaction met than as required by the SLA limit.
Solvernvarchar(255), nullName and surname of the current solver.
Respondednvarchar(255), nullName and surname of the solver who completed the first reaction.
Responded (department)nvarchar(255), nullName of the department of the solver who completed the first reaction.
Responded (position)nvarchar(255), nullName of the job title of the solver who completed the first reaction.
Responded (organization)nvarchar(255), nullName of the organization of the solver who completed the first reaction.
Related organizationnvarchar(255), not nullName of the organization for which the ticket is being implemented.
Processnvarchar(255), nullProcess name.
Requester IDint, not null
Solver IDint, null
Service IDint, not null
SLA IDint, not null
Requesters organization IDint, null
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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žadavkuint, not nullThe ticket identification number.
Název požadavkunvarchar(1024), null
Službanvarchar(1024), nullName of the service including the path in the tree.
SLAnvarchar(255), nullSLA name.
Řešitelnvarchar(255), nullName and surname of the solver.
Datum (UTC)datetime, nullDate of record creation.
Datum účinnosti (UTC)datetime, nullIn 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, nullDate of the beginning of the week in which the record was created.
Měsíc od (UTC)datetime, nullDate of the beginning of the month in which the record was created.
Rok (UTC)int, nullYear of record creation.
Čtvrtletí (UTC)int, nullThe quarter in which the record was created (1-4).
Měsíc (UTC)int, nullMonth in which the record was created (1-12).
Týden (UTC)int, nullWeek of record creation (1-53).
Hodina (UTC)int, nullHour in which the record was created (0-23).
Odnvarchar(255), nullName and surname of the person who created the record.
Čas celkem (hodiny)float, not nullTotal recorded time (Work + Travel time), in hours.
Značka a název požadavkunvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
Žadatelnvarchar(255), nullFirst and last name of the requester.
Oddělení (žadatel)nvarchar(255), nullName of the requester’s department.
Organizace (žadatel)nvarchar(255), nullName of the requester’s organization.
Pracovní pozice (žadatel)nvarchar(255), nullName of the requester’s job title.
Práce (hodiny)float, nullReported work in hours.
Čas na cestě (hodiny)float, nullReported time spent on trip in hours.
Vzdálenost (km)float, nullReported distance in km.
Druhnvarchar(255), nullType of record (e-mail, note, ...).
Nejvyšší požadavekint, nullIdentification number of the root parent ticket.
Nejvyšší službanvarchar(1024), nullName of root service in the service tree.
Nefakturovatbit, not nullThe "Exclude from invoice to the requester" flag.
Předmětnvarchar(max), nullSubject of the record in the log.
Stavnvarchar(64), not nullTicket status name.
Termín (UTC)datetime, null
Interní cílnvarchar(255), nullInternal target name.
Interní cíl (termín) (UTC)datetime, null
Související organizacenvarchar(255), not nullName of the organization for which the ticket is being implemented.
Procesnvarchar(255), nullProcess name.
Id žadateleint, not null
Id řešiteleint, null
Id službyint, not null
Id SLAint, not null
Id organizace žadateleint, null
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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-Nummerint, not nullThe ticket identification number.
Name der Anfragenvarchar(1024), null
Servicenvarchar(1024), nullName of the service including the path in the tree.
SLAnvarchar(255), nullSLA name.
Bearbeiternvarchar(255), nullName and surname of the solver.
Datum (UTC)datetime, nullDate of record creation.
Datum der Wirksamkeit (UTC)datetime, nullIn 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, nullDate of the beginning of the week in which the record was created.
Monat seit (UTC)datetime, nullDate of the beginning of the month in which the record was created.
Jahr (UTC)int, nullYear of record creation.
Quartal (UTC)int, nullThe quarter in which the record was created (1-4).
Monat (UTC)int, nullMonth in which the record was created (1-12).
Woche (UTC)int, nullWeek of record creation (1-53).
Stunde (UTC)int, nullHour in which the record was created (0-23).
Vonnvarchar(255), nullName and surname of the person who created the record.
Zeit gesamt (Stunden)float, not nullTotal recorded time (Work + Travel time), in hours.
Zeichen und Name der Anfragenvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
Anfragestellernvarchar(255), nullFirst and last name of the requester.
Abteilung (Anfragesteller)nvarchar(255), nullName of the requester’s department.
Organisation (Anfragesteller)nvarchar(255), nullName of the requester’s organization.
Arbeitsposition (Anfragesteller)nvarchar(255), nullName of the requester’s job title.
Arbeit (Stunden)float, nullReported work in hours.
Fahrzeit (Stunden)float, nullReported time spent on trip in hours.
Entfernung (km)float, nullReported distance in km.
Typnvarchar(255), nullType of record (e-mail, note, ...).
Höchste Anfrageint, nullIdentification number of the root parent ticket.
Höchster Servicenvarchar(1024), nullName of root service in the service tree.
Nicht in Rechnung stellenbit, not nullThe "Exclude from invoice to the requester" flag.
Betreffnvarchar(max), nullSubject of the record in the log.
Statusnvarchar(64), not nullTicket status name.
Termin (UTC)datetime, null
Internes Zielnvarchar(255), nullInternal target name.
Internes Ziel (Termin) (UTC)datetime, null
Zugehörige Organisationennvarchar(255), not nullName of the organization for which the ticket is being implemented.
Prozessnvarchar(255), nullProcess name.
Id des Anfragestellersint, not null
ID des Bearbeitersint, null
Id des Serviceint, not null
Id der SLAint, not null
Id der Organisation des Anfragestellersint, null
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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 numberint, not nullThe ticket identification number.
Request namenvarchar(1024), null
Servicenvarchar(1024), nullName of the service including the path in the tree.
SLAnvarchar(255), nullSLA name.
Solvernvarchar(255), nullName and surname of the solver.
Date (UTC)datetime, nullDate of record creation.
Efective date (UTC)datetime, nullIn 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, nullDate of the beginning of the week in which the record was created.
Month starting (UTC)datetime, nullDate of the beginning of the month in which the record was created.
Year (UTC)int, nullYear of record creation.
Quarter (UTC)int, nullThe quarter in which the record was created (1-4).
Month (UTC)int, nullMonth in which the record was created (1-12).
Week (UTC)int, nullWeek of record creation (1-53).
Hour (UTC)int, nullHour in which the record was created (0-23).
Fromnvarchar(255), nullName and surname of the person who created the record.
Total time (hours)float, not nullTotal recorded time (Work + Travel time), in hours.
Request tag and titlenvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
Requesternvarchar(255), nullFirst and last name of the requester.
Department (requester)nvarchar(255), nullName of the requester’s department.
Organization (requester)nvarchar(255), nullName of the requester’s organization.
Job title (requestor)nvarchar(255), nullName of the requester’s job title.
Work (hours)float, nullReported work in hours.
Time traveled (hours)float, nullReported time spent on trip in hours.
Distance (km)float, nullReported distance in km.
Kindnvarchar(255), nullType of record (e-mail, note, ...).
Highest requestint, nullIdentification number of the root parent ticket.
Highest servicenvarchar(1024), nullName of root service in the service tree.
Exclude from invoicebit, not nullThe "Exclude from invoice to the requester" flag.
Subjectnvarchar(max), nullSubject of the record in the log.
Statusnvarchar(64), not nullTicket status name.
Due date (UTC)datetime, null
Internal targetnvarchar(255), nullInternal target name.
Internal target (due date) (UTC)datetime, null
Related organizationnvarchar(255), not nullName of the organization for which the ticket is being implemented.
Processnvarchar(255), nullProcess name.
Requester IDint, not null
Solver IDint, null
Service IDint, not null
SLA IDint, not null
Requesters organization IDint, null
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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žadavkuint, not nullThe ticket identification number.
Název požadavkunvarchar(1024), null
Službanvarchar(1024), nullName of the service including the path in the tree.
SLAnvarchar(255), nullSLA name.
Žadatelnvarchar(255), nullFirst and last name of the requester.
Organizace (žadatel)nvarchar(255), nullName of the requester’s organization.
Řešitelnvarchar(255), nullName and surname of the solver.
Datum (UTC)datetime, nullDate for ticket resolution.
Týden od (UTC)datetime, nullDate of the beginning of the week in which the ticket was solved.
Měsíc od (UTC)datetime, nullDate of the beginning of the month in which the ticket was solved.
Rok (UTC)int, nullYear of ticket resolution.
Čtvrtletí (UTC)int, nullQuarter in which the ticket was resolved (1-4).
Měsíc (UTC)int, nullMonth in which the ticket was resolved (1-12).
Týden (UTC)int, nullWeek of ticket resolution (1-53).
Den v týdnu (UTC)int, nullDay of the week of ticket solution (1-7).
Hodina (UTC)int, nullHour in which the ticket was resolved(0-23).
Značka a název požadavkunvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
Nejvyšší požadavekint, nullIdentification number of the root parent ticket.
Nejvyšší službanvarchar(1024), nullName of root service in the service tree.
Čekáno na žadatele (hodiny)float, nullTotal waiting time for requesters during the whole solution of a ticket, in hours, during the operating hours of the service.
Pozastaveno SLA (hodiny)float, nullTotal SLA pause time within a specific requirement in hours (including the currently running SLA pause).
Doba do vyřešení (hodiny)float, not nullHours from the creation to the resolution of the ticket during the operating hours of the service.
Termín (UTC)datetime, null
Interní cílnvarchar(255), nullInternal target name.
Interní cíl (termín) (UTC)datetime, null
Překročení SLA (hodiny)float, nullBy how many hours was the deadline for solving the ticket as per SLA exceeded.
Splnění SLA (hodiny)float, nullHow many hours earlier the ticket was resolved than the SLA limit.
Překročení termínu (hodiny)float, nullBy how many hours was the deadline for resolution of the ticket exceeded (Ticket time/Due date item).
Splnění termínu (hodiny)float, nullHow many hours earlier the ticket was resolved than the value listed in the Ticket time/Due date item.
Související organizacenvarchar(255), not nullName of the organization for which the ticket is being implemented.
Procesnvarchar(255), nullProcess name.
Rychlost řešenífloat, nullSatisfaction survey - Resolution speed field.
Profesionalitafloat, nullSatisfaction survey - Professionalism field.
Odbornostfloat, nullSatisfaction survey - Expertise field.
Komentáře a poznámkynvarchar(max), nullSatisfaction survey - Comments and remarks field.
Celková spokojenostfloat, nullSatisfaction survey - General satisfaction field.
Id žadateleint, not null
Id řešiteleint, null
Id službyint, not null
Id SLAint, not null
Id organizace žadateleint, null
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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-Nummerint, not nullThe ticket identification number.
Name der Anfragenvarchar(1024), null
Servicenvarchar(1024), nullName of the service including the path in the tree.
SLAnvarchar(255), nullSLA name.
Anfragestellernvarchar(255), nullFirst and last name of the requester.
Organisation (Anfragesteller)nvarchar(255), nullName of the requester’s organization.
Bearbeiternvarchar(255), nullName and surname of the solver.
Datum (UTC)datetime, nullDate for ticket resolution.
Woche seit (UTC)datetime, nullDate of the beginning of the week in which the ticket was solved.
Monat seit (UTC)datetime, nullDate of the beginning of the month in which the ticket was solved.
Jahr (UTC)int, nullYear of ticket resolution.
Quartal (UTC)int, nullQuarter in which the ticket was resolved (1-4).
Monat (UTC)int, nullMonth in which the ticket was resolved (1-12).
Woche (UTC)int, nullWeek of ticket resolution (1-53).
Wochentag (UTC)int, nullDay of the week of ticket solution (1-7).
Stunde (UTC)int, nullHour in which the ticket was resolved(0-23).
Zeichen und Name der Anfragenvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
Höchste Anfrageint, nullIdentification number of the root parent ticket.
Höchster Servicenvarchar(1024), nullName of root service in the service tree.
Gewartet auf den Anfragesteller (Stunden)float, nullTotal waiting time for requesters during the whole solution of a ticket, in hours, during the operating hours of the service.
SLA ausgesetzt (Stunden)float, nullTotal SLA pause time within a specific requirement in hours (including the currently running SLA pause).
Zeit bis zur Lösung (Stunden)float, not nullHours from the creation to the resolution of the ticket during the operating hours of the service.
Termin (UTC)datetime, null
Internes Zielnvarchar(255), nullInternal target name.
Internes Ziel (Termin) (UTC)datetime, null
Überschreitung der SLA (Stunden)float, nullBy how many hours was the deadline for solving the ticket as per SLA exceeded.
Erfüllung von SLA (Stunden)float, nullHow many hours earlier the ticket was resolved than the SLA limit.
Überschreitung des Termins (Stunden)float, nullBy how many hours was the deadline for resolution of the ticket exceeded (Ticket time/Due date item).
Erfüllung des Termins (Stunden)float, nullHow many hours earlier the ticket was resolved than the value listed in the Ticket time/Due date item.
Zugehörige Organisationennvarchar(255), not nullName of the organization for which the ticket is being implemented.
Prozessnvarchar(255), nullProcess name.
Schnelligkeit der Bearbeitungfloat, nullSatisfaction survey - Resolution speed field.
Professionalitätfloat, nullSatisfaction survey - Professionalism field.
Fachkompetenzfloat, nullSatisfaction survey - Expertise field.
Kommentare und Anmerkungennvarchar(max), nullSatisfaction survey - Comments and remarks field.
Gesamtzufriedenheitfloat, nullSatisfaction survey - General satisfaction field.
Id des Anfragestellersint, not null
ID des Bearbeitersint, null
Id des Serviceint, not null
Id der SLAint, not null
Id der Organisation des Anfragestellersint, null
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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 numberint, not nullThe ticket identification number.
Request namenvarchar(1024), null
Servicenvarchar(1024), nullName of the service including the path in the tree.
SLAnvarchar(255), nullSLA name.
Requesternvarchar(255), nullFirst and last name of the requester.
Organization (requester)nvarchar(255), nullName of the requester’s organization.
Solvernvarchar(255), nullName and surname of the solver.
Date (UTC)datetime, nullDate for ticket resolution.
Week starting (UTC)datetime, nullDate of the beginning of the week in which the ticket was solved.
Month starting (UTC)datetime, nullDate of the beginning of the month in which the ticket was solved.
Year (UTC)int, nullYear of ticket resolution.
Quarter (UTC)int, nullQuarter in which the ticket was resolved (1-4).
Month (UTC)int, nullMonth in which the ticket was resolved (1-12).
Week (UTC)int, nullWeek of ticket resolution (1-53).
Weekday (UTC)int, nullDay of the week of ticket solution (1-7).
Hour (UTC)int, nullHour in which the ticket was resolved(0-23).
Request tag and titlenvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
Highest requestint, nullIdentification number of the root parent ticket.
Highest servicenvarchar(1024), nullName of root service in the service tree.
Waited for requester (hours)float, nullTotal waiting time for requesters during the whole solution of a ticket, in hours, during the operating hours of the service.
SLA paused (hours)float, nullTotal SLA pause time within a specific requirement in hours (including the currently running SLA pause).
Time to resolve (hours)float, not nullHours from the creation to the resolution of the ticket during the operating hours of the service.
Due date (UTC)datetime, null
Internal targetnvarchar(255), nullInternal target name.
Internal target (due date) (UTC)datetime, null
SLA breached by (hours)float, nullBy how many hours was the deadline for solving the ticket as per SLA exceeded.
Time until SLA breach (hours)float, nullHow many hours earlier the ticket was resolved than the SLA limit.
Exceeding of due date (hours)float, nullBy how many hours was the deadline for resolution of the ticket exceeded (Ticket time/Due date item).
Meeting of due date (hours)float, nullHow many hours earlier the ticket was resolved than the value listed in the Ticket time/Due date item.
Related organizationnvarchar(255), not nullName of the organization for which the ticket is being implemented.
Processnvarchar(255), nullProcess name.
Resolution speedfloat, nullSatisfaction survey - Resolution speed field.
Professionalismfloat, nullSatisfaction survey - Professionalism field.
Expertisefloat, nullSatisfaction survey - Expertise field.
Comments and notesnvarchar(max), nullSatisfaction survey - Comments and remarks field.
Overall satisfactionfloat, nullSatisfaction survey - General satisfaction field.
Requester IDint, not null
Solver IDint, null
Service IDint, not null
SLA IDint, not null
Requesters organization IDint, null
Problem candidatebit, null
Incident closure codenvarchar(max), null
Symptomsnvarchar(max), null
Diagnostic Activitiesnvarchar(max), null
Root causenvarchar(max), null
Workaroundnvarchar(max), null
Method of resolutionnvarchar(max), null
Problem closure codenvarchar(max), null
Five Whysnvarchar(256), null
Change end (scheduled)datetime, null
Change start (scheduled)datetime, null
Level of risksnvarchar(max), null
Change end (actual)datetime, null
Change start (actual)datetime, null
Risk descriptionnvarchar(256), null
Successful changebit, null
Overran change windowbit, null
Departuredatetime, null
Returndatetime, null
Purpose of tripnvarchar(256), null
Means of transportnvarchar(256), null
Namenvarchar(256), null
Surnamenvarchar(256), null
Departmentnvarchar(max), null
Position namenvarchar(max), null
Managerint, null
Sitenvarchar(max), null
Periodnvarchar(max), null
Number of monthsnvarchar(max), null
First Daydate, 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 carbit, null
Other trainingnvarchar(256), null
Describe potential specific requirementsnvarchar(max), null
Mobile packagenvarchar(max), null
URLnvarchar(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žadavkuint, not nullThe ticket identification number.
Značka a název požadavkunvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
Službanvarchar(1024), nullName of the service including the path in the tree.
Procesnvarchar(255), nullProcess name.
Stavnvarchar(64), not nullTicket status name.
Přechod do stavu (UTC)datetime, nullDate when the ticket was transited to the status.
Přechod ze stavu (UTC)datetime, nullDate when the ticket transited from the status.
Týden od (UTC)datetime, nullDate of the beginning of the week in which the ticket was created.
Měsíc od (UTC)datetime, nullDate of the beginning of the month in which the ticket was created.
Rok (UTC)int, nullYear of ticket creation.
Doba ve stavu (hodiny)float, nullTime in hours for which the ticket was in status.
Doba ve stavu (hodiny v provozní době)float, not nullTime 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-Nummerint, not nullThe ticket identification number.
Zeichen und Name der Anfragenvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
Servicenvarchar(1024), nullName of the service including the path in the tree.
Prozessnvarchar(255), nullProcess name.
Statusnvarchar(64), not nullTicket status name.
Übergang in den Status (UTC)datetime, nullDate when the ticket was transited to the status.
Übergang aus dem Status (UTC)datetime, nullDate when the ticket transited from the status.
Woche seit (UTC)datetime, nullDate of the beginning of the week in which the ticket was created.
Monat seit (UTC)datetime, nullDate of the beginning of the month in which the ticket was created.
Jahr (UTC)int, nullYear of ticket creation.
Zeit in dem Status (Stunden)float, nullTime in hours for which the ticket was in status.
Zeit in dem Status (Stunden innerhalb der Betriebszeit)float, not nullTime 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 numberint, not nullThe ticket identification number.
Request tag and titlenvarchar(1282), nullTag and name of the ticket, e.g., "T123456COMPANY Request for a new printer".
Servicenvarchar(1024), nullName of the service including the path in the tree.
Processnvarchar(255), nullProcess name.
Statusnvarchar(64), not nullTicket status name.
Transition to status (UTC)datetime, nullDate when the ticket was transited to the status.
Transition from status (UTC)datetime, nullDate when the ticket transited from the status.
Week starting (UTC)datetime, nullDate of the beginning of the week in which the ticket was created.
Month starting (UTC)datetime, nullDate of the beginning of the month in which the ticket was created.
Year (UTC)int, nullYear of ticket creation.
Time in status (hours)float, nullTime in hours for which the ticket was in status.
Time in status (hours during the operating hours)float, not nullTime in hours for which the ticket was in status in the operating hours.