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 display in a table (see Alvao Asset Management, Working with Tables) and you can send the data to MS Excel for further evaluation.
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.