IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > Installation Guide > Tivoli Data Warehouse solutions: common procedures > Test the connection between the portal server and the Tivoli Data Warehouse
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
3. Assign the query to the workspace
The third step of the test procedure is to assign the query to the workspace.
- In the WAREHOUSELOG workspace, click Table on the tool bar, release the mouse button; then click inside one of the workspace views (for example, the Situation Event Console view).
- Click Yes on the message asking if you want to assign the query now.
- In the Query tab, select Click here to assign query.
The Query editor opens with a list of all product queries.
- In the list of queries, expand the category folder you specified when you created the query (for example Windows OS or UNIX OS), and then expand the Custom_SQL folder.
- Select WAREHOUSELOG from the list of queries in the Custom_SQL folder.
The query definition opens in the right frame.
Figure 1. Assigning the WAREHOUSELOG query to a workspace
- Click OK to select the WAREHOUSELOG query for the table and close the Query editor.
- Click OK to close the Properties editor.
The columns of the WAREHOUSELOG table are displayed within the table view in the WAREHOUSELOG workspace. The content of the table is also displayed if the table is not empty.
Parent topic:
Test the connection between the portal server and the Tivoli Data Warehouse