Skip Navigation LinksALVAO 10.1ALVAO Service DeskSystem Operation EvaluationSQL Query Skip Navigation Links. Skip Navigation Links Skip Navigation Links.


SQL Query

You can use File – Database – SQL query to get an overview of data based on custom SQL queries. The SQL Query window will open.

Go to File – Open to open and evaluate a saved query from a file. The query result will be shown in a table (see Alvao Asset Management, Working with Tables) and you can send the data to MS Excel for further evaluation.

Note:
Creating custom queries requires the knowledge of SQL and of the ALVAO Service Desk database structure.

 

Did not find what you were looking for? Ask our technical support team.