Database view on CMDB class tables

[Prudhvi Raj4]

Hi Team,

I have a requirement to create a database view on table where cmdb_ci are associated and wan to get the field values from 5 different cmdb_ci classes like (Business Application, Application Cluster, Business Application Module, etc) and we want to show the different table field values in the same columns on the database view for example Business application table has files like (Service Offering, Service Name, Business Justification fields) The same fields we have Application cluster as well but need to do a dot walk and get those values and new display in same column instead of adding new column from each ci class fields.

Please suggest

Thanks,

Prudhvi 

[Bert_c1]

Hi Prudhvi,

I suggest you list the specific table names you want to include fields from.  From above I find 'cmdb_ci' and 'cmdb_ci_business_app' (which is a child of 'cmdb_ci'). I'm not sure it makes sense to create a database view on the cmdb_ci table and its child tables.

[Prudhvi Raj4]

Hi

Below are the list of table I want to include in the database view

1. Major Incident

2. Impacted CI

3. Business Application

4. Business Application Module

5. Application Instance

6. Application Cluster

 where are all these child tables of CMDB will connect to one table (business application) are we want to get those values on that table for all cmdb class tables

[Bert_c1]

Post your database view with each of those tables and include 'where clauses'.

[Prudhvi Raj4]

Where Clauses

Impacted CI - impci_incident_alert = ia_sys_id

Business Application - impci_imapcted_configuration_item = busapp_sys_id

Application Cluster - impci_imapcted_configuration_item = appclu_sys_id

Application - impci_imapcted_configuration_item = appl_sys_id

Business Application Module - impci_imapcted_configuration_item = busmod_sys_id

Application Instance - impci_imapcted_configuration_item = appins_sys_id