Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Archive > 2017December13 - Deletes > SAM resources appear in Node Details page after being uninstalled

SAM resources appear in Node Details page after being uninstalled

Created by Jane Baylon, last modified by Kevin.Swinson on Dec 13, 2017

Views: 763 Votes: 0 Revisions: 4

Overview

This article describes the issue when SAM Web Resources still show in the Node Details page even after being uninstalled.

Environment

All versions of SAM 

Cause 

This issue occurs when SAM resources are not removed from the database after the uninstalling.

Resolution

1. Go to Start > All Programs > Solarwinds Orion > Advanced Features > Database Manager > Add default server. Find and expand your Solarwinds database.


2. Right-click Views table and then select Query table.

 

3. Click Execute Query. Take note of the ViewID of the Node Details page. By default, it is set as 2.


4. Right-click Resources table and then select Query table.

 

5. Run this query:
SELECT TOP 1000 * FROM [dbo].[Resources] where viewid = 2 and resourcefile like '%apm%'
This provide results for all SAM (also known as APM) resources that are under the Node Details view.


6. Click Enable table editing and change the ViewID from 2 to 0.

 

7. Press enter to save changes.

 

Last modified

Tags

Classifications

Public