Obtaining the list of virtual machine UUIDs

You can use the list of virtual machine UUIDs that are currently connected to the BigFix Inventory server to select those for whom the capacity data is to be collected.

About this task

You can find all of the virtual machine UUIDs that are currently connected to the BigFix Inventory server in the ADM.VIRTUAL_VM_UUID table in the TEMADB database. You can extract the complete list of UUIDs and then remove the chosen UUIDs to omit certain virtual machines.

The following procedure explains how to retrieve the list of UUIDs from the DB2 database. If you are using MS SQL, use a method of retrieving information from database tables that is suitable for this database.

Procedure

  1. Log in to the database server as db2inst1 or other user with DBADM rights.
  2. To obtain the list of virtual machines UUIDs, enter the following commands in the system command-line interface:
    db2 connect to TEMADB
    db2 "select distinct uuid from ADM.VIRTUAL_VM_UUID" >uuids.txt
    Note: TEMADB is the default database name. If you are unsure whether it applies to your database, see: Checking the database name.

Results

The list is now stored in the uuids.txt file.

What to do next

Remove the unnecessary UUIDs from the uuids.txt file and copy the remaining UUIDs to the vmmfilterconf.properties file.