Running Object Queries

iTop uses its own internal query language to retrieve the objects from the database. Inside the MySQL database the objects manipulated by iTop are stored using several relational tables, but the Object Query Language (OQL) hides this complexity by manipulating objects almost as if they were plain SQL tables.

The OQL syntax is quite similar to the SQL syntax, except that there is no need to indicate which columns to retrieve, since iTop always manipulates “objects” and retrieves the columns as necessary.

The menu “Run Queries” allows Administrators to test and run OQL queries (For more information about the OQL syntax, refer to Object Query Language Reference). Some predefined queries are listed as examples at the top of the page (click on “Query Examples” at the top).

To test a query, type the OQL expression in the text area, and click on “Evaluate” to get the results.