Notifications
Clear all
Topic starter
Hey Youll,
Is there an easy way to print out a list of EMR users in the system and their roles? I know you can go into Application users in Administration but I cant print from there. we have over 600 users. Please help.
Posted : December 4, 2015 9:19 am
I am assuming role = jobtitle .... This will pull all active accounts... You may have to build a crystal report if you want a basic user to routinely get this information.
-James
select LOGINNAME,LASTNAME,FIRSTNAME,jt.DESCRIPTION from USR as u
inner join JOBTITLE as jt on u.JOBTITLE = jt.JTID
where STATUS = 'A'
Posted : December 4, 2015 9:46 am
I have a crystal report from the Old Knowledge base that can give you this.
I sent it in a separate email to you.
Posted : December 4, 2015 10:24 am
Topic starter
James,
Thanks for that script! Can i filter that to show users who have logged in the past month?
Posted : December 4, 2015 10:56 am
select LOGINNAME,LASTNAME,FIRSTNAME,jt.DESCRIPTION,LAST_LOGIN_DATE from USR as u
inner join JOBTITLE as jt on u.JOBTITLE = jt.JTID
where STATUS = 'A'
and last_login_date > dateadd(dd,-30,CAST(GETDATE() AS DATE))
Posted : December 4, 2015 11:25 am
