Skip Navigation LinksALVAO 11.1ALVAO Asset ManagementSearching, reporting and data analysisSQL query and database script Skip Navigation Links.


SQL query and database script

Data that cannot be retrieved from the database by searching or queries can be retrieved and possibly manipulated directly in the SQL database. To write an SQL query or script, you need at least a basic understanding of the structure of Alvao database and writing SQL queries. Alternatively, contact ALVAO technical support.

You can find the commands you need in AM Console - Tools - Database.

Creating SQL queries

  1. When creating SQL queries, we recommend using views created for easier access to data in Asset Management. All views designed to access AM information are in the database schema "Query".
  2. SQL queries only allow you to run SELECT queries.
  3. Always enter custom column names in the form . View.[Column], for example Node.[Serial Number]. You can rename columns using an AS statement, for example SELECT View.[Column]AS [View Column].
  4. Do not use SELECT * FROM in queries, but always list specific columns, otherwise the result display may be slowed down.
  5. Views that contain object properties always contain the top 100 most used object properties. Updating these views (redefining them for the 100 most used properties) can be done in ALVAO WebApp - Administration - Database Maintenance - Update data for reports
  6. Before creating your own queries over views, we recommend that you take a look at the examples of using views described below.

 

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