Adrian Simpkins Posted March 8, 2022 Posted March 8, 2022 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 Posted March 8, 2022 Posted March 8, 2022 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. 1
Adrian Simpkins Posted March 18, 2022 Author Posted March 18, 2022 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
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