I want to create a Report that would map user info taken from LDAP import and match with last user login from computer inventory
I would like to be able to create a report that would map the last user login of the computer to the user name import through LDAP.
In the Computer Device inventory, we get a last logged on user, and in the Users which I have imported from Active Directory LDAP, I know the full name, and employee number (which I imported as Custom 2) of the user based on the last logged on user which is the user name account.
How can I write a query that would map this?
Computer Name - from computer inventory, Last logged on user - from computer inventory and we would use this as a key to look up the other information from the Users information taken from LDAP, Full Name - from Users information, employee number - Custom 2 in Users
I have never used SQL query before so I am not sure how to relate the 2 data together. Please help. Thank you.