Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

User List

General Discussion

Last Post by caswelljm 9 years ago

5 Posts

3 Users

0 Reactions

59 Views

RSS

sharansunkara

(@sharansunkara)

Posts: 83

Estimable Member

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

caswelljm

(@caswelljm)

Posts: 80

Trusted Member

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

kdevin

(@kdevin)

Posts: 75

Estimable Member

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

sharansunkara

(@sharansunkara)

Posts: 83

Estimable Member

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

caswelljm

(@caswelljm)

Posts: 80

Trusted Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
2 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0