1 of 1 people found this helpful
If your Web Help Desk is run on a SQL box you can run this something i put together their might actually be other ways to do it but i like the SQL
You will need to make sure you are running it against your WHD DB instance you see below it has WHD_Live just change that to your WHD Database and you should be golden.
Select T.FIRST_NAME AS 'NAME', T.LAST_NAME AS 'LAST NAME', SE.SESSION_START_TIME AS 'LOGON', SE.SESSION_END_TIME AS 'LOGOFF', convert(varchar(10), datediff(MINUTE,SE.SESSION_START_TIME, SE.SESSION_END_TIME)) + ' Mins'AS 'Session Time' FROM [WHD_Live].[dbo].[SESSION_HIST_ENTRY] SE JOIN [WHD_Live].[dbo].[TECH] T ON (T.CLIENT_ID = SE.tech_ID) Where (SE.SESSION_START_TIME > GETDATE()-1) --change this value to expand the time frame
You can put the SQL into a report but we dont use SQL WHD any more moved to a Linux backend.
Great stuff - many thanks, that works a treat
Thank you, this works awesome!