database view for computer table

[Hafila Hatta]

hi im trying to join 2 tables, to get a list of assets being assigned to the same user. is this possible?

cmdb_ci_computer

cmdb_ci_acc

[Rohit Singh]

Hi @Hafila Hatta ,

With the help of database view you can achieve this.

If my response helped, please hit the Thumb Icon and accept the solution so that it benefits future readers.

Regards,
Rohit

[Chaitanya ILCR]

Hi @Hafila Hatta ,

try this

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

[Ankur Bawiskar]

@Hafila Hatta 

what did you start with and where are you stuck?

you can join those 2 tables based on common field between those tables.

If my response helped please mark it correct and close the thread so that it benefits future readers.