Back to Opsview FAQ

Internal documentation only

This page has been marked as draft.

List of ALL URLs in Opsview

Purpose Copied

A step-by-step guide on how to list all the URLs from Opsview and extract the necessary details for monitoring or auditing purposes.

Process Overview Copied

1. Login to the orchestrator.

   Access your orchestrator using root user

2. Connect to your Opsview database using cx.

   /opt/opsview/coreutils/utils/cx opsview
   

3. Run the SQL Query

   Execute the following SQL query to extract relevant fields from the host_attributes table.

   SELECT id, host, attribute, TRIM(value) AS value, TRIM(arg1) AS arg1 FROM host_attributes WHERE attribute = 5;
   

4. Export the Output

   Copy and paste the output into Excel, then make a few small changes to it.

   id	  host	  attribute	  value  	arg1
   1001	server01	5	default	  websso.test.org
   1002	server02	5	default	  web.test.com