Join clm_m2m_contract_asset and alm_hardware tables

[GisleH]

Hi.

Im trying to create a report that shows asset with and without a contract.

Report need to show asset and contract information (also asset that does not have a contract) 

is there anyway to join clm_m2m_contract_asset and alm_hardware tables ? 

[Bhavya11]

Hi @GisleH ,

Create Database view between these two tables clm_m2m_contract_asset and alm_hardware then you can create report on the Database view.

How to create Database view

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Thanks,

BK

[Runjay Patel]

Hi @GisleH ,

Create database view with below condition and run the report on database view.

alm_hardware.sys_id = clm_m2m_contract_asset.asset

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

[GisleH]

Hi.

have tired this but getting error

[Runjay Patel]

Hi @GisleH ,

Try like below.

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------