Hello,
I am looking for a report which will show all staff (non-patient) account creation dates. The audit reports show who created the accounts, but not which accounts were created. We have a lot of volunteer and student comings and goings which are not being tracked and I would like to audit our staff accounts.
Thank you.
I'd guess the value you're looking for would be either USR.DB_CREATE_DATE or DoctorFacility.Created, depending on which table your report uses. Do you have the ability to edit the existing audit report?
Not sure if you are CPS or EMR, but here's an EMR-version Crystal Report showing all Active EMR logins, including the main fields from USRINFO/USR. I just dump this into Excel and then use Filters to massage the data (ex: give me all the users who haven't logged in since yyyy). Put it under Reports within EMR and it can be run anytime in a number of variations (active vs. all users, by LOC, by date, etc.)
CHUG_USERLOGINS_ACTIVE_ALL_20150807