Using SQL to Display Key Asset Information

By default, the Assets Database displays the contents of the ASSETS table from the Site database. However, you can modify the SQL code in the Details view to display different tables, or to generate different views of the ASSETS table. For example, you can enter a SQL expression that only displays the asset columns that you want to view.

To control the data displayed:

1    In the menu of the Assets Database view, choose Details. The Details view is displayed.

2    In the Details view, either type the SQL expression in the SQL Code field, or click SQL Wizard to create the expression using a natural-language interface.