Configuration Item (cmdb_ci) filtering and display format for Database CIs

[shailja2101]

Hi All,

I have a requirement on the Change Request form.

Current implementation:

• Category = Software
• Subcategory = Database

Requirement:

• When Subcategory = Database, the Configuration Item (cmdb_ci) field should display only Database-related CIs.
• Database technologies include Oracle, MSSQL, MySQL, MariaDB, DB2, Progress, etc.
• The CI should be displayed in the format:
  
  DB_NAME@HOSTNAME

  Example 

  GDRP1@CASTNA04

  GDRM1@USTSNA01
  

  I would like to understand the best practice for implementing this requirement:

  1. How can I dynamically filter the Configuration Item reference field to show only Database CI classes when Subcategory = Database?
  2. For a reference field, what is the recommended approach to display records in a concatenated format such as:
     
     DB_NAME@HOSTNAME
  3. Should this be implemented using:
     • Dynamic Reference Qualifier
     • Client Script
     • Script Include
     • Display Business Rule
     • Any other recommended approach?

  Any guidance or examples would be greatly appreciated.

  Thanks!