I am working on trying to create a custom report in LEM that would be a modification of the Change management - Windows/Active Directory Domains: user Events - Account Created report. Here is what I want Event time, user ID source account, I then want some of the details like Office location, Department, Manager but I see to use crystal reports to update a copy of a report I am not sure about the fields to use and from what I am seeing I can't configure a Crystal ODBC to connect to the LEM database so need some help.
Regarding connecting Crystal to the LEM, have you seen this KB?
I'm not sure the information you're asking about (Office, Department, Manager) is going to be included in the change messages logged in AD. Do you see this information in the Event Viewer for the Security log? If not, there's no way the LEM is going to be aware of that information to present it in reports.