Using a Microsoft SQL Server query, you can generate a common report from the Update Manager database.

Procedure

  • To generate a report containing the latest scan results for all objects in the inventory and for all patches for an inventory object, run the query in Microsoft SQL Client.
    SELECT r.entity_uid,r.ENTITY_STATUS, 
                    u.meta_uid, u.title, u.description, u.type, u.severity,
                    (case when u.SPECIAL_ATTRIBUTE is null then 'false' 
                    else 'true'
                    end) as IS_SERVICE_PACK,
                    r.scanh_id, r.scan_start_time, r.scan_end_time 
    FROM VUMV_UPDATES u JOIN VUMV_ENTITY_SCAN_RESULTS r ON (u.meta_uid = r.update_metauid)
    ORDER BY r.entity_uid, u.meta_uid
    

Results

The query displays all patches that are applicable to the scanned objects in the inventory.