Reports - Linking Asset "Used By" to Accounts Table

[JamieMews]

I am trying to gather more information from the User that has been assigned the Asset

"Used By" and "Used.By.Name" are the fields that are available 

I am not sure how i can link this with the sys_acocunts table?

The PK could be the Customer URN but this is not located in the sys accounts

 

Thanks

Jamie

 

 

 

 

[James Ainsworth]

Hi @JamieMews

I had some success with this set up... 

Let us know if this provides the results that you are looking for.  

Regards,

James

[JamieMews]

Thank you for looking into this. 

This is currently how i have the report setup. 

Unfortunately we have 2x people with the same full name. It then pulls data from the wrong account.

Thanks 

Jamie