Network Management
UDT licensing shows all ports are used even though some ports have been unmonitored
The article helps resolve the issue in UDT, where it shows a different monitored port count even if ports were unmonitored.
First published date
Last published date
Overview
This is common for limited UDT license.
Product section
Resolution
NOTE: Ensure a good SolarWinds database backup.
- RDP on the SolarWinds server.
- Open the database manager and run the query below:
-- 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.
UPDATE dbo.UDT_Port SET IsMonitored = 0 WHERE Ismonitored = 1 and IsMissing = 1
UPDATE dbo.UDT_Port SET IsMonitored = 0 WHERE Ismonitored = 1 and IsExcluded = 1