Help Creating a Database view

[Alex319]

Hi All, 
I'm trying to create a database view to link a custom cmdb table and the case table. 
When I add the cmdb table to the database view and click on 'try me' the table shows no records. 
The purpose of this database view is to create a report which can look at an asset and see if there are any cases related to that asset. 

Any help would be greatly appreciated

Thanks

Alex

[AndersBGS]

Hi @Alex319 ,

Please also note the equal sign - that you have not corrected according to your update?

"ca_asset.sys_id = pp_asset.sys_id"

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

Best regards

Anders  

[Siddhesh Wani1]

Hi alex 

You have to correct your where clause

ca_asset.sys_id = pp_asset.sys_id

Kindly consider marking the provided answer as correct if it proves helpful.
Thank you and best regards,

[Alex319]

Even with this change it is still not showing any records. 

Thanks

Alex

[AndersBGS]

Ok, and you have an asset field on both the sn_customerservice_case and u_cmdb_ci (can't read the rest of the table name) where both entries are reference fields referring to the same sysid - is that correct? Have you verified this?

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

Best regards

Anders  

[Alex319]

Yeah so the asset field is on both case and cmdb table. without showing real life data you can see the same asset is visible on both. 

Thanks

Alex