Creating a Databaseview on alm_hardware table

[harsha005]

I am trying to create a database view by joining couple of tables from CDMB. While doing so I am trying to join alm_hardware table with many other cmdb tables to get corresponding information pertaining to a CI . When I make a join from alm_hardware table to any other cmdb tables the serial number filed from alm_hardware table is coming up as blank in my report. However, there are serial numbers. I am wondering why this is happening. My example Join condition is like this and I have a left outer join on the tables. 

Any input would be appreciated.

[JP - Kyndryl]

Hi Harsha,

The serial number field exists in both tables.

Make sure you are using the good one in personalizing the database view:

In my example OOTB, I have no values in alh_serial_number but plenty in hw_serial_number.

[harsha005]

Thank you for your response. 

[Prateek kumar]

Why do you need a DB view, Configuration item field is available on alm_hardware table and you can easily dot-walk

[harsha005]

Thank you for your response.  I need to connect a bunch of tables that's why took this route. I will try the Dot walk route too and see how it will help us.