Add Qualys host identification indexes

When large CMDBs are present, the data import and transformation can take a very long time. One possible cause of this is a slow matching of Qualys assets to configuration items in the CMBD. To improve data load time performance, add an index on the Qualys ID and the Qualys Host ID.

Before you begin

Role required: admin

About this task

When large cmdbs are present, the data import and transformation can take a long time. One cause is the slow match of Qualys assets to configuration items in the cmdb.

Procedure

  1. Navigate to Systems Definition > Tables.
  2. Open the Configuration Item [cmdb_ci] table.
  3. Scroll down and click the Database Indexes related list.
  4. Click New and add two individual indexes, one for Qualys ID and one for Qualys Host ID.
    Database indexes
  5. Click Create Index.
  6. Close the Database Indexes window.
    A new dialog box appears. You cannot enter an email address unless the Database Indexes window is closed.
  7. Enter an email address or choose Do not notify me.
  8. Click OK.
    It can take a while to process. If you did not request an email, check the Database Indexes related tab.
    Database indexes