Using Microsoft Excel, you can connect to the Update Manager database and query the database views to generate a common report.

Before you begin

You must have an ODBC connection to the Update Manager database.

Procedure

  1. Log in to the computer on which the Update Manager database is set up.
  2. From the Windows Start menu, select Programs > Microsoft Office > Microsoft Excel.
  3. Click Data > Import External Data > New Database Query.
  4. In the Choose Data Source window, select VMware Update Manager and click OK.

    If necessary, in the database query wizard, select the ODBC DSN name and enter the user name and password for the ODBC database connection.

  5. In the Query Wizard - Choose Columns window, select the columns of data to include in your query and click Next.

    Option

    Description

    Available tables and columns

    Lists the available tables, views, and columns. Scroll down to select a database view beginning with VUMV_, and expand the view to select specific columns by double-clicking them.

    Columns in your query

    Lists the columns you can select to include in your query.

    Preview of data in selected column

    Displays the data in a selected column when you click Preview Now.

    For example, if you want to get the latest scan results for all objects in the inventory and all patches for an inventory object, select the following database views and their corresponding columns from the Available tables and columns pane:

    • VUMV_UPDATES

    • VUMV_ENTITY_SCAN_RESULTS

  6. Click OK in the warning message that the query wizard cannot join the tables in your query.
  7. In the Microsoft Query window, drag a column name from the first view to the other column to join the columns in the tables manually.

    For example, join the META_UID column from the VUMV_UPDATES database view with the UPDATE_METAUID column from the VUMV_ENTITY_SCAN_RESULTS database view.

    A line between the columns selected indicates that these columns are joined.

Results

The data is automatically queried for all inventory objects in the Microsoft Query window.