Servicenow Database View

[shruthim1474210]

I have created the Database view (u_hardware_model_lifecycle_view) by joining the cmdb_hardware_product_model and cmdb_hardware_model_lifecycle. Database view created to get the report from alm_asset table which have active "ci" and doesn't have "Hardware lifecycle" data, but it is not working as expected. Please give me correct solution for this issue

[shruthim1474210]

Hi Ankur,

I have tried what you suggested, but it’s not working as expected. Please see the screenshot below. It should not retrieve records with a lifecycle phase — I only need the CI data where the lifecycle phase is empty.

[Bert_c1]

@shruthim1474210 

How do you expect to get assistance without posting how you have defined the Database View?

[shruthim1474210]

Hi Bert_c1, Please refer to the below screenshot which i have created the database view in Servicenow

[Bert_c1]

Please test Ankur's modification/suggestion. "Update the where clause for the third view table" as posted.