Submit a ticketCall us

WebinarWebinar: A checklist for planning your Network Performance Monitor (NPM) upgrade

Are you ready for your next upgrade? To help you plan smoothly, join this webcast to learn more about, SolarWinds® Orion® Installer, SolarWinds Upgrade Advisor, Upgrades Guides, Training Videos, and other resources available. We’ll share key upgrade planning considerations, lessons learned from customers with practical advice from SolarWinds Product Experts. We’ll also give practical tips to identify the estimated time needed and resources, how to prepare the business and IT staff for changes, ways to plan for required system changes, and more.

Register now.

Home > Success Center > Patch Manager > Patch Manager - Knowledgebase Articles > Computers deleted from the domain controller display in Patch Manager reports

Computers deleted from the domain controller display in Patch Manager reports

Table of contents

Updated: November 22, 2017

Overview

This article describes how to manually delete old computers through the database so they do not display in Patch Manager reports (such as Computer with Approved Update Percentage). 

Environment

All Patch Manager versions

Steps

Back up your Eminent Ware database before you perform this procedure.

 

Run the following query to select PCs from WSUS reports that are not managed computers. The third query (listed below) clears these results.

SELECT LOWER(fulldomainname) FROM_WSUS_fqdn_MISSING_IN_DEVICE
FROM [EminentWare].[dbo].[dt_wsus_computers] 
WHERE LOWER(fulldomainname) NOT IN(
SELECT LOWER(fqdn)
FROM [EminentWare].[dbo].[device] )

 

Run the following query to display computers in Patch Manager that are missing in the WSUS server. These computers may be removed from Managed Computers in the Patch Manager Console. See License count exceeded error in Patch Manager for details on how to remove these computers.

SELECT LOWER(fqdn) FROM_DEVICE_fqdn_MISSING_IN_WSUS
FROM [EminentWare].[dbo].[device] 
WHERE LOWER(fqdn) NOT IN(
SELECT LOWER(fulldomainname)
FROM [EminentWare].[dbo].[dt_wsus_computers])

 

Run the following query to delete all record from dt_wsus_computers that do not have corresponding computers in Managed Computers. You can also manually remove database rows using SQL Management Studio if you do not want to run this query. 

/* 
DELETE FROM [EminentWare].[dbo].[dt_wsus_computers] 
WHERE LOWER(fulldomainname) NOT IN(
SELECT LOWER(fqdn)
FROM [EminentWare].[dbo].[device] )
*/

 

 

 

Last modified

Tags

Classifications

Public