Script Help Needed

Script Help Needed

Postby djohnson » Wed Jun 08, 2011 9:12 am

Hey All,
I am fairly new to SQL and was looking for a script that will show all active users that have not accessed Allscripts in a rolling 90 days.

Any help would be appreciated!
Last edited by djohnson on Wed Jun 08, 2011 9:46 am, edited 1 time in total.
Debbie Johnson
Bend Memorial Clinic
Application/Interface Analyst
541-317-4590
djohnson@bmctotalcare.com
djohnson
 
Posts: 29
Joined: Wed Mar 30, 2011 1:57 pm

Re: Script Help Needed

Postby mike.dow » Wed Jun 08, 2011 9:17 am

Debbie,

Here's the script. Enjoy!
Code: Select all
-- Show all Active users who have not logged within 90 days
-- IDXwf is the default name for the GE Web Framework database.  This may differ by installation.
SELECT * FROM IDXwf..Users
WHERE LastLogin < dateadd(dd, -90, getdate())
AND Active = 'Y'


Mike

VP, Technical Services
Galen Healthcare Solutions
Mike Dow
VP, Technical Services
Galen Healthcare Solutions
mike.dow
 
Posts: 16
Joined: Tue Mar 22, 2011 3:49 pm

Re: Script Help Needed

Postby djohnson » Wed Jun 08, 2011 11:22 am

That worked perfect!

thanks
Debbie Johnson
Bend Memorial Clinic
Application/Interface Analyst
541-317-4590
djohnson@bmctotalcare.com
djohnson
 
Posts: 29
Joined: Wed Mar 30, 2011 1:57 pm


Return to Tools: Queries, Scripts

Who is online

Users browsing this forum: No registered users and 2 guests

cron