2 Replies Latest reply on Sep 14, 2016 8:20 AM by rickstevens

    Last Technician Login details

    rickstevens

      Does anyone know a way of gaining the last login date for a technician in WebHelpDesk?

       

      TIA

       

      Rick

        • Re: Last Technician Login details
          I LIKE EGGS

          Hi,

           

          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 
          

           

          Output

           

          You can put the SQL into a report but we dont use SQL WHD any more moved to a Linux backend.