Notifications

37 views

Description

During a discovery it creates and updates CMDB records when it detects a running instance at the PostgreSQL level.

Per our docs it collects the name PostgreSQL instance@hostname. However, as by default we see in the related tree of several CIs with 'PostgreSQL' with in the cmdb_ci_db_postgresql_instance table.

Cause

Out of box we see this:

Step 19. Set label

Value: $instance 
Name: $name

This is the Output example:
'PostgreSQL'

In the related tree of the CI we see there are several PostgreSQL, listed in the cmdb_ci_db_postgresql_instance.

 

Resolution

Do the following if you prefer to have the PostgreSQL pattern to populate the PostgreSQL@instance name.

Step 19. Set label
added the following:
Value: $instance + "@" + $computer_system.primaryHostname
Name: $name

This is the Output example:
'PostgreSQL@mikecamba'

 

Article Information

Last Updated:2019-10-10 10:50:14
Published:2019-10-10