Jump to content

Need to output the emails for Last logged on Users to laptops

Adrian Simpkins

Recommended Posts

Hi All

I am trying to output a report against our Laptop assets to include the email address of the associated User / Last logged on User. I have the report showing the assets and last logged on with no issues, however I am struggling to see how I can include the email of the Last Logged on User. Is it possible to join these in a report and output the email for the last logged on user at all please? I have tried joining a number of database values but could not see how to output the email for the Last logged on User - is this possible?


Link to comment
Share on other sites

  • 2 weeks later...

Hi Steve/,

I have been having a play to try and get this data output in a report. However when we run the report we are only getting back 4 values / 4 assets but we have a lot more assets than this, so something I am doing is not correct! We have  joined the CMDB Asset Users and H_Sys_Accounts tables as both of these have the User ID to match against. Basically we want to output a list of laptop assets, along with the email of the Used By / Owned by customer

Any assistance is greatly appreciated !


Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...