Notifications
Clear all
Topic starter
Hi does anyone have a license usage report they would be willing to share? Thanks
Posted : January 12, 2014 10:46 pm
This is an old post, but here is a sql query that will show you the current user licenses:
--User licenses in use
SELECT [WSID]
,l.[LoginName]
,[SpidId]
,[UserPvidID]
,[ServerID]
,[SessionID]
,ISNULL([Logged_IN],0) as Logged_IN
,[Last_Login]
,ISNULL([PM_Type],0) AS PM_Type
,ISNULL([EMR_Type],0) AS EMR_Type
,[Description] AS SessionDescription
,[LastUsed]
,CAST([Active] AS BIT) as Active
FROM [dbo].[iLicUserInfo] l
Left join [dbo].[AppSession] s
on l.[SessionID] = s.[AppSessionId]
Justin
Posted : September 12, 2014 3:19 am
Do you have the standard one in the Reports tab? Are you EMR or CPS? For EMR it is in the Reports folder under MedicaLogic > Audit Reports and it is called Licence Usage - Daily Highs...
Wendy Walecka, MS, RN
Affinity and Ministry Health System
Appleton, WI
[email protected]
Posted : November 5, 2014 7:10 am
