Search for Missing Patches

The following example adds tables and columns to search for missing patches.

1. At the end of the db:schema section add the following lines: 

   
   
   <db:table db:name="PatchInv_ObjType_6100">
     <db:column db:name="ATTR_161007" db:type="text"/>
     <db:column db:name="InstanceName" db:type="text"/>
   
     <db:column db:name="DeviceID" db:type="int">
       <db:join db:name="Devices.DeviceID"/>
     </db:column>
   </db:table>
    

   Information

   The table PatchInv_ObjType_6100 contains the list of missing patches, and the columns ATTR_161007 and InstanceName contain the bulletin name and the patch name, respectively, which are to be used for the search.

2. Go to the ix:schema section and add the following line to a Device file. 

   
   
   <!--  Patch Inventory -->
   

   Information

   This line will generate an additional line for each patch that is missing on the device in the device file.

3. Open the CM console if it is not yet open and go to the directory InstallDir\master\data\vision64Dtabase\index\data and delete the content of the directory.
4. To now regenerate the index go to node Global Settings > System Variables and select the Quick Search tab.
5. Click Edit > Update Index .
    The new indexation will be started immediately, however, depending on the size of your database this might take a few moments to finish.

Once the new index is generated you can go back to the Quick Search and execute searches on specific missing patches.