{"id":4353,"date":"2026-06-08T17:56:05","date_gmt":"2026-06-08T14:56:05","guid":{"rendered":"https:\/\/support.withsecure.com\/en\/?post_type=support_article&#038;p=4353"},"modified":"2026-06-08T17:56:05","modified_gmt":"2026-06-08T14:56:05","slug":"how-can-we-retrieve-a-list-of-missing-updates-per-hosts-for-software-updater-swup-on-the-policy-manager","status":"publish","type":"support_article","link":"https:\/\/support.withsecure.com\/en\/support-articles\/how-can-we-retrieve-a-list-of-missing-updates-per-hosts-for-software-updater-swup-on-the-policy-manager\/","title":{"rendered":"How can we retrieve a list of missing updates per hosts for Software Updater (SWUP) on the Policy Manager?"},"content":{"rendered":"<h3>Issue:<\/h3>\n<p>How can we retrieve a list of missing updates per hosts for Software Updater (SWUP)?\u00a0 The Policy Manager Web Reporting tool has a &quot;MISSING UPDATES&quot; report. This report lists how many computers have missing software updates but not the names of these computers.<\/p>\n<h3>Resolution:<\/h3>\n<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 &quot;<b>Policy Manager Advanced configurations settings&quot; -page<\/b><\/p>\n<p>&#8211;\u00a0<a href=\"https:\/\/community.f-secure.com\/discussion\/11869\/policy-manager-advanced-configuration-settings\" target=\"_blank\" rel=\"noopener\">https:\/\/community.f-secure.com\/discussion\/11869\/policy-manager-advanced-configuration-settings<\/a><\/p>\n<p>The setting to activate is\u00a0<span style=\"white-space: pre-wrap;\"><b>-Dh2ConsoleEnabled=true<\/b>. To start the H2 console, open the URL <b>https:\/\/localhost:8080 <\/b>on the Policy Manager Server and click the link visible in the screenshot below.<\/span><\/p>\n<h1><\/h1>\n","protected":false},"excerpt":{"rendered":"<p>How can we retrieve a list of missing updates per hosts for Software Updater (SWUP) on the Policy Manager?\u00a0The Policy Manager Web Reporting tool has a &#8220;MISSING UPDATES&#8221; report. This report lists how many computers have missing software updates but not the name of the computers.<\/p>\n","protected":false},"template":"","support_article_product":[106],"class_list":["post-4353","support_article","type-support_article","status-publish","hentry"],"acf":{"source_foreign_id":"000005654","source_version":3,"source_system":"salesforce","source_date_updated":"2026-06-08 14:56:05","import_hash":"4fa0502cc5ca5876de9b5dfb402e07e0c9b7b36c","vanilla_article_id":32457,"vanilla_url":"https:\/\/community.withsecure.com\/en\/kb\/articles\/32457-how-can-we-retrieve-a-list-of-missing-updates-per-hosts-for-software-updater-swup-on-the-policy-manager","vanilla_kb_id":30,"vanilla_category_id":103,"machine_translated":false,"reactions_helpful_yes":0,"reactions_helpful_no":0},"_links":{"self":[{"href":"https:\/\/support.withsecure.com\/en\/wp-json\/wp\/v2\/support_article\/4353","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.withsecure.com\/en\/wp-json\/wp\/v2\/support_article"}],"about":[{"href":"https:\/\/support.withsecure.com\/en\/wp-json\/wp\/v2\/types\/support_article"}],"wp:attachment":[{"href":"https:\/\/support.withsecure.com\/en\/wp-json\/wp\/v2\/media?parent=4353"}],"wp:term":[{"taxonomy":"support_article_product","embeddable":true,"href":"https:\/\/support.withsecure.com\/en\/wp-json\/wp\/v2\/support_article_product?post=4353"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}