How can we retrieve a list of missing updates per hosts for Software Updater (SWUP) on the Policy Manager? - F-Secure Community
<main> <article class="userContent"> <h3 data-version="2" data-article="000023074" data-id="issue">Issue:</h3> <p>How can we retrieve a list of missing updates per hosts for Software Updater (SWUP)? The Policy Manager Web Reporting tool has a "MISSING UPDATES" report. This report lists how many computers have missing software updates but not the names of these computers.</p> <h3 data-id="resolution">Resolution:</h3> <p>As a workaround, the following SQL query can be used to list the missing updates including the computer/server hostnames. To activate the setting, consult the "<b>Policy Manager Advanced configurations settings" -page</b><br><br>- <a rel="nofollow" href="https://community.f-secure.com/discussion/11869/policy-manager-advanced-configuration-settings">https://community.f-secure.com/discussion/11869/policy-manager-advanced-configuration-settings</a><br><br>The setting to activate is <b>-Dh2ConsoleEnabled=true</b>. To start the H2 console, open the URL <b><a href="https://localhost:8080" rel="nofollow">https://localhost:8080</a> </b>on the Policy Manager Server and click the link visible in the screenshot below.<br></p><h1><img alt="Starting the H2 console" height="202" src="https://us.v-cdn.net/6032052/uploads/542RBZL5CDA8/kcs-0em0x000002uvi3.png" width="500" class="embedImage-img importedEmbed-img"></img></h1> The SQL query to find missing updates on all hosts is below.<br><br> <pre class="code codeBlock" spellcheck="false"><br>select display_name,<br>case when severity = 1 then 'critical'<br> when severity = 2 then 'important'<br> when severity = 3 then 'unclassified'<br> when severity = 4 then 'moderate'<br> when severity = 5 then 'low'<br> else 'unspecified' end severity,<br>case when category = 0 then 'security update'<br> when category = 1 then 'non security update'<br> when category = 2 then 'service pack'<br> when category = 3 then 'security tool'<br> else 'unspecified' end category,<br>bulletin_id, product_name, vendor_name, update_name, cve_id, kb, description_url from missing_software_updates<br>join host_properties on computer_id = domain_id<br>join software_updates on id = software_update_id;</pre> <p>Article no: 000023074</p> </article> </main>