Notifications
Clear all
Topic starter
Is there a report in Centricity (still on version 9.5) pm/emr combined to see which users have logged in from 10/1/14 - 12/31/14?
If there is no report on the PM or EMR side, does anyone have a suggestion of where I could find this list?
Thanks a million!
Posted : January 8, 2015 2:45 am
Well, you can get a list of all successful logins from the stock reports, but you're going to get a record for every time a user logged in, not a distinct list of users.
You could do it with a SQL query. This query also returns the login count...if you don't need that you can scrap the grouping and just do a SELECT DISTINCT instead:
SELECT df.ListName AS EndUser, COUNT(ae.EVENT_ID) AS LoginCount
FROM AUDIT_EVENT ae
INNER JOIN AUDIT_PROFILE ap
ON ae.PROFILE_ID = ap.PROFILE_ID
INNER JOIN DoctorFacility df
ON ap.PVID = df.PVId
WHERE EVENT_TYPE_ID = 100
AND ae.OUTCOME = 0
AND EVENT_TIMESTAMP between '2014-10-01 00:00:00.000' AND '2014-12-31 23:59:59.999'
GROUP BY df.ListName
Posted : January 8, 2015 5:06 am
