JamieMews Posted July 18, 2018 Share Posted July 18, 2018 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 Link to comment Share on other sites More sharing options...
James Ainsworth Posted July 19, 2018 Share Posted July 19, 2018 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 Link to comment Share on other sites More sharing options...
JamieMews Posted July 19, 2018 Author Share Posted July 19, 2018 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now