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

[Ankur Bawiskar]

@shruthim1474210 

share screenshots of your config

[shruthim1474210]

Hi Ankur, Please refer the below screenshots

Thanks & Regards,

Shruthi

[Ankur Bawiskar]

@shruthim1474210 

this should work, add this in where clause for the 3rd view table

hml_model = hm_sys_id

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[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.