How to remove hosts from performance screen

Version 2 by Bren Eckles
on Oct 09, 2013 17:26.
<< Changes from 1 to 2
compared with
Current by Bren Eckles
on Sep 04, 2018 09:09.
Key
This line was removed.
This word was removed. This word was added.
This line was added.

Changes (10)

View Page History
...
Following is a simple procedure to remove hosts from the performance screen.
# From the command line set the environment to include the path to the tools:
{code}#source/usr/local/groundwork/scripts/setenv.sh{code}
{noformat}source /usr/local/groundwork/scripts/setenv.sh{noformat}
# Log in to the postgres database:
{code}# psql -U postgres{code}
# Select the configuration database:
{code}postgres=# \c monarch{code}
{noformat}psql -U postgres{noformat}
# You should see a prompt similar to {{postgres=#}}, select the configuration database:
{noformat}\c monarch{noformat}
# Remove the entries you don't want from the host_service table. For example:
To delete all entries for host _foo_:
{code}postgres=# delete from host_service where host like 'foo'{code}
For example, to delete all entries for host {{foo}}:
{noformat}delete from host_service where host like 'foo'{noformat}
To delete all entries for service _foo_service_:
{code}postgres=# delete from host_service where service like 'foo_service'{code}
{noformat}delete from host_service where service like 'foo_service'{noformat}
To delete a specific service from a host and leave the others:
{code}postgres=# delete {noformat}delete from host_service where host like 'foo' and service like 'foo_service'{code} 'foo_service'{noformat}