Submit a ticketCall us

Quickly Address Software Vulnerabilities
Patch Manager is an intuitive patch management software which extends the capabilities of WSUS and SCCM to not only patch Windows® servers and workstations, and Microsoft® applications, but also other 3rd-party applications which are commonly exploited by hackers. Learn more about our patch management solution.

 

Home > Success Center > Virtualization Manager (VMAN) > Remove orphaned collectors

Remove orphaned collectors

Table of contents
Created by Interspire Import, last modified by Steven Bansil on Jul 11, 2016

Views: 18 Votes: 0 Revisions: 9

Environment

VMan v6.1.1

 

When a collector is shut down or decommissioned, the database entries may be intact causing the old collectors to still appear under the Setup tab of the VMan website.

To remove old entries of orphaned collectors from the database: 

  1. Log into the VMan Appliance console using a remote connection network tool such as putty.
  2. Type psql -U h9pgsu hyper9db to login to the database, then you should see the prompt hyper9db=# on the screen.
  3. Run the following query:
    • DELETE FROM cfg_systemconfig_collectors WHERE id NOT IN (SELECT collector_id FROM cfg_systemconfig_hosts) and name !='localhost';
    Type \q
Last modified
00:45, 11 Jul 2016

Tags

Classifications

Public