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

[Adrian Simpkins]

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?

Thanks

[Steve Giller]

Off the top of my head, for Users (Full or Basic) the email is stored in h_sys_accounts.h_email, and for Guests the email is stored in h_sys_contact.h_email_1

If you have User ID you should be able to join on that.

 

[Adrian Simpkins]

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 !

Thanks