How to clear Patch Manager (PM) data from the SolarWindsOrion database

Sometimes it is necessary to clear the information from these 5 tables in the SolarWindsOrion database to troubleshoot bad or missing entries, or when information is not loading from the Patch Manager database. This can happen after an upgrade of either PM or the SolarWinds Platform. Please ensure you are on the same/similar version of NPM and Patch Manager (i.e.,2025.4, 2026.1, etc).

Sometimes these tables will contain outdated information or missing entries.

1) It is recommended to take a full backup of the SolarWindsOrion DB first.
2) Stop the SolarWinds Platform services (or at least pause polling/job engine) while you run the truncates.
3) Run the following query commands in SQL Management Studio or SW Database Manager against the SolarWindsOrion database only, not the Patch Manager DB.

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties, including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

TRUNCATE TABLE [dbo].[PM_Updates];
TRUNCATE TABLE [dbo].[PM_WsusGroups];
TRUNCATE TABLE [dbo].[PM_WsusNodes];
TRUNCATE TABLE [dbo].[PM_WsusNodesUpdates];
TRUNCATE TABLE [dbo].[PM_WsusServers];

4) Start services (if stopped/paused #2 above), then allow the PM integration sync to refill the tables 
5) Go to https://<yourSolarWindsPlatformhost>/Orion/PM/Summary.aspx and click on "Load Newest Data" in the upper right of the dashboard.