Reporting from opmanager postgre database using pgadmin

Reporting from opmanager postgre database using pgadmin

Hi Team,

I have a probe running with PostgreSQL as database.

I installed pgadmin and im able to see all the tables in postgre sql.

since the reporting is very limited and we are not abel to add any column like location to the report.

Please let me know the database schema or the query to get the following columns from devices that are available in the probe.

1. Availability as per Technology(Switch, router)
2. Availability as per Location (as mentioned in each device)

Thanks In advance.

Regards,
Prabhu
                New to ADManager Plus?

                  New to ADSelfService Plus?